Data Import & Export

How to Automate Weekly Stock Data Updates in WPS Spreadsheets

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 868 views

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.

How to Automate Weekly Stock Data Updates in WPS Spreadsheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the import tool

In WPS Spreadsheets, open the workbook and click Data > Import Data > From Web.

2
Enter the approved stock data URL

Type or paste the URL of the stock data source that allows automated retrieval, then click Go or Connect.

3
Load the data into the worksheet

Select the table or data you want to import, choose a destination cell, and click Load.

4
Refresh weekly

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.

Use an Approved Web Query to Import and Refresh Stock Data
Approved sources update reliably: Using a source that permits automated access is the most reliable way to get recurring stock data without manual copying.

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. 1. Download WPS Office: Go to the official WPS Office website and download WPS Office Free for your device.
  2. 2. Open your workbook: Launch WPS Spreadsheets and open the existing Excel workbook that contains your stock data.
  3. 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. 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. 5. Save the workbook: Save the file as .xlsx for a standard query or in a macro-enabled format for a macro-based schedule.
Weekly stock data refresh from approved sourcesSupports Excel-compatible .xlsx and macro-enabled workbook formatsFree and lightweight Office spreadsheet alternativeFamiliar ribbon UI for users switching from Microsoft Excel
microsoft office alternative - wps office

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.