My Excel Trading Journal

ksganesh100 · #1 12th July 2006, 03:52 PM

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,

shreyadr · #2 12th July 2006, 04:19 PM

Downloaded ur file but have some queries.

what are c.p. , s.p., 1 r , R etc.

please explain the complete file what u have created.

ksganesh100 · #3 12th July 2006, 04:36 PM

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 100@1040 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

sarathc · #4 12th July 2006, 06:58 PM

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?

blossom04 · #5 12th July 2006, 08:20 PM

Just Downloaded It. Looks Very Good !!

Thanks

cooltetra · #6 13th July 2006, 12:33 AM

Thanks man
Looks good.
will get back with my flowers.

Best Regards
Coool.

ksganesh100 · #7 13th July 2006, 08:12 AM

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.

smineel · #8 16th July 2006, 08:23 PM

Excellent!!!!!!!!!! work done,

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

Quote:

Originally Posted by ksganesh100

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 · #9 17th July 2006, 10:18 AM

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

Quote:

Originally Posted by ksganesh100

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,

ksganesh100 · #10 17th July 2006, 10:29 AM

Quote:

Originally Posted by amar_gr

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 for: My Excel Trading Journal
Thread	Thread Starter	Forum	Replies	Last Post
Traders Journal Magazine at ***** group	jdm	Magazines	1	28th May 2006 12:24 AM
excel help	vvn	Introductions	4	8th August 2005 08:06 PM