Crypto Trading Journal & Wallet Tracker Spreadsheet (Excel + Google Sheets)
Most traders mean to keep a journal and stop after a week, usually because working out the numbers by hand gets tedious. This spreadsheet does that part for you. Log a trade in one row and the P&L, R-multiple, hold time and dashboard all update on their own.
The Trade Log has 300 rows with dropdowns for chain, wallet, strategy, setup, emotion and mistake. Enter your entry, planned stop, size, exit and fees, and it calculates P&L in dollars and percent, your planned risk, the R-multiple and the hold time. The Dashboard turns those rows into win rate, average win and loss, profit factor, expectancy, largest win and loss, and current equity against your starting bankroll. It also breaks P&L down by strategy, setup, chain and mistake tag, and draws an equity curve and a monthly P&L chart.
You also get a Wallet Tracker for your hot, cold and burner wallets (it includes a balance check against what you see on-chain), with a watchlist for wallets you follow. There's a Position Sizing calculator that sizes a trade from your entry, stop and risk %, a Weekly Review with reflection prompts, and a Monthly Summary. Five example trades marked "EXAMPLE - delete" show the formulas working before you add your own.
This is a record-keeping and self-review tool. It reports the numbers you enter. It doesn't predict prices, recommend trades or promise any result. Not financial advice. Crypto, and memecoins especially, is high-risk, and you can lose everything you put in.
What's inside
• Trade Log (300 rows): auto P&L $ and %, planned risk, R-multiple, hold time and open/closed status, plus dropdowns and green/red highlighting
• Dashboard: win rate, avg win/loss, profit factor, expectancy, largest win/loss, equity vs starting bankroll, P&L by strategy, setup, chain and mistake, a monthly P&L table, an equity curve and a monthly chart
• Wallet Tracker: wallet label, address, chain, purpose, deposits and withdrawals, calculated balance vs on-chain balance, and a tracked-wallets watchlist
• Position Sizing calculator (bankroll, risk %, entry, stop → max position) and a quick reference table
Weekly Review (auto weekly P&L with reflection prompts), Monthly Summary, a Settings tab with editable dropdown lists, and an 8-page quick-start guide with Google Sheets import steps and a journaling routine
Free starter + CTA
New to journaling? Start with the free one-page Pre-Trade Checklist: https://payhip.com/b/U1M76
Saw this on X? Comment JOURNAL on the post and I'll reply with the link.
Tools mentioned (referral links)
The guide lists the apps I use at the desk. Any trade from any app can be logged in the journal.
• Axiom: https://axiom.trade/@wallst39
• FOMO: https://fomo.family/r/_wallstreet39_ (FOMO says this link gives 10% off fees)
These are referral links. Max Kundanmal Desk may earn a reward if you sign up through them. They are not an endorsement or a recommendation to trade.
Disclaimer
Educational and record-keeping tool only. Not financial, investment, tax or legal advice. The spreadsheet only reports the figures you enter, and your past results don't predict future results. Crypto is high-risk and you can lose your whole position. For personal use by the purchaser; please don't resell or redistribute.