How i can get historical data of IDRxClosing to Excel

firly.armanda
firly.armanda
in DSS

How can i get the hisotrical data of IDRxClose.

I want historical of all currency againts IDR using IDR Closing Rate.

Usualy for daily i can get it from IDRxClose and generete it to excel with formula AdConvert.

But now i want the historical from IDRxClose for 1 Year Prior.

If i try use formula =TR and the RIC with AUD=, or JPY=, it different with IDR closing rate.


Thank You.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @firly.armanda

    You can try AUDIDR=R or IDRAUD=R to get FX cross rates.

    However, it is better to contact the content support team directly via MyRefinitv to confirm RICs and fields that can provide the required data.

Categories