Can I get to know how to use Python API and then how to do batch downloads for company's financials?
Posting this query on behalf of client -
(email address: xxxxx )
Here's the client question:
I need to download data (balance sheet, income statement and cash flow) for many companies. I would be highly grateful if you could send me the Python codes of how to do same and how to connect using Refinitiv API for that task. Please let me know if there is another way to do this bulky download faster.
Best Answer
-
There are a lot of examples available in CodeBook.
The client can start with EX_01_04_01__Eikon_Data_API_Get_Data.ipynb in the /__Examples__/01. Data Retrieval & Discovery/01.04. Eikon Data API/ directory that demonstrates how to use the get_data() function to retrieve Fundamental & Reference data and Real-time Snapshot data from Eikon or Refinitiv Workspace.
You can specify the list of RICs and fields in the get_data method.
df, err = ek.get_data(['GOOG.O','MSFT.O', 'FB.O'], ['TR.Revenue','TR.GrossProfit'])
dfYou can also use the Data Item Browser (DIB) or Code Creator (CODECR) tool to search for available fields.
0
Answers
-
Hi Raksina, I already ask the client and will keep you posted once I hear from him. thankyou!
0 -
Can you please confirm the difference of the two? Eikon Data API or RDP API/libraries or others? Client mentioned that he is using API Python.
0 -
Client confirmed that it is for Refinitiv API.
0 -
Any updates on this please?
0 -
If the client has an Eikon or Workspace account, they can use Eikon Data API or CodeBook. There are a lot of Examples available in CodeBook that show how to use our APIs.
If the client doesn't have an Eikon account, it could be other products, such as Refinitiv Data Platform, or DataScope Select.
1 -
Hi,
Here's the follow-up question of the client
Can you show me a specific case where Python codes have been applied for downloading data on balance sheets for some companies without the need to do it manually?
Please advise
0 -
Any updates on this? Please advise.
0 -
Hi, would it be possible to contact the client directly to assist on his concern? I already advise him though to post here in Dev Forum but he still refused and wanted to be contacted..
0 -
@Gilhang.MayAnne
Please confirm the Refinitiv products or APIs that the client is using.
Python is a programming language. Several APIs, such as Eikon Data API, and Refinitiv Data Platform can use with Python.
If we don't know the product or API that the client is using, we are unable to provide a sample code.
Moreover, the client can also contact the Refinitiv account team or sales team directly for any further assistance. The account team can suggest the product or API that the client can use to retrieve the required data.
0 -
Hi,
The client is using Eikon with Codebook if you can help with a sample for that. Much appreciated
0 -
Hi,
Any updates on this please?
Thanks
0
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 370 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛