New OFX File Creator Tool – SunsetOFX

Update December 29 2017 –  SunsetOFX now supports importing Yahoo quote exports.  This isn’t as fast as the old direct downloading of quotes but it sure beats manual entry and I hope you are able to realize some time savings with this update.  The new version can be downloaded here.  To use this functionality, download an updated quotes.csv file from your Yahoo portfolio screen by clicking “Export” there.  In SunsetOFX, make sure the “Yahoo CSV” tab is selected on the left (the other option is “Manual Input”). Click the “Load Yahoo CSV” button and open the quotes.csv file you downloaded from Yahoo.  Sunset OFX will go through that file, and where it sees a ticker in the file that exists in your SunsetOFX ticker list, it will update the price and date.  A couple things to note… 1) if a ticker in the quotes.csv file is not in your SunsetOFX list, it will be ignored and will NOT be imported as a new ticker for SunsetOFX to process for Microsoft Money import, 2) as with any SunsetOFX update, I recommend you back up your tickers.xml file (from wherever you are running SunsetOFX on your PC) and your Microsoft Money data file, 3) please provide feedback if you run into issues… this is freshly-developed and I don’t know enough about the particulars of Yahoo’s CSV output to have much error-handling in place. 

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 1.0.1.9 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.

 

SunsetOFX Screen Capture

41 Responses to New OFX File Creator Tool – SunsetOFX

  1. Pingback: New Money addon review – PalOMoney | Ameridan's Microsoft Money Offline Weblog

Leave a Reply

Your email address will not be published. Required fields are marked *

5 × 3 =