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



06/17/2013
Latest version of NeuralCode(v1.3) for
Neural Networks Trading.



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



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



09/01/2009
Launch of
Free Investment and Financial Calculator for Excel.



02/1/2008
Release of
SparkCode Professional - add-in for creating Dashboards in Excel with sparklines



12/15/2007
Announcing
ConnectCode Duplicate Remover - a powerful add-in for finding and removing duplicates entries in Excel



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


Technical Analysis Add-In

Analysis Add-In Setup

During the installation of TraderCode, the Analysis Add-In and formulas will be automatically setup in Microsoft Excel. It is very simple and straight forward to use the Add-In to create technical indicators for analysis.

In Excel 2003, a new toolbar will be inserted into the workbook after installation.




In Excel 2007, select the Add-In tab, the TraderCode command button will be located in this tab.




To follow this tutorial, you can first can launch Microsoft Excel from the Windows Start Menu and prepare the stock data where the Date, Open, High, Low, Close, Volume columns are adjacent to each other.




This can usually be done by downloading the data directly from financial websites (such as Google Finance or Yahoo! Finance). Refer to the document on "How to Download Stock Data to Excel" for more information or simply launch the TraderCode.xls spreadsheet which comes with pre-setup data.

Step by Step Tutorial

To start the Add-In, click on the TraderCode button as described above. The Add-In main dialog lets you choose an indicator to compute. Simply select a range to apply the computation, and select an output column to place the results.

Steps for Using the Add-In

1. Select a Technical Indicator to compute. For example, the screen below shows the Simple Moving Average being selected.



2. Click the Select Range box and choose a range in the Excel worksheet shown below. Depending on the indicator chosen, the input can be a range from single column or multiple columns. For our Simple Moving Average (SMA) example, we choose the data from the Close column.



3. The Period indicates the number of values used to compute the Moving Average. We will use the default value 10.

4. Click the Place Results in Column box and choose an empty column in the worksheet to place the results.



5. Click the OK button in the ain dialog box to start calculating the indicator values.

6. You will see the results in the column you have chosen.



7. You can now proceed to plot the results in Excel by selecting the Close column and the SMA-10 column and choose Insert->Line in Excel 2007 (or Insert->Chart (Line) in Excel 2003). You will be able to see a graph something as follows.


Options Dialog

The Options Dialog contains some of the generic options that apply to all the technical indicators.
  • Number of Decimal Points - The number of decimal points to round the values of the technical indicators generated.
  • Direction of Calculation - Stock prices downloaded from the internet can be sorted from Oldest to Latest in a Top to Bottom manner, or Latest to Oldest in a Bottom to Top manner. This option indicates whether to calculate the technical indicators from Top to Bottom or Bottom to Top. The default is Top to Bottom.


Back to TraderCode Technical Indicators and Technical Analysis Software


 

Copyright (c) 2007-2015, 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. All other product names are trademarks, registered trademarks, or service marks of their respective owners