Was looking to get the top 100 companies by market capitalisation in India semi-annually from Jan 2010. Would like the listing to include companies that were trading at the point in time - ie no survivor bias. Please can you help? Indifferent between Eikon and Datastream APIs - whichever is more efficient. Many thanks
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
63
●10 ●17 ●19
Top 100 companies by market capitalisation
Hello @rajanraju
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
Hi,
Please be informed that a reply has been verified as correct in answering the question, and marked as such.
Thanks,
AHS
22k
●59 ●14 ●21
Hi @rajanraju,
I am not a content expert but you could try getting the historical constituents of a market cap weighted index like S&P BSE100 or BSE500. Here is how to get data for year 2010:
>> ek.get_data('0#.BSE100(2010-01-01)', 'TR.RIC')
Instrument RIC
0 63MO.BO 63MO.BO
1 ABAN.BO ABAN.BO
2 ABB.BO ABB.BO
3 ABRL.BO^A18 ABRL.BO^A18
4 ACC.BO ACC.BO
.. ... ...
95 VDAN.BO VDAN.BO
96 VODA.BO VODA.BO
97 WGSR.BO WGSR.BO
98 WIPR.BO WIPR.BO
99 ZEE.BO ZEE.BO
[100 rows x 2 columns]
For content question, It is best to raise a service ticket with my.refinitiv.com.
