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!

image

Best Answer

  • Ching Yi.Tsai
    Answer ✓

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