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
chirag.arora avatar image
5 ●0 ●0 ●2

Fetching Poll, Min, and Max data for 'USJOB=ECI'

How can I get the Actual as well as the Poll data for 'USJOB=ECI' that comes every week? Though I tried it this way (code snippet attached below), I'm only getting the Actual data, and not the Poll data.

import refinitiv.data as rd
rd.open_session()
df=rd.get_history(
    universe='USJOB=ECI',
    start='2011-01-01',
    end='2024-04-30'
) 

I can download the data in excel file to get all the required columns (screenshot attached below) from the refinitiv app, but I want it to get updated automatically as it comes every week.

1715165537656.png

historical
1715165537656.png (10.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.

2 Answers

· Write an Answer
Upvote
Accepted
jason.ramchandani01 avatar image
10.3k ●18 ●6 ●9

@chirag.arora Thanks for your question - actually you just need to ask for those RICs as well:

import refinitiv.data as rd
rd.open_session()
df=rd.get_history(universe=['USJOB=ECI','pUSJOB=M','pUSJOB=L','pUSJOB=H'],
                  start='2011-01-01',
                  end='2024-04-30'
)

1715167314300.png


I hope this can help.


1715167314300.png (122.5 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.

chirag.arora avatar image chirag.arora
Thanks a ton @jason.ramchandani01 . It was really helpful!
Upvote
aramyan.h avatar image
5.6k ●18 ●2 ●7

Hi @chirag.arora ,


I have passed the poll RICs (eg pUSJOB=L) into the request and have the following output:

df=rd.get_history(
    universe='pUSJOB=L',
    start='2011-01-01',
    end='2024-04-30'
) 
df

screenshot-2024-05-08-at-121954.png

Is this something you were looking for?


Best regards,

Haykaz


screenshot-2024-05-08-at-121954.png (53.2 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.

chirag.arora avatar image chirag.arora
Thank you so much @aramyan.h . It is exactly what I was looking for.

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.