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

question

Upvotes
Accepted
lgreen avatar image
25 ●5 ●5 ●9

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-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

· Write an Answer
Upvote
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●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.

lgreen avatar image lgreen

@Alex Putkov.perfect.

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.