:: Subscribe to our newsletter
SpreadsheetML Articles
Latest version of TraderCode(v5.6) includes new Technical Analysis indicators, Point-and-Figure Charting and Strategy Backtesting.

Latest version of NeuralCode(v1.3) for
Neural Networks Trading.

ConnectCode Barcode Font Pack - enables barcodes in office applications and includes an add-in for Excel that supports mass generation of barcodes.

InvestmentCode, a comprehensive suite of
Financial calculators and models for Excel is now available.

Launch of
Free Investment and Financial Calculator for Excel.

Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines

ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel

Launch of
TinyGraphs - open source add-in for creating sparklines and tiny charts in Excel.

Add-ins and other tools

TraderCode - Technical Indicators and Technical Analysis Software

TraderCode is a comprehensive library of technical indicators and technical analysis functions for use with Microsoft Excel. It allows you to create many types of technical indicators used in trading systems like Moving Average, Bollinger Bands, Average Directional Movement Index, Oscillators, True Range, Standard Deviation, Donchian Channels and many more. With these indicators you can easily perform end-of-day analysis or back-testing of historical stock data. The software comes with both formulas for Excel and a built-in Wizard to help you create the indicators.

Notice - If you are a user of a previous version of TraderCode (v3.x, v4.x, v5.0, v5.1, v5.5), please contact us for your free upgrade.

Download The Trial - TraderCode - Purchase - Demo Videos

Price $69 (Single User License)

You can also choose to purchase the edition of TraderCode that includes the complete source code. This allows you to understand the technical indicators in depth or customize the software for special needs. A foundation course on Microsoft Excel VBA (Visual Basic for Applications) is also included to get you started quickly.

  User feedbacks

Your customer service and the possibility to easily include stop-losses and take-profits in your backtesting mode have made TraderCode the overall best option in my opinion. I will recommend your software to my circle of trader/investor friends... B.R.

I like that you have created many technical studies into this addin that simplifies the user from having to create these formulas from scratch on the data.
Glenn Martin

An intuitive gui for the first-time and/or novice user... Karl Malmberg

TraderCode is a very useful addon package... Himanshu Mittal

TraderCode has enabled me to thoroughly backtest many strategies in a very efficient manner. I know of no other way to accomplish the results that I have obtained in such a relatively short period of time. F.N.

As a professional Money Manger, I have found that Trader Code is one of the most robust Excel addin programs available for back testing trading ideas. Since it is Excel the learning curve is almost nonexistent and the output data can be formatted into our customized reports. Martin M. (CFP)

Using Microsoft Excel as a platform

The reason for choosing Excel as the platform is an obvious one. It is the ubiquitous tool for analyzing data and crunching numbers. Different tasks like importing data, calculating formulas, charting results and analysing scenario can be easily carried out. It is also one of the most commonly used software by financial and technical analysts. By building on top of the Excel platform, users of TraderCode can tap on the vast variety of functions offered by Excel for further understanding of their data.

Components of TraderCode

TraderCode software is divided into three major components, the Technical Analysis Add-In, the Formulas and the Experts.

Technical Analysis Add-In and Formulas

The Technical Analysis Add-In and Formulas form the foundation of TraderCode since the first version of this popular software. The Add-In allows a user without any prior experience to quickly and easily create technical indicators from a user interface wizard. It also performs validation of the data, allows specification of where the output is to be located and guiding the user in creating the indicators accurately.

For more information, see the Technical Analysis Add-In Tutorial.

The Formulas on the other hand allow users who are more inclined to using Excel formulas to create the indicators in a similar manner.

Technical Analysis Expert

The Technical Analysis Expert is a spreadsheet model that helps you create your own trading system based on the different technical indicators. You can create multiple technical indicators, vary the parameters and repeat the tasks in a spreadsheet environment quickly and easily.

Analysis Expert is unique and extremely productive for technical analysis. It is built on top of the Analysis Add-In and Formulas foundation and is a result of listening to feedbacks and suggestions from our users. Many analysts and users are familiar with spreadsheets and prefer using a spreadsheet environment to a user interface (UI) tool for technical analysis.

For more information, see the Technical Analysis Expert Tutorial or the Technical Analysis Expert Demo Video.

Backtesting Expert

The Backtesting Expert is a spreadsheet model that helps you create trading strategies using the technical indicators and run the strategies through historical data. The performance of the strategies can then be measured and analyzed quickly and easily.

The model can be setup to enter Long or Short positions when certain conditions occur and exit the positions when another set of conditions are met. By trading automatically on historical data, the model can determine the profitability of a trading strategy.

For example, a trader can setup strategies for the Backtesting Expert to enter a Long position when the 12 days moving average of the price crosses above the 24 days moving average. On top of that, the Backtesting Expert can be configured to exit from the Long position when the profit or loss exceeds 10 percent of the original purchase price.

The flexible Backtesting Expert works well with the Analysis Expert. It is able to make use of the different technical indicators generated by the Analysis Expert to make decisions on when to enter or exit a position.

For more information, see the Strategy Backtesting Tutorial or the Strategy Backtesting Demo Video.

Point-and-Figure Charting Expert - New

Point-and-Figure charting is an analysis technique that has been around for many years. It has recently become very popular among traders and investors. This technical analysis technique uses a chart with "X"s and "O"s for predicting financial asset prices. The "X"s are used to indicate rising prices and "O"s to indicate falling prices. The point-and-figure chart is very unique as it does not plot prices against time like other technical analysis charts. Volume is also not taken into account, so it is basically a chart based purely on price movements.

This charting Expert helps you plot Point-and-Figure charts automatically. You can also setup important parameters such as the Box Size and Reversal easily. Besides being able to chart the past prices automatically, you can also choose to plot the chart manually in the Expert to get a better feel of the price trends.

For more information, see the Point-and-Figure Charting Expert Tutorial.

TraderCode Technical Analysis Software

Download TraderCode 5.6

Download a free trial of the TraderCode Technical Analysis Software Add-In for Microsoft Excel .

System Requirements

  • Microsoft Windows Windows XP, Vista, Server 2003, Server 2008, Server 2012, Windows 7 or Windows 8
  • 512 MB RAM
  • 25 MB of Hard Disk space
  • Excel 2003, Excel 2007, Excel 2010 or Excel 2013

TechnicalIndicators.exe (EXE Format - 5550 KB)

TechnicalIndicators.zip (Zip Format - 5458 KB)

TraderCode requires the Excel macro settings to be enabled to run successfully. After installation of the software, you can follow the steps below to enable the settings.

  1. Goto Start Menu->All Programs->Microsoft Office->Microsoft Excel.
  2. Goto the Developer tab and click on the Macro Security button.
  3. Set the Macro settings to Enable all macros and click on the OK button.


Copyright (c) 2007-2014, ConnectCode Pte Ltd. All Rights Reserved.

Trademark Acknowledgements

Microsoft and Microsoft Excel are registered trademarks of Microsoft Corporation. Avery is the trademark of Avery Dennison Corporation. Guppy Multiple Moving Average is the trademark of Guppytraders.com Pty Ltd. All other product names are trademarks, registered trademarks, or service marks of their respective owners