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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 2 1

How do I download ADJUSTED OHLC data for SP500 names daily using EIKON API with python?

I need to download adjusted OHLC prices daily. Should include all corporate actions including cash dividends, splits, mergers etc

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.

Upvotes
Accepted
39.2k 75 11 27

In line with industry standard Refinitiv does not adjust stock price history for cash dividends in most markets. You can use get_timeseries method with fields 'OPEN','HIGH','LOW','CLOSE':

ek.get_timeseries(['TRI.N'],['OPEN','HIGH','LOW','CLOSE'])

Or you can use get_data method with fields 'TR.PriceOpen', 'TR.PriceHigh', 'TR.PriceLow', 'TR.PriceClose', e.g.

ek.get_data('TRI.N',
            ['TR.PriceClose.date','TR.PriceOpen','TR.PriceHigh',
             'TR.PriceLow','TR.PriceClose'],
            {'SDate':'-1M','EDate':'0D'})

For more details see the documentation for Eikon Data APIs. In particular I suggest you check out this tutorial, that talks at length about metadata discovery (finding field names and parameters) for use with Eikon Data APIs.

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.

Upvotes
39.2k 75 11 27
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.

Upvotes
1 0 2 1

@Alex, What are the Eikon fields for Open, HIGH, LOW, CLOSE for daily OHLC?

Can you send a link to an python example which pulls this data from EIKON API?

I noticed on the links you sent that your adjusted prices do not contain cash dividends, is that still the case?

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