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

question

Upvote
lorenzo.rizzo avatar image
16 ●1 ●1 ●3

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)

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apistatus
cattura.png (157.8 KiB)
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.

Jirapongse avatar image   Jirapongse

@lorenzo.rizzo

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Zhenya Kovalyov avatar image
4.6k ●26 ●7 ●22

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.



screen-shot-2018-01-29-at-162928.png (49.5 KiB)
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.

lorenzo.rizzo avatar image lorenzo.rizzo

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!

Zhenya Kovalyov avatar image Zhenya Kovalyov lorenzo.rizzo

@lorenzo.rizzo

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.

Nipat Kunvutipongsak avatar image   Nipat Kunvutipongsak

@Zhenya Kovalyov lorenzo seems to have additional questions, can you come back and review them?

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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