How to Import Adjusted and Unadjusted Prices with Power Query in WPS Office
Question details
The user wants to import adjusted and unadjusted stock prices from a financial website into WPS Office Power Query/Get Data and needs to identify the underlying data request when the visible page does not load directly.
- Product
- WPS Office Spreadsheets - Power Query/Get Data
- Device & OS
- not provided
- Scenario
- A user is trying to bring adjusted and unadjusted historical price data from a JavaScript-driven financial website into WPS Office for analysis and refreshable reporting.
- Observed behavior
- The browser displays the price table, but Power Query/Get Data cannot retrieve the displayed results because the page URL remains unchanged and the menu is controlled by JavaScript.
Open the financial website in a desktop browser and press F12 to open Developer Tools. Have a sample stock symbol and date range ready so you can capture the exact network request after you run a search.
Find the Financial Site's Data Endpoint and Import It into WPS Office
Use this when the visible price table does not appear in Power Query because the page menu is JavaScript-driven and the displayed URL stays the same.
Power Query and web import features cannot run JavaScript menus. They import a URL response. If a site updates prices without changing the visible page URL, the import still fails until you point Power Query or Get Data at the actual data request.
On the financial website, press F12 to open Developer Tools and select the Network tab. Keep this panel open while you use the site.
Enter a stock symbol and the adjusted or unadjusted price date range on the website, then click the Search or Query button so the browser creates data requests.
In the Network panel, filter by XHR/Fetch or search for keywords such as price, symbol, Data.aspx, HisseTekil, or the ticker. Select the request that returns the price JSON, CSV, or XML response.
Right-click the request and choose Copy > Copy link address. If needed, open the Response tab to confirm that it contains the adjusted and unadjusted price fields.
In WPS Spreadsheets, go to the Data tab, open the Get Data or Import Data drop-down, choose From Web, paste the copied endpoint, and confirm the import.
If the endpoint contains the symbol and date parameters, edit the URL in the data connection or query with the next symbol or date range, then refresh the table.
Download the Captured Response File and Import It When No Stable Endpoint Is Available
Use this if the site presents a one-time response, blocks direct URL import, or you only need a snapshot of adjusted and unadjusted prices.
Import Hidden Web Price Data with WPS Office Get Data/Power Query
WPS Office can load the same JSON, CSV, or XML endpoint you find in browser Developer Tools, so you can bring adjusted and unadjusted stock prices into a familiar spreadsheet and refresh them without paying for a large office suite.
- 1. Open WPS Spreadsheets: Launch WPS Office and create a blank spreadsheet.
- 2. Start a web data import: Go to the Data tab, click Get Data or Import Data, and select From Web.
- 3. Paste the identified endpoint: Paste the URL captured from the browser Developer Tools Network tab and click OK or Connect.
- 4. Set the query parameters: Replace the symbol and date values in the URL or connection dialog with the desired ticker and date range.
- 5. Load and refresh data: Load the data into a worksheet, then use Refresh to update prices when the endpoint is called again.
Frequently Asked Questions
Why does Power Query only see a blank webpage or no table from the financial site?
The site likely uses JavaScript to render the displayed menu and results while keeping the page URL unchanged. Power Query and WPS Get Data read the initial URL response, not the browser-rendered page, so you need to locate the underlying data request in Developer Tools.
How do I find the data endpoint for a stock symbol and date range?
Press F12, open the Network tab, submit the symbol and date range, filter by XHR/Fetch, and look for a request whose response contains the price data. Right-click that request and copy the link address to use in WPS Office.
Can I change the symbol and date parameters directly in the imported URL?
Yes, if the endpoint is stable. In WPS Spreadsheets, open the web data connection or Power Query/Get Data step, paste the endpoint, and edit the symbol and date parameter values in the URL or connection dialog before refreshing.
What programming language are the captured URLs written in?
They are not a programming language. They are web request URLs with query string parameters. The site may return data in JSON, CSV, or XML format, and those parameter values are simply text used by the website's data request.
What should I do if the site blocks automated import or the terms do not allow it?
Do not bypass access controls. Use a manual export or CSV download if the site provides one, or use an official data API or licensed data service that permits automated access.
