Import Stock Prices Issues

Spiros's Avatar


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


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

    Spiros's Avatar

    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.

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

    dwg's Avatar

    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.

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

    Spiros's Avatar

    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

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

    dwg's Avatar

    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.

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

    Peter's Avatar

    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

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? 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

Recent Discussions

14 Jun, 2024 06:26 AM
14 Jun, 2024 05:55 AM
14 Jun, 2024 02:01 AM
13 Jun, 2024 10:05 PM
13 Jun, 2024 09:58 PM