RHistory excel - how to receive close price of multiple instruments on weekly frequency?

Question

Question by ychen11 · Aug 11, 2019 at 09:03 AM · eikon-com-api datastream-api dsws-api pricing

RHistory excel - how to receive close price of multiple instruments on weekly frequency?

Dear community, I am trying to retrieve the weekly close price for multiple instruments during the period 2008 to 2018. I have difficulty steaming the output structured as below. Can someone please tell me how to adapt RHistory formula? Many thanks in advance!

capture.png (21.3 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-08-11T22:02:29Z

REFINITIV

Best Answer

Answer by Ching Yi.Tsai · Aug 11, 2019 at 10:02 PM

@ychen11 Do you have Eikon in Excel? If so, if you have your RICs listed in column A, just use the following formula in one of the Excel cell:

=TR($A$1:$A$26,"TR.PriceClose","SDate=2018-12-31 EDate=2008-01-01 Frq=AW CH=Fd RH=IN;date",D2)

0 · Share

10 |1500 characters needed characters left characters exceeded

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

RHistory excel - how to receive close price of multiple instruments on weekly frequency?

1 Reply

Watch this question

Related Questions