Get a dataframe of FX rates from foreign currency to USD

Options
hlteh3388
hlteh3388 Newcomer
in Eikon Data APIs

Hi,

I am trying to get populate the following table with the relevant FX rates into a dataframe using python and eikon api.

FX ratesUSDAUD
USDSGD
USDMYR
USDCNY
USDHKD


Can anybody help?

Thanks,

Tagged:

Best Answer

  • umer.nalla
    umer.nalla LSEG
    Answer ✓

    Hi @hlteh3388

    You can use your Eikon Desktop application to help you identify the relevant RICS e.g. you could use INRAUD=R, IRNSGD=R and so on.

    I discovered the above by starting to type INRAUD etc into the main search bar.

    Likewise, to help identify which Fields you want you can use the Data Item Browser in Eikon too e.g. by typing 'INRSGD=R DIB and then clicking on the Data Item Browser lookup, you can explore the various FIDS available for that RIC.

    1645436043822.png

Answers

  • umer.nalla
    umer.nalla LSEG

    Hi @hlteh3388

    Have you tried something like this?

    df, err = ek.get_data(
        instruments = ['AUD=','SGD=','MYR=','CNY=','HKD='],
        fields = ['DSPLY_NAME','BID','ASK','ACVOL_1','NUMB_BIDS','QUOTIM_MS','TIMACT']
    )
    display(df)

    to output:

    1645434248632.png

  • hlteh3388
    hlteh3388 Newcomer

    Hi umer.nalla,

    This is quite close to what I want. I haven't decided on the base currency. If I want to change my base currency to INR, what should I do?

  • hlteh3388
    hlteh3388 Newcomer

    Thanks a lot for your help.

Categories