Stock: Technical Analysis

Motivated by email from Jim B.
Many stock trading strategies involve staring at charts of Stock Price, Moving Averages, Exponential Moving Averages, MACD, RSI, Stochastics ...
>Huh?
All that stuff is here, but let's recap a wee bit:
 MA (Moving Average) of prices P:
 Pick a number, like N = 20.
 Generate MA = Average of Stock Prices over the last N days.
 EMA (Exponential Moving Average) of prices P:
 Pick a number, like N = 20 and calculate A = 1  2/(N+1).
 Start with EMA = Stock Price.
 Generate today's 20day EMA from yesterday's like so: EMA[today] = A*EMA[yesterday] + (1A)*P[today].
 MACD (Moving Average Convergence Divergence):
 Pick two numbers, like N = 12 and M = 26.
 Generate: MACD = (12day EMA)  (26day EMA).
 Generate, in addition, the MACD "trigger" = 9day EMA of MACD. (It smooooths out the MACD curve.)
 RSI (Relative Strength Index):
 Pick a number like N = 14.
 Calculate U = the Average of stock Price Increases over the past N days. (If it's not an Increase, ignore it.)
 Calculate D = the Average of stock Price Decreases over the past N days. (If it's not an Decrease, ignore it.)
 Generate: RSI = 100*{ 1  1/(1+U/D) }. (U and D are both nonnegative. If D = 0 you're in BIG trouble.)
 RSC (Relative Strength Comparison):
 Pick a number like N = 14 and a "Benchmark" or Index. (Like the DOW.)
 Calculate P = the Stock Price Gain over the past N days.
 Calculate Q = the Index Gain over the past N days.
 Generate: RSC = 100*P/Q. (If it's greater than 100 you're laughin' ... cause the Stock is doin' better than the Index, eh?)
 Stochastics (Fast and Slow):
 Pick a number like N = 14.
 Note today's price, P.
 Determine H = the largest stock Price over the past N days.
 Determine L = the smallest stock Price over the past N days.
 Generate: %K Stochastic = 100*(P  L) / (H  L).
 Generate, in addition, %D Stochastic = 3day MA of %K. (It smooooths out the "fast" %K stochastic curve.)
>Don't tell me!! You stick all this in a spreadsheet, right?
Yes ... and it looks like this: (Click on the picture to download the spreadsheet.)
>That's it?
That's it.
>And it's guaranteed accurate?
... or your money back.
