search

cmallwitz / Financials-Extension

Extension for LibreOffice Calc to access stock market data
Other
145 stars 19 forks source link

Market Cap for HYU:DEU missing #30

Closed casper43 closed 1 year ago

casper43 commented 3 years ago

See above. Did your endeavours to look for a reliable provider (life market cap, etc) yield any results?

cmallwitz commented 3 years ago

If you try HYU on the FT web site, it looks like a Euro listing is available as HYU:BER

(And, no - I'm not currently looking to add another data provider)

casper43 commented 3 years ago

But not market cap. I get #NV with =GETREALTIME(Ticker;"MARKET_CAP";Source) .

cmallwitz commented 3 years ago

Because it isn't available on https://markets.ft.com/data/equities/tearsheet/summary?s=HYU:BER either

What is your use case for getting market cap from secondary exchanges instead of just using the primary exchange of a particular equity and (using an additional FX lookup) convert that to any currency you need?

Even prices from secondary exchanged don't strike me as particular useful - prices may not be comparable to primary exchange due to low volume or larger spreads...

casper43 commented 3 years ago

Hi. Every source is from a secondary exchange. As FT doesn't seem to have the original (Hyundai is a South Korean car manufacturer) available.

Not sure how to do FX lookups.

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ cmallwitz @.***> schrieb am Mittwoch, 30. Juni 2021 um 15:01:

Because it isn't available on https://markets.ft.com/data/equities/tearsheet/summary?s=HYU:BER either

What is your use case for getting market cap from secondary exchanges instead of just using the primary exchange of a particular equity and (using an additional FX lookup) convert that to any currency you need?

Even prices from secondary exchanged don't strike me as particular useful - prices may not be comparable to primary exchange due to low volume or larger spreads...

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

cmallwitz commented 3 years ago

Then try Yahoo - either (in different currencies) https://uk.finance.yahoo.com/quote/005380.KS?p=005380.KS&.tsrc=fin-srch or https://uk.finance.yahoo.com/quote/HYMTF?p=HYMTF&.tsrc=fin-srch

The file examples.ods in the "Release" area here on GitHub has FX lookup examples.

casper43 commented 3 years ago

Okay, my whole doc is refering tickers to a source cell currently. Have you found Yahoo more reliable than FT?

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ cmallwitz @.***> schrieb am Mittwoch, 30. Juni 2021 um 15:56:

Then try Yahoo - either (in different currencies) https://uk.finance.yahoo.com/quote/005380.KS?p=005380.KS&.tsrc=fin-srch or https://uk.finance.yahoo.com/quote/HYMTF?p=HYMTF&.tsrc=fin-srch

The file examples.ods in the "Release" area here on GitHub has FX lookup examples.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

cmallwitz commented 3 years ago

Based on my experience Yahoo and FT have similar reliability. While Yahoo has more symbols/exchanges (e.g. Hyundai on South Korean exchange in this example and/or US option details), FT is faster for me mainly (I reckon) because it is closer (I'm in London too).

casper43 commented 3 years ago

Thanks for your answer. That market cap isn't calculating the "current" market cap on the fly, makes your plugin not very usable however for calculating fundamentals.

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ cmallwitz @.***> schrieb am Mittwoch, 30. Juni 2021 um 16:27:

Based on my experience Yahoo and FT have similar reliability. While Yahoo has more symbols/exchanges (e.g. Hyundai on South Korean exchange in this example and/or US option details), FT is faster for me mainly (I reckon) because it is closer (I'm in London too).

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

cmallwitz commented 3 years ago

Well, I can't make up the numbers if they aren't available :-)

But I guess even if I add "shares outstanding" as a field, the quality of it would be the same: is it really shares outstanding / total share number or some "free float". Additionally it could be different from exchange to exchange on only updated once or twice a year...

casper43 commented 3 years ago

I assume we need a reliable datasource for this. Google has it. The power of your plugin pretty much depends on reliable data. :)

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ cmallwitz @.***> schrieb am Montag, 5. Juli 2021 um 11:06:

Well, I can't make up the numbers if they aren't available :-)

But I guess even if I add "shares outstanding" as a field, the quality of it would be the same: is it really shares outstanding / total share number or some "free float". Additionally it could be different from exchange to exchange on only updated once or twice a year...

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

cmallwitz commented 1 year ago

Closing this for now.