Import of FT.com csv. data files

[Wealdman]

Prices which have been downloaded from FT.com when processed by MS MoneyQuotes from Gaier Software upload effortlessly into MS Money. Can something similar be incorporated into Maxim Money - going back to inputting prices manually would be a real chore.

[Campbell]

Could you send me a sample file please, and I'll see what I can do.

[Wealdman]

The fields in the .csv FT datafile are:

Name, Symbol, Last Price, Last Price_Currency, Today's price Change - %, Volume, Chart, 1-Year Trailing Total Return.

I have sent you a sample populated file.

[Campbell]

Thank you. Incidentally, how did you import this into Microsoft Money? I only have an option to update prices manually in my version:

image.png (16.2 KiB) Viewed 127 times

[Wealdman]

I import prices into MS Money using a piece of software called MS Money Quotes, written by a chap called Dan Gaier, an ex-Microsoft software developer involved in MS Money. - https://gaiersoftware.com/Money. $9.99 well spent!

Having created a Wishlist at FT.com of the securities which I own the workflow is simply:

1 whenever I require to update prices in MS Money I go to FT.com and export and download the Wishlist (which will contain the current prices) and save this as a .csv file.
2 MS Money Quotes is run from the Command Prompt with file paths of the MS Money file to be updated and the data file plus some necessary switches.
3 MS Money Quotes uploads the prices into MS Money (recording the Source as on-line) and reports details of the update.

If a GUI is required in place of using Command Prompt a Python script can be written and used to select the files and apply the necessary switches.

As I have said, details of my securities are stored in a FT Wishlist, rather than a FT Portfolio - I think the former must have fewer fields - Dan Gaier, speaks of 13 columns in his help in relation to FT files. A copy of this is attached for your information.

[Campbell]

Thanks for this.

I’m actually about to start working on the custom price downloads, which may actually be more straightforward than this. Perhaps you can see what you think when it’s done.

[Wealdman]

I'll look forward to it.

Having to jump through the particular hoops to upload prices in bulk using MS Money Quotes is a necessary evil, but it sure beats manual input. If you are able to streamline the process that would be so much better.

[Amazone]

This would interest me too.
Updating prices with MM does not work for me because not all banks are included in your list.
I can download my investments and the prices from my banks in cvs lists.