# 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!

capture.png (21.3 KiB)

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

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

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