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
