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

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

“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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

chavalit-jintamalit avatar image   chavalit-jintamalit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS

1 Answer

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

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 512.0 KiB each and 1.0 MiB total.

RizalieJean.Manayon avatar image RizalieJean.Manayon

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

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.