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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
25 4 4 8

Excel Add In - How do I add the date as a column to a time series

I have the following formula which returns the correct closing price:

=@RDP.Data("AAPL.OQ","TR.PriceClose","Frq=D SDate=0 EDate=-9998 CH=Fd RH=IN",B2)

But the result does not include the date. And when I try to add the price close date in the formula builder, it replaces the priceclose...

Basically i just want a column with date, and a column with closing price...

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apieikon-com-apipricingprice-history
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.

1 Answer

Upvote
Accepted
39.3k 76 11 27

Use

=RDP.Data("AAPL.OQ","TR.PriceClose","Frq=D SDate=0 EDate=-9998 CH=Fd RH=Date")

or

=RDP.Data("AAPL.OQ","TR.PriceClose.date;TR.PriceClose","Frq=D SDate=0 EDate=-9998 CH=Fd")

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.

@Alex Putkov.perfect.