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 Team,
Can you help me to use eikon api and use the command ‘import eikon as ek’ to import the code below?
import refinitiv.data as rd
rd.open_session()
rd.get_history(
universe='CBF24^2',
fields=["SETTLE"],
count=1,
)
Could you please provide the code that can be used through eikon package?
For some reason, seems "count" is not being recognized. Please advise. Thank you!
Hi @Mark Lucio ,
As the error message suggest the issue is with requested range. Since the instrument expired on Jan, 2024 and the function by default returns values for more recent periods, you get the error. Please consider adding start and end dates. I also removed count parameter to see the whole series:
ek.get_timeseries(
rics=['CBF24^2'],
fields=["CLOSE"],
interval="daily",
start_date='2022-01-01',
end_date='2024-01-01'
)
Hope this helps.
Best regards,
Haykaz
This is the reason why we use the count=1 to only display one value. This is the equivalent of nbrows in Excel. I am looking for the code where the client do not need to indicate the start and end date which will show him/her the last value of these expired futures.
Hi @Mark Lucio ,
The best would have been to use ek.get_data for that scenario:
df, err = ek.get_data(instruments='CBF24^2', fields='CF_LAST') df
However, this resulst in NA and the reason why can be checked by raising a content query via my.refinitiv.com
As a workaround I would suggest using get_timeseries but provide only a valid start_date and then pick the last value of the output:
df = ek.get_timeseries(
rics=['CBF24^2'],
fields=["CLOSE"],
interval="daily",
start_date='2020-01-01',
)
df['CLOSE'][-1]
Hi @Mark Lucio ,
Could you detail why "count" is not being recognized ? Do you have any error ?
On my side, same code returns this result:
CBF24^2 SETTLE Date 2024-01-31 262.94
Note that refinitiv-data library is meant to replace eikon, but for those who want to continue using it, it is included and can be used like this:
from refinitiv.data import eikon as ek r1 = ek.get_data(...) r2 = ek.get_timeseries(...) ...
But with rd.get_history(), you can request much more fields than ek.get_timeseries()
Hi @pf, thank you for your assistance. Using the Python code above, it works fine.
However, since the client needs ‘import eikon as ek’, I am not certain how to convert the above code to ‘import eikon as ek’.
I tried to use:
import refinitiv.dataplatform.eikon as ek
import datetime
ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')
ek.get_timeseries(['CBF24^2'],
fields=["close"],
count=1,
interval="daily"
)
but it is showing error:
Error with CBF24^2: No data available for the requested date range CBF24^2: No data available for the requested date range |
