Mismatched rates on Eikon and Excel API

tan.jieyong
tan.jieyong Newcomer
in Eikon Data APIs

image

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

Tagged:

Best Answer

  • m.bunkowski
    m.bunkowski LSEG
    Answer ✓

    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.

    image

    The syntax would be

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

Answers

Categories