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

lgreen
lgreen
in Eikon Data APIs

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

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    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")

Answers

Categories