Refinitiv Eikon - Microsoft Office | Formula Builder

cristian01
cristian01
in Eikon COM

Hi!

I am trying to retrieve FX rates over time. I have used the formula =TR(B4,"CF_CLOSE",,E4)

However, it does not allow me to select a specific date for which I want to retrieve the data for

CHFDKK=R


Is there a formula that allows me to get the FX rate on a specific date in time?

Thank you

Tagged:

Best Answer

  • Jirapongse
    Jirapongse admin
    Answer ✓

    @cristian01

    Thank you for reaching out to us.

    CF_CLOSE is a real-time field which doesn't provide historical data.

    You can use the TR.BIDPRICE field instead or use the RHistory function.

Categories