tag:infinitekind.tenderapp.com,2009-01-14:/discussions/investments/2064-yahoo-and-historical-pricesInfinite Kind: Discussion 2018-10-18T14:09:02Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672017-09-13T20:05:07Z2017-09-13T20:09:37ZYahoo and historical prices?<div><p>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.</p>
<p>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 <a href="https://finance.yahoo.com/quote/LOXO/history?p=LOXO">Yahoo quotes</a> 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.</p>
<p>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.</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672017-09-14T07:57:51Z2017-09-14T07:57:51ZYahoo and historical prices?<div><p>Hi,</p>
<p>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.</p>
<p>However, there may be other customer who have further suggestion in this regard so I'll leave this discussion public and open.</p>
<p>Ian O<br>
Infinite Kind Support</p></div>Ian Otag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672017-09-14T10:00:55Z2017-09-14T10:00:55ZYahoo and historical prices?<div><p>Google seems to be more US centric, so probably will not be of much use for those outside the U.S.</p>
<p>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).</p>
<p>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.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672017-09-14T18:47:13Z2017-09-14T18:48:04ZYahoo and historical prices?<div><p>Thx Ian, there are lots of smart MD users, so I too hope others will comment.</p>
<p>@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?</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672017-11-03T06:23:05Z2018-09-24T05:01:03ZYahoo and historical prices?<div><p>It appears that downloading daily prices from Yahoo has now stopped as well!</p>
<p>Since my portfolio is international (Australian, US, Euro and UK) the daily update has been an absolute necessity to keep track of things.</p>
<p>What alternative service is there and is the Quotes and Exchange Rates Extension going to be updated?</p></div>priggalltag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672018-01-06T00:26:52Z2018-01-06T00:26:52ZYahoo and historical prices?<div><p>On 09/14/2017 12:57 AM, Ian O wrote:</p>
<p>Tried to login today to see if there's been any updates on this issue. I<br>
can login but get to this page <a href="http://help.infinitekind.com/welcome">http://help.infinitekind.com/welcome</a><br>
that asks me to respond to an email infinitekind (just) sent. And if I<br>
didn't receive the email (I didn't) to click a link<br>
<a href="http://help.infinitekind.com/users/resend_activation_email?email=feffer777%40yahoo.com">http://help.infinitekind.com/users/resend_activation_email?email=feffer777%40yahoo.com</a><br>
on the page to have the email resent. When I do, I get this deadend page<br>
<a href="http://help.infinitekind.com/users/resend_activation_email?email=feffer777%40yahoo.com">http://help.infinitekind.com/users/resend_activation_email?email=feffer777%40yahoo.com</a>.<br>
If I try to directly to discussions, I'm brought back to the first page<br>
<a href="http://help.infinitekind.com/welcome">http://help.infinitekind.com/welcome</a>. So a catch 22...can't get to<br>
discussions! Also the first page says, I recently changed my email<br>
address which is NOT true.</p>
<p>Wondering what is happening? I know Yahoo was massively hacked and I did<br>
change my pw at least 3x. The URL to your pages "looks" OK, but could I<br>
be getting misdirected? Possibly to a counterfeit site looking for my<br>
user/pw? Could you have been hacked?</p>
<p>Trying to do my year-end books, re-organize my portfolio, and make<br>
several changes, so I would like (need) to get this going quickly. I'm<br>
using this previous email which I know was OK, to communicate with<br>
Infinitekind. Particularly with Ian if possible whom I've had past<br>
communication with, and trust.</p>
<p>thx,<br>
Ron Pepper</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672018-01-06T00:33:04Z2018-01-06T00:33:04ZYahoo and historical prices?<div><p>To Infinitekind,</p>
<p>My previous email probably went into the discussion thread where it does<br>
NOT belong. However, as stated I'm having issues logging in. Please take<br>
it out of the thread, but reply to me concerning the issue. Sorry for<br>
using this method of communication, but I'm a bit worried about a hack.</p>
<p>Thank you<br>
Ron Pepper</p></div>feffer777tag:infinitekind.tenderapp.com,2009-01-14:Comment/434373672018-01-06T07:52:16Z2018-01-06T07:52:16ZYahoo and historical prices?<div><p>OK, the login issue is related to security. Both Firefox and Chrome now<br>
notice whether login and other sensitive pages are in the insecure http<br>
form (instead of secure https) and warn the user that the site is<br>
insecure. I'm pretty sure this is why login results in the dead-end<br>
described earlier.</p>
<p>Again, I apologize for posting this here, but I don't think I can reach<br>
the bug report site.</p>
<p>Please look into this issue, and email me back. Also delete this and my<br>
previous 2 notes from the thread.</p>
<p>Sincerely,<br>
feffer</p></div>feffer777