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.
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.
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.
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
- TraderCode is a very useful toolbox for stock traders. You can use it to compute the indicator values for stock prices and plot them in Excel.
- TraderCode provides a convenient library so you can make the computations of the indicators yourself and plot and analyze them.
- A built-in wizard accompanies the library, so that you can use the user interface to select ranges quickly and obtain results.
- TraderCode currently supports some of the most popular and successful technical indicators used by many analysts.
- As you play around with the indicators and become more experienced, you will appreciate the fact that using the different indicators to predict stock prices is like viewing the market in different angles (while suppressing other angles), and they may give very different results.
- The indicators attempt to express as a formula the different relationships that many traders have abstracted over the years of their trading experiences. For example,
- the relationship between prices and volume (OBV)
- the short-term price fluctations along a trend (MACD)
- stock cycles (Moving Averages applied to long term stock movements)
- You may also creatively 'invent' your own indicator using the basic set of functions provided by the TraderCode library. For example, you can try to measure the level of a stock price with respect to several of its competitors by plotting their moving averages alongside each other.
- Depending on the angle you used to compute the indicators, for e.g, the window or period of analysis, you will be able to detect the buy or sell signals, overbought or oversold levels, bullish or bearish signs. The different parameters (e.g the period) that is used to compute the same indicator will predict different results under different situations.
- For example, using the MACD indicator, a same point in time in the chart may sometimes indicate a bullish level when using one set of periods, while the same point may indicates a bearish level when using another set of periods. So it is important to choose the periods carefully. And even if many pairs of periods indicate an bullish level, it may still be possible that other factors not taken into account by this indicator will affect the stock price.
- Also it must be stressed that the fact that multiple traders using the same indicator (with the same parameters) to predict the bullish/bearish signals and taking action as a result of the prediction will alter the outcome itself.
- Thus, understanding these indicators and applying them appropriately will give you a more accurate picture of the market, and TraderCode is the ideal tool for doing so.
- The technical indicators currently implemented by TraderCode include
- External Integration
- TraderCode provides the flexibility for you to use external market data for analysis, charting and backtesting. You may have obtained your market data by exporting data to a comma-separated values (csv) file in some existing trading tools or you may have purchased an entire collection of historical data from some well-known data vendors. In any of these cases, TraderCode lets you use these data very quickly and easily.
- FOREX Technical Analysis
- Import FOREX Market Data for Technical Analysis. - New
Download TraderCode 5.7
Download a free trial of the TraderCode Technical Analysis Software Add-In for Microsoft Excel .
- Microsoft Windows Windows XP, Vista, Server 2003, Server 2008, Server 2012,
- Windows 7, Windows 8 or Windows 10
- 512 MB RAM
- 25 MB of Hard Disk space
- Excel 2003, Excel 2007, Excel 2010, Excel 2013 or Excel 2016
TechnicalIndicators.exe (EXE Format - 5794 KB)
TechnicalIndicators.zip (Zip Format - 4700 KB)
1. 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.
2. In May 2017, the "tables" and "ichart" API from Yahoo to download historical stock data was discontinued by the Yahoo Finance team.
The sample spreadsheet in TraderCode that illustrates the integration of TraderCode with the download of
historical stock data from Yahoo has since been updated to use the new "query1" API. For users of previous version of TraderCode, please contact us via email
to get the latest registered installer.
- Goto Start Menu->All Programs->Microsoft Office->Microsoft Excel.
- Goto the Developer tab and click on the Macro Security button.
- Set the Macro settings to Enable all macros and click on the OK button.