Python- workspace excel implementation

Mark Lucio

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)?

Jirapongse

@Mark Lucio

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.