Python- workspace excel implementation
Hi Team,
Can you please answer two questions below?
1) Will new workflow (Python-Excel) implementation require additional payable data access licensing (for instance to data API licenses). If yes – then where can we find pricing?
2) Is there a way (please share some sample python file or reference) to initiate some “Updated” Event from data server in Python-Excel model (the same how it previously works with starting VBA macro on update) and will allow immediate update reaction on the client side without making regular requests from python to the server (which will use limited requests in DSWS API for Desktop version)?
Best Answers
-
Thank you for reaching out to us.
Please explain more about a new workflow (Python-Excel) implementation. Currently, we need to use a third library, such as Xlwings as a bridge between Python and Excel. Moreover, this forum is more for programming type queries, rather than pricing queries. Typicallly, the client can directly contact the LSEG account team or sales team for pricing.
Regarding the updated events from data server, it depends on the endpoints that can provide data. If the endpoints support request-response mechanisms, the application needs to send another request to get updated data. If the endpoints can provide streaming data (such as real-time pricing data), the application can provide the callbacks to retreive updated events.
1 -
Hello @Mark Lucio
If you interested in the Xlwings, there are articles that describe how to use the library with the Data Library version 1 as follows:
- How to integrate Financial Data from Data Platform to Excel with Xlwings - Part 1
- How to integrate Financial Data from Data Platform to Excel with Xlwings - Part 2
Note: The content above can be applied to LSEG Data Library (Data Library version 2) with the Workspace Desktop session too.
1
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 689 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 24 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 713 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛
