My Excel Trading Journal

#1
Hi all,

I would like to share my trade logging system with all of you . This acts as my trading journal which also keeps track of my weekly P/L. To give an overview of my trading style, I am a swing trader who mostly trades channels and less frequently, breakouts.

You would be able to download this from here:

My trading Journal

Most of this should be self-explanatory to the traders here. I would be happy to clarify if need be. To protect the formulae from being edited by mistake, I have protected the worksheet. People interested in editing formulae might want to unlock the sheet by using the password "traderji".

Hope you find it useful ! :)

Best Regards,
 
Last edited:
#3
There are three major sections to the trading journal.

1. The Overview section: This is at the top left of the sheet. This provides a snapshot of various dimensions of your trading:

Starting Equity: This is the account equity (Shares + cash) at the start of a particular month

Total P&L: Self Explanatory

% Wins: (Winning trades)/(Total trades)

Invested Capital: Your money locked in

Balance Cash : Starting equity - Invested capital

Capital Risk: This is the percentage of your equity that is at risk. This will be determined by your stop losses.

Expectancy = (Average Profit % * % winning trades) - (Average Loss % * % Losing trades)

2. Position Sizing : This section helps you determine the ideal number of shares to be bought. This assumes a max risk of 0.75% of your starting equity per trade.

3. Trade log: This records the trades as and when they happen

C.P. - Cost Price or Price per share at purchase

S.P. - Sale Price or Price per share at sale

Stop - Stop loss (Should be ideally decided at the time of purchase)

Break even - Your break even price

1 R - The price at which your gain = Qty * (purchase price - Stop loss). This is where your gain is equal to the money you initially risked in the trade.

IR - Your initial risk in the trade. For eg., If you bought Reliance [email protected] with 1000 as a stop loss. Then your IR = (1040-1000)*100 = 4000

R Multiple - Equals (Price or Loss)/(Initial Risk)

Hope this clears your doubts
 
#4
Good one, thanks a ton for sharing it with us all!

Can you please explain how we can add more weeks (30th, 31st, so on and so forth) to the P&L Worksheet?
 
#7
Thanks a lot for the kind words. Am glad some of you find it useful :)

sarathc,

The P&L calculation is done using a pivot table. As time goes by, whenever you press the refresh button (red "!" on the pivot toolbar), it will automatically update the table and charts to include the new week and calculate the profits for that week.

You can experiment this by putting in fictitious sell dates for the coming weeks.
 
#8
Excellent!!!!!!!!!! work done,

thanks a lot for sharing.........





ksganesh100 said:
Hi all,

I would like to share my trade logging system with all of you . This acts as my trading journal which also keeps track of my weekly P/L. To give an overview of my trading style, I am a swing trader who mostly trades channels and less frequently, breakouts.

You would be able to download this from here:

My trading Journal

Most of this should be self-explanatory to the traders here. I would be happy to clarify if need be. To protect the formulae from being edited by mistake, I have protected the worksheet. People interested in editing formulae might want to unlock the sheet by using the password "traderji".

Hope you find it useful ! :)

Best Regards,
 

amar_gr

Active Member
#9
Hi,
I downloaded your Trading Journal, however it only shows various links and references to esinps. I cannot see any table or data relating to trading journal.

Am i doing something wrong ?

Thanks in advance for your Help.

Regards
Amar R



ksganesh100 said:
Hi all,

I would like to share my trade logging system with all of you . This acts as my trading journal which also keeps track of my weekly P/L. To give an overview of my trading style, I am a swing trader who mostly trades channels and less frequently, breakouts.

You would be able to download this from here:

My trading Journal

Most of this should be self-explanatory to the traders here. I would be happy to clarify if need be. To protect the formulae from being edited by mistake, I have protected the worksheet. People interested in editing formulae might want to unlock the sheet by using the password "traderji".

Hope you find it useful ! :)

Best Regards,
 
#10
amar_gr said:
Hi,
I downloaded your Trading Journal, however it only shows various links and references to esinps. I cannot see any table or data relating to trading journal.

Am i doing something wrong ?

Thanks in advance for your Help.

Regards
Amar R
Hi Amar,

A few others had this problem too. Don't think you did anything wrong, guess this is just one of those occurances. You may try downloading this from this alternate location.

http://www.megaupload.com/?d=E0YMVMSV

Regards,
Ganesh
 

Similar threads

Zerodha – Open Paperless Account

Open online account with Zerodha. Free delivery trading and Max Rs 20 for Intraday, F&O, Currency and Commodity Trading. Intraday High leverage with MIS, CO and BO.

Name:Phone:
Email:City:
State:
Are you a day trader?