HotStockMarket › Forums › HSM Stock Forum › Trade Journals & Stock Tips › FREE EXCEL SPREADSHEETS FOR TRADING
New Posts  All Forums:Forum Nav:

FREE EXCEL SPREADSHEETS FOR TRADING - Page 3

post #41 of 133
12/14/08 at 3:03am
Thread Starter 
And one that shows the markets data for the day, Remember you need the add-in for this to work. it pulls the data from the web automatically



and the file

http://www.mediafire.com/file/eiqywzntwmn/Market Momentum.xls
Reply
Reply

Featured Stories on HotStockMarket

Mark's Weekly Trading Log
thinkorswim Trading platform
Stonerangers forum
post #42 of 133
12/14/08 at 3:40am
timmyb i likey! only problem i see is that the fee is automatically set to 10 right? nice though!
Reply
Reply
post #43 of 133
12/14/08 at 3:43am
Thread Starter 
no it should not be

you set it in lower left, double check for me k and let me know

oh and i just fixed couple things make sure u got v1.20 of each (links updated)
Reply
Reply
post #44 of 133
12/14/08 at 3:50am
Thread Starter 
http://www.mediafire.com/file/zynoaiyomnk/SIMPLE STOCKv1.20.xls

this one is updated
Reply
Reply
post #45 of 133
12/14/08 at 4:31am
Thread Starter 
there was a request to add current portfolio etc to the option sheet

so here is the updated one
http://www.mediafire.com/file/mty0g3mjxxo/SIMPLE OPTION SHEETv1.40.xls

Reply
Reply
post #46 of 133
12/14/08 at 4:38am
Thread Starter 
version 1.40 is most current for options sheet
version 1.20 is most curretn for stocks sheet
Reply
Reply
post #47 of 133
12/14/08 at 4:43am

chart

Hey thanks again Timmy!!
Reply
Reply
post #48 of 133
12/14/08 at 4:44am
Thread Starter 
Quote:
Originally Posted by CThor View Post
Hey thanks again Timmy!!
let me know if you have any issues or any ideas to add. I think they should all work fine now
Reply
Reply
post #49 of 133
12/14/08 at 4:46am
Looks like its working fine, I just entered my info into it.
Reply
Reply
post #50 of 133
12/14/08 at 4:48am
Thread Starter 
Quote:
Originally Posted by momoneynoprobs View Post
timmyb i likey! only problem i see is that the fee is automatically set to 10 right? nice though!
should be all fixed please download latest versions in my signature
Reply
Reply
post #51 of 133
12/14/08 at 4:49am
Thread Starter 
Oh hey I just thought of a cool idea if anyone doesn't mind show a few screen shots of your trades in the spreadsheets. It will share with others trades you made and show off the sheets
Reply
Reply
post #52 of 133
12/14/08 at 4:57am
Funny thing I noticed when comparing my sheet with my Zecco account. Zecco seems to take a penny extra on top of the normal fees. Only a penny total though for each completed trade. I've done 3 complete trades as in bought and sold. My zecco account is 3 cents less than the spreadsheet says. I just emailed them to see why that is...

What do I need to do to post a screen shot of the spreadsheet?
Reply
Reply
post #53 of 133
12/14/08 at 5:03am
Thread Starter 
just take a screenshot "print screen" key and uplad somewhere. I use tinypic.com very easy copy the info that comes up after upload for message boards and paste it in the post
Reply
Reply
post #54 of 133
12/14/08 at 5:29am
Quote:
Originally Posted by timmyb199 View Post
should be all fixed please download latest versions in my signature
sorry! foolish me didnt see that. thanks timmy!
Reply
Reply
post #55 of 133
12/14/08 at 5:51am
Thread Starter 
And incase anyone ever liked to know how small gains rolled over can turn into big ones here is a sheet for you. Just enter your start $ amount and the % gain you want to target, It calculates compound interest for up to 30 trades, or substitute trades for months year or what not.



and the file
http://www.mediafire.com/file/oinzjjwokzh/Compound Interest Calc.xls
Reply
Reply
post #56 of 133
12/14/08 at 6:03am
wow, i am liking those numbers
Reply
Reply
post #57 of 133
12/14/08 at 6:15am
Quote:
Originally Posted by Mizzike View Post
wow, i am liking those numbers
You have to re-invest all your money + gain to the next trade. Impossible!
Reply
Reply
post #58 of 133
12/14/08 at 8:27am
These sheets are great, thanks!
Reply
Reply
post #59 of 133
12/14/08 at 3:27pm
Thread Starter 
Quote:
Originally Posted by foss View Post
You have to re-invest all your money + gain to the next trade. Impossible!
actually not impossible, just have to use tight stops
Reply
Reply
post #60 of 133
12/14/08 at 7:24pm
Quote:
Originally Posted by timmyb199 View Post
actually not impossible, just have to use tight stops
Imagine yourself investing $100,000 into one trade, I think after you make $100,000 you have to trade only certain amount of your portfolio, leave the rest in cash.
Check out very good book by Nassim Taleb "The Black Swan"
Reply
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Trade Journals & Stock Tips

Featured Stories on HotStockMarket

Mark's Weekly Trading Log
thinkorswim Trading platform
Stonerangers forum
HotStockMarket › Forums › HSM Stock Forum › Trade Journals & Stock Tips › FREE EXCEL SPREADSHEETS FOR TRADING