Home → Investments →

Import Stock Prices Issues

• Edit

Spiros

03 Sep, 2017 01:01 AM

Question 1
The historic price download for stocks does not work for Canadian stock. Google give a message saying "Not Found" and Yahoo says
Received response code 401 and message 'Unauthorized'. The current price for the stock works fine and the symbol is recognized. When using the Google for historic prices for US stocks download fine. This isn't good.

Problem 2
Also, when i try to upload the historic prices for US stocks it seems that it changes the price for example if the file had a price at US 10.43
 it will change it to 8.414814. It seems like it is thinking i am uploading a US stock on CAD but i am not. When i update using the Quotes and Exchange Rate extention the prices look right, but cant get history for more than 5 days. This is also not good

:(

• Screenshot_from_2017-09-02_18.43.04.png 41.4 KB
• Screenshot_from_2017-09-02_18.42.53.png 28.4 KB

1. 1 Posted by Spiros on 03 Sep, 2017 01:10 AM

   

   I was able to correct problem 2 by changing the base currency from US to CAD and then import the US historic stock prices. Then switched back to CAD.

   This needs fixing. You shouldn't have to do the above work around.

   • Edit

2. 2 Posted by dwg on 03 Sep, 2017 03:18 AM

   

   Yahoo has discontinued support for the API that was used to get historical quotes programmatically hence the error message.

   Google is typically poor for quotes outside of the U.S.

   • Edit

3. 3 Posted by Spiros on 03 Sep, 2017 10:08 PM

   

   Thanks dwg

   I still believe this needs to be resolved. Quicken is able to get historic prices for years in the past. both of the Question 1 (should have been labeled as problem 1) and Problem 2 needs to be resolved by infinitekind

   • Edit

4. 4 Posted by dwg on 03 Sep, 2017 10:18 PM

   

   Quicken hosts prices on their own systems from feeds that they pay for, hence the regular Quicken upgrade costs as they only provide price data for a certain period for each purchased version and also the yearly subscription model. Quicken also only provides data for limited countries, so has a smaller scope.

   • Edit

5. 5 Posted by Peter on 12 Oct, 2017 03:24 AM

   

   I'm having the same problem with AUD and GBP related stocks. It seems to me that the program converts the price using the currencies. I can't even import historic prices in non base currency stocks because the conversion takes place!

   Very frustrated
   Peter

   • Edit

6. System closed this discussion on 11 Jan, 2018 03:30 AM.