If you saw my last post, I posted a spreadsheet using Gnumeric. Now, if you are one of those people who use Windows, please stop and get Linux. I recommend Ubuntu.

Now for some reason , like a crazy IT department and you are forced to use Windows you can get a copy of GNumeric For Windows here.

And Gnumeric is much more accurate for finance. Did I mention it has option valuation functions built in ?

I wrote a spread sheet so I could look at a glance and get a price range. This combined with technical analysis is how I SHOULD make my trades. I always start out this way, but I get side tracked.

This spreadsheet helps bring back a little reality to my decision making. If I am thinking about a target price, and I see that it is 2 standard dev’s away, I probably would not take the trade.

The spreadsheet is written for Gnumeric, which is more accurate than Excel. And free. And runs on Linux.

Standard Deviation Spreadsheet

You plug the volatility, price and date into the spreadsheet, and it will calculate the price ranges to 1, 1.5 and 2 standard deviations.