We have an Excel file called the Macro Weekly Calendar which is used weekly by our team at Frais Capital. The file pulls live data directly through Refinitiv Workspace Lite via the Excel add-in. The file contains four types of live data:
Economic indicators for Australia, United States and China — including macro data such as unemployment rates, GDP, inflation, jobless claims, PMI figures and central bank decisions, pulled via RIC codes with event dates, next dates and consensus figuresASX listed company earnings reporting calendar — including estimated earnings dates, current EPS, EPS forecasts, growth figures and forecast labels for a large number of ASX listed companiesUS listed company earnings reporting calendar — same structure as the ASX calendar but for US listed companies across major exchanges
Australian other events — including operational updates, production reports and activity reports for ASX listed companies
The file uses a backend data table which feeds into a front end weekly calendar view via FILTER and INDEX MATCH formulas. The weekly calendar displays events for the current week organised by day, with columns for Australia macro, US macro, China macro, ASX reporting and US reporting alongside consensus figures.
The problem is that every time the file is opened and content is enabled, Refinitiv Workspace begins fetching all of this data simultaneously which causes the file to take between 10 and 45 minutes to load. This makes the file very difficult to use on a weekly basis.We are looking for advice on how to reduce the loading time. We have already confirmed that our licence supports the LSEG Data Library API through Python and have successfully connected using lseg.data. We would like to know whether there is a way to either speed up the data refresh within Excel, or use the LSEG Python API to replicate the data pull and write static values into the file so it opens instantly.
