Traderji.com - Discussion forum for Stocks Commodities & Forex


My Excel Trading Journal

Discuss My Excel Trading Journal at the Technical Analysis within the Traderji.com - Discussion forum for Stocks Commodities & Forex; Hi all, I would like to share my trade logging system with all of you ...


Go Back   Traderji.com - Discussion forum for Stocks Commodities & Forex > METHODS & STRATEGIES > Technical Analysis

Technical Analysis Discussion of all the principles involved in technical analysis.


Reply
 
Thread Tools
  #1  
Old 12th July 2006, 03:52 PM
Member
 
Join Date: Apr 2006
Location: Bangalore
Posts: 27
Thanks: 0
Thanked 2 Times in 2 Posts
ksganesh100 is on a distinguished road
Smile My Excel Trading Journal

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 by ksganesh100; 12th July 2006 at 04:20 PM.
Reply With Quote
Sponsored Links
  #2  
Old 12th July 2006, 04:19 PM
Member
 
Join Date: Jun 2005
Location: Borivli, Mumbai
Posts: 79
Thanks: 2
Thanked 0 Times in 0 Posts
shreyadr is on a distinguished road
Question Re: My Excel Trading Journal

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.
Reply With Quote
  #3  
Old 12th July 2006, 04:36 PM
Member
 
Join Date: Apr 2006
Location: Bangalore
Posts: 27
Thanks: 0
Thanked 2 Times in 2 Posts
ksganesh100 is on a distinguished road
Lightbulb Re: My Excel Trading Journal

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
Reply With Quote
  #4  
Old 12th July 2006, 06:58 PM
Member
 
Join Date: Mar 2006
Location: Hyderabad
Posts: 81
Thanks: 5
Thanked 3 Times in 3 Posts
sarathc is on a distinguished road
Default Re: My Excel Trading Journal

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?
Reply With Quote
  #5  
Old 12th July 2006, 08:20 PM
Member
 
Join Date: May 2006
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
blossom04 is on a distinguished road
Default Re: My Excel Trading Journal

Just Downloaded It. Looks Very Good !!

Thanks
Reply With Quote
  #6  
Old 13th July 2006, 12:33 AM
Member
 
Join Date: Mar 2006
Location: Pune
Posts: 193
Thanks: 0
Thanked 24 Times in 9 Posts
cooltetra is on a distinguished road
Default Re: My Excel Trading Journal

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

Best Regards
Coool.
Reply With Quote
  #7  
Old 13th July 2006, 08:12 AM
Member
 
Join Date: Apr 2006
Location: Bangalore
Posts: 27
Thanks: 0
Thanked 2 Times in 2 Posts
ksganesh100 is on a distinguished road
Default Re: My Excel Trading Journal

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.
Reply With Quote
  #8  
Old 16th July 2006, 08:23 PM
Member
 
Join Date: Dec 2005
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
smineel is on a distinguished road
Default Re: My Excel Trading Journal

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,
Reply With Quote
  #9  
Old 17th July 2006, 10:18 AM
amar_gr's Avatar
Member
 
Join Date: Mar 2006
Posts: 112
Thanks: 73
Thanked 46 Times in 27 Posts
amar_gr will become famous soon enough
Default Re: My Excel Trading Journal

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,
Reply With Quote
  #10  
Old 17th July 2006, 10:29 AM
Member
 
Join Date: Apr 2006
Location: Bangalore
Posts: 27
Thanks: 0
Thanked 2 Times in 2 Posts
ksganesh100 is on a distinguished road
Thumbs up Re: My Excel Trading Journal

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


Reply With Quote
Reply

Bookmarks


Advertise Here


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads for: My Excel Trading Journal
Thread Thread Starter Forum Replies Last Post
excel help vvn Introductions 6 9th December 2009 10:11 PM
Traders Journal Magazine at yahoo group jdm Magazines 1 28th May 2006 12:24 AM


All times are GMT +5.5. The time now is 04:48 PM.

Indemnity, Disclaimer & Disclosure Notice:
By visiting Traderji.com you automatically indicate that you agree to our Forum Rules, Indemnity, Disclaimer & Disclosure Notice and General Content Disclaimer Notice and indemnify Traderji.com, its associates and related parties of all claims howsoever resulting from the usage of the forum/site.
Disclaimer: Trading or investing in stocks & commodities is a high risk activity. Any action you choose to take in the markets is totally your own responsibility. You are recommended to make appropriate enquiries and seek appropriate advise before sending money, incurring any expenses, acting on recommendations or entering into any commitment in relation to any advertisement published here. Traderji.com does not vouch for any claims made by the advertisers of products and services. Traderji.com will not be held liable for any consequences in the event such claims are not honoured by the advertisers. Traderji.com will not be liable for any, direct or indirect, consequential or incidental damages or loss arising out of the use of any information by anybody mentioned anywhere on this site.
Disclosure: The information in this forum is neither an offer to sell nor solicitation to buy any of the securities mentioned herein. The writers may or may not be trading in the securities mentioned.
All names or products mentioned are trademarks or registered trademarks of their respective owners.
General Content Disclaimer Notice:
In light of our policy of encouraging candid, open exchanges of views and the rapid distribution of information originating from many sources, Traderji.com cannot determine the accuracy or legality of any information that may be uploaded to the forum. Opinions, advice and all other information expressed by participants in discussions are those of the author. You rely on such information at your own risk. You are urged to seek professional advice for specific, individual situations and not rely solely on advice or opinions given in the discussions. Since Traderji.com is an open and free discussion forum, any comments made by members of this forum in their posts reflect their own views and not of the owner or administrator of Traderji.com. Thus the owner/administrator indemnify themselves of all claims whatsoever and will not be liable or responsible for any members comments/views in this forum Traderji.com. Although we constantly delete all irrelevant content and/or SPAM, if you should find any objectionable or offensive posts made by members of this forum which you would like to bring to our notice for removal then please Contact Us.
 


Copyright © www.Traderji.com 2001 - , All rights reserved.

Recommended Websites - www.TradersEdgeIndia.com - www.TradingPicks.com - www.MasterOfTrading.com

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247