How i can get historical data of IDRxClosing to Excel

firly.armanda

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.

Jirapongse

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