Financials-Extension icon indicating copy to clipboard operation
Financials-Extension copied to clipboard
verified publisher icon cmallwitz

TOM:FRA

Open casper43 opened this issue 4 years ago • 3 comments

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).

casper43 avatar Mar 10 '21 15:03 casper43

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 avatar Mar 10 '21 16:03 cmallwitz

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...

cmallwitz avatar Mar 10 '21 18:03 cmallwitz

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.

casper43 avatar Mar 12 '21 10:03 casper43

Closing this for now.

cmallwitz avatar Jan 02 '23 20:01 cmallwitz