
Google Sheets Templates


Portfolio Tracker (App Script)
Real-time crypto portfolio tracker with automated price refreshes using importJSON App Script
Portfolio Tracker (No-code)
Can't code? We got you. This guide fetches real-time crypto prices using the API Connector GSheet Extension
Tax Calculator
Calculate capital gains, track cost basis, and organize all your trades in one spreadsheet


Trading Journal
Track trades, calculate profit and loss (PnL) and analyze your performance in real-time


Exit Strategy Planner
Stimulate various exit scenarios to decide when to sell and how much crypto to hold


Staking Rewards Calculator
Log your staking positions to calculate the effective APY, project future earnings, and analyze performance

Excel Templates


Portfolio Tracker
Get a complete view of your crypto portfolio performance with automated profit and loss tracking


Trading Journal
Stay disciplined by logging, tracking and analyzing your trades


Tax Calculator
Simplify crypto taxes with this template that calculates your capital gains or losses using the FIFO method


Exit Strategy Planner
Model various exit scenarios tailored to your financial goals and risk appetite


Import Crypto Data


Import Crypto Prices
Import real-time and historical crypto prices with CoinGecko API and an API Connector


Export OHLC Data
Download OHLC and OHLCV data to XLSX & CSV using Python, Excel and Google Sheets


Import Stocks & Crypto Prices
Import real-time crypto and stocks price data on Microsoft Excel


Import Crypto Prices
Fetch live and historical crypto prices into Microsoft Excel with CoinGecko API














