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 4

post #61 of 133
12/15/08 at 3:53am
I have an idea for the compound interest chart. Could you put in a spot so you could put in a percentage of your portfolio that you would risk at a time. Like I've read some people choose to only use a third of their portfolio at once. That way if people don't want to use the whole portfolio on each trade they can see how fast it will grow using whatever percentage they want to use.
Reply
Reply

Featured Stories on HotStockMarket

thinkorswim Trading platform
Stonerangers forum
Mark's Weekly Trading Log
post #62 of 133
2/14/09 at 2:23am
Thread Starter 
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

NEW VERSION 1.75
http://www.mediafire.com/file/jfwm4n...Option.Futures ver 1.75.xls
Reply
Reply
post #63 of 133
2/15/09 at 6:43am
hi,

thank you for the great work

can you please make them all at one file?

and you can name every sheet like stocks and options as I prefere to hold all my data in one file

another note

the cell current available to trade is the total gain + the fees

it shout be the net gain not the gross

if you can pls fix this

thanks again
Reply
Reply
post #64 of 133
2/15/09 at 8:10pm
Thread Starter 
Not sure what you mean. Can you re explain what you mean. The current available to trade is the total not invested. And the gain is minus fees so not sure where u are coming from
Reply
Reply
post #65 of 133
2/16/09 at 2:48am
Quote:
Originally Posted by timmyb199 View Post
Not sure what you mean. Can you re explain what you mean. The current available to trade is the total not invested. And the gain is minus fees so not sure where u are coming from


ok here is the example

buy 7000 shares at 0.07 total is $490 + $29 fees = $519

sell 7000 ahares at 0.13 total is $910 - $29 fees = $881

net Gain is $881 - $519 = $362

and the current available to trade = 1000 + 362 = 1362

I hope you can see what i mean now

and this file the one in your signature

thank you
Reply
Reply
post #66 of 133
2/16/09 at 2:56am
Hello timmyb199,

I need to copy the table into another sheet in the same file as I make trades at canadian market and US market and I need separate sheet for each of them

thanks again
Reply
Reply
post #67 of 133
2/16/09 at 4:59pm
Thread Starter 
K 1 min will be fixed quick here. I thought you meant the new sheet let me take a look and see
Reply
Reply
post #68 of 133
2/16/09 at 6:35pm
Thread Starter 
Here you go should be all fixed. Let me know. I added a button on the instructions tab to add another page. This page can be renamed on the tab for it and the top of the sheet. Let me know if this solves all your issues


tim

here is the sheet
http://www.mediafire.com/file/zmz0mq4nlzy/Stock ver 1.75.xls
Reply
Reply
post #69 of 133
2/17/09 at 5:21am
that's great now the file is fine

have another issue ;-)

can you add another button on the instructions tab to add another page for option trading !!

this will be the best file ever

thanks man
Reply
Reply
post #70 of 133
2/17/09 at 9:31pm
Thread Starter 
didnt realize you trade options also. I wil get it added this week and update. Add anything else here so i can add it all at the same time

Tim
Reply
Reply
post #71 of 133
2/17/09 at 9:58pm
awesome timmy. thanks!
Reply
Reply
post #72 of 133
2/18/09 at 7:25am
Quote:
Originally Posted by timmyb199 View Post
didnt realize you trade options also. I wil get it added this week and update. Add anything else here so i can add it all at the same time

Tim
in fact yes I trade both.

I think of some thing but i'm not sure if its a good idea

I trade options and stocks through one account right?

if I have a column to select the type of the trade if its options or stocks then calculate the fees for the trade and calculate the total portfolio all at one file

and we have the instructions sheet to add another page for option trading or stock trading or both

in this way the file will meet all the needs of traders and will be more flexible and the trader will preserve all his data in one file

tell me what do you think
Reply
Reply
post #73 of 133
2/18/09 at 2:05pm
Thread Starter 
Yeah I been throwing around this ides. Just trying to figure out of it makes for confusing code on my end. I will figure something out this week either way. I will prob work on it sometimes today. Again post anything else.

Tim
Reply
Reply
post #74 of 133
3/4/09 at 5:06pm
how do I enable macros again?
Reply
Reply
post #75 of 133
3/4/09 at 5:22pm
i figured it out
Reply
Reply
post #76 of 133
3/5/09 at 6:57am
Thread Starter 
Still working on the stock and option one, GHO what version you using??
Reply
Reply
post #77 of 133
5/18/09 at 4:08am
I don't know why but for some reason I just can't get the stock chart to download and open.
Reply
Reply
post #78 of 133
5/18/09 at 4:54am
Dang this looks really nice. Thanks for the upload and effort to make it.
Reply
Reply
post #79 of 133
5/24/09 at 6:50am
Timmy I am currently working on modifying your stock spreadsheet and was wondering if I could have your permission to post it here when I finish with it?

The modifications I and working on right now are input boxes to enter the stock data into a different sheet and from there put an your total position of each stock onto the layout that you created.
Reply
Reply
post #80 of 133
5/29/09 at 10:27pm
Thread Starter 
Sure your more than welcome to, i have been horribly busy lately. I hope this thread can go on with you guys helping and advancing the sheets.

Tim
Reply
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Trade Journals & Stock Tips

Featured Stories on HotStockMarket

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