get_data produces multiple identical lines

Question

Question by barbara.bukhvalova · Aug 10, 2017 at 03:40 PM · get_data r time series

get_data produces multiple identical lines

I am pulling a time series using get_data, and for some ids I get multiple identical lines. What causes such behavior?

data_frame<- data.table(get_data(list("NO0003019002"), list('TR.PriceClose(SDate=19890101,EDate=20170805,Curn=NOK).date','TR.PriceClose(SDate=19890101,EDate=20170805,Curn=NOK)'),debug=F))

data_frame has 4060 lines, while unique(data_frame) has 117. Note, that it is not due to prices staying the same, as one of the columns is the time stamp.

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2017-08-10T17:23:46Z

REFINITIV

Best Answer

Answer by pierre.faurel · Aug 10, 2017 at 05:23 PM

The result is similar in Eikon EXCEL :

=TR("NO0003019002";"TR.PriceClose.date;TR.PriceClose";"CH=Fd RH=IN SDate=19890101 EDate=20170805 Curn=NOK")

7227 rows but a lot of duplicate rows.

I'll escalate the issue

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

barbara.bukhvalova · Aug 10, 2017 at 06:07 PM 0

Share

Interesting: the number of rows produced by API and Excel is not the same as you got 7227 lines, while I got 4060 in the API. Even though both share the duplicate row problem.

get_data produces multiple identical lines

1 Reply

Watch this question

Related Questions