How to Track Stock Investments in WPS Spreadsheets Without Microsoft Access
Question details
The user wants a practical Microsoft Access template or alternative method to track stock investments, including transactions, securities, prices, dividends, and portfolio holdings.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user wants to monitor stock investments and portfolio performance in a structured, reusable tracker instead of tracking it manually.
- Observed behavior
- The goal is to maintain transaction, securities, account, dividend, and price history data in one structured tracker that calculates current holdings and returns.
Gather your investment records such as transaction dates, symbols, quantities, purchase prices, and dividend payments. If you already have an Excel stock tracker or CSV, keep it ready to open in WPS Spreadsheets.
Build a Stock Investment Tracker in WPS Spreadsheets
Best for most users who want a free, Excel-compatible tracker without needing a Microsoft Access database.
WPS Spreadsheets can open .xlsx templates and create a relational-style tracker using separate sheets for transactions, securities, accounts, dividends, and price history. This approach gives you the core calculations of an Access stock database with less setup.
Open WPS Office and choose WPS Spreadsheets. Create a new blank workbook and rename the first sheet to Transactions.
Add sheets named Securities, Accounts, Dividends, and Price History by clicking the plus icon next to the sheet tabs.
In each sheet, enter column headers such as Date, Symbol, Quantity, Price, Fees, Account, and Dividend Amount. Select the header row, open the Insert tab, and choose Table to format the range as a table.
Enter your transaction and dividend records into the corresponding sheets, using one row per transaction or payment.
Use formulas such as SUMIFS to calculate current holdings, cost basis, dividend income, and return. For example, =SUMIFS(Transactions[Quantity],Transactions[Symbol],A2) totals quantity for a symbol.

Use an Excel Stock Tracker Template in WPS Spreadsheets
Use this if you want a ready-made structure and prefer to adapt an existing Excel template instead of creating sheets manually.
Use WPS Spreadsheets as a Free Stock Investment Tracker
Instead of waiting for a Microsoft Access template, build or open an Excel-compatible stock tracker in WPS Spreadsheets. You can track transactions, holdings, dividends, and returns with familiar tables and formulas, without paying for a database application.
- 1. Install WPS Office: Download WPS Office from the official WPS website and install it on your Windows PC.
- 2. Open WPS Spreadsheets: Launch WPS Office, click New, and select Spreadsheets to create the tracker workbook.
- 3. Create or import the tracker: Create tracker sheets manually or open an existing .xlsx stock tracker template in WPS Spreadsheets.
- 4. Enter your investment data: Add transactions, holdings, dividends, and price records into the respective sheets.
- 5. Save as Excel-compatible workbook: Save the file as .xlsx so it remains compatible with Microsoft Excel and WPS Office.

Frequently Asked Questions
Does WPS Office have Microsoft Access or an Access template gallery?
No. WPS Office does not include an Access database application. Use WPS Spreadsheets with .xlsx templates or create a multi-sheet stock tracker with tables and formulas instead.
Can WPS Spreadsheets open Excel stock tracker templates?
Yes. WPS Spreadsheets can open most .xlsx stock portfolio templates. Templates that depend on Microsoft 365 Stocks or Geography data types may not refresh current prices in WPS Office.
How do I calculate total holdings and returns in WPS Spreadsheets?
Use formulas such as SUMIFS to total quantities and costs by symbol, then compare current price or market value against cost basis to calculate unrealized return.
Can I import my existing transactions into WPS Spreadsheets?
Yes. Save your transaction history as CSV or .xlsx, open it in WPS Spreadsheets, and copy the rows into the relevant tracker sheet, keeping column headers consistent.
Is WPS Spreadsheets free for tracking stock investments?
Yes. You can download WPS Office free and use WPS Spreadsheets to create, edit, and save Excel-compatible investment trackers on Windows.




