search

cmallwitz / Financials-Extension

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

TOM:FRA #21

Closed casper43 closed 1 year ago

casper43 commented 3 years ago

I just discoverd that =GETREALTIME(Ticker;"MARKET_CAP";Source) for TOM:FRA get's a faulty result. This might have to do with currency conversion. You can compare it with TM:NYQ (Japan).

cmallwitz commented 3 years ago

Issue confirmed - I will have to take a look - maybe it gets confused with some reference to Yen some place but but I can't immediately see where...

cmallwitz commented 3 years ago

Looks like the (all the German at least) exchanges, have market cap in JPY rather then in quoted currency (EUR). The number is really that big in JPY :-)

Compare: https://markets.ft.com/data/equities/tearsheet/summary?s=7203:TYO vs https://markets.ft.com/data/equities/tearsheet/summary?s=TOM:FRA vs https://markets.ft.com/data/equities/tearsheet/summary?s=TM:NYQ

Not sure if we can do something (sensible) about it...

casper43 commented 3 years ago

There seems the problem. If the number of shares would be obtainable one could calculate market cap. This seems missing so I currently do the opposite: I calculate the number of shares by dividing the Market_Cap through price.

cmallwitz commented 1 year ago

Closing this for now.