python can not get the "TR.MIDPRICE" data of “AUDQM3AB3Y=”，however the excel can do it

chengyuchi
chengyuchi Newcomer
in Eikon Data APIs

python code is：

ek.get_data(['AUDQM3AB3Y='],{"TR.MIDPRICE": {'params': {'SDate': '2017-12-28', 'CALCMETHOD': 'CLOSE', 'Points': 1}}})[0]

run it，we can get NAN like this：

Instrument Mid Price
0 AUDQM3AB3Y= NaN

However in excel，we can get the data.

EXCEL code is:

=RHistory("AUDQM3AB3Y=","MID_PRICE.Timestamp;MID_PRICE.Close","START:2017-12-28 NBROWS:1 TRADETIME:YES INTERVAL:1D",,"TSREPEAT:NO SORT:ASC NULL:NA CH:Fd")

Only AUD currency has this problem,AUDQM3AB5Y=, AUDSM6AB2Y=, AUDQM3AB3Y= all can not get the data through python.

However other currency like USDAM3L2Y=; CADSB3BA2Y=;CHFAB6L10Y= do not has the problem, they can get the data through excel or python.

How can I deal with the problem?

THANKS

Tagged:

Best Answer

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    Answer ✓

    The equivalent to RHistory in Excel is get_timeseries() The only problem here is that the get_timeseries() currently only supports the default "view", which for OTC instruments is BID. So, to summarise - there is no way that you can get the mid price into python, unfortunately.

Answers

  • chavalit-jintamalit
    chavalit-jintamalit admin

    Using Data Item Browser to check the data, it also returns no value.

    image

    This is the equivalent call on Excel:

    =TR("AUDQM3AB5Y=","TR.MIDPRICE(CALCMETHOD=CLOSE)","SDate=2017-12-28 Points=1 CH=Fd RH=IN")

    Which also returns Null value.

    AUDQM3AB5Y=  NULL

    Please submit data question to ContactUs.

  • chengyuchi
    chengyuchi Newcomer
    https://community.developers.refinitiv.com/discussion/comment/22734#Comment_22734

    =RHistory("AUDQM3AB3Y=","MID_PRICE.Timestamp;MID_PRICE.Close","START:2017-12-28
    NBROWS:1 TRADETIME:YES INTERVAL:1D",,"TSREPEAT:NO SORT:ASC NULL:NA
    CH:Fd")

    what is the equivalent call of this on python.

    thanks

  • chengyuchi
    chengyuchi Newcomer
    https://community.developers.refinitiv.com/discussion/comment/22720#Comment_22720

    Thanks for your answer.

    But there is no problem with other currency RIC， such as： USDAM3L2Y=;CADSB3BA2Y=；CHFAB6L10Y=；GBPSB6L10Y=；SGDSB6SO4Y= and so on. I can get the mid data using get_data() in python, which is the same with the RHistory data in Excel. As you said, no way unfortunately to get the mid price in python. How to explain it?

    Eikon python API not support AUD only?

    Thanks very much !

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    https://community.developers.refinitiv.com/discussion/comment/22753#Comment_22753

    Sorry for a bit of a delay on this, I did not understand your question fully.

    You were referring to the RHistory() function in Excel, the equivalent of which in Python is get_timeseries(). The get_timeseries() function at the moment only supports the default set of fields, which is BID for all currency instruments. I hope this clarifies the difference between RHistory and get_timeseries().

    Now, as for AUD, when you perform a get_data() call with TR.MIDPRICE, it accesses the reference database, and @chavalit-jintamalit has correctly pointed you to the data support desk.

    Hope this clarifies it.

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG
    https://community.developers.refinitiv.com/discussion/comment/22753#Comment_22753

    Just to add one more thing. It seems like the MID price for AUD IRS is available through get_data(), therefore, the content issue was fixed. The equivalent call for get_data() for last 100 points in Excel will be:

    =TR("AUDQM3AB5Y=";"TR.MIDPRICE.date;TR.MIDPRICE.value";"SDate=0 EDate=-99")
  • zoya faberov
    zoya faberov ✭✭✭✭✭

    Does this example help:

    df, err = ek.get_data("AUDQM3AB5Y=", 
         [ 
         'TR.MIDPRICE.date',
         {'TR.MIDPRICE.value':{'params':{'SDate': '20171228','CALCMETHOD': 'CLOSE'}}},
         {'TR.MIDPRICE.value':{'params':{'SDate': '20180110','CALCMETHOD': 'CLOSE'}}},
         {'TR.MIDPRICE.value':{'params':{'SDate': '1D','CALCMETHOD': 'CLOSE'}}},
         ])

    resulting in:

        Instrument                  Date  Mid Price  Mid Price  Mid Price
    0  AUDQM3AB5Y=  2018-01-24T00:00:00Z      2.395      2.375      2.503

    Note, that TR.MIDPRICE.date is the date of the run, with TR.MIDPRICE.value defined by SDate parameter

Categories