Technical Analysis Pro Excel Template (25 Technical Indicators)

$67

Based on your convenience you can change the currency at checkout.

Are you looking for a simple and effective way to do technical chart analysis of stocks in a spreadsheet?

Do you want to type in any stock ticker symbol and get technical indicators automatically calculated?

Would you like to be able to look at multiple indicators at the same time?

Are you interested in trading smartly using sound data analysis?

Do you prefer to have the flexibility of an Excel spreadsheet to customize and extend your analysis?

Look no further. We present to you our ‘Technical Analysis Pro Excel Template’.

 

Simple & Effective Technical Analysis Tool

Enter a stock ticker symbol and immediately see live market data and technical indicators. That is it. As simple as it gets.

25 technical indicators sample screenshot
25 technical indicators sample screenshot

You can see the indicator values as well as trading signals.

5 Charts – You can view up to 5 indicators at a time

Candlestick Chart: View candles for any specific date range for your favorite stock.

Candlestick chart for stock market
Candlestick chart for stock market

 

Signal Chart: Choose a technical indicator and see the trading signals (Buy/Sell/Neutral).

Buy and Sell Signals based on Technical Indicator
Buy and Sell Signals based on Technical Indicator

 

DISCLAIMER: We do not provide any trading or financial advice. The template uses Excel formulas calculate mathematically the technical indicator values and applies specific rules or conditions to determine Buy/Sell signal. They are documented in our support portal. 

 

Multiple Indicators Chart: Choose two different indicators to view along with price line.

Multiple technical indicators in one chart
Multiple technical indicators in one chart

In the screenshot above, we are looking t Bollinger Bands as well as EMA Crossover indicators.

More Charts: You can also view 2 charts with one indicator each.

Multiple charts at the same time
Multiple charts at the same time

In the above screenshot, we are viewing RSI and MACD.

25 Technical Indicators

The following technical indicators are included in the template.

  1. Simple Moving Average
  2. Weighted Moving Average
  3. Exponential Moving Average
  4. EMA Envelope
  5. EMA Crossover
  6. SMA Crossover
  7. Bollinger Bands
  8. Donchian Channels
  9. Keltner Channels
  10. Supertrend Indicator
  11. Parabolic SAR
  12. Momentum
  13. Rate of Change
  14. Awesome Oscillator
  15. MACD
  16. Relative Strength Index
  17. Average True Range
  18. Williams %R
  19. Stochastic
  20. On Balance Volume
  21. Commodity Channel Index
  22. Average Directional Index
  23. Ultimate Oscillator
  24. Chaikin Money Flow
  25. Balance of Power

If you need to replace any with indicators of your choice, please email support@indzara.com with your requirements. We take on development projects for a fee and we can provide an estimate to based on your requirements.  

 

Accurate Calculations of Technical Indicators

We have tested each technical indicator’s results with TradingView.com and ensured that the calculations are 100% accurate.

 

Customize the Technical Indicators by controlling the Parameters

You can modify the parameters of the indicators anytime. By this way, you can do the analysis as YOU prefer.

Control parameters for technical indicators
Control parameters for technical indicators

Control the Stock History Data and Timeframe

You can choose to look at latest data or data in the past.

You can also toggle between daily, weekly and monthly timeframes.

 

control dates intervals timeframes
control dates intervals timeframes

 

Easy to Extend

If you need to add any sheets to the file, feel free to. It’s a simple Excel spreadsheet where you can add sheets and do your additional analysis. No Macros are used.

 

Requirements

You can download the template, and open using Microsoft Excel in your computer (PC or Mac). It will also work in browser (Excel for Web).

The template performs all the calculations of the technical indicators, however the stock market history data comes from Microsoft’s service. You will need a Microsoft 365 subscription to get live market data into the template.

Microsoft 365 subscription is the most popular suite of Office apps including Word, Excel, PowerPoint, Teams, Outlook, OneDrive & more. It also includes cloud storage of 1TB.

If you already have a subscription then you don’t need to purchase anything new. Stock market history data is already included in your Microsoft 365 subscription.

Learn about Microsoft 365

 

 

 

Description

Are you looking for a simple and effective way to do technical chart analysis of stocks in a spreadsheet?

Do you want to type in any stock ticker symbol and get technical indicators automatically calculated?

Would you like to be able to look at multiple indicators at the same time?

Are you interested in trading smartly using sound data analysis?

Do you prefer to have the flexibility of an Excel spreadsheet to customize and extend your analysis?

Look no further. We present to you our ‘Technical Analysis Pro Excel Template’.

 

Simple & Effective Technical Analysis Tool

Enter a stock ticker symbol and immediately see live market data and technical indicators. That is it. As simple as it gets.

25 technical indicators sample screenshot
25 technical indicators sample screenshot

You can see the indicator values as well as trading signals.

5 Charts – You can view up to 5 indicators at a time

Candlestick Chart: View candles for any specific date range for your favorite stock.

Candlestick chart for stock market
Candlestick chart for stock market

 

Signal Chart: Choose a technical indicator and see the trading signals (Buy/Sell/Neutral).

Buy and Sell Signals based on Technical Indicator
Buy and Sell Signals based on Technical Indicator

 

DISCLAIMER: We do not provide any trading or financial advice. The template uses Excel formulas calculate mathematically the technical indicator values and applies specific rules or conditions to determine Buy/Sell signal. They are documented in our support portal. 

 

Multiple Indicators Chart: Choose two different indicators to view along with price line.

Multiple technical indicators in one chart
Multiple technical indicators in one chart

In the screenshot above, we are looking t Bollinger Bands as well as EMA Crossover indicators.

More Charts: You can also view 2 charts with one indicator each.

Multiple charts at the same time
Multiple charts at the same time

In the above screenshot, we are viewing RSI and MACD.

25 Technical Indicators

The following technical indicators are included in the template.

  1. Simple Moving Average
  2. Weighted Moving Average
  3. Exponential Moving Average
  4. EMA Envelope
  5. EMA Crossover
  6. SMA Crossover
  7. Bollinger Bands
  8. Donchian Channels
  9. Keltner Channels
  10. Supertrend Indicator
  11. Parabolic SAR
  12. Momentum
  13. Rate of Change
  14. Awesome Oscillator
  15. MACD
  16. Relative Strength Index
  17. Average True Range
  18. Williams %R
  19. Stochastic
  20. On Balance Volume
  21. Commodity Channel Index
  22. Average Directional Index
  23. Ultimate Oscillator
  24. Chaikin Money Flow
  25. Balance of Power

If you need to replace any with indicators of your choice, please email support@indzara.com with your requirements. We take on development projects for a fee and we can provide an estimate to based on your requirements.  

 

Accurate Calculations of Technical Indicators

We have tested each technical indicator’s results with TradingView.com and ensured that the calculations are 100% accurate.

 

Customize the Technical Indicators by controlling the Parameters

You can modify the parameters of the indicators anytime. By this way, you can do the analysis as YOU prefer.

Control parameters for technical indicators
Control parameters for technical indicators

Control the Stock History Data and Timeframe

You can choose to look at latest data or data in the past.

You can also toggle between daily, weekly and monthly timeframes.

 

control dates intervals timeframes
control dates intervals timeframes

 

Easy to Extend

If you need to add any sheets to the file, feel free to. It’s a simple Excel spreadsheet where you can add sheets and do your additional analysis. No Macros are used.

 

Requirements

You can download the template, and open using Microsoft Excel in your computer (PC or Mac). It will also work in browser (Excel for Web).

The template performs all the calculations of the technical indicators, however the stock market history data comes from Microsoft’s service. You will need a Microsoft 365 subscription to get live market data into the template.

Microsoft 365 subscription is the most popular suite of Office apps including Word, Excel, PowerPoint, Teams, Outlook, OneDrive & more. It also includes cloud storage of 1TB.

If you already have a subscription then you don’t need to purchase anything new. Stock market history data is already included in your Microsoft 365 subscription.

Learn about Microsoft 365

 

 

 

FAQ

Some common FAQs

More support articles

 

Reviews

1 2 3 4 5