Daily Exchange rate through EIKON Python API

alankar.gupta
alankar.gupta Newcomer
in Eikon Data APIs

I am trying to fetch the daily Exchange rate from EIKON API solution. Please see the below code.

start_date          = '2019-01-01'
end_date            = '2019-03-01' 
field               = ['BID','ASK']
ric                 = ['ZAR=','GBPZAR=']
params              = parameters={'SDate': start_date, 'EDate': end_date,'Frq': 'D'}
 
data,err            = ek.get_data(ric,field,params)

The Output is only showing results of the current date.

Can someone help?


  Instrument      BID      ASK
0       ZAR=  14.4942  14.4992
1    GBPZAR=  19.8543  19.8783


Tagged:

Best Answer

  • [Deleted User]
    [Deleted User] Newcomer
    Answer ✓

    Hi @alankar.gupta ,


    By using the CodeCreator or Data Item Browser app, you may look for all fields you're looking for, e.g.: 


    TR.BIDPRICE.date

Answers

  • [Deleted User]
    [Deleted User] Newcomer

    Hi @alankar.gupta ,


    Have you tried the CODECREATOR app on Eikon/Workspace?

    Using it, I was able to look for different Bid and Ask fields to test, and I found some that seem to work as expected:


    start_date ='2019-01-01'
    end_date = '2019-03-01'
    field = ['TR.BIDPRICE','TR.ASKPRICE']
    ric = ['ZAR=','GBPZAR=']
    params = {'SDate': start_date, 'EDate': end_date, 'Frq': 'D'}


    df2, err = ek.get_data(instruments=ric,
                           fields=field,
                           parameters=params)
    df2


    Do let me know if this works as you wish.

  • alankar.gupta
    alankar.gupta Newcomer

    Hi @jonathan.legrand How do I print the date beside the records?

Categories