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
Hi, I need to get all the components of CHFFWD= (including but not limited to CHFON, CHFTN, CHFSW, CHF1M...) and their BID and ASK values.
The following code
data, err = ek.get_data(instruments=["CHFFWD="], fields=['BID', 'ASK'])
Throws an error. What am I missing?
Thank you
Hello @mi.v.,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
Hi @mi.v.
Please read the chain data structure section in this article.
Here is the sample code:
LONGNEXTLR = 'CHFFWD='
fields = ['LONGLINK{}'.format(x) for x in range(1, 15)]
fields.append('LONGNEXTLR')
all_components = []
while LONGNEXTLR!='':
df,e = ek.get_data(LONGNEXTLR,fields)
LONGNEXTLR = df.iloc[0]['LONGNEXTLR'] if pd.notnull(df.iloc[0]['LONGNEXTLR']) else ''
for x in range(1, 15):
currentField = 'LONGLINK{}'.format(x)
all_components.append(df.iloc[0][currentField]) if pd.notnull(df.iloc[0][currentField]) else None
df,e = ek.get_data(all_components,['BID','ASK'])
df
Output:
