Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • TRKD /
avatar image
Question by vijay.singh · Nov 06, 2020 at 07:53 AM · rkd-apihistoricalrkdfundamentals

how to get historic fundamental-financial data for more than 6 years using TRKD api

@wim.ooms, while searching answer for this question I came across query-7638. It says that "GetFinancialStatementsReports_1" provide the mentioned data. Could you please let me know how we can run this API on the webpage here.

https://www.trkd.thomsonreuters.com/SupportSite/TestApi/Op?svc=Fundamentals_1&op=GetFinancialStatementsReports_1


Also does it require additional permission than "Get Financial Statements Reports " API. I already have the access to "Get Financial Statements Reports" but getting error-500 while calling the API in python environment.


api_url = 'http://api.trkd.thomsonreuters.com/api/Fundamentals/Fundamentals.svc/REST/Fundamentals_1/GetStandardFinancials_1'

# company_id = 'IBM.N'
message_request = {
    'GetStandardFinancials_1': {
        'companyId': company_id,
        'companyIdType': 'RIC'
    }

People who like this

0 Show 0
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.

4 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by wasin.w · Nov 09, 2020 at 09:36 AM

Hello @vijay.singh

I am not a data expert but you can download the Fundamental data coverage guide document in the RKD API --> Fundamentals service --> Coverage button to check if your interested data is available in the service or not.

If you have more questions regarding RKD data coverage, I strongly suggest you contact RKD team directly via http://my.refinitiv.com/ web site.

You can check the service's features, query parameter in the service's Developer document.



fundamental-1.png (136.2 KiB)
fundamental-2.png (204.8 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 wasin.w · Nov 06, 2020 at 10:21 AM

Hello @vijay.singh

Do you want to request "Standard Financials" or "Financial Statements Reports" service?

If you want to request "Standard Financials", please see the service detail (request message, URL endpoint, data coverage, etc) in RKD - Fundamental Standard Financials page. The Standard Financials requires a different request message structure from Financial Statements Reports.

Your message_request data is a request message of "Financial Statements Reports" service, not "Standard Financials".

Please see an example code below:

message_request = {
        "GetStandardFinancials_Request_1": {
        "companyId": "IBM.N",
        "companyIdType": "RIC",
        "finStatement": "AIS",
        "startFY": 0,
        "endFY": 0,
        "fpNumber": 0,
        "updateType": "MostRecent",
        "completeStatement": "AllStatements",
        "finalFiling": "AllFilings",
        "lang": "en-US"
     }
    }
api_url = 'http://api.rkd.refinitiv.com/api/Fundamentals/Fundamentals.svc/REST/Fundamentals_1/GetStandardFinancials_1'

headers = {'content-type': 'application/json;charset=utf-8',
               'X-Trkd-Auth-ApplicationID': appid, 'X-Trkd-Auth-Token': token}

requests.post(api_url, data=json.dumps(message_request ), headers=headers)

rkd-standard-financial.png (43.6 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
Answer by vijay.singh · Nov 06, 2020 at 01:30 PM

@wasin.waeosri thanks a lot for your response. Currently I am using "Financial Statements Reports" api. But I also required the historic financial data(beyond recent 6 years).

Can you please tell if the data provided by "Standard Financials" have the same set of features as "Financial Statements Reports". Also is there any catalogue from where I can see the available features in "Standard Financials" without taking access to this API.

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
Answer by vijay.singh · Nov 09, 2020 at 01:11 PM

@wasin.waeosri thanks a lot for your help.

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

How do I get more than 5 years of fundamental data from the TRKD API?

GetStandardFinancials_Request_1 Historical data (TRKD API)

Erro while invoking "GetInterdayTimeSeries_2" method - "The remote server returned an error: (500) Internal Server Error."

trkd GetInterdayTimeSeries_4 slow

Python code Industry Classification TRKD

  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Electronic Trading
    • Generic FIX
    • Local Bank Node API
    • Trading API
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Intelligent Tagging
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open Calais
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • RDMS
  • 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
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • Workspace SDK
    • Element Framework
    • Grid
  • World-Check Data File
  • 中文论坛
  • Explore
  • Tags
  • Questions
  • Badges