Ultimate Investing & Trading Templates
7 advanced investing & trading templates for Excel and Google Sheets.
Investment Portfolio Tracker
Fifty holdings, each with a sector as well as a ticker and a name, and each one's share of the whole portfolio. The Ultimate Investment Portfolio Tracker spreadsheet template records dividend per share, annual income and yield per position, shows each holding's share of total dividend income, and reports sector performance across the year in money and percentage terms. Six sheets. Google Sheets and Excel, one file. No macros, no VBA.
Capital Gains Calculator Ultimate
Fifty realised lots with shares, both dates, basis and proceeds, and a percentage return on each so positions of very different sizes can be compared. The Ultimate Capital Gains Calculator spreadsheet template derives days held and term from the dates, works out an effective rate across everything realised, tests the result against other rates on a sensitivity sheet, and keeps a wash sale tracker. Five working sheets. Google Sheets and Excel.
NPV & IRR Calculator
Three project sheets, pre-named as examples and yours to rename, each carrying fifteen years of cash flow and its own discount rate, so different risks are not held to one hurdle. The Ultimate NPV & IRR Calculator spreadsheet template shows the discount factor beside every year and ranks all three on value, rate of return, payback, profitability index and simple return. Seven tabs, sensitivity included. Google Sheets and Excel, one file. No macros, no VBA.
Stock Trading Journal Ultimate
Two hundred trade rows carry both prices together, so a result and a percentage return derive on each and different position sizes compare. The Ultimate Stock Trading Journal spreadsheet template breaks the record down by ticker with wins and win rate, by strategy with count and average return, and by month, keeps a strategy label and notes on every trade, and adds a risk sheet reporting what the record implies. Six working sheets and a chart, Google Sheets and Excel. No macros, no VBA.
Options Trading Journal Ultimate
A hundred and fifty positions, each carrying the date opened and the date closed, with entry and exit as total position values and the result and percentage return derived from them. The Ultimate Options Trading Journal spreadsheet template marks a position open by leaving the close date blank, keeps strategy and direction on dropdowns so the breakdowns stay consistent, and reports total, count, win rate, average result and average return per approach. Seven sheets, Google Sheets and Excel. No macros, no VBA.
Crypto Portfolio Tracker Ultimate
Fifty positions, each tagged with the wallet or exchange it sits on and a category, and a Transaction Log of a hundred lines carrying type, fee and venue. The Ultimate Crypto Portfolio Tracker spreadsheet template keeps regular buying on a DCA Tracker, holds forty purchase lots individually with their holding period and unrealised gain, and sets your actual allocation against the targets you set. Six working sheets. Google Sheets and Excel, one file. No macros, no VBA.
Dividend Tracker Ultimate
Thirty holdings with cost basis, current price, market value and yield, tagged by sector and payment frequency, set against a hundred rows of dividend history with a reinvestment marker on each. The Ultimate Dividend Tracker spreadsheet template spreads income across all twelve months on a sheet of its own, measures yield on cost against what you originally paid rather than today's price, and adds a DRIP calculator. Seven tabs. Google Sheets and Excel, one file. No macros, no VBA.
Looking for free templates?
We also offer free investing & trading templates with basic features. Try them first, then upgrade to Ultimate.