Can I get historical data for a chain by specifying SDate, EDate?

Hello

I know I can use :

df= ek.get_data(['CFI2K1'], ['TR.CLOSEPRICE.date', 'TR.CLOSEPRICE.value'], {'SDate': '2021-03-01', 'EDate': '2021-04-21'})

to get data for a specific RIC, but what happens if I have a chain

0#CFI2:

which includes the above RIC(CFI2K1) along with CFI2M1,CFI2N1,....etc

Can I do the same thing with one request, without having to make a request for each included RIC separately?

Thank you

Find more posts tagged with

eikon

workspace

chain-ric

@sfaka try this:

df,err = ek.get_data(['0#CFI2:'],'CF_NAME')
chain = df['Instrument'].astype(str).values.tolist()
df

df, err= ek.get_data(chain, ['TR.SETTLEMENTPRICE.date','TR.SETTLEMENTPRICE.value'], {'SDate': '2021-03-01', 'EDate': '2021-04-21','Frq':'D'})
df

@sfaka try this:

df,err = ek.get_data(['0#CFI2:'],'CF_NAME')
chain = df['Instrument'].astype(str).values.tolist()
df

df, err= ek.get_data(chain, ['TR.SETTLEMENTPRICE.date','TR.SETTLEMENTPRICE.value'], {'SDate': '2021-03-01', 'EDate': '2021-04-21','Frq':'D'})
df

Thank you Jason

Actually this will only for work for/near the current date, where the 'active' RICs are correct for these dates.

How should I change this to get historical data for all months from 1-jan-2019 until 1-jan-2020?

Thank you.