How do I use the Eikon API to get the data in the red box in the screenshot below?

Best Answer

  • @yuyang So im not exactly sure which data in the redbox you are referring to but the starmine stuff is easily available using:

    df,err = ek.get_data(["AAPL.O"], ['TR.RelValEvSalesComponent','TR.RelValEvEbitdaComponent','TR.RelValPeComponent','TR.RelValPriceCashFlowComponent','TR.RelValPriceBookComponent','TR.RelValDividendYieldComponent','TR.RelValEVSalesNTM','TR.RelValEVEBITDANTM','TR.RelValPENTM','TR.RelValPriceCashFlowNTM','TR.RelValPriceBookNTM','TR.RelValDividendYieldNTM','TR.TRBCEconomicSector','TR.TRBCIndustryGroup'])

    df.transpose()

    image

    The industry average numbers are actually calculated items which you would also need to calculate using members of the TRBC Economic Sector and Industry Group respectively. I hope this can help.