For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

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

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
eikonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonapieikon-data-api-r
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

2 Answers

Upvotes
Accepted
Jirapongse avatar image
38.1k ●69 ●35 ●53

@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 5.0 MiB each and 10.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
18k ●21 ●12 ●20

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea