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.

Tarique says

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

Rajandran R says

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

Kindly check out the updated link

kirtan raut says

how to find service menu in Excel 2003?

Rajandran R says

@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

Vineet says

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

veer says

For Office 2007 how to find service menu.

Regards,

veer

Rajandran R says

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

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

Rajandran R says

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.

veer says

Thank you very much.

Regards,

Veer

Ganesh says

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

Rajandran R says

@Ganesh… Yeh Sure… Will do that…

Rajandran R says

How to Install Ta-Lib Excel addon in Office 2007 -- Videosrinivas murthy says

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

Vinay says

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

Rajandran R says

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

jesse says

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

Rajandran R says

@Jesse…

We need to reconfigure the spreadsheet accordingly for TSX.

Piyush says

Dear Rajandran,

May i have your email id?

Regards,

Piyush

Vinay says

Hi,

Can you please explain how to use this excel sheet…

Thank you

Rajandran R says

@Vinay.

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

Stay tuned

Vinay says

Dear Rajandran,

Eagerly waiting for your excellent work.

Regards

Vinay

Raj says

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

Rajandran R says

sure raj will make a short video on that

ndc says

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!

Rajandran R says

Hi NDC,

Most of the formulas in the addin are based on array formula. Refer Introduction to Array Formula in Excel 2007.

vairamani says

sir ,how to use this file plz explain

Harsimran says

Sir,

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

Saisonia says

Sir,

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

Thank you

shekar says

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

Jimmy V says

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.

rea says

wen i click download my stet up doesnt start?

how to download it get it installed?

rea says

excal addon software is not available plz checkt it out

Rajandran R says

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.

Rajkumar says

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

Rajandran R says

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

rea says

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

George says

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

Siddharth Maheshwari says

any support for

Excel 2011 for Mac ?

Thanks

Gopinath says

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?

andre says

The link for download is dowm! could you share again please?

Rajandran R says

I guess TA-Lib site is now down. Alternatively access here https://github.com/stoni/ta-lib/tree/master/excel

Vin Tal says

Sir,

when i add the xll file in exel 2003 add-ins, i get error ‘not a valid add-in’.

Please help. 🙂

Vin Tal says

Hi sir, i got it working but i do not know how to use it. do you have a how to document?

Vin Tal says

ooops got the sample already in the file, thank you so much sir Raj

SUNIL PATIL 08390490162 says

Dear SIR I have read much more about you on google , i really always thanks god, because the persone like you on earth…, i have not download excel yet, i will do it, if any problem arise plz help me , because i do not have any idea about excel idea, i have seen only exampl in website calculation I know well it only on software , it will decrese my manual seaching i hope

Zim says

Just an add-in with a limit indicators and cannot expand. I think if you want to use a new indicator that not listed in the list so you have to rewrite and recompile the add-in file. It’s not comfortable way I think so, and all the formulas are hidden from viewing so you cannot modified it easily, user can’t learn from inside formulas and I’m not sure about the corrective of formulas.

David says

I want to add dynamic ranges to one of the formulas, like for example get a AROON of period stored in another cel but don’t know how to do it. always get a #N/A and High and Low using DESREF

venkat says

dear,

thank you for the tool…. i installed in my excel but not able to use it; can u pls explain it with a simple video on how to use this tool for technical like MA, RSI or MACD/Stocha …..

awaits for reply…. thank you.

James says

Request you to please share Excel for Supertrend Indicator. Thanx

Nick says

Hello Rajandran,

First of all: thank you for sharing and explaining the add-on tool!

The installation process worked for me, although I do not get any values (N/A) when I make use of some of these functions. I understand from your earlier comments that I need to make use of the array function, but even then it doesn’t work.

Could you tell me for instance with the ADX function what to do in excel to give me an actual value? What I do now is selecting the high, low, closing and date cells and then press ‘CTR-SHIFT-ENTER’. What is needed to take care of the Array issue?

Cheers!

Peter says

Hi

I can not find the downloadable link. Can you help please?

PDR says

Is there a different addins avaiable. Since my machine is having office 2013 64 bit it seems that it is not working. Other Technical analysis addin is not so comprehensive as such

rana says

Hi

I installed the ADDONS but don’t know how to use them.

is there any way to get a pdf or video that explains how to apply the TA functions on the data.

Thanks

sandeep kumar says

Hi,

For Excel 2013 .xll was installed but, I am unable to see the functions.

If possible, please provide the function derivations of the indicator.

Thank you

Kunda says

Have a VBA code for NSE Future Stock prices Live from Google Finance and Live update?

Also, need EMA (high,5) and EMA (low,5) technical analysis added to the VBA.

Please help