Top 100 companies by market capitalisation

rajanraju
rajanraju Contributor
in Eikon Data APIs

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

Tagged:

Best Answer

  • Gurpreet
    Gurpreet admin
    Answer ✓

    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.


Answers

Categories