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

Question

question

lgreen

25 ●3 ●3 ●8

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...

Nov 30, 2020 at 06:59 PM

10 |1500

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

Answer 1 · 2020-11-30T21:54:42Z

Alex Putkov.1

39.2k ●75 ●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")

Nov 30, 2020 at 09:54 PM

10 |1500

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

lgreen Nov 30, 2020 at 10:00 PM