Quote Loader and Yahoo Historical Data decimal placing

Mark Bowen's Avatar

Mark Bowen

20 Jul, 2020 07:32 AM


In the last couple of weeks, it seems that Yahoo has messed about with decimal placing on it's historical data showing for one of my investments. For example on 2nd July price was "1.58" and on the 3rd July price was "157.00".

As a result, when Quote Loader downloads the data, the current price shows as "0.0157" instead of "1.57". I've been manually adjusting this when it happens, but is it something I can fix in the extension settings?

Thanks in advance,

  1. 1 Posted by Mike Bray on 20 Jul, 2020 08:47 AM

    Mike Bray 's Avatar

    Hi Mark, what is the security and what trade currency is being returned?

  2. 2 Posted by Mark Bowen on 20 Jul, 2020 09:37 AM

    Mark Bowen's Avatar

    Hi Mike,

    Security is SRP.L and Trade Currency is GBp(157.4000), which all looks correct when saved.

    Kind Regards,
    Mark Bowen

  3. 3 Posted by Mark Bowen on 20 Jul, 2020 09:43 AM

    Mark Bowen's Avatar

    Screenshot attached showing issue. I'm guessing it's their problem to sort it out.

  4. 4 Posted by derekkent23 on 20 Jul, 2020 10:40 AM

    derekkent23's Avatar

    am not support staff, just a user.
    Hi Mark

    It seems Yahoo is playing games with historical data for Serco Group plc (SRP.L)

    See screen shot of their web page.

    It looks like they corrected the one that was wrong in your screen shot, but others are still incorrect.

    Just to confirm as you would expect Quote Loader retrieve exactly the same prices as shown on the Yahoo web page when I ran a test just now.

    Hope they get their act together.

    Have Fun, Stay Safe.

  5. 5 Posted by Mike Bray on 20 Jul, 2020 12:10 PM

    Mike Bray 's Avatar

    Hi Mark

    Derek is quite correct. QL takes the currency for the security from the
    top of the page. In this case it is GBp (British pence).  GBp is one of
    the recognised 'pseudo currencies', the others being GBX and ZAX, QL
    divides the prices in these currencies by 100. On those dates with
    incorrect prices I assume Yahoo reported the prices in GBP (British
    pounds), hence the different price.  Either change them as you have been
    doing or delete the entry.  QL will not overwrite them.

  6. 6 Posted by Mark Bowen on 20 Jul, 2020 04:03 PM

    Mark Bowen's Avatar

    Hi Mike and Derek,

    I thought so, problem with Yahoo. Thanks for your help.


  7. Maddy closed this discussion on 21 Jul, 2020 08:46 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