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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
emitiukov avatar image
1 ●0 ●1 ●0

MID_SPREAD For CDX HY Index

Hello,

I'm trying to get CDX HY spreads via Python Eikon API with the following request.

cdx_data = ek.get_timeseries('CDXHY5Y23=R', fields='MID_SPREAD.Close', start_date='2014-09-22', end_date='2019-10-20',interval='weekly'). It returns the following result:

DXHY5Y23=RMID_SPREAD.CLOSEDate
2014-10-10NaN2014-10-17NaN2014-10-24NaN


While in excel it works fine and I'm able to receive CDX spreads history using the field MID_SPREAD.Close. Could you please tell me what's wrong with my Python data request?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@emitiukov

The get_timeseries function can return the OPEN, HIGH, LOW, and CLOSE fields, as shown below. It doesn't support MID_SPREAD.Close.

I assume that you get MID_SPREAD.Close from the RHistory excel function. Refer to this thread, the data from the RHistory function may not be available via Python Eikon Data APIs.


1574666157823.png (22.0 KiB)
icon clock
10 |1500

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

Click below to post an Idea Post Idea