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
5 1 1 1

Historic Options data - Python

Hi. Im trying to download historic options data. Ive found that I can open the data in Eikons chart app with the example ticker QHYGH171808500.U^H18

[for the ticker HYG -17Aug2018 strike 85]

but I cant seem to be able to access this data through Python

#--trying every possible header I can find for any result--

fields = ['DSPLY_NAME','EXPIR_CYCL','CF_DATE', 'TR.CLOSEPRICE', 'EXPIR_DATE', 'PUTCALLIND', 'STRIKE_PRC', 'CF_CLOSE','IMP_VOLT','CF_VOLUME','OPINT_1']

df = ek.get_data('HYGH171808800.U^H18',fields)


Not sure if I'm doing something wrong or if this is not possible.

If its not possible how do I download this through the Excel data stream?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

Upvotes
Accepted
78.1k 246 52 72

@bchip

The historical data for this RIC is available through the get_timeseries method.

df = ek.get_timeseries(["HYGH171808500.U^H18 "],start_date="2017-07-01", end_date="2018-08-17", interval="daily")


1598237981119.png (24.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.

Upvotes
5 1 1 1

Thank you so much!


@jirapongse.phuriphanvichai

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.

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.