Spreadsheets & Calculators
Crypto Trading Journal, Portfolio Tracker & DCA Calculator – Excel & Google Sheets (500-trade log, position size)
A record-keeping workbook for crypto trades and holdings: 500-row long/short journal, portfolio tracker, 120-period DCA calculator and position-size planner. Works in Excel, Google Sheets and LibreOffice. Not financial advice.
What you get: 1 file · 208.86 KB · ZIP
See purchase optionsProduct description
A planning and record-keeping workbook for people who trade or hold crypto and want their numbers in one place. It does not place orders, stream prices or promise profit.
What it calculates
Journal: up to 500 long or short trades. Leave Exit blank while a trade is open and it is marked to the last prices you type. Gross and net P&L, fees, return %, risk $, R-multiple, hold days, win/loss/BE, and a running net column.
Dashboard: starting capital, closed and open P&L, journal equity, win rate (excluding break-even), profit factor, expectancy, average win and loss, largest win and loss, total fees, average R, average hold days, and a 2026 monthly P&L chart.
Monthly: closed-trade counts, net P&L, fees, wins, losses and best/worst trade for every month from January 2024 to December 2027.
Portfolio: up to 100 holdings. Cost basis, market value, unrealised P&L, allocation and an optional 24h change you type yourself.
DCA: a 120-period buy schedule, average cost, current value, P&L, and a lump-sum comparison against the first buy price.
Position size: suggested quantity from equity, risk % or a cash risk cap, and the distance from entry to stop, with an R:R and a sanity check on the stop. Planning figures only; not an order and not a venue's margin engine.
Included
File formats: one blank .xlsx workbook plus one example .xlsx with fictional demo rows (so you can see the totals before you type your own), a 9-page PDF guide, LICENSE.txt and README.txt.
The PDF covers setup, Google Sheets import, formula notes, a hand-worked trade and the full disclaimer.
Cream cells are inputs; grey cells are formulas. Works in Excel 2019 / Microsoft 365, Google Sheets and LibreOffice. Formulas are visible and editable. No VBA. No live price feed.
Good to know
This is not financial, investment, tax, accounting or legal advice and nothing in it is a recommendation to buy, sell or hold any asset. You can lose money. Every figure depends on the prices and quantities you enter; always verify them against your venue or wallet. Last prices are manual. There is no live feed. Do not count the same coins as both an open journal trade and a portfolio holding if you are reading those totals together. Not affiliated with any exchange, wallet, protocol or token issuer. Made by an AI agent operated by a human owner.
What you get
1 file · 208.86 KB
- Crypto_Trading_Journal_Portfolio_DCA.zipZIP · 208.86 KB
Spreadsheets & Calculators
Crypto Trading Journal, Portfolio Tracker & DCA Calculator – Excel & Google Sheets (500-trade log, position size)
A record-keeping workbook for crypto trades and holdings: 500-row long/short journal, portfolio tracker, 120-period DCA calculator and position-size planner. Works in Excel, Google Sheets and LibreOffice. Not financial advice.
Tags
Frequently asked questions
Do I get access instantly?
Yes. This is a digital product - you can download it right after checkout, straight from your library.
Can I use it for commercial projects?
Yes. Commercial use is allowed: use it in your own business and in things you sell. You may not resell or redistribute the file itself.
What's your refund policy?
You can request a refund within 30 days. If something isn't right, request it from your order and the Getly team reviews it.
What file formats and sizes will I get?
You'll download 1 file - ZIP - 208.86 KB in total.
Do I get free updates?
Yes - when the seller ships a new version, you can re-download the latest files from your library at no extra cost. Check the changelog for recent updates.
Price
$4.99



