Would anyone know a good place to find some simple technical indicator formulae for Excel? I was able to figure out the Bollinger Bands as follows: The upper band = ma(A1:A20) + 2*stdev(A1:A20) The middle band = ma(A1:A20) The lower band = ma(A1:A20) - 2*stdev(A1:A20) I'm still working on MACD and RSI.
The formula for RSI is as follows: RSI= 100-100/1+RS RS = (total price gains/n)/(total price losses/n) n=number price changes RSI could be calculated in Excel as follows: Set up a column of 14 prices in column A. (A1:A14) In column B, calculate the difference of each price in column A from the price below it. (B1:B14) RSI = 100-(100/(1+(SUMIF(B1:B14,">0")/16)/((SUMIF(B1:B14,"<0")*-1)/16))) Any comments or corrections would be appreciated
Hi Sam, There's a trading site at Yahoo! that focuses on Excel. Its called Xltraders. Should have lots of what you're looking for. Here's the URL. http://groups.yahoo.com/group/xltraders/ Regards, chaos
you may want to take a look at http://www.debry.com/ and buy their A to Z spreadsheet program. ( Achilles, the guy behind Metastock, wrote a book on all the indicators and this are the formulas in Excel format. )