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 1 3

Mismatched rates on Eikon and Excel API

The rates i see on Eikon differs from the rates i get using excel API

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apieikon-com-api
sgdsb6so1yprea.jpg (158.8 KiB)
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.

Upvotes
Accepted
3.8k 4 4 6

Hi @tan.jieyong

Most probably you are using fields that hold last close value. With the syntax below you can see that the timestamp is not the current date.

ek.get_data('SGDSB6SO1Y=PREA',['TR.BIDPRICE.date','TR.BIDPRICE','TR.ASKPRICE'])

If you want to get real time values that are visible on the quote, you need to use real time fields. You can get them by hovering over the value on the quote.

The syntax would be

ek.get_data('SGDSB6SO1Y=PREA',['PRIMACT_1','SEC_ACT_1'])

tip.jpg (46.7 KiB)
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.

Upvotes
18.2k 21 13 21

Hi @tan.jieyong

For authoritative answer on content question, please contact Refinitiv content helpdesk at this URL.

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.