Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
rgustin avatar image
7 ●1 ●2 ●6

Python API get_data function cannot pull data on .HEDGEINDEX

Hi,

I'm using get_data function to pull index details with no problem until I need to grab the same data for a new index .HEDGEINDEX, in which case all I'm getting for this index is <NA>. Can anyone help me figure out a way to pull? Thanks.

Below is my code:

df_ric_ts, err_ric_ts = ek.get_data(
        ['.HEDGEINDEX', '.SPX'],
        ['TR.BIDPRICE.date; TR.BIDPRICE; TR.BIDPRICE(Curn=USD); '
         'TR.CLOSEPRICE.date; TR.CLOSEPRICE; TR.CLOSEPRICE(Curn=USD); '
         'TR.TotalReturnYTD; TR.TotalReturnMTD; TR.TotalReturnQTD; '
         'TR.TotalReturn6Mo; '
         'TR.CompanyMarketCap(CURN=USD); TR.PE; '
         'TR.PriceToBVPerShare; TR.PriceToTangBVPerShare; TR.FwdPEG; TR.BasicNormalizedEps.date; '
         'TR.BasicNormalizedEPS(CURN=USD); TR.LTDebtToTtlCapitalPct; TR.TtlDebtToTtlEquityPct; '
         'TR.AvgDailyVolume3M'],
        {'SDate': -5, 'EDate': 0, 'FRQ': 'M'})

print(df_ric_ts)


Below is the result, and as you can see, .HEDGEINDEX returns nothing, .SPX is fine.

1716387564623.png

eikon-data-api#contentpython apiindex
1716387564623.png (31.4 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
jason.ramchandani01 avatar image
10.6k ●20 ●6 ●9

@rgustin Thanks for your question - so I am unclear what you are trying to achieve here - so you have an index '.SPX' - which is filled with constituent companies '0#.SPX'. You seem to be trying to request individual company data for an index - so this won't work for those fields. You can of course request company level data for the ocnstituents say like so:

df_ric_ts = rd.get_data(
        ['0#.SPX'], #'.SPX' '.HEDGEINDEX'
        ['TR.BIDPRICE.date','TR.BIDPRICE', 'TR.BIDPRICE(Curn=USD)',
         'TR.CLOSEPRICE.date', 'TR.CLOSEPRICE', 'TR.CLOSEPRICE(Curn=USD)',
         'TR.TotalReturnYTD', 'TR.TotalReturnMTD', 'TR.TotalReturnQTD',
         'TR.TotalReturn6Mo','TR.CompanyMarketCap(CURN=USD)','TR.PE',
         'TR.PriceToBVPerShare','TR.PriceToTangBVPerShare', 'TR.FwdPEG', 'TR.BasicNormalizedEps.date','TR.BasicNormalizedEPS(CURN=USD)','TR.LTDebtToTtlCapitalPct', 'TR.TtlDebtToTtlEquityPct','TR.AvgDailyVolume3M'],
        {'SDate': -3, 'EDate': 0, 'FRQ': 'M'})
 
df_ric_ts

1716400682273.png

If you want to look at overall index information you would need to select a different set of fields. You can see which fields you need by looking at the Data Item Browser app. Type DIB into eikon search - and then enter an instrument and there you can see all applicable fields. Is this what you are looking for? I hope this can help.



1716400682273.png (439.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

rgustin avatar image rgustin
Thank you, DIB is the way to go. I need to further combine them into one single column.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.