top of page
Snímek obrazovky 2022-10-21 212715.png

Looking for an efficient way to record your trades? This spreadsheet is for you! 

 

The first sheet is used to enter the trades you have made in the past.

You write down here:

  • Date

  • Day of the week

  • Month

  • Time

  • Instrument

  • Position direction

  • You can also insert a link to a chart from Tradingview to easily refer back to the situation.

  • The last column is for notes.

  • Profit/Loss

  • Entry price

  • Exit price

  • Risk reward ratio

  • Profit

  • Loss

Snímek obrazovky 2022-10-21 211538.png
Snímek obrazovky 2022-10-21 212810.png

The second sheet is fully automated. It displays statistics about your trading. 

The first rectangle shows the EQUITY LINE of your trading account. Here it is important to fill in the INITIAL CAPITAL correctly in order to display your account's equity line correctly.

The second rectangle shows:

In the left part is the total profit factor on your account.

On the right side is:

  • Total profit

  • Total loss

  • Cumulative result

The rectangle below shows: 

  • Average profit

  • Average loss

  • Largest profit

  • Largest loss

  • Profit / Loss ratio. 

 

The Profit / Loss by month chart shows the results of each month.

 

The Profit / Loss by week day chart shows the results of each day.

 

The Long / Short chart shows the ratio of long and short positions that you have traded.

 

The Long - Profit / Loss chart shows the profit and loss of long positions in percentage

 

The Short - Profit / Loss chart shows the profit and loss of short positions in percentage

 

The Profit / Loss chart shows the profit and loss ratio in percentage
 

Snímek obrazovky 2022-10-20 220504.png

On the last sheet you will find a calculator for Forex, Indexes and commodity.

 

You enter here which pair you are trading.

 

The price of one pip is automatically filled in.

 

You enter your stoploss in pips and the maximum loss you are able to accept.

 

The calculator will automatically calculate what position size you should enter with.
 

We also have TRADING JOURNAL in WHITE color
Look at our shop
HERE
bottom of page