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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

Mismatched rates on Eikon and Excel API

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

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-api
sgdsb6so1yprea.jpg (158.8 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.

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 5.0 MiB each and 10.0 MiB total.

Upvotes
18k 21 12 20

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea