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
3 0 0 3

How do i get adjusted and unadjusted interval high and low price for a security ?

I want to get the interval high and low price of a security say 'AAPL.O' in the period 2023-01-01 and 2023-04-01 in python, what is the formula for it? Is there a parameter to for getting adjusted prices and non-adjusted prices

#technologypython 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
1.3k 5 3 6

Hi @thomas.ng

You can also try this, that involves data cloud computations. Adjusted parameter can be 0 or 1.

rd.get_data("AAPL.O",["MAX(TR.HighPrice)","MIN(TR.LowPrice)"], {"SDate": "2023-01-01", "EDate" : "2023-04-01", "Adjusted":1})
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.

Thanks so much! That's what I tried. When iterating this through a dataframe with 1k rows, this is extremely slow though.
Upvote
76.9k 240 52 72

@thomas.ng

Thank you for reaching out to us.

You can use the Refinitiv Data Library for Python to retrieve this information. The examples are available on GitHub.

The code looks like this:

rd.get_history(universe="AAPL.O",start="2023-01-01",end="2023-04-01",
               fields=["HIGH_1","LOW_1"])


rd.get_history(universe="AAPL.O",start="2023-01-01",end="2023-04-01",
               fields=["HIGH_1","LOW_1"],
               adjustments="unadjusted")

You can run the help(rd.get_history) statement to see all available parameters.

If you don't specify the fields parameter, the method will return all available fields.

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.

this doesn't work if start date and end date are the same. Any way to overcome this issue ?

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.