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.

Find more posts tagged with

historical

Accepted answers

jason.ramchandani01

@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'
)

I hope this can help.

All comments

aramyan.h

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

Is this something you were looking for?

Best regards,

Haykaz

jason.ramchandani01

@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'
)

I hope this can help.

chirag.arora

Thanks a ton @jason.ramchandani01 . It was really helpful!

chirag.arora

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

EXPLORE OUR SITES