For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvote
Accepted
16 0 0 3

Retrieve historical top market cap

Hello,

For a research projet, I would like to extract the top 10 market cap by country over a 20 year period. It's easy with the stock screener to extract this for the year 2019, but I didn't find any solution to retrieve historical data.

For now, I extract all data for an index (for example S&P500), including leavers and joiners, and I download all the market cap for all the constituents, and then sort by market cap. Is there a better way of doing that ?

With the API (Python) or with the Excel add-in.

Best regards,
Thomas

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythontime-series
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
39.2k 75 11 27

I cannot think of a better way of doing this. I think the method you devised is as good as it gets.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea