Get the MarketCap in USD

mohammed.mroweh

Hello, Is it possile to have the MarketCap in USD.

For example : CAGR.PA, the Market Cap of this Ric is in local currency (EUR) but i want in USD. Is it possible in python?

The formula in excel is =@TR("CAGR.PA@RIC","TR.CompanyMarketCap(ShType=OUT)","Curn=USD")

What is the instrument in pyhton ?

Thx

chavalit-jintamalit

Hi @mohammed.mroweh

Please see the detailed answer in this post.

df, err = ek.get_data(
    instruments = ['CAGR.PA'],
    fields = ['TR.CompanyMarketCap(Curn=USD,ShType=OUT)']
)
display(df)

danielwattm0821

It works. Thanks.

slitherio