Eikon Data API (Python) - Bid/Ask price and volume by broker and day
Hello,
I want to download daily data (bid/ask prices and volumes e.g.) by broker as it can be seen in the web application when using the plattform "BROKER STATISTICS (NEW) BRKST" (Broker by Market or Broker by Symbol). I want to use Python through the "Eikon"-API and I got it to work in order for me to download data on individual stocks or forex data. (e.g. using "eikon.get_data")
In the end I want to aggregate the data by the classification of "retail broker" and "non-retail broker" using an existing definition. The resulting data set should have the bid/ask (weighted average) price and volume per day and per "broker type".
Could anyone tell me how to access bid/ask data by broker (and day/time window) via the Eikon Data API (Python)?
Thank you very much for your time and help!
Best Answer
-
Hi @programs.office,
I just found a way around using estimates, but please note that this will only work for those RICs for which data is available, and it will not work for every RIC:
import refinitiv.dataplatform.eikon as ek
ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')
df, err = ek.get_data(["AAPL.O"],fields=["TR.EPSEstValue.BrokerName", "TR.OPENPRICE", "TR.CLOSEPRICE", 'TR.HIGHPRICE',
'TR.LOWPRICE', 'TR.VOLUME', 'TR.EPSEstValue.Date'], parameters = {'SDate':'2022-04-01','EDate':'2022-04-11','Curn':'USD', 'Frq':'D'})Let me know if this is helpful and if this is what you were looking for
0
Answers
-
Hi @programs.office,
Hope you are doing well and having fun using Eikon,
Regarding your query, I connected with the support team and product specialist and they confirmed that broker statistics data is only available via the Eikon desktop. Since API works similarly to Eikon excel, we need to have the data items in order to pull the data. The financial modelling team have confirmed that they are unable to pull it in Eikon excel it would be the same case in Eikon API.
You may wait for some expert developers to get an answer if there is a workaround given but I am not so sure since we do not have the data item to pull the data as well as the identifiers to use. In order for us to pull the data in Eikon excel or in API, we do need the ISIN, RIC or similar identifiers
Also as this forum is dedicated to software developers using Refinitiv APIs and the moderators on this forum do not have deep expertise in every bit of content available through Refinitiv products, which is required to answer content questions such as this one. The best resource for content questions is the Refinitiv Helpdesk, which can be reached by either calling the Helpdesk number in your country or submitting a new ticket to the support team via MyRefinitiv.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
- 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
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛