Trading Journal Spreadsheet

There are commercial services that let you log trades, but they can be expensive and not always available for every trading platform.

This is a list of Excel templates and spreadsheets that are good as a trading log for crypto trading. Often you can adopt templates from stock trading, if you trade on technical analysis, or from forex, if you scalp.

Trading Journal Spreadsheet. Enter your email address and we'll send you a free PDF of this post. A trading journal is the book a trader writes about their own trading. A trading journal records decisions made in the market so you can see any errors in discipline, risk management, or process. If you can measure it, you can change it. This is a list of Excel templates and spreadsheets that are good as a trading log for crypto trading. Often you can adopt templates from stock trading, if you trade on technical analysis, or from forex, if you scalp. The trading journal templates are ordered by complexity, from the simplest template to the more complex. A good journal will capture your actions as close to raw as possible. In designing my trading journal template, I opted to use Excel because it provided me with a large workspace where I can keep just about everything I wish to track, plan with, analyze, etc. And the ability to use formulas to automate some of the processes and make it more. New premium trading journals for forex, crypto, stocks & shares, spread betting and lots. Buy Premium Journals - Di. Trading Journal Spreadsheet Download. I’ve had quite a few requests for a copy of the spreadsheet I use for my trading journal. I uploaded it to the server so feel free to download a copy if you’re interested. It’s not the most elegant spreadsheet but it does what I need. Here’s some details about the columns included: Expectancy: An.

The trading journal templates are ordered by complexity, from the simplest template to the more complex.

  • The simplest trading log spreadsheets include market, direction, entry price, exit price, amount.
  • The more complex trading log templates have additional fields for notes on the pattern or setup you traded on, and space for notes about your market predictions.

The more information you log (within reason) the more accountable you can hold yourself.

Trading Journal Spreadsheet

Basic: Crypto Trading Log Spreadsheet

This is your super simple trading journal spreadsheet. It only has the fields that are absolutely necessary, but at least it doesn’t take forever to log your trades.

There is no built in analysis, you will have to process the spreadsheet yourself.

Trading log fields:

  • Opened (date)
  • Closed (date)
  • Market
  • Setup (…on which you traded)
  • Direction
  • Entry (price)
  • Target (price)
  • Exit (price)
  • Size
  • PnL
  • Funding (cost)
  • Fee (cost)
  • Notes

Get this spreadsheet: Open the Google Sheet - Click 'File' > 'Make a Copy'

Intermediate: EarnForex Excel Trade Journal

The Google spreadsheet version modified for crypto is linked below.

The original EarnForex Excel Log (v3.0 from 2020)

The EarnForex Excel template in its original form already includes all the things you will need in crypto. The modifications of its 2020 version are minimal - change the forex markets to crypto markets and you’re good.

The template comes with an analysis sheet. Source

Original trading log fields included:

  • Open Date
  • Strategy (such as “double bottom”)
  • FX No (number of the market from the sheet that lists your markets)
  • Currency Pair
  • Direction (long / short or put / call)
  • Entry Price
  • Initial Stop
  • Initial Target
  • IRR
  • Position Size
  • Exit Price
  • Close Date
  • Profit/Loss
  • Swap (your costs of margin funding)
  • Commission (trading fee charged by the exchange)
  • Length (scalp, swing)
  • Open Comment (your reasoning for entering)
  • Close Comment (your reason for exiting, whether it was scaled in or at once, or stopped out)
  • End Balance

EarnForex Excel Log Adopted for crypto

The link below is a (work in progress) - the EarnForex’s Forex trading log transformed into Google Spreadsheet and modified for crypto markets.

With this version of the trading journal, 10 different crypto markets are set up for you. You can overwrite them into any other pairs, depending on which markets you trade. But remember to also modify the column with Google Finance integration that gets you the conversion rate into USD.

Thanks to this data, your PnL is calculated in the base currency and in current USD rate for that base currency.

To learn from jour trading journal, rate of return will probably tell you more about your trades. This trading log calculates both your expected rate of return (from your target price) and the realised rate of return for each trade.

Trading Journal Spreadsheet Philippines

The Analytics tab breaks down your trades by several metrics:

  • Total USD Profit or loss based on traded pair
  • Total USD Profit or loss based on technical analysis, pattern or setup
  • Total USD Profit or loss based on direction of your position

Trading Journal Spreadsheet Coupon

Other than that the fields are more or less the same as in the forex log above.

Trading Journal Spreadsheet Free

Get this spreadsheet: Open the Google Sheet - Click 'File' > 'Make a Copy'