locked
Uploading historical share prices to MS Money RRS feed

  • Question

  • A lot of the discussion on this forum has been about getting stock quote updates for a given day into MS Money.

    I want to use Microsoft Money to load historical fund prices up over time - so multiple prices for a given fund on many different dates historically.

    I can get this data  into a spreadsheet easily enough. Is there anyway that I can then load this price date into MS Money.

    ( Guess this is sort of likle loading .qif data for transaction information - but I want to do it for prices).  Has anyone been able to do this ?

    Tuesday, January 8, 2013 3:22 PM

All replies

  • I didn't think anybody had actually done this. But hlequotes2 did it as he pointed to below.  I am modifying my post. Cool.


    Tuesday, January 8, 2013 5:10 PM
    Moderator
  • See: https://code.google.com/p/hle-ofx-quotes/wiki/Build_20111104_41

    Also: top-level project page, if you are using the tool for the first time

      . https://code.google.com/p/hle-ofx-quotes/


    Tuesday, January 8, 2013 5:12 PM
  • See: https://code.google.com/p/hle-ofx-quotes/wiki/Build_20111104_41


    Cool. You might consider offering options to just download Friday closes or monthly closes.
    Tuesday, January 8, 2013 5:22 PM
    Moderator
  • Tuesday, January 8, 2013 6:13 PM
  • Hi hleofxquotes2.

    Thanks for this - I hadn't found your wiki with posts of information relating to this before so many thanks for that. The wiki discussing historical quotes upload talks about getting quotes from Yahoo. As I'm a UK user looking at UK Mutual funds I note that you have recommended using FT.com (in other wiki links).  Do you know if getting historical quotes for a fund would also work for FT.com ?

    Wednesday, January 9, 2013 1:31 PM
  • Unfortunately, the curent code for historical quotes only works for Yahoo. But you had mentioned in your original post that you can get the data yourself into a spreadsheet. If that is the case, it will be straightforward to add code to read data from a *.csv file and generate an OFX fie for each line. Most of that codes for such functionality are already there.

    I've added an enhancement request:

    https://code.google.com/p/hle-ofx-quotes/issues/detail?id=61

    Wednesday, January 9, 2013 2:12 PM
  • I'm trying to get historical quotes, as well.  I noticed that hleofxquotes had a build (20111104_41) with historical quotes from Yahoo, but I don't believe that functionality is currently available.  I've also tried the "date offset" feature in the current build but when I review the OFX output file, the price is always the current day's price even though the date has changed.

    I'm also looking to do this for multiple securities for multiple periods (e.g. weekly for years).

    Does anyone have a workable solution?

    Many thanks!


    • Edited by TheMaineMan Monday, January 22, 2018 5:28 PM
    Monday, January 22, 2018 5:15 PM
  • The historical quotes support for hleofxquotes was temporarily removed due to the recent Yahoo quote API change.

    Do you already the quote price data available? for example: in CSV format? if so, I can try to add back the functionality to generate and import the generated OFX from existing CSV file.

    Monday, January 22, 2018 6:59 PM
  • For all my securities, I can get the historical security data from Yahoo or Google and download the data from their web sites in .csv format.

    Is that what you're looking for?

    I'd be happy to work with you on this.

    Thanks and Cheers

    Monday, January 22, 2018 9:59 PM
  • If you can upload sample CSV for both Yahoo and Google, I will put it in todo list.
    Monday, January 22, 2018 11:20 PM
  • Here you go:

    Aapl quote from Google Finance going back 3 years:

    https://www.dropbox.com/s/76fm1tjy37rhhob/aapl%20quote%20from%20google.csv?dl=0

    Aapl quote from Yahoo Finance going back 3 years:

    https://www.dropbox.com/s/iqh94fp8a3ob1py/aapl%20quotes%20from%20yahoo.csv?dl=0

    Cheers

    Tuesday, January 23, 2018 3:14 PM
  • OK, I can download the CSV files. Will take a look.
    Tuesday, January 23, 2018 8:12 PM