Excel Eikon API formula decimal places

brad_meagher

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!

zoya faberov

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.