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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
RizalieJean.Manayon avatar image
1 ●0 ●0 ●0

“My initial query (I was testing CIK versus ticker. The CIK is pulling in some null results compared to ticker for some datatypes.):

“My initial query (I was testing CIK versus ticker. The CIK is pulling in some null results compared to ticker for some datatypes.):

df, err = ek.get_data(

instruments = ['AAPL.O','0000320193'],

fields = [

'TR.CIKNUMBER', 'TR.CommonName', 'TR.F.PeriodEndDate(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)', 'TR.F.TotAssets(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)',

'TR.F.DebtTot(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)', 'TR.F.MktCap(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)', 'TR.F.CashCashEquivTot(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)',

'TR.F.EV(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)', 'TR.F.CAPEXTot(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)', 'TR.EBITDA(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)', 'TR.EBIT(SDate=0,EDate=-19,Period=FQ0,Frq=FQ)'

]

)

display(df)

=======================================================================

I tried some more datatypes and also converted CIK to RIC. I think CIK works with datatypes of TR.xxx while RIC works with both TR.xxx and TR.F.xxx most of the time.

While the figures are mostly equivalent, for some quarters, the numbers do differ. Should I be using one rather than the other (TR.F. vs TR.) for RIC/CIK? Which one would be data from SEC filings?

'TR.BSPeriodEndDate(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)', 'TR.F.PeriodEndDate(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)',

'TR.TotalAssetsReported(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)', 'TR.F.TotAssets(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)',

'TR.TotalDebtOutstanding(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)', 'TR.F.DebtTot(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)',

'TR.CashandEquivalents(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)', 'TR.F.CashCashEquivTot(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)',

'TR.CapitalExpenditures(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)', 'TR.F.CAPEXTot(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)',

'TR.TotalEquity(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)','TR.F.ComEqTot(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)',

'TR.TotalEquityAndMinorityInterest(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)', 'TR.F.TotShHoldEq(SDate=0,EDate=-10,Period=FQ0,Frq=FQ)',

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @RizalieJean.Manayon

For your sample fields, you can also pass in parameter which applies to all fields.


From my understanding, RIC is a preferred identifier type.

But this forum is not the best place to ask about content questions.
For an authoritative answer to any content questions, the best resource is the Refinitiv Content Helpdesk.
This forum is dedicated to things specific to the use of Eikon APIs.
The moderators here do not have deep expertise in every type of content available through Eikon.
The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
Or by calling the Helpdesk number in your country.
Or at https://my.refinitiv.com/



ahs.jpg (145.2 KiB)
icon clock
10 |1500

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

RizalieJean.Manayon avatar image RizalieJean.Manayon

Thank you. This is noted. We'll reach out to Content Team for assistance.

Click below to post an Idea Post Idea