Top 100 companies by market capitalisation

rajanraju

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

Gurpreet

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.

rajanraju

Many thanks @Gurpreet