Proper symbols for retrieving financial/market data - Inactive/Active Company Status
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)
Answers
-
Try TR.OrganizationStatusCode. You can get a full list of available fields with the Data Item Browser app (DIB) on Thomson Reuters Eikon. For example, type AAPL.O DIB in to the Eikon command bar.
0 -
We already tried TR.Organization Status Code, and in most of the cases it does not provide any information.
We also tried Equity Status (in datastream) and it gave an even worst result (e.g. philip morris -> status "Dead" (??) )
Is there any other variable indicating the status and the date status change?
Thank you!
0 -
Apologies for the delay! To make sure someone responds to your question, please tag your counterpart with the @ sign.
As for your question, I suggest that you should contact Thomson Reuters Support Desk with this directly, as this seems like a content related issue. I would also recommend asking them for help in Eikon Excel first and then replicate the solution in the API either yourself or with my help.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛