My Excel Trading Journal

Discussion in 'Technical Analysis' started by ksganesh100, Jul 12, 2006.

  1. ksganesh100

    ksganesh100 New Member

    Joined:
    Apr 26, 2006
    Messages:
    27
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Bangalore
    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: Jul 12, 2006
  2. shreyadr

    shreyadr Member

    Joined:
    Jun 1, 2005
    Messages:
    79
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Borivli, Mumbai
    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.
     
  3. ksganesh100

    ksganesh100 New Member

    Joined:
    Apr 26, 2006
    Messages:
    27
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Bangalore
    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
     
  4. sarathc

    sarathc Member

    Joined:
    Mar 7, 2006
    Messages:
    81
    Likes Received:
    3
    Trophy Points:
    8
    Location:
    Hyderabad
    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?
     
  5. blossom04

    blossom04 New Member

    Joined:
    May 10, 2006
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    1
    Just Downloaded It. Looks Very Good !!

    Thanks
     
  6. cooltetra

    cooltetra Active Member

    Joined:
    Mar 17, 2006
    Messages:
    193
    Likes Received:
    25
    Trophy Points:
    28
    Location:
    Pune
    Thanks man
    Looks good.
    will get back with my flowers.

    Best Regards
    Coool.
     

  7. ksganesh100

    ksganesh100 New Member

    Joined:
    Apr 26, 2006
    Messages:
    27
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Bangalore
    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. smineel

    smineel Member

    Joined:
    Dec 28, 2005
    Messages:
    43
    Likes Received:
    0
    Trophy Points:
    6
    Excellent!!!!!!!!!! work done,

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





     
  9. amar_gr

    amar_gr Active Member

    Joined:
    Mar 7, 2006
    Messages:
    115
    Likes Received:
    30
    Trophy Points:
    28
    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



     
  10. ksganesh100

    ksganesh100 New Member

    Joined:
    Apr 26, 2006
    Messages:
    27
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Bangalore
    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
     

Share This Page