General Topics
Technical Topics
Brokerage Firms
Community Lounge
Site Support

Excel Technical Indicator Formulae

Discussion in 'Trading Software' started by Sam Mcgee, Mar 29, 2004.

1. Sam Mcgee

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.

Usually it is rather exponential moving average that is used with BB.

3. Sam Mcgee

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

5. Sam Mcgee

Thanks sptrading, I looked at Analyzerxl but they have all the formulae for the indicators hidden.

6. chaos

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.

Regards,

chaos

7. bali_survivor

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. )

ET IS FREE BECAUSE OF THE FINANCIAL SUPPORT FROM THESE COMPANIES: