Extracting Deals using API not possible at all
I am referring to this thread I opened quite a while ago: https://community.developers.refinitiv.com/questions/88111/extracting-deals-wont-working-anymore-when-using-f.html?childToView=88561#answer-88561
The support got in touch with me and told me that a team would take care of the bug over the weekend of the 17. and 18. December. Since this weekend, extracting deals using the API doesn't work for some time periods at all. Even though I do understand that fixing the error may take a long time, the API has been useless to me for almost a month now.
The Support did a good job, keeping me updated and told me that the developer team found some issues during the testing and wasn't able to fix the bug.
Using the following code, extracting deals works just fine for the period given (01/01/1990 to 31/12/2002).
criteria = "SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), \
BETWEEN(TR.MnAAnnDate,19900101, 20021231)/*dt:Date*/, \
IN(TR.MnAStatus,""C""), \
TR.MnADealValue(Scale=6,IncludeNull=False)>=1, \
IN(TR.MnAFormType,""A"",""AA"",""AC"",""AM"",""AR"",""M""), CURN=USD)"
display = ["TR.MnASDCDealNumber",
"TR.MnAAnnDate",
"TR.MnAAcquiror",
"TR.MnATarget",
"TR.MnAAcquirorNation",
"TR.MnATargetNation",
"TR.MnADealValue",
"TR.MnAAcquirorPublicStatus",
"TR.MnATargetPublicStatus",
"TR.MnAStatus",
"TR.MnAPctOfSharesOwnedPostMerger",
]
deals, er =ek.get_data(criteria,display,debug=True)
However, if I am about to change the time period (01/01/1990 to 31/12/2010), I receive a useless output:
Also, when I change back the time period to 31/12/2002 for example, the code won't work either and gives back the empty df.
Answers
-
hi @flammers
This question appears to be a duplicate of this previous discussion thread
0 -
@flammers I believe the reason your call is not working is because of data limits. The Screener query you posted is returning over 85,000 deals and then 12 fields for each deal from 1990 to 2002. That you want to increase this date out further to 2010 is even further over the limits so you must expect it to fail. The limit (please familiarise yourself with this document as a number of throttles are in operation) for the get_data API is around 10,000 datapoints per API call as opposed to the over 1 million datapoints you are requesting. I suggest you reduce the date range to annual or monthly ie you make 1 separate API call for each year or month in your daterange. You can then append them together to get the larger dataframe you wish to use. You can check to see the size of the universe returned using the SCREENER app in Eikon. I hope this can help.
1
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 中文论坛