TR.Close(CURN=USD) not working???

newuser
newuser Contributor
in Eikon Data APIs

import sys;
import datetime;
import time;
import eikon as ek;
import pandas as pd;
import sakonnet_db as sdb;
ek.set_app_id("<app key>");

fields=['TR.GICSSector','TR.ClosePrice','CF_CURR', 'TR.CompanyMarketCap(CURN=USD)','TR.ClosePrice(CURN=USD)']
rics=['JD.L']

df, err = ek.get_data(rics, fields, params);


Instrument GICS Sector Name Close Price CF_CURR Company Market Cap Close Price
0 JD.L Consumer Discretionary 770.6 GBp 9.727913e+09 770.6


Somehow I get closeprice that is in local currency!

Tagged:

Best Answer

  • newuser
    newuser Contributor
    Answer ✓

    Issue seems to be that I am requesting values in local and then again with currency conversion.

    For example, if I remove TR.ClosePrice, it provides me with TR.ClosePrice(CURN=USD)

    if I have [TR.ClosePrice(CURN=USD),TR.ClosePrice], it returns only USD values in both columns.


    I worked around it since I don't really need local currency

Categories