FREE EXCEL SPREADSHEETS FOR TRADING

Hi, I have been making excel spread sheets for quite a long time. And well as of lately there has been a huge run on my sheets. It has been brought to my attention by about 20 people so far that maybe this is something I could do for people. I am willing to give away the ones I have created thus far. But if you are in need of a Custom designed spreadsheet. PM me your needs and maybe we can work together to make em. To get the sheet look in this thread and find the link below the screen shot of the excel sheet. There will be two version typically to help with issues of people not having the latest excel.

If you are in need of a custom excel please reply here so I can judge the need.

Timmyb

LINKS ARE BELOW SCREEN SHOTS FOR DOWNLOAD, MY PM GOT INSANE SO NOW YOU CAN GET IT YOURSELF

Here is one of them I am giving away to interested folks. It auto calculates everything and has color green, red etc. Journeyman98 is currently using this sheet and appears to like it. If you have been a person who was sent this sheet and enjoy using it please reply here.



Updated 11/14/08 5:51pm

Now scale of compounded stays set to original portfolio amount

fixed some bugs reported about fees not adding right

Fixed it not taking the fees off total portfolio

updated 11/14/08 6:48 pm

Also added instructions on how to add more lines for additional trades

DownLoad Link For excel 2003 up-------
http://www.mediafire.com/?wwinrznwmyz

Download link for excel 2003 and down (older excels)
http://www.mediafire.com/?kjtoynqziny


This one is setup for options. When asking for a sheet please define what you trade and the info you would like.

WOWSERS

PM box already full

geesshhh

here is link for download


Here is a new one 12/12/08
Just fixed all the issues with my excel sheet. Seems its hard when going to another person pc. But think I got all the glitches hammered out now

Here is a screenshot





All info is auto calculated. Just enter starting portfolio, your fees and your wanted stop and gain

here is the link, let me know if it doesn't work for you
http://www.mediafire.com/file/mty0g3mjxxo/SIMPLE OPTION SHEETv1.40.xls



YOU MUST ALLOW MACROS FRO THE LAST TWO SHEETS TO WORK


Here is the one for stocks



and the file
http://www.mediafire.com/file/zynoaiyomnk/SIMPLE STOCKv1.20.xls


NEW 2/13/09

Adding a new one here. For those who trades options and futures. The futures are entered by drop down lists. It calculates everything short and long. Should be a nice additon to a option and futures trader

here is a pic



Again it is almost entirely self calculating. The QM contract can be changed to add another future if so desired. The QM is untested with tick in mind. I forgot the qm may not be a full tick. Let me know if there are issues with that. The others work flawlessly. Let me know any issues. in pick shows invested 80k thats cause a future is not selected on drop downs.
ENJOY

http://www.mediafire.com/file/ktjmoo5kg0h/Option And Futures Ver 1.50final.xls

Did you get the current green colored one?? i re-sent it to everyone

Again if your PM is blocked give me time to answer all the pm's. Never imagined it would get this insane.

I will be doing mass emailing tonight. So please pm me if you would like the current version

I dont know how to post it here so people can download it, I am doing it through email so far. and sending it to them

And I am protecting the sheet under protect sheet etc. If there is anything else I need to know please let me know. I am pretty good at excel but never had to really protect anything i made. I have it currently that they can only choose cells they should and need a password to access everything else. Is this enough??

Is it better to choose protect sheet or click the protect and share workbook??

OMG this is insane. Yes journey you can. Its the same but does look nicer. Journey is gonna have to be my guinea pig on the protect deal. Did the ones i sent you not allow you to change it??

ahhh ok thank man

yep did that then i should be good, thanks for replying

timmyb

Ok download link are now below the screen shot of corresponding excel. There are two link for what version of excel you may be running. If you ahve issues try the other file format. thanks

timmyb

Will have that situated this weekend, Gotta change a few things around and make it easier to add rows. Use it for now i will have different one soon for you

oh and i jsut updated it bigtime

so unless you used the links in last 2 mins please re download

JOURNEY YOU NEED THIS ONE> MY OLD ONE HAD PROBLEMS WIHT CALCULATIONS

Ok just updated for final version. Please follow links under the screen shot to get correctly working final version


thanks

timmyb