question

Upvotes
Accepted
andreas01 avatar image
50 ●1 ●0 ●3

Issues downloading Economic Indicator history and even fields

Hi,

i've got an issue downloading historic data for economic indicators. my code is this:


df = rd.get_history(
    universe=['aUSSPDIVY'],
    interval="monthly",
    start="1924-03-01"
)
print(df)
aUSSPDIVY      VALUE
Date                
2022-05-31  1.567599
2022-06-30  1.641982
2022-07-31   1.64768
2022-08-31  1.560287
2022-09-30   1.69635
2022-10-31  1.767346
2022-11-30  1.694609
2022-12-31  1.710467
2023-01-31  1.700476
2023-02-28  1.661403
2023-03-31   1.71876
2023-04-30  1.659037
2023-05-31  1.653171
2023-06-30  1.581222
2023-07-31  1.528613
2023-08-31  1.550517
2023-09-30  1.572049
2023-10-31   1.63122
2023-11-30   1.56889
2023-12-31  1.500596

which gives me history back to 2022-05-31.

however, i can clearly see in Eikon that history exists until 1871 (though chart only shows 1924):

1710222503263.png

what do i do wrong?


apart from the above issue, which btw. only responds with Date and Value, i thought, based on DIB for the item, i should be able to get back the following fields:

1710222619333.png

actually all of the fields, but for this issue i just focus on the two in the red box.

but when trying to query those:

df = rd.get_history(
    universe=['USJOB=ECI'],
    fields=["ECON_ACT", "ECON_PRIOR"],
    interval="monthly",
    start="1924-03-01"
)
print(df)

i am greeted with an error message:

RDError: Error code -1 | No data to return, please check errors: ERROR: No successful response.
(TSCC.Economics.UserRequestError.96104, The universe does not support the following fields: [ECON_ACT, ECON_PRIOR])

so, i clearly do something wrong again. can you please let me know what that is?

thanks,
Andreas

#productrefinitiv-data-platformhistoricaleconomic-data
1710222503263.png (166.7 KiB)
1710222619333.png (231.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.

raksina.samasiri avatar image   raksina.samasiri

Hi @andreas01 ,

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,
AHS

5 Answers

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

Hi @andreas01 ,

Thank you for your patience, if you know the RIC of each polls/forecasts, you can simply put them in the universe parameter in the get_history function as a Python array as below.

df = rd.get_history(
    universe=['aUSSPDIVY', 'USJOB=ECIX'],
    interval="monthly",
    start="1924-03-01",
    end="2024-03-12"
)
df

1711006830979.png

However, to get the RIC of forecasts/polls you're interested (if you cannot find it using the Workspace search bar) as the moderators on this forum are expertise on Refinitiv APIs usage. Hence, they do not have deep expertise in every type of content available through Refinitiv products. Such expertise is available through Refinitiv Helpdesk, which can be reached via MyRefinitiv then the content support team is going to contact you soon to assist with this.

Hope this helps and please let me know in case you have any further questions


1711006830979.png (16.4 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.

Upvotes
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

Hi @andreas01 ,

First, to get the historical data, please assign parameters start and end to see data in the date range, for example,

df = rd.get_history(
    universe=['aUSSPDIVY'],
    interval="monthly",
    start="1871-03-01",
    end="2024-03-12"
)
df

1710236823998.png

However, the fields without the TR prefix are real-time fields which can't provide historical data when using the get_data method. Hence get_history will be used instead.

df = rd.get_history(
    universe=['USJOB=ECIX'],
    interval="monthly",
    start="1924-03-01",
    end="2024-03-12"
)
df

1710236831115.png

Hope this helps and please let me know in case you have any further questions.


1710236823998.png (11.7 KiB)
1710236831115.png (13.3 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.

Upvotes
andreas01 avatar image
50 ●1 ●0 ●3

thank you for that. can you tell me how i get the historical data for the different forecasts and polls?


thanks
Andreas

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
andreas01 avatar image
50 ●1 ●0 ●3

hey @raksina.samasiri , any comment regarding the history for the polls / forecasts?

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
andreas01 avatar image
50 ●1 ●0 ●3

seriously?

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.

timothyferrissy avatar image timothyferrissy

Check Data Provider Documentation: Refer to the documentation for rd to see if there are limitations on historical data access for aUSSPDIVY.

retro bowl

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.