Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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!
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
