Yahoo and historical prices?

feffer777's Avatar

feffer777

13 Sep, 2017 08:05 PM

As dwg has posted, historical prices are no longer updated automatically by Yahoo through the Quotes and Exchange Rates extension in MD. This is an unwelcome development. I own 8-9 publicly traded securities and track a few others. In addition, I own some proprietary funds (TIAA-CREF) that never got historical prices. I manually downloaded the .csv file from their website.

Yesterday when doing my 2nd Qtr portfolio reconciliation (yes...I'm behind), I looked for a good way to get the missing historical data. I don't know yet whether Google will export historical prices as Yahoo did. So there may be better ways, but this is what I did. Go to the Yahoo quotes site and click on the "Historical" prices tab. Copy the symbol for your security into the search box and choose the proper result (usually the first one). Set the date parameters you want, then "Apply" and hit the "download" symbol. A choice between a download or open in a spreadsheet program will appear. I chose the spreadsheet (Excel or in my case, LibreCalc). When it opens, you may have to delete or move some columns around (quick and easy). You will see the dates go from oldest on top instead of the MD order (newest on top)...don't worry about that, they'll switch correctly during import as long as the Date header is on the column. Save the spreadsheet as .csv (text) and then import it into MD in the usual way. After the first one, it's easier. If you have a list of all your security symbols, just put them into the Yahoo search bar one by one and they'll come up; hit "Apply" (the date parameters you set the first time are kept); and download/open in excel.

So Yahoo may be preventing automation, but one can still get the prices from them. If someone has a better idea, please post. It's possible Google can be used? Also, one might open MD every day and that would get the "history" daily? My process would be a chore, but doable if one only wanted to bother once a quarter or so.

  1. Support Staff 1 Posted by Ian O on 14 Sep, 2017 07:57 AM

    Ian O's Avatar

    Hi,

    You're absolutely right, manually downloading your prices from Yahoo should work without issue. This is likely the most appropriate work around for those experiencing issues getting their rates into Moneydance and I'd like to thank your for raising this point on the forum. As you have pointed out it does involve a fair amount of work but until we have found a new service to supply prices via automatic download, this should hopefully fit the bill.

    However, there may be other customer who have further suggestion in this regard so I'll leave this discussion public and open.

    Ian O
    Infinite Kind Support

  2. 2 Posted by dwg on 14 Sep, 2017 10:00 AM

    dwg's Avatar

    Google seems to be more US centric, so probably will not be of much use for those outside the U.S.

    I have had problems with prices as far back as 2012 with some prices getting zeroed out. So I have not used the historical pricing option to prevent the problem (some stocks only had daily prices and no history on Yahoo so got overwritten with zeros when it tried to get historical data).

    I open Moneydance each day Monday to Friday, at least for a few minutes to allow it to download daily prices, as such I have been building a history of prices by doing this, so now I have at least 5 years worth of historical prices. It is just something that has become part of my daily routine so not a big deal, especially since I also check my email once a day.

  3. 3 Posted by feffer777 on 14 Sep, 2017 06:47 PM

    feffer777's Avatar

    Thx Ian, there are lots of smart MD users, so I too hope others will comment.

    @dwg/Ian, I've just become aware of this issue and haven't had time to test whether Google will bring in historical prices like Yahoo used to...at least for the US markets. Do you know?

  4. 4 Posted by Peter Riggall on 03 Nov, 2017 06:23 AM

    Peter Riggall's Avatar

    It appears that downloading daily prices from Yahoo has now stopped as well!

    Since my portfolio is international (Australian, US, Euro and UK) the daily update has been an absolute necessity to keep track of things.

    What alternative service is there and is the Quotes and Exchange Rates Extension going to be updated?

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac