EXCEL DBI to Python
We have a excel spreadsheet that currently pulls back newly issued corporate bonds using DBI add-in within Excel. We now want to move this into Python, is anyone able to assist writing the code for us? Thanks
Best Answer
-
Hi @stephen.newell,
Would this video answer your demand by any chance?
https://developers.refinitiv.com/en/video-catalog/data-item-browser
0
Answers
-
Hi @stephen.newell ,
Do you mean using the Eikon Excel formula to retrieve the data? If so, could you please provide the Eikon Excel formula used so we could check if it's able to be replicated in the Python code?
0 -
Hi,
There is no formula, its from DBI excel add-in so the data currently is in a pivot table. We understand that we can get the data that feeds into the pivot that Eikon (DBI) has into Python.
Below is what some of the data looks like.
0 -
I'm afraid not, what we are looking for is can we pull data from DBI using python and if so how do we do that.0
-
We want to pull DBI data using Python and if we can do that how do we do that.
There is no excel formula as its DBI data which is in the pivot table format.
0 -
I was wondering if anyone can help with my question I posted:
EXCEL DBI to Python
We have a excel spreadsheet that currently pulls back newly issued corporate bonds using DBI add-in within Excel. We now want to move this into Python, is anyone able to assist writing the code for us?
I need to get my project moving forwards and I cannot find if we can pull DBI data using Python and if we can how do I do this?
0 -
Is it Deals Business Intelligence?
0 -
Yes that is the tool in Excel. We use this currently in Excel but want to move over to Python and wondering if we can pull all the Deals Business Intelligence (DBI) data into Python. Then we can get the Python code to do the filtering, calculations and aggregation for us. But we dont know if this is possible and if it is how do we do it?
0 -
@stephen.newell
Sorry. I am not familiar with this Excel add-in.
Please kindly contact the Refinitiv Workspace team directly via MyRefinitiv to verify if the data can be retrieved with Python or if the data is available on the Refintiv Data Platform.
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 中文论坛