question

Upvotes
Accepted
cristian01 avatar image
1 ●1 ●1 ●1

Refinitiv Eikon - Microsoft Office | Formula Builder

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

#product#contentexcel
icon clock
10 |1500

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
Jirapongse avatar image
83.1k ●281 ●53 ●77

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

icon clock
10 |1500

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.