question

Upvotes
Accepted
54 2 4 11

What is the most correct way of retrieving adjusted closed prices via Python Eikon API?

Should I use this formula

ek.get_timeseries(['TD.TO'], fields=['CLOSE'], corax='adjusted', start_date='2022-01-01', end_date='2022-11-09', interval='daily')

or the formula with rd.get_gistory for the same information?


What do you recommend?


If you recommend rd.get_history could you please provide the most correct way of implementing it on my particular case?

Could you please explain more corax='adjusted' parameter or send me the documentation where I could read it?

Thank you!

eikon-data-apipythonrefinitiv-dataplatform-eikon#technology#contentpython 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.

1 Answer

· Write an Answer
Upvote
Accepted
18k 83 39 63

Hi @alekseenkova.marina

I would recommend you utilize the rd.get_history() call. Looking at the capabilities, you can specify adjustments at a more granular level as well as retrieve more fields within the response. For example:

rd.get_history(universe='TD.TO', interval='1D', 
               start='2022-01-01', end='2022-11-09',
               adjustments=Adjustments.EXCHANGE_CORRECTION)

ahs.png

I would also recommend you review the 'adjustments' within the historical reference guide defined within the RDP Playground. If you still require more details, you should open a ticket within the Helpdesk - they will bring in a historical content expert to address further details around adjustments. If you are accessing this content within the desktop (Eikon or Workspace), you can press F1 - Help & Support and ask your question there.



ahs.png (58.7 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.

I think you forgot to write the parameter - close price as it was written in the question. Could you please show the complete formula?

Thanks!

Hi @alekseenkova.marina

I did not forget to include the 'CLOSE' parameter because the field doesn't exist. What I showed above is a way to see ALL fields associated with 1-day prices for TD.TO. Looking at the result, you can see there are fields called: 'ALT_CLOSE' and 'TRDPRC_1'. I don't know the difference between these fields, but I believe either one is the field you are after. I suggested to contact the helpdesk as they would have a much better understanding of the meaning behind these fields.

I would also recommend you review the 'adjustments' within the historical reference guide defined within the RDP Playground


Could you please show where exactly on the page I could find that @nick.zincone ?

Hi @alekseenkova.marina

I just clicked on that link above and it brought me to the documentation. If you are prompted to login, login first then try clicking the link again.

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.