search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
137 stars 17 forks source link

Sometimes wrong asking price / offer price is being downloaded from yahoo #59

Closed R7914T closed 1 year ago

R7914T commented 2 years ago

It is rather difficult to give examples because it seems to only happen with some shares and not consistently. I have noticed that this formula is not bringing down the latest ask price shown on yahoo:

=GETREALTIME("ASTO.L",25,"yahoo")

Today it was showing 830 when it was higher on the yahoo site.

cmallwitz commented 2 years ago

It is indeed difficult to say what or if something is wrong.

Looking at daily chart for ASTO.L though and it had a low/high of 801/900p today. Could it be the price was just very volatile?

Take a look at the full screen chart and you see it was very "jumpy" today.

23 Jun 2022 17:03:47 R7914T @.***>:

It is rather difficult to give examples because it seems to only happen with some shares and not consistently. I have noticed that this formula is not bringing down the latest ask price shown on yahoo:

=GETREALTIME("ASTO.L",25,"yahoo")

Today it was showing 830 when it was higher on the yahoo site.

— Reply to this email directly, view it on GitHub[https://github.com/cmallwitz/Financials-Extension/issues/59], or unsubscribe[https://github.com/notifications/unsubscribe-auth/AA226T6B7RV7BBYEOT3RT4TVQSDF7ANCNFSM5ZU4PEBA]. You are receiving this because you are subscribed to this thread.[Tracking image][https://github.com/notifications/beacon/AA226T5N4RM5VXY6H26QMS3VQSDF7A5CNFSM5ZU4PEBKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4TDTOPMA.gif]

R7914T commented 2 years ago

I ran a full recalc on the spreadsheet and then immediately checked the price on Yahoo. 830 was not the correct asking price at the time. The spreadsheet showed the the bid and offer at 830, with no spread.

Another example is BATM. At 16.23 the ask price was 36 and bid 36.6.

R7914T commented 2 years ago

another example today at 14.04 after a Recalc Hard:

TP group Per spreadsheet Ask and Bid price shown as 1.20 (yahoo: 1.3 / 1.1)

NB Asset co & Batm both currently showing the correct prices

cmallwitz commented 2 years ago

Let's first look at this from the extensions perspective - using TPG.L on Yahoo as example

Now let's look at data flow from London Stock Exchange to Yahoo (or any other web site you may be looking at). The raw data published by the exchange will be send to exchange subscribers (Yahoo, Financial Times, most banks, anybody else) - the data will include quotes with bid/ask changes and/or executed trades with prices. This data is at least 15 minutes delayed for non-paying (public) customers - this includes Yahoo. There will be additional delays inside Yahoo before data is available on their website for you to see (this delay is probably short but different for any of the website you are comparing).

Now looking at TGP.L itself (I have access to the private, real-time LSE data) - reviewing the data I would categorize TGP.L as volatile and only lightly traded:

You mentioned a time of 14:04 - going back 15 minutes, the public information would have been a bid/ask of 1.1/1.3p with a last traded price of 1.27p - this correlates with what you mentioned above and it seems Yahoo was fairly "correct"

I hope this makes any sense - not the most straight forward thing to wrap ones head around...

cmallwitz commented 1 year ago

Closing this for now