How can I use an excel macro to refresh Refinitiv/(DSGRID) formulas detect completion

Michael_B

Hi there,

I am working on creating a process that relies on data returned via DSGRID formulas. I am trying to build a macro that I can run using a python script that refreshes the formulas and returns/confirms when the data has actually been retrieved.
Looking at other posts, I've been able to find that the below line will trigger the refreshes.

Application.Run "PLRefreshWorkbookEventHandler" 

Is there a robust way to have the macro complete only when the data range thats expected to be populated by the formula is not blank?

Jirapongse

@Michael_B

Thank you for reaching out to us.

This forum is intended for software developers working with LSEG APIs. Calling an Excel macro from a Python script is outside the scope of our supported APIs, as we do not provide an API for this functionality.

As an alternative, you could use the Datastream Web Service (DatastreamPy within a Python script to retrieve the data, and then use xlwings to populate the data into Excel. For more details, please refer to the article Integrating LSEG Financial Data to Excel with Xlwings and Data Library - Part 1.

For further assistance with Workspace Excel macros, please contact the Workspace Excel Support team directly through LSEG Support.