Aller au contenu principal

Menu de commandes

Accédez à une page ou recherchez dans le catalogue

Tableurs et calculateurs

Journal de trading crypto et calculateur de risque et de taille de position - Excel / Google Sheets (multiple R, calendrier des gains et pertes, GHS/NGN/KES)

Dimensionnez chaque position selon le risque, enregistrez vos opérations en quelques secondes et suivez votre vrai taux de réussite, votre R et votre drawdown, en USD et en cédis, nairas ou shillings.

$9.00

Ce que vous recevez : 1 fichier · 481.42 KB · ZIP

Voir les options d'achat

Description du produit

Most traders can't say what their win rate is, which setup actually makes money, or how much the last "small" FOMO trade cost them. This journal answers those questions using your own trades.

Before a trade, the Risk Calculator gives you the position size that loses exactly the % you chose if your stop is hit, fees included. After the trade, the Trade Log works out net P&L, R multiple and % of account. The Dashboard, Analysis and Monthly tabs then show you what is working and what is costing you money.

WHAT'S INSIDE

- Dashboard: 15 key numbers: net P&L (USD + local currency), win rate, profit factor, expectancy (avg R), total R, account equity, max drawdown, avg win / avg loss, fees + funding paid, open trades and open risk, rules-followed %, best / worst trade, longest losing streak, average holding time, rows to check. Plus 4 charts: equity curve, net P&L by month, P&L by strategy, P&L by coin.

- Trade Log (1,000 trades): entry/exit date, exchange, coin, spot/futures/margin, long/short, strategy, entry, stop, target, exit, quantity, leverage, fees, funding, rules followed, mistake, emotion, notes. Dropdowns everywhere. Net P&L, 1R, R multiple, risk % of account, planned R:R, days held and local-currency P&L calculate automatically. A Check column flags impossible inputs (stop on the wrong side, exit date without exit price, text instead of numbers) and leaves those rows out of every total until you fix them.

- Position-Size & Risk Calculator: account balance + risk % + entry + stop gives position size in coins, position value, margin needed, leverage needed, approximate liquidation price (warns if liquidation comes before your stop), break-even exit price after fees, and up to 3 take-profit targets in USD, R, % of account and local currency.

- Risk tables: what 1-20 losses in a row do to your account at 0.5%-5% risk, the gain needed to recover from a drawdown, and the break-even win rate for each reward:risk ratio (including your own).

- Trade Planner: plan up to 8 trades and see the total risk if every stop is hit, including open trades from your log, compared with your max open-risk limit.

- Analysis: trades, win rate, net P&L, avg P&L, total R, avg R and profit factor by coin, strategy, exchange, long vs short, spot vs futures, rules followed vs broken, mistake ("cost of mistakes"), emotion and weekday.

- Monthly report: trades, wins, losses, win rate, gross profit/loss, fees, net P&L (USD + local), total R, start/end equity and return % for each month, plus a daily P&L calendar for any month you choose.

- Equity tab: closed trades in exit-date order with equity, peak, drawdown, cumulative R and win/loss streaks. You can log trades in any order.

- Settings: starting balance, local currency (GHS, NGN, KES, ZAR, UGX, TZS, XOF, XAF, EGP, MAD, EUR, GBP or USD) and rate, default risk %, max risk per trade, max open risk, fee per side, break-even band, and editable lists of coins, strategies, exchanges, mistakes and emotions.

- Start Here tab inside the file and a 2-page PDF quick-start guide.

- 52 example trades, clearly marked EXAMPLE, so you can see every tab working. Clearing them takes one selection and the Delete key.

WHY THIS ONE

- Built around risk first: R multiples, risk % per trade, open risk and losing-streak maths, not just a profit list.

- Fees and funding go into every number, so a "win" that only covered fees shows up as break-even.

- Shows your results in GHS, NGN, KES or any currency you set, next to USD.

- Spot and futures, long and short, any exchange (Binance, Bybit, OKX, KuCoin, Bitget, Quidax, Yellow Card...).

- Mistake and emotion tags show what breaking your rules actually cost you.

- Clean dark design, frozen headers, protected formula cells (no password, so you can unprotect any time), no macros, no add-ons, no sign-ups, no API keys.

WHAT'S INCLUDED

- Crypto-Trading-Journal-Risk-Calculator.xlsx (9 tabs)

- Quick-Start-Guide.pdf (2 pages)

Delivered as one ZIP. Instant download.

COMPATIBILITY

- Microsoft Excel 2010 or newer / Microsoft 365 (Windows & Mac)

- Google Sheets (upload, then File > Save as Google Sheets)

- LibreOffice Calc 7+

- Works offline. No macros or scripts.

PLEASE NOTE

- You type your own trades. The file does not connect to exchanges or wallets.

- All prices, fees and funding are entered in USD/USDT. Local-currency figures use one rate that you set.

- Liquidation prices are estimates (isolated margin, simple formula). Always check the figure on your exchange.

DISCLAIMER: NOT FINANCIAL OR TAX ADVICE

This product is a record-keeping and calculation template. It is not financial, investment, trading, tax or legal advice. It gives no trading signals, makes no predictions and promises no profits. Statistics describe your own past trades only and do not predict future results. Crypto trading, especially with leverage, is high risk and you can lose all the money you put in. Example data is fictional. Not affiliated with Binance, Bybit, OKX, KuCoin, Bitget, Quidax, Yellow Card or any exchange named.

License: personal use by one person. Please don't resell or share the file.

Ce que vous recevez

1 fichier · 481.42 KB

  • CryptoSheets-Trading-Journal-Risk-Calculator.zipZIP · 481.42 KB
LicenceUsage personnel uniquement
Vues26
Publié16 nov. 2026
Taille du fichier481.42 KB
Format du fichierZIP
Versionv1.0

Tags

crypto trading journaltrading journal spreadsheetposition size calculatorrisk calculatorR multiplewin rate trackergoogle sheets templateexcel templateP&L calendarcrypto futures
C
CryptoSheets Africa

Questions fréquentes

Ai-je accès au produit immédiatement ?

Oui. C'est un produit numérique : vous pouvez le télécharger juste après le paiement, directement depuis votre bibliothèque.

Puis-je l'utiliser pour des projets commerciaux ?

Usage personnel uniquement. Utilisez-le pour vous, pas dans un travail que vous vendez ou remettez à un client, et ne revendez ni ne redistribuez le fichier.

Quelle est votre politique de remboursement ?

Vous pouvez demander un remboursement dans un délai de 30 jours. Si quelque chose ne va pas, demandez-le depuis votre commande et l'équipe Getly l'examine.

Quels formats et quelles tailles de fichier vais-je recevoir ?

Vous téléchargerez 1 fichier - ZIP - 481.42 KB au total.

Ai-je droit aux mises à jour gratuites ?

Oui : quand le vendeur publie une nouvelle version, vous pouvez retélécharger les derniers fichiers depuis votre bibliothèque sans frais. Consultez le journal des modifications pour les dernières mises à jour.

Prix

$9.00