Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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.
@barbara.bukhvalova
Thank you for your participation in the forum.
Is the reply below satisfactory in resolving your query? If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
-AHS
Hello again!
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
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
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.
