Help with TR.MIDPRICE for API Python

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'}}},]) Where is my mistake?

Best Answer

  • Hi @Emmanuelle Jerome.Cadahing - much simpler than you think - try this:

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