Technical Indicators in Excel Spreadsheet- Free Addons

Looking for some free tools to help you in analyzing financial data,here is a addon which you can use it in excel spreadsheet to compute Basic technical indicators and it is available at free of cost.The Free addon contains a list of mathematical funtions to compute Technical analysis indicators like RSI,MACD,Bollinger Bands in a very easy format just like sum(), avg()…etc used in excel.


Download Technical Indicators Excel Addon here

List of Available Indicators in the form of funtions

AD – Chaikin A/D Line
ADOSC – Chaikin A/D Oscillator
ADX – Average Directional Movement Index
ADXR – Average Directional Movement Index Rating
APO – Absolute Price Oscillator
AROON – Aroon
AROONOSC – Aroon Oscillator
ATR – Average True Range
AVGPRICE – Average Price
BBANDS – Bollinger Bands
CCI – Commodity Channel Index
CORREL – Pearson’s Correlation Coefficient (r)
DEMA – Double Exponential Moving Average
DX – Directional Movement Index
EMA – Exponential Moving Average
HT_DCPERIOD – Hilbert Transform – Dominant Cycle Period
HT_DCPHASE – Hilbert Transform – Dominant Cycle Phase
HT_PHASOR – Hilbert Transform – Phasor Components
HT_SINE – Hilbert Transform – SineWave
HT_TRENDLINE – Hilbert Transform – Instantaneous Trendline
HT_TRENDMODE – Hilbert Transform – Trend vs Cycle Mode
KAMA – Kaufman Adaptive Moving Average
LINEARREG – Linear Regression
LINEARREG_ANGLE – Linear Regression Angle
LINEARREG_INTERCEPT – Linear Regression Intercept
LINEARREG_SLOPE – Linear Regression Slope
MA – All Moving Average
MACD – Moving Average Convergence/Divergence
MACDEXT – MACD with controllable MA type
MACDFIX – Moving Average Convergence/Divergence Fix 12/26
MAMA – MESA Adaptive Moving Average
MAX – Highest value over a specified period
MEDPRICE – Median Price
MFI – Money Flow Index
MIDPOINT – MidPoint over period
MIDPRICE – Midpoint Price over period
MIN – Lowest value over a specified period
MINUS_DI – Minus Directional Indicator
MINUS_DM – Minus Directional Movement
MOM – Momentum
OBV – On Balance Volume
PLUS_DI – Plus Directional Indicator
PLUS_DM – Plus Directional Movement
PPO – Percentage Price Oscillator
ROC – Rate of change : ((price/prevPrice)-1)*100
ROCP – Rate of change Percentage: (price-prevPrice)/prevPrice
ROCR – Rate of change ratio: (price/prevPrice)
ROCR100 – Rate of change ratio 100 scale: (price/prevPrice)*100
RSI – Relative Strength Index
SAR – Parabolic SAR
SAREXT – Parabolic SAR – Extended
SMA – Simple Moving Average
STDDEV – Standard Deviation
STOCH – Stochastic
STOCHF – Stochastic Fast
STOCHRSI – Stochastic Relative Strength Index
T3 – Triple Exponential Moving Average (T3)
TEMA – Triple Exponential Moving Average
TRANGE – True Range
TRIMA – Triangular Moving Average
TRIX – 1-day Rate-Of-Change (ROC) of a Triple Smooth EMA
TSF – Time Series Forecast
TYPPRICE – Typical Price
VAR – Variance
WCLPRICE – Weighted Close Price
WILLR – Williams’ %R
WMA – Weighted Moving Average

Just unpack it to somewhere in your computer. Open Excel, select from menu: ‘Service’, then ‘Add-In’. If you are using Excel 2003 the procedure may differ.

1)Copy the ta-lib.xll file
2)Open Excel 2003 goto Tools->Addons->Browse Note the path and Paste the ta-lib.xll file in that path… Also check ta-lib in the list of addon

If you are trying with some other version try googling or use the MS Office Help

Then to insert the file ta-lib.xll to the list which was opened (because you press ‘Add-In’) choose the file’s location by pressing ‘Browse’, then find this file (ta-lib.xll). Make sure that ‘ta-lib’ was added in.

Then you may close everything if you want.

In the file example.xls you will see the examples of indicators (examples only).
And in the file func_list.txt you may see the list of the functions available (to work with this indicators).

So, just open your Excel (with your data) once again,press Shift-F3, and you will see the master of function’s menu,
select any required indicator you want to configure.

Related Readings and Observations

  • Merge Indices & Bhavcopy text files into One text file Use the link given to access the Excel VBA that will merge different EOD Indices files to the main Bhavcopy file. This is a temporary arrangement till the GetBhavCopy gets in order.
  • VBA Macro to Download Bhavcopy Here is a initiative from me to automate the NSE EOD data in ASCII format using simple VBA Scipts in MS Excel. The following MS Excel VBA macro copies the Getbhavcopy zip file corresponding to 02No...
  • TA Lib Excel Addon installation in Ms Office 2003 & 2007 Here is a simple video that explains how to install TA Lib Excel Addon installation in Ms Office 2003.Ta-Lib is a free tools to help you in analyzing financial data,which you can be used in excel s...
  • How to Extract Data from Nseinda.com using Google Docs Here is a short and very simple video tutorial about how to extract remote data from a webpage(nseindia.com) into your google spreadsheet. It also describes how to share the Extracted table content...
Rajandran R

Rajandran is a trading strategy designer and founder of Marketcalls, a hugely popular trading site since 2007 and one of the most intelligent blog in the world to share knowledge on Technical Analysis, Trading systems & Trading strategies. More From Rajandran R »

39 comments… add one

  • Tarique September 25, 2010, 7:31 pm

    i downloaded the .jar file, now how do you unpack it? I unzipped it but not getting any .xll file..!!!

    Reply
    • Rajandran R September 25, 2010, 8:59 pm

      @Tarique… Iam sorry i had updated the correct link now…. Jar file is for different purpose.
      Kindly check out the updated link

      Reply
  • kirtan raut September 26, 2010, 8:25 am

    how to find service menu in Excel 2003?

    Reply
    • Rajandran R September 26, 2010, 8:46 am

      @Kirtan raut :

      1)Copy the ta-lib.xll file
      2)Open Excel 2003 goto Tools->Addons->Browse Note the path and Paste the ta-lib.xll file in that path… Also check ta-lib in the list of addon

      Reply
  • Vineet September 26, 2010, 10:16 am

    Great Post. Can be a very useful for plotting some technical indicators without buying any expensive tools. Thanks

    Reply
  • veer September 26, 2010, 11:07 am

    For Office 2007 how to find service menu.

    Regards,

    veer

    Reply
  • Rajandran R September 26, 2010, 11:20 am

    @Veer …. You can try this one for a sample solution in Office 2007

    http://peltiertech.com/WordPress/installing-an-add-in-in-excel-2007/

    Reply
  • Rajandran R September 26, 2010, 11:25 am

    I tried Ta-Lib with Office 2003 for RSI(2) along with 5EMA High and 5 EMA low.It work fine and values are perfect.

    One more thing i just want to point out. Most of the funtions in Ta-Lib Addon uses “Array Formula”. But a normal excel user wont be aware about those ARRAY FORMULA in Excel. This is done by selecting the whole output range and press CTRL-SHIFT-ENTER after entering or modifying the formula. If you want to know more about it then you can learn more about Array Formula from the Excel Help.

    Reply
  • veer September 26, 2010, 12:41 pm

    Thank you very much.

    Regards,

    Veer

    Reply
  • Ganesh September 26, 2010, 9:41 pm

    Rajendran,

    Please can u post some examples , i added it in ADDON all but i dont know how to use it in excel file…
    Thanks..

    Reply
    • Rajandran R September 27, 2010, 9:38 am

      @Ganesh… Yeh Sure… Will do that…

      Reply
  • Rajandran R September 28, 2010, 5:41 pm

    How to Install Ta-Lib Excel addon in Office 2007 – Video

    httpv://www.youtube.com/watch?v=UJeJAfhvUk8

    Reply
  • srinivas murthy September 29, 2010, 10:48 pm

    hai,

    I have a amibroker software ,can you help me to make a icchimoku charts on my amibroker software .I” am ready to pay the charges

    Reply
  • Vinay September 30, 2010, 10:16 pm

    Add on has been installed but how to use this excel… how to feed data in to excel it is manually feeded or what…. pls give some clue…

    thanks

    Reply
    • Rajandran R September 30, 2010, 10:37 pm

      @vinay : I will be explaining here before the week ends!

      Reply
  • jesse September 30, 2010, 11:31 pm

    Hello Rajandran,

    I just stumbled on your website last night while searching for Heatmap on google.

    I was wondering whether I can use your heatmap spreadsheet on North American stocks, NYSE, Amex, and/or Canadian stocks on TSX?

    jesse

    Reply
    • Rajandran R October 1, 2010, 11:21 am

      @Jesse…

      We need to reconfigure the spreadsheet accordingly for TSX.

      Reply
  • Piyush October 1, 2010, 6:11 pm

    Dear Rajandran,

    May i have your email id?

    Regards,
    Piyush

    Reply
  • Vinay October 4, 2010, 7:36 pm

    Hi,

    Can you please explain how to use this excel sheet…

    Thank you

    Reply
    • Rajandran R October 4, 2010, 9:35 pm

      @Vinay.

      Iam planning to make one…missed to do this week…will do soon
      Stay tuned

      Reply
  • Vinay October 6, 2010, 8:46 pm

    Dear Rajandran,

    Eagerly waiting for your excellent work.

    Regards
    Vinay

    Reply
  • Raj October 18, 2010, 2:06 am

    It is a wqonderful tool for those who do not have a charting package with all the technical analysis tools.

    BTW, it would be helpful if you could make a short video on how to input variables for a few commonly used indicators like MAs, MACD, Stochastic, etc.

    For instances, thee are two variables viz.,In Real & Time period for moving averages. I have selected closing price column worth five rows for In real input and input a value of 5 in the Time period to get a 5 EMA. But I get a result in the cell as ”N/A”.

    Look forward to your advise.

    Keep up your good work.

    Regards,

    Raj

    Reply
    • Rajandran R October 18, 2010, 7:50 am

      sure raj will make a short video on that

      Reply
  • ndc May 30, 2011, 7:39 pm

    HiRajandran , I tried using your add-in but I keep on getting N/A similar to what the Raj encountered. What do you think we are doing wrong? Thank you very much!

    Reply
  • vairamani May 31, 2011, 10:00 pm

    sir ,how to use this file plz explain

    Reply
  • Harsimran January 10, 2012, 10:50 pm

    Sir,
    unable to use every time the result is #NA………kindly help

    Reply
  • Saisonia January 30, 2012, 11:43 am

    Sir,
    Excellent work. Very well explained. the download is not available. Can it still be downloaded.

    Thank you

    Reply
  • shekar February 11, 2012, 12:32 pm

    sie iwant latest AFL closeof the twodays price and midpoint and above that the current market price should be run .pl.try to give me link as soon as possible

    Reply
  • Jimmy V March 21, 2012, 6:29 pm

    Hi. I have not been successful in finding a link where I can download the spreadsheet add on library. Can you forward/advise of a live link? Thanks so much.

    Reply
  • rea March 27, 2012, 11:26 am

    wen i click download my stet up doesnt start?
    how to download it get it installed?

    Reply
  • rea March 27, 2012, 11:39 am

    excal addon software is not available plz checkt it out

    Reply
  • Rajandran R March 27, 2012, 12:19 pm

    Jimmy and REA

    I had updated the New link for Ta-Lib Pro Download. But not the download is not available for free but trial version is availabe.

    Reply
  • Rajkumar March 31, 2012, 11:50 pm

    Raj, can you forward me the ta-lib zip file, as now it provides only Trial version.

    Reply
    • Rajandran R April 1, 2012, 1:28 am

      @rajkumar : I dont have the file now with me.

      Reply
  • rea April 4, 2012, 12:15 pm

    sir i have got the trial version
    wen i unpacked it is not in xll
    it is in .dll file extension
    do i have to convert or do i have to install any other requirement program?
    kindly let me know and thanks for ur previous reply

    Reply
  • George May 17, 2012, 10:05 pm

    Hi RAJ , after downloading and adding in the TALIB addon , how do i get access to the other functions

    Reply
  • Siddharth Maheshwari June 18, 2013, 3:14 pm

    any support for
    Excel 2011 for Mac ?

    Thanks

    Reply
  • Gopinath April 4, 2014, 12:55 pm (2 weeks ago)

    You have made very good efforts!

    I will be very thankful if you can include “Commodity Selection Index” which will be useful to identify Quality shares and as detailed by Welles Wilder in his book?

    Reply

Leave a Comment

Follow Us

Recommend on Google

About the Author

    • Rajandran is a Market Analyst and founder of Marketcalls, one of the most intelligent blog in the world to share knowledge on Technical Analysis, Trading systems & Trading strategies.