General Topics
Markets
Technical Topics
Brokerage Firms
Company Specific
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 FOR TRADERS BECAUSE OF THE FINANCIAL SUPPORT FROM THESE SPONSORS:
 Alaric Securities EU Licensed Broker/Dealer Algoseek Data Products for Quants AMP Futures Futures Trading Supercenter! AXIA Futures Trader Training and Mentorship Bookmap Visual Trading Platform Cannon Trading Futures and Options Brokerage Databento Pay as You Go Data Vendor dxFeed Market Data Services Guardian Trading Optimized Services for Active Traders Ironbeam FCM & Futures Broker IVolatility Options Data & Analytics Lightspeed Equities & Options Trading Limex Trading Software and Solutions MotiveWave Full-Featured Trading Software Ninja Mobile Trader VPS Virtual Private Trading Servers NinjaTrader Trading Software & Brokerage ninZa.co Indicators for NinjaTrader Norgate Data Historical Market Data NxCORE by NANEX Whole market data feeds.. Optimus Futures Futures Software and Order Routing ORATS Option Data & Backtesting Polygon.io Real-Time & Historic Data Rithmic Futures Trade Execution Platform TradeZero America Commission Free Trading