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.
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'
}
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.
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)
@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.
@wasin.waeosri thanks a lot for your help.