The Stock Exchanges Dashboard in Google Sheets turns a trade log into four slicer-driven analysis pages (Overview, Listings, Trading and Sectors), plus a Trade ID Search page and a built-in Instructions sheet. It ships with 500 fictional sample trades dated 2024, covering 10 exchanges, 60 listed companies, 10 sectors and 6 instrument types. Those trades feed 16 KPI cards, 18 chart panels and 15 slicers.
🌍 Built by NextGenTemplates, the team behind thousands of ready-to-use Excel, Google Sheets and Power BI templates that replace recurring software fees with a one-time purchase.
✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access
⚠️ This is a reporting template filled with fictional sample data. It has no live market data feed and places no orders. It is not a trading, market-surveillance or listing-compliance system, it makes no exchange-rule or regulatory claim, and nothing in it is investment advice.
🔑 Key Features of the Stock Exchanges Dashboard in Google Sheets
📊 Four analysis pages, each with its own slicers. Overview filters by Month, Exchange, Sector and Instrument Type. Listings filters by Exchange, Listing Tier, Instrument Type and Region. Trading filters by Order Type, Broker and Status. Sectors filters by Sector, Region, Month and Exchange. Slicers work per page, so each view keeps its own filters.
💹 16 KPI cards across the four pages. Total Turnover ($M), Listed Companies, Shares Traded, Avg Trade Size, Main Board Listings, ETF Turnover, Premium Tier Trades, Instrument Types, Total Trades, Block Trade Value, Settled Trades, Failed Rate, Tech Turnover, Sectors Traded, Net Mkt Cap and APAC Turnover.
🧭 A sidebar on every analysis page. Each sidebar has snapshot ratios, a 12-month turnover trend and a Top 5 table (exchanges, companies, brokers or sectors by turnover). It also has a mix panel with percentage bars, an At a Glance list and a 12-month trade volume line.
⚙️ Native pivot tables and slicers. Every chart reads a pivot table parked to the right of its page. No helper formulas sit behind the charts, so the file stays quick as your trade log grows. You can scroll right to inspect the numbers behind any chart.
🔎 Trade-level Search page. Pick any Trade ID to read its 16-field record: date, exchange, sector, instrument type, company, listing tier, turnover, shares traded, avg trade size, broker, order type, status, region, month and market cap change.
📈 Auto-expands to 1,000 rows. Pivots, slicers and formulas already cover the Data sheet down to row 1001. Paste new trades and the whole dashboard updates on its own.
📦 What’s Inside the Stock Exchanges Dashboard
Page 1: Overview (Global Market Performance)
The KPI cards show Total Turnover ($15,636M in the sample), Listed Companies (60), Shares Traded (92,455,266) and Avg Trade Size ($26,538). Charts include Avg Daily Trading Volume by Month, Market Cap Bridge by Sector, Turnover by Sector, Trade Size Distribution, Listed Companies by Exchange and Turnover by Instrument Type. The sidebar lists the Top 5 Exchanges by Turnover and a Trade Status Mix (Settled, Pending, Partial fill, Cancelled).
Page 2: Listings
This page covers listing tiers, the instrument mix and regional spread. KPI cards show Main Board Listings, ETF Turnover, Premium Tier Trades and Instrument Types. Charts include Listed Companies by Listing Tier, Turnover by Exchange and Instrument, Listed Companies by Region, and Shares Traded vs Turnover by Company. The sidebar ranks the Top 5 Companies by Turnover and shows Instrument Turnover Share.
Page 3: Trading (Order Flow)
This page looks at monthly turnover, trade size and the order-type mix. KPI cards show Total Trades (500), Block Trade Value, Settled Trades and Failed Rate. Charts include Monthly Turnover vs Trade Count, Average Trade Size by Month and Trades by Order Type (Algorithmic, Block Trade, Iceberg, Limit, Market, Stop-Loss). The sidebar ranks the Top 5 Brokers by Turnover and shows the Order Type Mix.
Page 4: Sectors
This page covers sector turnover, momentum and regional weighting. KPI cards show Tech Turnover, Sectors Traded, Net Mkt Cap and APAC Turnover. Charts include Trades by Sector, Monthly Turnover Trend, Turnover by Broker, Sector Turnover by Region, and Sector Turnover vs Shares Traded. The sidebar ranks the Top 5 Sectors by Turnover and shows Regional Turnover Share.
Page 5: Search
Choose a Trade ID (TRD-0001 onwards) to see its full 16-field trade record in one panel. It is useful for checking a single row without opening the Data sheet.
Page 6: Instructions
A 10-step user guide explains the pivot-and-slicer design and how to clear slicers. It also explains why KPI cards show unfiltered totals, how to replace the sample rows, and how currency formats work (turnover and market cap change in USD millions).
📊 Stock Exchanges Dashboard in Google Sheets vs. Microsoft Excel Dashboard vs. Paid BI Platforms: Where This Fits
| Feature | Stock Exchanges Dashboard in Google Sheets | Microsoft Excel Dashboard | Paid BI Platforms (Tableau / Looker Studio Pro) |
|---|---|---|---|
| Cost | ✅ $9.99 one-time | Template fee plus a Microsoft 365 or Office licence | Recurring per-user subscription |
| Platform | ✅ Google Sheets in any browser | Excel desktop or Excel for the web | Vendor web app, often with desktop authoring |
| Setup time | ✅ Minutes: make a copy, paste your trade log | Minutes, then share the file separately | Data connections, modelling and licences first |
| Real-time team collaboration | ✅ Built into Google Sheets | Co-authoring through OneDrive or SharePoint | ✅ With paid seats |
| Mobile access | ✅ Google Sheets app | ✅ Excel mobile app | ✅ Vendor mobile app |
| Customizable fields | ✅ Edit headers, pivots and colours yourself | ✅ Editable | Needs a report author |
| Share with link | ✅ View-only or edit link | Through OneDrive links | Depends on licence tier |
| Year-1 cost at 5 users | ✅ $9.99 total | Licence per user | Per-seat fees × 5 users × 12 months |
| Live market data feed | ❌ No. You paste your own records | ❌ No | ✅ Through paid connectors and data vendors |
| Trade ID search page | ✅ Included | Depends on the template | Custom build |
If you want exchange, listing and order-flow reporting from your own trade records without paying per seat, this template is a good fit. If you need live quotes, choose a data vendor instead.
👥 Who This Template Is For, and Who It’s Not For
✅ This template is built for:
- 📌 Brokerage and back-office reporting teams that export a trade log and want settlement status, broker turnover and order-type views in one file
- 📌 Finance lecturers and students who need a realistic, fictional exchange dataset to teach turnover, listing tiers and instrument mix
- 📌 Market-data and fintech analysts who want to prototype an exchange-comparison report before building it in a BI tool
❌ This template is NOT for:
- 📌 Anyone who needs live or delayed stock quotes. The template has no market data connection
- 📌 Order execution, trade surveillance, listing-rule compliance or regulatory reporting
- 📌 Choosing investments. It summarises records and gives no buy, sell or return guidance
⚙️ How to Use the Stock Exchanges Dashboard in Google Sheets
- Buy and download the PDF guide, then click its Google Sheets link to make your own editable copy in Google Drive.
- Explore the sample data on the Overview page and try each slicer in the FILTERS strip.
- Replace the sample rows on the Data sheet with your own trades, keeping the same column headers.
- Add rows up to row 1001. Pivots, slicers and charts pick them up automatically.
- Use the Listings, Trading and Sectors pages to filter by tier, broker, status, sector or region.
- Open the Search page and pick a Trade ID to review any single record.
- Share a view-only link with colleagues who only need to read the dashboard.
💼 Real-World Use Cases
Daniel runs reporting for a small brokerage back office. Each month he pastes the exported trade log into the Data sheet. He then checks the Trade Status Mix and failed-trade count, and reviews the Top 5 Brokers by Turnover before the operations meeting, all without a new software subscription.
Priya teaches a capital-markets module at a business school. She shares a copy with her class so students can filter the fictional sample by exchange and instrument type. They then explain why ETF and common-stock turnover differ across regions.
Mei is an analyst at a fintech startup. She uses the Sectors page to mock up a sector-and-region turnover report for stakeholders. Once the layout is agreed, she rebuilds it on the company’s data platform.
❓ Frequently Asked Questions
What does the Stock Exchanges Dashboard in Google Sheets track?
It tracks turnover, listed companies, shares traded, trade size, listing tiers, order types, settlement status, brokers, sectors and regions across 16 KPI cards and 18 chart panels. The sample holds 500 fictional trades from 10 exchanges, and every chart updates when you paste your own records.
Does the dashboard pull live stock prices or market data?
No. The Stock Exchanges Dashboard has no live market data feed and does not connect to any exchange. It reports only on the trade records you paste into the Data sheet, which ships with fictional sample data.
How long does setup take?
Most people are running in under 10 minutes. Make a copy from the PDF link, paste your trades into the Data sheet with the same headers, and the pivots, slicers and charts refresh automatically for up to 1,000 rows.
Why don’t the KPI cards change when I use a slicer?
By design, the KPI cards and At a Glance lists use SUMIFS and COUNTIFS on the Data sheet, so they always show unfiltered totals. The charts, pivot tables and Top 5 panels respond to the slicers on their page.
How does it compare to Tableau or other paid BI platforms?
Paid BI platforms add live connectors and enterprise governance but charge per user every month. This template costs $9.99 once, runs in Google Sheets and suits teams that report from exported trade logs rather than streaming data.
Is this a trading, compliance or investment advice tool?
No. The Stock Exchanges Dashboard in Google Sheets is a reporting template. It does not place orders, monitor market abuse, check listing rules or give investment advice, and it makes no return promises.
👤 About the Author
Built by PK, a Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. PK is the founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PKAnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.
🔗 Explore Related Templates
📈 Investment Management Dashboard in Google Sheets reports on portfolio and fund-level activity with the same slicer-first approach.
🏦 Investor Relations Dashboard in Google Sheets reports shareholder engagement and IR activity.
💼 Stock Portfolio Tracker in Google Sheets is a one-page tracker for recording your own holdings.
🔁 Separate KPI-dashboard builds on the same topic (month-picker scorecards, not these pages): Stock Exchanges KPI Dashboard in Excel and Stock Exchanges KPI Dashboard in Power BI. Also see the Stock Brokerage KPI Dashboard in Excel.
🗂️ Browse all Google Sheets Dashboards or the full Google Sheets template collection. New to the tools behind this file? Google’s guides to pivot tables and slicers cover the basics.
📖 Click here to read the Detailed Blog Post
🎥 Visit our YouTube channel for step-by-step video tutorials
👉 YouTube.com/@NextGenTemplates
Watch the step-by-step video Demo:
📅 Last updated: September 2026
