Good day,
1) What are the correct symbol to enter in python for searching financial and market data?
We need to retrieve market capitalization, total liabilities, current liabilities, stock prices, number of shares outstanding, company status, Change Status Date.
In most of the cases, RIC symbols do not provide any data and we have to apply the extension "^" (e.g. ^C16) or to rule out the last letter (e.g. from CC.N to CC).
In other cases, we are not able to find data even by changing the symbol used.
Could you please tell us what are the proper symbols to use?
Is there any univocal way to inquiry by symbols on Eikon API?
2) Could you please tell us which is the proper variable to use in Eikon API for taking the Company Status and the Change Status Date?
We stated that TR.OrganizationStatusCode does not provide a correct (real) result.
As you can see in the printscreen, OrganizationStatusCode considers Company Noranda Aluminum as Active (Act.) but actually it got bankruptcy more than one year ago.
Also Company Readcrest Capital is considered as Active, but actually it dissolved almost one year ago.
We found an other variable in Eikon API, "AssetStatus", which perhaps better describe the Company Status: unfortunately, it is just available for few Companies.
That said, we need a variable showing the correct Company Status and the Change Status Date as well.
Here below a part of the Python code used for retrieving data:
import eikon as ek
import itertools
import json
import collections
import datetime
ek.set_app_id('...')
ticker = ['CC.N','AROG.DE','ORA.PA','TEM.MC','AT.TO','SNSG.F','TECF.PA','EOT.N','RD.AS','CUW.TO','VDOR.AS','PRFI.MI','RSTG.F','UNF.MC']
# quarter
fields1 = [ek.TR_Field('TR.TotalLiabilities.date'),ek.TR_Field('TR.TotalCurrLiabilities',{'Scale': 0, 'Curn': 'USD','ConsolBasis':'Consolidated','ReportingState':'Orig'}),ek.TR_Field('TR.TotalLiabilities',{'Scale': 0, 'Curn': 'USD'})]
params1 = {"SDate":"2014-12-27","EDate":"2017-04-01","FRQ":"FI",'Period':'FI0'}
req1 = ek.get_data(ticker,fields1,params1,raw_output=True)
# daily
fields2 = [ek.TR_Field('TR.TtlCmnSharesOut',{'RollPeriods':'False'}),ek.TR_Field('TR.TtlPreferredSharesOut',{'RollPeriods':'False'}),ek.TR_Field('TR.CompanyMarketCap.date'),ek.TR_Field('TR.CompanyMarketCap',{'Scale': 0, 'Curn': 'USD','ShType':'OUT'}),ek.TR_Field('TR.PriceClose',{'Scale': 0,'Curn': 'USD','Lag':'0D'}),ek.TR_Field('TR.PriceClose.date')]
params2 = {"SDate":"2014-12-27","EDate":"2017-04-01","FRQ":"D"}
req2 = ek.get_data(ticker,fields2,params2,raw_output=True)
# status
fields3 = [ek.TR_Field('TR.ISINCode'),ek.TR_Field('TR.OrganizationStatusCode')]
params3 = {"SDate":"2017-10-01","EDate":"2017-12-01","FRQ":"D"}
req3 = ek.get_data(ticker,fields3,params3,raw_output=True)
