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
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
13k
●32 ●12 ●18
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.
