New posts are disabled while we improve the user experience.

You can browse the site, or for urgent issues, raise a query at MyAccount.

question

Upvotes
Accepted
economics01 avatar image
1 ●0 ●1 ●1

Null result on GDP API R Timeseries request

Hi all!

I'm trying to pull some GDP time series data (RIC: aIDCGDPPD/A) in R using the eikonapir package. However, my request is returning null values (see below). I have a feeling this is because something in my request is incorrect, but I can't figure out what. Can


The 'ECONOMIC.Timestamp' and 'ECONOMIC.Value' fields are taken from my search in the Excel formula builder. Can anyone tell me whats wrong?


> GDPqq <- eikonapir::get_timeseries("aIDCGDPPD/A", 
                                   start_date='2020-01-02T15:04:05-07:00',  # start date
                                   end_date='2022-06-06T15:04:05-07:00', # end date
                                   fields=list('ECONOMIC.Timestamp', 'ECONOMIC.Value'),
                                   interval = "quarterly",
                                   debug = T)
[1] "Request *************************************"
{"Entity":{"E":["TimeSeries"],"W":{"rics":[["aIDCGDPPD/A"]],"fields":[["ECONOMIC.Timestamp"],["ECONOMIC.Value"]],"interval":["quarterly"],"startdate":["2020-01-02T15:04:05-07:00"],"enddate":["2022-06-06T15:04:05-07:00"]}}} 
[1] "Response *************************************"
[1] "{\"timeseriesData\":[{\"dataPoints\":[[null,null],[null,null],[null,null],[null,null],[null,null]],\"fields\":[{\"name\":\"ECONOMIC.Timestamp\",\"type\":\"\\u003cnil\\u003e\"},{\"name\":\"ECONOMIC.Value\",\"type\":\"\\u003cnil\\u003e\"}],\"ric\":\"aIDCGDPPD/A\",\"statusCode\":\"Normal\"}]}"
[1] "Response status *************************************"
[1] 200
eikonworkspacerefinitiv-dataplatform-eikonworkspace-data-apiapieikon-data-api-r
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
Upvotes
Accepted
Jirapongse avatar image
87.8k ●294 ●53 ●79

@economics01

The get_timeseries method can be used to only retrieve "default" historical view data.

Typically, it returns the OPEN, HIGH, LOW, CLOSE fields.

1624433904849.png

Please share the formula created by the Excel formula builder to retrieve the 'ECONOMIC.Timestamp' and 'ECONOMIC.Value' fields.



1624433904849.png (34.1 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.

Jirapongse avatar image Jirapongse

@economics01

The code should look like this:

GDPqq <- get_timeseries("aIDCGDPPD/A", 
           start_date='2020-01-02T15:04:05-07:00',  # start date
           end_date='2022-06-06T15:04:05-07:00', # end date
           fields=list('*'),
           interval = "quarterly")
GDPqq

The output is:

1624439291165.png

1624439291165.png (40.9 KiB)
Upvotes
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

Hi @economics01

You can add interval = 'quarterly' parameter in your request and remove the field name (to get all available fields)


ahs1.png



ahs1.png (26.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.

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.