Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
REFINITIV
Question by Hiroaki.Yanagi · Jul 23, 2017 at 11:31 PM · apipythonpython apifundamental datafundamental

Missing fundamentals data via Python API

Can you please check the lack of Instrument Income Statement data of <4812.T> for FY 2015?

People who like this

0 Show 1
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Zhenya Kovalyov ♦♦ · Jul 24, 2017 at 04:08 AM 0
Share

@Hiroaki.Yanagi for content related questions please contact your local Thomson Reuters Support Desk

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by jirapongse.phuriphanvichai · Jul 25, 2017 at 05:29 AM

At first, we used this field: TR.ISOriginalAnnouncementDate which doesn't have data for 2015.

However, from the attached picture, it uses this field: TR.JPINCOriginalAnnouncementDate. You can use this code.

df, err = ek.get_data(['4812.T'], 
                      [ 'TR.JPINCOriginalAnnouncementDate'], parameters={'SDate':'2010-01-01', 'EDate':'2017-07-25'})

The result is:

  Instrument (JP) Income Statement Original Announcement Date
0     4812.T                                       2010-05-12
1     4812.T                                       2011-05-12
2     4812.T                                       2012-05-11
3     4812.T                                       2013-05-10
4     4812.T                                       2014-05-12
5     4812.T                                       2015-05-12
6     4812.T                                       2017-02-09

It doesn't have the data for year 2016. Please recheck this with the support team.

Comment
Hiroaki.Yanagi

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by jirapongse.phuriphanvichai · Jul 24, 2017 at 03:55 AM

@Hiroaki.Yanagi

I can retrieve TR.TotalRevenue, TR.CostofRevenueTotal and TR.GrossProfit of FY2015 properly with the following code.

df, err = ek.get_data(['4812.T'], 
       [ 'TR.TotalRevenue(Period=FY2015)','TR.CostofRevenueTotal(Period=FY2015)','TR.GrossProfit(Period=FY2015)'])
print(df)

If you are still unable to retrieve the Income Statement data, please share your snippet code.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Hiroaki.Yanagi · Jul 24, 2017 at 11:20 PM

Thank you for your reply. Can you please see the attached and check the Announce Date as well

python-api-fundamentals-annnounce-date-error.jpg


python-api-fundamentals-annnounce-date-error.jpg (98.7 KiB)
Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
jirapongse.phuriphanvichai ♦♦ · Jul 25, 2017 at 12:25 AM 0
Share

@Hiroaki.Yanagi

Eikon Excel also returns the same result.

Therefore, it is a content related question mentioned by Zhenya Kovalyov. Please contact Thomson Reuters Support Desk in order to verify the data.

4812t.png (8.2 KiB)
avatar image
REFINITIV
Answer by Hiroaki.Yanagi · Jul 25, 2017 at 05:03 AM

4812t.jpgCustomer Support says the following data item is available on Eikon Excel.

TR.JPINCOriginalAnnouncementDate

Can you please re-check this via Python API?


4812t.jpg (39.1 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by Hiroaki.Yanagi · Jul 31, 2017 at 09:15 PM

As I confirmed, the settling date of <4812.T> was changed in 2016, hence, the result is correct.

Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

Can't get quaterly data

get_timeseries doesn't start from the date I put - Eikon API python

ERROR in Data

HTTP or PYTHON APIs

Companies missing from historical ASX 100 data retrieved with Python API

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges