search

cmallwitz / Financials-Extension

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

Yahoo prices #39

Closed R7914T closed 2 years ago

R7914T commented 2 years ago

I have had to stop using FT prices. Some of the shares are showing unusable results. For some shares the results are unreliable and do not match that shown at the London Stock exchange or LSE. I also prefer to work on bid prices rather than last price, as I am unable to check if the last price was a sale or a purchase.

As an example Centamin shows:

Ask 107, Bid 90, Last price 99. The actual spread is 2.1%. I could not work that out from the FT listing.

I now realise that Yahoo prices are more reliable and up to date.

To have them work, your function has to be completed as in this example: GETREALTIME("ASTO.L",25,"YAHOO") I suspect that the actual yahoo code has to be checked if it does not work. In non London Stock Exchange quotes the extension will be different.

Note the .L In your code example on site you leave that off.

R7914T commented 2 years ago

I am also getting some strange stats from some shares quoted on yahoo.

                                   Yahoo                  Spreadsheet

EG: ASTO:L
Mkt Cap 145.329m 113m Shares out NA 7M Free float NA 6M PE 6.55 63 CENTAMIN PE 11.04 10

R7914T commented 2 years ago

BTW what I am now doing is using Yahoo for some cols in my Spreadsheet and FT for some others cols.

cmallwitz commented 2 years ago

Hi

Sorry I'm "off-grid" this week and a bit slow to respond.

We have discussed that before - depending on your use case you have to use the data you are comfortable with or find useful. Bid/ask and last_price all tell you something but the extension or web sites don't know what you want. last_price always comes from a trade executed which means a buyer purchased and a seller sold at that price. Until the next buyer/seller agree on a price (or rather get matched by the exchange), bid/ask will move away from the last_price changing many times a second (depending on the asset)

Now regarding consistency: unless you pay for an exchange feed you will most likely look at a 15 minute delayed feed. That effects the LSE web site itself and of course FT and Yahoo. All these systems will add their own latency so the final delay when you look at the data on a web site could by 15.01 or 15.5 or 17 minutes - its impossible to know. Therefore you will always see differences between web sites if there has been movement on prices. LibreOffice and this extension will add another second or two and cache values per symbol for up to a minute.

I checked AssetCo and Centamin today and they broadly looked as expected.