9/17/2023: I have released a new working version of MSMoneyQuotes that uses Microsoft's new Quote Web Service!
It works the same as the previous version, but will require you to switch from the old "Financial Instrument" symbols to the new "Financial Instrument ID" symbols if you're using the -m SymbolMap.csv feature.
For example, switch from using "126.1.GOOG.NAS" to "a1u3p2" to identify Google. Download MSMoneyQuotes Version 3.0 to replace the older version, switch all "Financial Instrument" references to its corresponding "Financial Instrument ID" if using SymbolMap, and start getting quotes again!
Please see this post for more information. Existing customers can download version 3.0 here.
Here is some basic information about MSMoneyQuotes.exe
MSMoneyQuotes.exe is a "command-line" executable (aka a console application).
It can be run from a DOS prompt, and/or a shortcut on your desktop, taskbar or start menu.
See the Setup section for instructions on how to create a shortcut to MSMoneyQuotes.exe
If MSMoneyQuotes runs without any problems, it will simply exit. If you’re setup to run MSMoneyQuotes using a shortcut, then the DOS window will simply go away.
If MSMoneyQuotes encounters some sort of problem, it will output an error message and then prompt you to press a key. The key press is there to prevent the DOS window from closing and thus gives you a chance to see the error message. Likewise, if the –v option is specified, a key press is required so you can see the output before the window closes.
MSMoneyQuotes accepts the following optional parameters. I’ll show you how to use these in a shortcut below.
Usage: [-f file] [-p password] [-r] [-o] [-a] [-m] [-i file] [-t] [-c] [-v] [-b] -f Target a specific Money file. By default, the current Money file is used. -p The password to use if the Money file is "Money Password" protected. -r Remember Password. Use with -p to save the password. Use without -p afterwards to use the saved password automatically. -o Open Money if not already open. -a Automatically update quotes every 15 minutes as long as Money is open. -m Use SymbolMap.csv file to resolve symbols. -i Import quotes from csv file. -t Include additional timestamp column from csv file. Use with -i to import historical quotes. -c Update currency exchange rates. -v Verbose output. -b Batch file mode. Suppress "Press any key..." prompts to allow running unattended from a batch file.
By default MSMoneyQuotes will update your "current" Money file. That is, the Money file you last had open in Money. However, the –f option allows you to override this behavior and update any arbitrary Money file you’d like.
If your Money file does not have a "Money password", then you don’t need to use the –p option. If it does have a "Money password", then by default MSMoneyQuotes will prompt you to enter the password every time MSMoneyQuotes runs. If you don’t want to be prompted to enter your password, you can supply the password to MSMoneyQuotes by using the –p option. For example: MSMoneyQuotes.exe -p mypassword123
The -r option can be used to instruct MSMoneyQuotes to securely "remember" a password. This option is useful if your Money file is password protected, but you don't want to use the -p option in your shortcut. Obviously placing the password in the shortcut is insecure because the password is in plain text in the shortcut properties.
Here's how to use the -r option:
As a one-time setup, you’d run MSMoneyQuotes.exe with both -r and -p. You could run this from a DOS prompt. This would result in the program storing the password specified in the -p parameter. The password will be securely encrypted and saved in the computer’s registry. During this step MSMoneyQuotes will simply save the password and then exit. It will not run through its normal steps of updating quotes, opening Money, etc.
After this is setup, you’d then need to simply run MSMoneyQuotes with the -r option, and will no longer need the -p option (in fact, make sure you remove the -p option or MSMoneyQuotes won't update quotes!). When just the -r option is specified without the -p option, MSMoneyQuotes will use the previously saved password. The program internally decrypts the password and uses it to open the Money file and then run as it normally would.
Using the -r option means you will no longer need to use the -p option in your shortcut, and thus your password is more secure.
Note that you will still need to enter the password in Money in order for it to open the Money file. There’s no way pass a password to msmoney.exe.
If -o is specified, then MSMoneyQuotes will automatically open Money in addition to updating quotes. With this option, I believe users can get in the habit of using MSMoneyQuotes’s shortcut instead of the standard Money shortcut as a means to open Money (with the added benefit of updated quotes!). The -o option will do nothing if Money is already running, so it’s safe to simply leave the -o option in your shortcut permanently. If both the -f and -o options are specified, then Money will open to the file specified in the -f argument.
One idea is to put the MSMoneyQuotes shortcut on your taskbar and use it to open Money. Then while Money is open, if you’d like to update quotes again, you simply click the shortcut again to update quotes.
If -a is specified, then MSMoneyQuotes will stay open and automatically update quotes every 15 minutes while Money is open. MSMoneyQuotes will automatically close when Money is closed.
To use the -a option, you should do one of the following:
If -m is specified, then MSMoneyQuotes will look for a SymbolMap.csv file in the same folder as MSMoneyQuotes.exe and use it to resolve symbols. SymbolMap.csv is used to manually map symbols from your Money file to symbols on MSN Money (aka financial instruments).
If the symbol is found in SymbolMap.csv, then MSMoneyQuotes will simply use the mapped MSN Money symbol (aka financial instrument IDs) from the file. Otherwise it will follow the normal flow and use the MSN Money web services to attempt to resolve the symbol.
If you use –m and SymbolMap.csv doesn’t exists, MSMoneyQuotes will run "normally" (i.e. as if you didn’t use –m) and use the MSN Money web services to attempt to resolve the symbols. However in this case, MSMoneyQuotes will create a SymbolMap.csv file for you using all the symbols it automatically resolved using the MSN Money web services. With this in mind, I recommend you run MSMoneyQuotes once with –m to let it create your SymbolMap.csv file for you. And then you can continue to use –m and add/remove/update symbol mappings from SymboMap.csv as necessary.
Consider using the -m option if MSN Money is unable to consistently resolve symbols. Many users have reported MSN Money occasionally has problems resolving symbols and as a result you see "symbol not found on msn money" error messages outputed MSMoneyQuotes's -v option.
By using the -m SymbolMap.csv option, you can skip the online symbol resolve step and instead have MSMoneyQuotes use the manually resolved symbol mappings from SymbolMap.csv. For example, recently MSN Money has been unable to resolve the symbol "MSFT". So you’d go figure out the proper symbol mapping on your own and enter it into SymbolMap.csv.
The format of SymbolMap.csv is:
[Symbol You Used In Money],[Financial Instrument ID On MSN Money]
Example of mapping your "MSFT" symbol in MS Money to the financial instrument ID on MSN Money. Enter a new line in SymbolMap.csv:
This is essentially telling MSMoneyQuotes the following: For the "MSFT" symbol in Money, please use the "a1xzim" Financial Instrument ID in the quote service call to MSN Money to get quotes.
Example of a fund:
Use this page to lookup Financial Instrument IDs:
Financial Instrument Search Page
Use this page to map "old" Financial Instruments used for MSMoneyMoney version 2.5 and older to "new" Financial Instrument IDs used for MSMoneyMoney version 3.0 and newer:
Map a Financial Instrument to an Instrument ID
Lastly, MSMoneyQuotes will run much faster when using -m because it eliminates the need to make online web service calls for symbols it resolves using SymbolMap.csv. It can go directly to the "fetch quotes" step.
Starting with version 2.3, SymbolMap.csv also accepts a third column which allows you to specify the ISO currency code. This "Currency Override" feature was added as a workaround due to the MSN Money quote data having the incorrect currency. See this MSN Money Forum post for more details.
To use, you’ll need to manually modify the SymbolMap.csv file. Basically for any security that MSN Money is reporting the incorrect currency, you’ll want to “override” the currency via the SymbolMap.csv file. For example, if MSN Money is returning the currency for RDSB as GBP (which is incorrect), you’ll want to tell my program to actually interpret the prices as GBX. You an do this via the extra column in the SymbolMap.csv file (add “,GBX”).
If -i is specified, then MSMoneyQuotes will import quotes from the provided csv file instead of getting online quotes. This option was built to support importing quotes from a downloaded csv file from FT.com.
See more details on the FT.com Quotes page.
This option must be used along with the above -i option. If -t is specified, then MSMoneyQuotes will import an additonal timestamp column from the csv file and use it for the time of last sale.
The csv file should contain an additional column that list dates in the following format: year-month-day. For example, January 16th, 2018 should be formatted like: 2018-01-16.
Essentially this option allows your to import historical quotes from a csv file into MS Money.
See more details on the FT.com Quotes page.
If -c is specified, then MSMoneyQuotes will fetch online currency exchange rates from MSN Money and update your Money file with these rates. You can see currency exchange rates in Money by going to Tools/Settings --> Program settings --> Update Currencies...
If -v is specified, then MSMoneyQuotes will output extra information about each symbol in your money file and pause. Primarily it will tell you if it successfully found the symbol on MSN Money and updated the security in your Money file. This may be helpful to diagnose problems. The pause option is also useful if you use a shortcut to the program and want to keep the DOS window from disappearing before you’ve had a chance to review other messages. If you have any question about which securities MSMoneyQuotes is updating, use the –v option to see exactly what’s going on.
If -b is specified, then MSMoneyQuotes will suppress the "Press any key..." prompt when using the -v option. This is useful if you want to use MSMoneyQuotes from an unattended batch file and would like to use the -v option.
After trying/buying MSMoneyQuotes, you’ll be able to download MSMoneyQuotes.exe from my website. You can save it anywhere you like such as the C: drive, in your documents folder, in the Money installation folder, wherever. Then create a shortcut by right-clicking on MSMoneyQuotes.exe, select “Sent To”, and then “Desktop (create shortcut)”. You can then also drag that shortcut from your desktop to your Windows Taskbar to create a button there.
If you have Norton AntiVirus and it's complaining about WS.Reputation.1 detection for MSMoneyQuotes.exe, you may have to remove it from Quarantine. This happens because MSMoneyQuotes.exe is a new program so Norton is unable to evaluate its "reputation". I assure there is no malicious code in my program.
Instructions on removing from Quarantine can be found here
At this point, running MSMoneyQuotes can be a one click process by leveraging the shortcut.
If you have a Money password and want to use a shortcut to run MSMoneyQuotes without getting prompted to enter the password, then you have three options:
Instructions for (B):
Assuming you've created a shortcut to MSMoneyQuotes and put that shortcut on your Desktop, here's how you would add the -p option.
Use the same steps above to add the -f, –o, –a -r or -v options to the shortcut. Just put a space between each option.
"C:\MSMoneyQuotes.exe" -p YourMoneyPassword –o -a
MSMoneyQuotes works by following these basic steps:
MSMoneyQuotes honors Portfolio Manager’s "Update Prices…" –> "Pick quotes to download…" selections.
If you do want quotes for a particular security, make sure it’s checked here.
If you don’t want to get quotes for a certain security, you can uncheck it.
Here is the complete list of quote fields updated by MSMoneyQuotes:
Last, change, open, high, low, 52 week high, 52 week low, PE, market cap and volume
Please read this section if you're having problems with MSMoneyQuotes working for you.
If your question is not answered below, then I can be reached at my support email address: firstname.lastname@example.org
You may also find additional information on Ameridan's Microsoft Money Offline Weblog and the MS Money Forum