For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
97 5 9 11

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

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!

eikoneikon-data-apipythonworkspaceworkspace-data-apirefinitiv-dataplatform-eikonforex
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
97 5 9 11

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.