Others

How to Track Stock Investments in WPS Spreadsheets Without Microsoft Access

Khadija KhanKhadija Khan Nov 13, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Create the tracker workbook

Open WPS Office and choose WPS Spreadsheets. Create a new blank workbook and rename the first sheet to Transactions.

2
Set up tracker sheets

Add sheets named Securities, Accounts, Dividends, and Price History by clicking the plus icon next to the sheet tabs.

3
Define table columns

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.

4
Enter portfolio data

Enter your transaction and dividend records into the corresponding sheets, using one row per transaction or payment.

5
Calculate holdings and returns

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.

Build a Stock Investment Tracker in WPS Spreadsheets
Excel compatibility: Save the file as .xlsx to keep the tracker compatible with Microsoft Excel and other spreadsheet applications.
WPS Spreadsheets investment tracker

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. 1. Install WPS Office: Download WPS Office from the official WPS website and install it on your Windows PC.
  2. 2. Open WPS Spreadsheets: Launch WPS Office, click New, and select Spreadsheets to create the tracker workbook.
  3. 3. Create or import the tracker: Create tracker sheets manually or open an existing .xlsx stock tracker template in WPS Spreadsheets.
  4. 4. Enter your investment data: Add transactions, holdings, dividends, and price records into the respective sheets.
  5. 5. Save as Excel-compatible workbook: Save the file as .xlsx so it remains compatible with Microsoft Excel and WPS Office.
Free stock portfolio tracker with no Microsoft Access license requiredOpens and saves .xlsx files for Microsoft Excel compatibilityFamiliar spreadsheet interface reduces the learning curve from ExcelTables and SUMIFS formulas make holdings, dividends, and returns easy to calculateLightweight Office suite that runs on Windows and supports everyday investment tracking
microsoft office alternative - 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.