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
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.