Investor Relations Dashboard in Google Sheets

Original price was: ₹1,699.00.Current price is: ₹999.00.
Details, requirements and demo below
Sale!

Investor Relations Dashboard in Google Sheets

Original price was: ₹1,699.00.Current price is: ₹999.00.

  • Six linked pages – Overview, Shareholders, Performance, Engagement, Search and Instructions, with a tab strip on every page.
  • 15 slicers across four analysis pages – filter by Month, Quarter, Investor Type, Region, Holder, Analyst Rating, Engagement Type, Sentiment and IR Officer.
  • 18 charts on native pivot tables – no helper formulas behind the visuals, so the file stays fast as your register grows.
  • 16 KPI cards – position value, shares held, net flow, average P/E, institutional value, holders on register, interactions and more.
  • Sidebar Top 5 panels – holders, regions, investor types and IR officers ranked by value, updating with the slicers.
  • Record lookup page – pick any Event ID and read all 16 fields of that IR record.
  • Auto-expanding to 1,000 rows – paste new records anywhere up to row 1001 and the whole dashboard follows.
  • 500 rows of demo data – a worked example you can study, then overwrite with your own register.
  • Editable theme – one palette block at the top of the script controls the slate, cyan and amber colours.
  • Instant download – a PDF with a Make a copy link that drops the sheet straight into your Google Drive.
Customize this template for your business (optional)

Handled by email: we contact you within 1 business day. One revision round included. What is included

- +
Have your own data? Build a dashboard from your Excel, CSV or Google Sheets file free in Dashboard Studio →
,

💡 Buy any 2 templates and save 20% automatically at checkout.

Included in All-Access Templates. Get this plus 7,000+ templates for ₹4,999.00 a year. Compare plans →
Pricing country
Prices follow your selected country; checkout uses your billing country.
Google Sheets Complete Course: Beginner to Advanced courseLaunch offer
🎓 NEXTGENTEMPLATES ACADEMY
Want to build Google Sheets like this yourself?
Google Sheets Complete Course: Beginner to Advanced

Formulas, lookups, QUERY, dynamic arrays, pivot tables, charts, live data and Apps Script, ending with an interactive sales dashboard. 74 lessons by PK with a practice file for every lesson.

The Investor Relations Dashboard in Google Sheets turns a shareholder register and an IR contact log into six linked pages you can read in one sitting. The sample file ships with 500 demo IR records covering 10 institutional holders, 5 regions, 8 IR officers and 7 engagement types, driven by 15 slicers and 18 charts that all read native pivot tables. Built by NextGenTemplates, whose spreadsheet templates reach 300,000+ subscribers across our YouTube channels. Pivots, slicers and formulas already cover 1,000 rows, so you paste your own register over the demo data and every chart redraws. Instant download, lifetime access, and a PDF with a one-click Make a copy link into your own Google Drive.

Every figure in the screenshots is sample data supplied for demonstration. This is a tracking and reporting template: it does not give investment advice and makes no regulatory or disclosure-compliance claims.

Key Features of the Investor Relations Dashboard in Google Sheets

  • Pivot-and-slicer architecture. Every chart reads a pivot table parked to the right of its page. Scroll past the spacer column and you can inspect the exact numbers behind any visual.
  • Per-page filter strips. Overview, Shareholders and Engagement each carry four slicers; Performance carries three. Clicking one redraws every chart, pivot and Top 5 panel on that page, and leaves the other pages untouched.
  • KPI cards that stay absolute. The four metric cards and the At a Glance list on each page use SUMIFS and COUNTIFS against the Data sheet, so they always show unfiltered totals as a reference point while the charts move with the slicers.
  • Four ranked sidebars. Top 5 Holders by Value, Top 5 Regions by Value, Top 5 Investor Types by Value and Top 5 IR Officers by Value, each paired with a share-of-total bar list.
  • A single-record lookup. The Search page takes an Event ID and returns all sixteen fields for that record, from holder and region through to sentiment and the IR officer who owned the interaction.
  • Room to grow. Pivots, slicers and formulas already reach row 1001, so pasting a longer register needs no re-ranging.
  • One-block theme. The slate ink, cyan accent and amber second-series colours live in one palette block, so rebranding is a three-value edit.

What’s Inside the Investor Relations Dashboard in Google Sheets

Overview – shareholder base, valuation and capital flows

The landing page carries four slicers (Month, Investor Type, Region, Analyst Rating) above four KPI cards: Total Position Value, Shares Held, Net Flow and Average P/E Ratio. Below them sit Position Value by Month, P/E Ratio vs Growth Rate, Ownership by Investor Type, Top Holders by Position Value, Average Share Price by Month and Net Flow Bridge by Quarter. The sidebar adds an IR Snapshot, a 12-month position value column strip, the top five holders and an analyst rating mix.

Overview page of the Investor Relations Dashboard in Google Sheets with KPI cards and six charts

Shareholders – register composition

This page answers who owns what. Register Metrics show institutional value, sovereign wealth value, holders on register and average position size. Value vs Shares by Investor Type puts value columns against a share-count line, Position Value by Region ranks the five regions, Region Value by Investor Type stacks the mix inside each region, and Shares Held by Holder ranks the register itself. Slicers cover Investor Type, Region, Holder and Month.

Shareholders page showing register composition by investor type, region and holder

Performance – share price, multiples and capital flow by period

Three slicers (Quarter, Analyst Rating, Holder) drive Average Share Price vs Position Value by Month, Net Flow by Month as a stepped area, and Average P/E by Analyst Rating. Valuation Metrics report average share price, peak share price, average growth rate and net inflow, while the sidebar breaks value down by quarter and lists the top five investor types.

Performance page showing share price trajectory, net flow by month and average P E by analyst rating

Engagement – IR outreach, sentiment and analyst coverage

The outreach page counts total interactions, earnings calls, positive sentiment share and one-on-one meetings, then breaks them down through Sentiment Mix, Interactions by Engagement Type, Interactions by IR Officer, Monthly Interaction Volume and Value vs Interactions by Analyst Rating. Slicers cover Engagement Type, Sentiment, IR Officer and Region, so you can isolate a single officer’s roadshow record in two clicks.

Engagement page showing IR interactions, sentiment mix and analyst coverage

Search – look up any IR record by Event ID

Choose an Event ID from the dropdown and the Record Details panel returns date, institutional holder, investor type, region, engagement type, analyst rating, position value, shares held, share price, P/E ratio, growth rate, net flow, sentiment, IR officer and month for that single row.

Search page returning the full record for one IR event ID

Instructions – a ten-step user guide

The last tab explains where the pivots live, how the slicers scope to a page, why the KPI cards stay unfiltered, how far the auto-expand reaches and which units the figures use. It is the page to read before you paste your own data.

Instructions page explaining the pivot table and slicer architecture

Investor Relations Dashboard in Google Sheets vs. Excel vs. Paid IR Software – Where This Fits

This template (Google Sheets)An Excel IR workbookPaid IR / CRM platform
Cost16.99 one-off (9.99 on sale)Similar one-off, plus an Office licenceTypically four figures a year and up
PlatformBrowser, any OSWindows or Mac desktopVendor web app
Setup timeCopy the sheet, paste your register – under an hourSimilar, once the file is downloadedOnboarding and data migration, often weeks
Real-time team collaborationNative, multiple editors at onceNeeds OneDrive or SharePointNative
Mobile accessGoogle Sheets mobile appExcel mobile appVendor app
Customisable fieldsAdd columns and pivot fields yourselfYesUsually vendor-controlled
Share with a linkYesFile or cloud linkSeat-based invitations
Year-1 cost at 5 users16.99 total16.99 plus licencesPer-seat subscription
Shareholder register viewBuilt in, sliced by type, region and holderBuilt inBuilt in, often with data feeds
Live market data feedNo – you supply the numbersNoUsually included

If you need a live pricing feed or automated regulatory filing, a paid IR platform is the right tool. If you keep your register and meeting log in a spreadsheet already and want it to read like a dashboard, this is the cheaper path.

Who This Template Is For – and Who It’s Not For

A good fit for: IR managers at listed mid-caps who report to a board every quarter; CFOs and finance leads at growth companies preparing an investor update; fund administrators and family offices tracking positions across a handful of holders; and consultants who build IR reporting packs for clients.

Not a good fit if: you need live share prices pulled automatically from an exchange; you are managing thousands of retail holders and need registrar-grade record keeping; you want automated regulatory filing or disclosure workflow; or you need audit trails and per-field permissions. This is a spreadsheet you control, not a compliance system.

How to Use the Investor Relations Dashboard in Google Sheets

  1. Open the PDF in your download and click the Make a copy link. The dashboard lands in your own Google Drive.
  2. Read the Instructions tab first – it takes two minutes and explains the pivot and slicer layout.
  3. Open the Data sheet and replace the 500 demo rows with your own register and IR log. Keep the column headers exactly as they are.
  4. Check your units. Position Value and Net Flow are in millions and Shares Held in thousands; change the headers and number formats if you prefer different units.
  5. Refresh the slicer lists if you added new holders, regions or IR officers, then click through the filter strip on each page.
  6. Use the Search page to spot-check a few records against your source system before you circulate anything.
  7. Recolour the palette block if you want the dashboard in your own brand colours, then share the file with view access to your board or leadership team.

Real-World Use Cases

Priya, IR manager at a listed industrials group. She keeps the register in the Data sheet and files each analyst call, roadshow and site visit as an IR record. Before each board meeting she filters the Engagement page to the current quarter and screenshots the sentiment mix and interactions-by-officer charts straight into the pack.

Daniel, CFO at a pre-IPO software company. He has no listed price yet, so he repurposes the share price column as a last-round valuation per share and uses the Shareholders page to show his board how concentrated the cap table has become by investor type and region.

Amara, analyst at a boutique advisory firm. She copies the template once per client, drops in their register, and uses the Top 5 Holders and Position Value by Region panels as the opening two slides of every quarterly review.

Frequently Asked Questions

Does this template give investment advice or price recommendations?

No. It is a tracking and reporting tool. It displays the numbers you enter and nothing more – no valuations are calculated for you, no recommendations are produced, and the analyst ratings are simply a field you record.

Are the numbers in the screenshots real?

No. All 500 rows are demo data generated to show the layout working. Delete them and paste your own register before you share the file with anyone.

Do I need Google Sheets add-ons or macros?

No. The dashboard uses only native Google Sheets features: pivot tables, slicers, charts and standard formulas such as SUMIFS and COUNTIFS.

How many records can it hold?

Pivots, slicers and formulas are pre-ranged to 1,000 data rows. You can paste new rows anywhere up to row 1001 without re-ranging anything. Beyond that, extend the pivot ranges once and the rest follows.

Why do the KPI cards not change when I click a slicer?

That is deliberate. The four metric cards and the At a Glance list use SUMIFS and COUNTIFS on the Data sheet so they always show the unfiltered total, giving you a fixed reference while the charts, pivots and Top 5 panels respond to the slicers.

Can I use it in Microsoft Excel?

The file is built for Google Sheets. Slicers and pivots do not translate cleanly on export, so if you work in Excel, look at our Excel dashboards instead.

Can I change the colours?

Yes. The theme is one palette block – a slate ink, a cyan accent and an amber second-series colour. Edit those three values and the whole dashboard follows.

About the Author

Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.

Explore Related Templates

Browse the full Google Sheets Dashboard category or the wider Google Sheets template library.

Ready to put your shareholder register on one screen? Add the Investor Relations Dashboard in Google Sheets to your cart and download it instantly – the PDF inside gives you a Make a copy link straight into your Google Drive. Read the full walkthrough on our blog: Investor Relations Dashboard in Google Sheets.

Watch the step-by-step video Demo:

Last updated: 14 August 2026.

Compatibility and Requirements

  • Works in Google Sheets. You need a free Google account and a web browser.
  • The dashboard uses native pivot tables, slicers, charts and standard formulas, so no add-ons or macros are involved. Google explains how charts work in Add and edit a chart or graph.
  • The file is built for Google Sheets and is not designed for Microsoft Excel.

Frequently asked questions

How do I get my own copy?
After purchase you get a link to the Google Sheet. Open it while signed in to your Google account and use File > Make a copy - the copy in your Google Drive is fully yours and editable.
Do I need a paid Google account? Will it expire?
No. A free Google account is enough, and your copy lives in your own Google Drive - it never expires and there is nothing to renew.
Does it work on Mac, phone or tablet?
Yes - in any browser on Windows, Mac or Chromebook, and in the Google Sheets mobile app for viewing and quick entries.
Can I share it with my team?
Yes. Share your copy with colleagues using Google's normal sharing, with view or edit rights as you choose.
Can I change the design and formulas?
Yes, your copy is fully editable - colours, labels, logo, formulas and charts. If a range is protected, use Data > Protect sheets and ranges to remove it in your copy.
Are there macros or add-ons?
No macros or add-ons - it uses normal Google Sheets formulas and charts.
Is it a one-time payment or a subscription?
One-time payment. No subscription, no per-user fees and nothing to renew - the file is yours to keep.
How do I get the file after payment?
Instantly. The download link appears on screen after checkout, is emailed to you, and stays under My Account > Downloads on our website. If the email does not arrive within a few minutes, check your spam or promotions folder.
Is a user manual included?
Most of our newer products include a PDF user manual in the download. If yours does not have one, message us with your order number and we will send it.
Do I get free updates?
Bug fixes are always free - if something does not work as described, we fix it and send you the corrected file. New versions with new features are not included in the price, unless this product's description says otherwise.
Can you customise it for me?
Yes. Small changes to this template (your columns, categories, logo, colours, minor layout) cost the template price plus $40-80 (Rs 3,000-6,000 + GST), quoted once you send your list. A fully custom build is usually $100-200 (Rs 8,000-18,000 + GST) with two revision rounds. Email your requirements to [email protected] or message us on WhatsApp.
Can I use it for my business or my clients?
Yes, for your own personal or internal business use, for as long as you like. Reselling or redistributing the template is not allowed.
What is your refund policy?
Because these are digital downloads, they are non-refundable once delivered - except when the product does not match its description (report it within 48 hours of purchase) or there is a technical problem our team cannot fix within 72 hours. Email [email protected] with your order number.
How do I get help?
Email [email protected] (Mon-Fri, 10 AM-7 PM IST) or message us on WhatsApp +91 80770 90260 (chat only, no calls). Please include your order number.

Still have a question? Click Need help? at the bottom-left to ask our assistant, or message us on WhatsApp.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

You may also like…

Investor Relations Dashboard in Google Sheets template coverInvestor Relations Dashboard in Google Sheets
Original price was: ₹1,699.00.Current price is: ₹999.00.
- +
Have your own data? Build a dashboard from your Excel, CSV or Google Sheets file free in Dashboard Studio →
Scroll to Top