rdp.get_data() returns N/A for Canadian symbols
Below get_data function works fine for LSEG and AAPL but returns <NA> for BMO.TO. I wonder if there are no "Revenue" and "GrossProfit" feeds for Canadian stocks.
import refinitiv.dataplatform as rdp
rdp.get_data(
universe=["LSEG.L", "BMO.TO","AAPL.O"],
fields=["TR.Revenue", "TR.GrossProfit"]
)
Best Answer
-
I would like to share a resolution from the content support team.
BMO.TO (Bank of Montreal) or other banks or financial institutions would not have any records for fields TR.Revenue and TR.GrossProfit since they don't sell goods or services.
In order to pull the same information, we need to use the fields TR.InterestIncomeBank and TR.NetInterestIncome.
0
Answers
-
hi @yzhou ,
according to this answer from my colleague
If the same code is working for many other RICs and not yielding data for certain RICs, then this is most likely a content issue.
I would recommend you create a content query ticket on MyRefinitiv to discuss your requirements. They may be able to advise if the required data is available in a different field for those particular RICs. For this case, case number 11341856 was raised on your behalf and the support team is going to contact you directly to assist on this.
Whilst we do try to normalise our data, we carry 80million RICs from 10,000+ sources - and sometimes there can be differences based on the source of data/asset class etc.
0
Categories
- All Categories
- 6 AHS
- 37 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
- 367 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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛