FREE spreadsheet for trading log!

This is a discussion on FREE spreadsheet for trading log! within the Trading Software forums, part of the Commercial category; OK, I finally completed my spreadsheet and I took the time to verify the calculations by hand so I know ...

Reply
 
LinkBack Thread Tools Search this Thread
Old Aug 3, 2008, 3:35pm   #1
 
4 Posts
Joined May 2008
FREE spreadsheet for trading log!

OK, I finally completed my spreadsheet and I took the time to verify the calculations by hand so I know this should be the final version that works very well. If you want to use the file with the original program I used to write it, it’s free at...(you click on Calc after installation)

www: OpenOffice.org - The Free and Open Productivity Suite

And some tips on how to use Microsoft Excel (the spreadsheet in the free Open Office is supposedly a “clone” of Excel)...



This spreadsheet will calculate the total profits or losses (including commissions as well), your percentage of winning trades (and losers), average profit or loss per trade, average percentage profit on winners (and losers as well), risk/reward ratio, number of winners (and losers) and total profits and total losses. All you have to do is type in your ticker symbols, entry price, exit price, number of shares traded and the commissions column you don’t need to fill. (You can always click to change the formula and insert the right amount instead of $25. So, tell me if you like it.
Attached Files
File Type: zip Finalspreadsheet1.zip (10.1 KB, 10035 views)
clambill is offline   Reply With Quote
Old Aug 3, 2008, 4:25pm   #2
 
4 Posts
Joined May 2008
clambill started this thread HERE ARE THE FORMULAS IN CASE YOU WANT TO CONSTRUCT YOUR OWN.

column A
row 1: Equities Paper Trading
row 2: Ticker symbol

column B
row 2: Long or short

column C
row 2: Entry price

column D
row 2: Exit price

column E
row 2: N of shares

column F
row 2: Profit or loss
=IF(B3=“L”;D3*E3-C3*E3;C3*E3-D3*E3)

column G
row 2: Net P/L
=F3-25
(this is a $25 round-trip commission, you can double-click to change the amount)

column H
row 2: Profit=1
=IF(F3>0;1;0)

column I
row 2: Losses=1
=IF(F3<0;1;0)

column J
row 2: Total cost
=C3*E3

column K
row 2: % win or loss
=F3/J3*100

column L (here the title is in column L but the formula is in column M so I’ll just add the title to the column M description)

column M
row 2: Total profit or loss
=SUM(F3:F10)

row 3: Including commissions
=SUM(G3:G10)
(in reality, the calculations for % of gain on winners etc is all done with the results excluding the cost of commissions)

row 4: % of winners
=M9/M11*100

row 5: % of losers
=M10/M11*100

row 6: Avg P/L per trade
=M2/M11

row 7: Avg % loss on losers
=M15/M10

row 8: Avg % profit on winners
=M14/M9

row 9: Number of winners
=SUM(H3:H10)

row 10: Number of losers
=SUM(I3:I10)

row 11: Number of trades
=SUM(M9:M10)

row 12: Total profits
=SUMIF(H3:H10;”>0”;F3:F10)

row 13: Total losses
=SUMIF(I3:I10;”>0”;F3:F10)

row 14: Total % gains
=SUMIF(H3:H10;”>0”;K3:K10)

row 15: Total % losses
=SUMIF(I3:I10;”>0”;K3:K10)

row 16: Risk/reward ratio
=M8/M7*-1
clambill is offline   Reply With Quote
Old Aug 3, 2008, 7:54pm   #3
Joined Apr 2008
Instead of using open office (not saying you have to use excel), go to google applications online bit.

It has a spreadsheet area which you can share freely. Therefore you could have an online version of this / you could download it off there too i think.
KillPhil08 is offline   Reply With Quote
Old Aug 3, 2008, 8:14pm   #4
Joined Apr 2008
Here's the excel version.

Bit messy though, i converted it. I didn't bother typing the whole thing.
Attached Files
File Type: xls finalspreadsheet1.xls (10.5 KB, 7243 views)
KillPhil08 is offline   Reply With Quote
Old Aug 4, 2008, 1:04am   #5
 
Magos's Avatar
Joined Feb 2007
That looks impressive I like it, well done

Personally I use the one from the Trading Athletes book (anyone can modify it accordingly)
__________________
Stops are 4 buses
Magos is offline   Reply With Quote
Old Aug 4, 2008, 7:26am   #6
Joined Apr 2008
Quote:
Originally Posted by KillPhil08 View Post
Here's the excel version.

Bit messy though, i converted it. I didn't bother typing the whole thing.
thanks this is good.
i like to split my position into 3 portions, and take profit at 25, 75 pips and then trail the final lot with 75 pips trailing. can you design a spreadsheet for me?
thanks
forex999 is offline   Reply With Quote
Old Aug 4, 2008, 3:40pm   #7
 
4 Posts
Joined May 2008
clambill started this thread Gee, I don't know how to modify it for Forex. I just learned how to do this in like 3 days.
clambill is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Spreadsheet-if any use Burney Psychology, Risk & Money Management 4 Dec 26, 2008 5:12pm
new site for trading online, data free, indicators free and fee tsxela Educational Resources 0 Nov 9, 2007 10:39am
Exporting to Spreadsheet Pippppin Data Feeds 1 Feb 24, 2007 3:49pm
Trading SpreadSheet jklondon Psychology, Risk & Money Management 7 Feb 24, 2004 12:10pm

Currently Active Users Viewing This Thread: 3 (0 members and 3 guests)