Update November 2 2017 – It appears Yahoo has discontinued the web service that SunsetOFX and Perl/Java scripting solutions depend on to download ticker quotes. The scripting solutions may be dead in the water, but with SunsetOFX you can still manually update your quotes for importing into MS Money. Not as easy as it was October 31, but definitely easier than one-by-one price updates within MS Money. If other solutions develop, or if Yahoo changes their mind, I’ll update this post.
Update July 19 2016 – I noticed when Yahoo Finance online access goes flaky while you are updating quotes, an unfriendly error message pops up. Now you should see a note about a quote lookup not making it back and to try again. Current version is 126.96.36.199 and is what you’ll get from the Downloads page.
Update March 1 2015 – After using SunsetOFX for a couple of years for all my own quote updates for Microsoft Money, I have brought it out of beta into Version 1.n. Thank you for all the feedback!
This post is mainly for those using python scripts and other methods to supply the sunset edition of Microsoft Money with stock quotes from Yahoo.
Lately the quotes coming down from Yahoo have contained odd numbers for prices, and invalid dates in the quotes. This prevents a valid OFX file from being created.
Inspired by http://thefinancebuff.com , the creator of the Python script I have been using to get my stock price updates nightly, I created a Windows app that lets you establish a ticker list that you can add/delete from, as well as visually change what is being downloaded from Yahoo’s web services before the OFX file is created. That way if any stock prices are showing $554,665,321 when it should be $10.23, you’ll be able to change them without hand-editing an OFX file or manipulating Python script.
If you’d like to give it a try you can download the tool at http://syntap.com/downloads/sunsetofx.zip. Unzip the file to its own directory and run the program, no other installation required. Whenever you exit the app your tickers will be saved to an xml file. Also in that directory is where the OFX file the app creates will be stored, filename SunsetOFX.ofx.
When beginning to use this tool, it is highly recommended that you try it out on a copy of your MS Money data file in order to make sure it is working with your setup.
Remember, the assumptions for this app are the same as the thefinancebuff.com Python script discussed here. When you add tickers, you get a choice between Stock and Fund. Make sure you specify the same thing your MS Money file is expecting. To check that within Money, right-click on a portfolio position and select “Investment Details” to see what the “Investment type” field is showing.
The .NET framework required is 3.5, which comes default with Windows 7. The latest version is in the file linked above.
There is some support for options at this time, but quotes are not automatically downloaded. When you create your option position in Money, use the Yahoo ticker as the position name and do not supply a ticker symbol. In the Dummy Investments area, as with a stock or fund entry, “buy” zero contracts of it. When updating quotes, manually fill in the latest option price and it will be included in the OFX dump. If you run into trouble where Money option prices are not updating, look at the holding settings and copy-paste the option symbol into the Ticket field for the option in SunsetOFX. I run into this problem myself sometimes because Money supports the old option ticker symbol system which was a shorter ticker string. If it is truncated in Money, just paste into SunsetOFX whatever Money is showing for the ticker.