How to Automate Weekly Stock Data Updates in WPS Spreadsheets
Question details
The user needs to refresh stock information in a spreadsheet automatically each week by using an approved web query or a scheduled macro.

- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user maintains a workbook with stock data and wants it to update on a recurring weekly schedule without manually downloading or copying the data each time.
- Observed behavior
- Stock data should refresh automatically from an approved source on the selected weekday; sources that require authentication may not support unattended updates.
Verify that your stock data provider allows automated retrieval and that you can access the data without a login. If you plan to use a macro, save the workbook in a macro-enabled format so the code can run.
Use an Approved Web Query to Import and Refresh Stock Data
Best for most users because it uses a direct data connection and avoids custom code.
Only use stock data sources that permit automated access and do not require interactive authentication. Providers that require login or have restrictive terms may block unattended refreshes.
In WPS Spreadsheets, open the workbook and click Data > Import Data > From Web.
Type or paste the URL of the stock data source that allows automated retrieval, then click Go or Connect.
Select the table or data you want to import, choose a destination cell, and click Load.
After the data is imported, use the refresh option in the connection properties to set or confirm the update schedule. If a built-in schedule is not available, open the workbook weekly and click Data > Refresh All.

Run a VBA Macro to Schedule Weekly Stock Data Updates
Use this if you need a custom weekday schedule or want to automate the refresh through code.
Automate Stock Updates Directly in WPS Spreadsheets
Use WPS Spreadsheets to import stock data from an approved web source or run a weekly macro, with full compatibility for Excel workbooks and a familiar ribbon interface.
- 1. Download WPS Office: Go to the official WPS Office website and download WPS Office Free for your device.
- 2. Open your workbook: Launch WPS Spreadsheets and open the existing Excel workbook that contains your stock data.
- 3. Set up the data connection: Click Data > Import Data > From Web, enter the approved stock data URL, and load the data into the worksheet.
- 4. Configure the weekly refresh: Set the refresh schedule in the connection properties if available, or create a VBA macro that refreshes the data on the desired weekday.
- 5. Save the workbook: Save the file as .xlsx for a standard query or in a macro-enabled format for a macro-based schedule.

Frequently Asked Questions
Can WPS Spreadsheets automate weekly stock data updates?
Yes. Use Data > Import Data > From Web with an approved source, then schedule the refresh through connection properties or run a macro on the desired weekday.
Which stock data sources can I use for automated updates in WPS Spreadsheets?
Use sources whose terms allow automated access and that do not require interactive login. Public financial data pages or APIs that support direct queries are usually better candidates.
Does WPS Spreadsheets support Excel VBA macros for stock data updates?
WPS Spreadsheets supports many Excel VBA macros. Press Alt+F11 to open the editor, paste your trusted code, adjust the weekday setting, and run it from View > Macros > View Macros > Run.
Why does a stock data query fail when the website requires authentication?
Websites that require login or have terms restricting automated access may block unattended refresh. Choose an approved source that permits automated retrieval and does not require authentication.
How should I save a workbook that uses a stock update macro?
Save it in a macro-enabled format so the VBA code can run. Standard web queries can be saved as .xlsx.




