question

Upvotes
Accepted
1 1 0 1

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!

eikon-com-apidatastream-apidsws-apipricing
capture.png (21.3 KiB)
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
21 0 0 0

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

icon clock
10 |1500

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

Click below to post an Idea Post Idea