Hi,

I made a speedsheet in Excel.

when yoiu buy a stock you enter the amount of shares posted.
the dollar per share you paid.

it then calculates the rest...telling you the price to sell....I have it set to stop loss at 7.5%...and also the pice to start looking to protect profits....15%

it also adds the up the total value of the trade.


Once you sell you enter the price sold and it gives you the profit/loss
in the sheet ...I color the cells yellow on a winning trade and light yellow on a losing trade.

for me it's nice becasue I can see all my trades at a glance and know when to start looking to sell up or down

if anyone were interested in trying thsi sheet out...I'd like to pass it on...for one...if can help someone...2) for posterity.

That's a great idea jag857. I really need to work on my bailing out of stocks - with a profit.

Yeah, I did a lot better when I left my opinion and emotion behind and followed the rule.

On the upside...I put sells in thoughtout the day as it goes up X amount below it's current trading price

jag
I did something very similar in excel. Mine is a 'what-if' calculation. I enter the # shrs to buy, 1st price and anticipated sell price, the formulas then compute profit on that transaction. The spreadsheet passes the total dollars from the sale into another column, you plug in a new purchase price and it will compute how many additional shares you can buy back in at if you are flipping and re-buying.

I agree with you that before you buy a stock you should take the time to decide how much you are trying to make and do some homework.

Be glad to share my sheet with you or anyone interested.

Happy trading

__________________
fz4fun

-----------------------

It's only money----but try not to lose it, OK?

is this one of these if you show me yours I'll show you mine kind of thing?

No, I didn't intend it to sound that way at all. Just offered to share it with anyone interested.


Happy trading

__________________
fz4fun

-----------------------

It's only money----but try not to lose it, OK?

wanna go camping