Discrepancy between Yahoo HD quotes and transactional quotes

harold's Avatar

harold

24 Jan, 2021 08:43 PM

Hello,
Several securities that I downloaded from Yahoo with Quote Loader have very different quotes (by a factor of 10 or less) from the existing quotes that I had imported from Quicken via QIF. The quotes are identical to the ones in Quicken, so I assume the import worked. In these cases I have run the import of the quotes again selecting the option to "import from transactions". In this case the historical quotes from the first import were overwritten by the transactional quotes. Will this mess up my data? Are the historical quotes from Yahoo known to have errors?
In generally would it be better to clear the existing transactional quotes before importing the historical quotes over them?

  1. 1 Posted by derekkent23 on 24 Jan, 2021 10:45 PM

    derekkent23's Avatar

    I am not support staff, just a user,
    Hi harold

    If you believe some prices obtained using Quote loader are not correct can you post some examples. There ticker symbols, the security name, the prices you are getting and the prices you expect.
    Can you also post your computer operating system, version and build of Moneydance e.g. 2021.1(3034) and build of Quote Loader e.g. 3027.

    Once we understand this issue it should be possible to on to sorting things out.

  2. 2 Posted by derekkent23 on 24 Jan, 2021 10:51 PM

    derekkent23's Avatar

    I am not support staff, just a user,
    Hi harold

    I should also have asked what is your base currency and can you define if any of these securities are quoted in another currency. If any are, are you setting up the security in that currency or in the base currency.

  3. 3 Posted by harold on 25 Jan, 2021 05:47 AM

    harold's Avatar

    Hi Derek, I misspoke: I did not download the quotes through Quote Downloader but imported the historical quotes from the Yahoo website through the import button in the security history window. So the discrepancy is not with the extension but between the Yahoo historical data and my bank statement. The import produced 77 errors that could account for the discrepancy. Strangely, the data from investing.com agree with the Yahoo data.

    Would a stock split account for the discrepancy? I have searched and did not find any reports of a split. I can only guess that both sites use the same data source that is corrupted. The base currency is CAD and all KL prices are correct except for some time in 2011 when I bought it.
    My setup: Windows 10 latest preview 021.1(3034) and build of Quote Loader 3027. I have uploaded 2 screenshots to show the details. Thanks!

  4. 4 Posted by derekkent23 on 25 Jan, 2021 09:20 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Harold

    Looking at KL on Yahoo the available website historical data does not appear to go back to 2011, it currently starts a 1st December 2016.
    So, if you were at the time obtaining prices via Yahoo I don’t think there is a way to checked from the site what Yahoo would have provided. It’s sounds like you still have the CSV file you obtained from Yahoo back in 2011. If you look at it in a spread sheet it may provide some clues to why you get 77 errors when you import it into Moneydance using the KL Security history window import.
    I did look at another web site Market Watch https://www.marketwatch.com/investing/stock/kl/download-data?startD...
    And that had a price of $6.09, for the 23rd August 2011, don’t know if that helps.
    Also, there was at least one stock split 12/06/2016 100:211 STOCK SPLIT shown on that site, there may be others, you would need so look at the price tables to see.
    Anyway, set up Quote Loader for KL and the up to date price it is returning seems correct see screen shot.

    Hope this helps

  5. 5 Posted by harold on 26 Jan, 2021 03:36 PM

    harold's Avatar

    Hi Derek, the historical quotes for KL from the Yahoo site go back to 1996. I have attched screenshots from that site and investing.com. My bank quotes agree with my Quicken quotes which differ from Yahoo and investing.com data is different again but closer to Yahoo than mine. I am just trying to assess which data source is reliable for historical quotes imports.

  6. 6 Posted by derekkent23 on 26 Jan, 2021 05:22 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi harold

    The Yahoo site you are using must be different to the one Quote Loader uses https://finance.yahoo.com/quote/KL/history?p=KL

    This Yahoo page show a default of about 1 year of historical data. On the wed page you can adjust a calendar to get back to December 2016. Quote Loader can only pick up one year.

    Regarding which data is accurate back in 2011 I have no idea.

    Did you look at the Market Watch web page link I posted and examining the splits it identifies for example the one in 23rd August 2011

  7. 7 Posted by harold on 26 Jan, 2021 06:32 PM

    harold's Avatar

    I see, you have referred to KL at the NYSE I am using the TSE which labels it KL.To. So the Canadian quotes go back much farther. The Marketwatch quotes in USD are again very different from the others. I could not find any stock splits of KL.To could you link your source? Thanks

  8. 8 Posted by derekkent23 on 26 Jan, 2021 08:16 PM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Harold

    Sorry you are correct I posted the wrong link to the Yahoo web site page, it was for USD, not CAD this is the page Quote Loader uses for CAD

    https://finance.yahoo.com/quote/KL.TO/history?period1=1313798400&am...

    and you can set the calendar to go back to 2011.
    However not sure it helps as the values are not the same as the ones you posted, see screen shot.

    The link to web site Market Watch

    https://www.marketwatch.com/investing/stock/kl/download-data?startD...

    is as I posted before and that had a price of $6.09, for the 23rd August 2011, don’t know if that helps.

    Also note the STOCK SPLITS, see screen shot.

    Hope this helps

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