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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 0 0 0

Excel Eikon API formula decimal places

Hi I have an Excel formula that retrieves historical yield data as following:

=@RHistory(B2,A5:B5,A3,,"SORT:DESC TSREPEAT:N",A6)

B2: CA13509PFA6=

A3: NBROWS:360 RTFEED:IDN INTERVAL:1D

A5: ASK_YIELD.TIMESTAMP

B5: ASK_YIELD.CLOSE

Is there any way to have 5 decimals instead of defaulted 3 decimals? Thanks for your help!

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonexcel
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
Accepted
23k 22 9 14

Hello @brad_meagher,

Please be informed that Refinitiv developers forums are dedicated to general questions and discussions centered around Refinitiv API usage, the majority of the forum's members are developers, the moderators of the forum are API experts.

For help with using Eikon Excel, as a customer you will be able to get Eikon/Refinitiv Workspace Excel expert help by asking directly on Refinitiv Helpdesk Online -> Get Support -> Eikon.

As a developer, I think this will first depend on the content, that is being published by Refinitiv Realtime feed:

By calling up Quote in Eikon and specifying "all fields"

we can see the raw value of the field of interest. If the available content is 4 decimal points, than max meaningful decimal places will be 4, and if 3, then 3, no increase in precision can be derived via Excel access, for example:

Consequently, it is possible to change the format of the Excel cell/column, but not to gain more precision in content.

Hope this makes sense and perhaps this helps.


allfields.gif (5.3 KiB)
precision.gif (26.7 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea