1

Resolved

Generated ofx invalid in Money 2003

description

Attached are two ofx files generated from the same data. Also the csv files used to generate those.
  1. Created using csv-to-ofx tool from downloaded FT Watchlist data
  2. Created from the same data using the hleofx java tool. The downloaded FT Watchlist csv was re-formatted into the old layout by copy/pasting into an Excel spreadsheet which created one sheet by doing VLOOKUPs in a second sheet.

file attachments

comments

rgifford wrote Apr 3, 2014 at 9:45 AM

4 files in a zip file

gbjbaanb wrote Apr 3, 2014 at 6:21 PM

It appears that you're getting POSMFs created for the stocks rather than POSSTOCKS - so the colfund issue is the issue here, that's fixed in the new release, leave it off and it generates the right looking ofx file.

rgifford wrote Apr 6, 2014 at 9:19 AM

Created ofx is now in the correct format and is not rejected by MS Money 2003.

However, it doesn't update either. The hleofx tool adds .001 to each holding every time that it is run whereas the csv-to-ofx tool appears not to be doing that. Units in the hleofx file are therefore 0.026 and in the csv-to-ofx file are 0.025. Double clicking the csv-to-ofx ofx file processes in Money but nothing changes.

gbjbaanb wrote Apr 6, 2014 at 12:29 PM

I use Money Sunset and it doesn't need the 'add 0.001' every run - in fact, the ofx generated for me has 0 for the units, which is much nicer, and it means I don't have to keep state somewhere to remember what the last number was.

Have you considered upgrading to Money sunset? It wasn't particularly hard to do.

rgifford wrote Apr 6, 2014 at 2:05 PM

I remember looking at the Sunset edition some time ago and decided against, I can't remember why. It is possible that Money 2003 was still updating stock prices at that time which the Sunset edition doesn't.

I'll have another look. Do you have a link for a UK version or does it have to be a US version?

gbjbaanb wrote Apr 6, 2014 at 3:45 PM

There was only the US version - you can run them both. Export all your accounts as ofxs and then import them into Sunset. It was a nuisance tidying it all up afterwards, but I figured I'd have to do it eventually if I changed OS as getting old moneys to run on Win7 was a pain in the first place.

As it is, I've uploaded an update , just for you :-)

rgifford wrote Apr 6, 2014 at 4:26 PM

Thanks for the update. I'll check it tomorrow because the add to holding technique only works once a day and I've already updated today using my old technique of remapping the csv.

I'll look at Sunset, it is unfortunate that it isn't possible to simply migrate the database as I have lots of accounts going back years. A number of the shares don't exist any more so importing those could be interesting.

I haven't had a problem getting Money 2003 to run on Win7.

rgifford wrote Apr 7, 2014 at 4:29 PM

Update works a treat, thanks

gbjbaanb wrote Apr 7, 2014 at 5:34 PM

Good to hear it. Keep watching - I will get it downloading automatically one day, and auto-open the file too.

rgifford wrote Apr 7, 2014 at 5:55 PM

If you do the download automatically make sure there is an option for a fixed destination file name. I have no interest in keeping daily file versions of the prices in my watchlist, I use Sharescope for historical data if I need it.

Clicking a link on a tab that I leave open then double clicking two files isn't a lot of work. Thanks again for doing this.