Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

How to retrieve USD LIBOR 3M using Rhistory?

Hi,

I'm new to Thomson Reuters and working with the Thomson Reuters Excel Add-In to retrieve data using the RHistory function.

I'm trying to retrieve the time series of US LIBOR 3-month, but it seems that the formula doesn't work. Plz tell me what's wrong with my syntax.

Thanks!

=RHistory("USD3MFSR=", "BID.TIMESTAMP;BID.CLOSE", "NBROWS:1500 INTERVAL:1D",,"CH:In;Fd TSREPEAT:N", B3)
eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-com-api
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
339 4 4 6

@Thu ThaoThe USD3MFSR= does not seem to have BID fields. Will the “Close” field meets your need? If not, you may check with the client specialist on first because this may not be a API/technical question, but a content question.

=RHistory("USD3MFSR=","LAST_QUOTE.Close;LAST_QUOTE.Timestamp","INTERVAL:1D",,"TSREPEAT:NO
CH:IN;Fd", B3)
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.