|
|
Technical Analysis Expert
Technical Analysis Expert Step by Step Tutorial
1. Start the Technical Analysis Expert
The Technical Analysis Expert can be started from the Windows Start Menu-> Programs -> TraderCode -> Technical Analysis Expert. This launches a spreadsheet model with multiple worksheets that allows you to download data, generate technical analysis indicators, chart the results and configure the technical indicators parameters.
2. Make sure you are connected to the internet.
3. Using the default values in the "DownloadData" worksheet, click on the "Download, Analyze and Chart" button.
Stock prices of "YHOO" (Yahoo) will be downloaded from http://finance.yahoo.com and placed in the "AnalysisOutput" worksheet. The technical indicators are also generated in the "AnalysisOutput" worksheet after the data has been downloaded completely. Notice that over 40 types of technical indicators can be created so quickly and easily.
Explanation of the different Worksheets
DownloadData worksheet
All the input fields are marked with the "*" symbol.
- Start Date (MM/DD/YYYY)* - The start date to download the stock prices.
- End Date (MM/DD/YYYY)* - The end date to download the stock prices.
- Stock Quotes Frequency* - Whether to download Daily, Weekly or Monthly data.
- Use Adjusted Close for Analyzing (Y/N)* - Whether to use the Close or Adjusted Close to generate the technical indicators.
- Stock Symbols* - Prices and Volume information of this specific stock symbol will be downloaded.
- Download button - Download the stock data as specified in the above inputs.
- Download and Analyze button- Download the stock data and generate the technical indicators specified in the "AnalysisInput" worksheet.
- Download, Analyze and Chart button- Download the stock data, generate the technical indicators specified in the "AnalysisInput" worksheet and chart the results specified in the "ChartInput" worksheet.
Tip - Existing data and charts will be automatically deleted when a action relating to the buttons above are carried out.
AnalysisInput worksheet
This is the worksheet to configure the parameters of the different technical indicators. You can delete the technical indicators that you do not use or create multiple copies of the same technical indicator with different parameters.
- Technical Indicators* - The names of the technical indicators. The following lists of indicators are supported. Please note that the name of the indicators must match exactly as the names specified below. It will be easier if you copy and paste the names from an existing spreadsheet. Simply leave blank if no technical indicators are required. It is important to note that the technical indicators are generated in the sequence specified.
- Accumulation / Distribution Line (ADLINE)
- Average Directional Movement Index (ADX)
- Average True Range (ATR)
- Chaikin Money Flow (CMF)
- Commodity Channel Index (CCI)
- Directional Movement Index (DX)
- Donchian Lower Band
- Donchian Middle Band
- Donchian Upper Band
- Elder Force Index (EFI)
- Elder-Ray Index Bear Power (ERBE)
- Elder-Ray Index Bull Power (ERBU)
- Exponential Moving Average (EMA)
- Fibonacci Extension (FIBE)
- Fibonacci Fan (FIBF)
- Fibonacci Retracement (FIBR)
- Linear Regression Indicator (LRI)
- Lower Bollinger Band (LBB)
- Momentum (MOM)
- Money Flow Index (MFI)
- Moving Average Convergence/Divergence (MACD)
- Negative Directional Movement Indicator (NDMI)
- On Balance Volume (OBV)
- Parabolic (SAR)
- Percentage Price Oscillator (PPO)
- Percentage Volume Oscillator (PVO)
- Pivot Point - Camarilla (PIVOTCAM)
- Pivot Point - DeMark's System (PIVOTDMK)
- Pivot Point - Woodie's System (PIVOTWD)
- Pivot Point (PIVOT)
- Positive Directional Movement Indicator (PDMI)
- Rate of Change (ROC)
- Relative Strength Index (RSI)
- Simple Moving Average (SMA)
- Sine Weighted Moving Average (SWMA)
- Stochastic Oscillator (%D)
- Stochastic Oscillator (%K)
- Triangular Moving Average (TMA)
- True Range (TR)
- Ulcer Index (UIX)
- Upper Bollinger Band (UBB)
- Wilder's Moving Average (WMA)
- Williams %R
- Parameters Values* - Different technical indicators require different parameters. The values of the different parameters are specified in these six columns. Some indicators do not require parameters and you can simply leave the columns blank in the Parameter Values section. Each of the Parameter Values is described in the Parameter Names and Comments fields.
- Parameter Names and Comments - These two fields are for documentation purposes only. They describe the Parameter Values fields.
- Analyze button - This button allows you to generate the technical indicators specified without downloading data.
Tip - A maximum of 100 technical analysis indicators can be generated at one time. Additional technical indicators specified will be ignored.
AnalysisOutput worksheet
This is the worksheet where the downloaded data will be placed and also where the technical indicators are generated.
The downloaded data will be placed in the following sequence.
Date, Open, High, Low, Close, Volume, Adj Close
If Adjusted Close is specified to be used for the calculation of the technical indicators, the downloaded data will be placed in the following order.
Date, Open, High, Low, Adj Close, Volume, Close
Once the data is downloaded, the technical indicators will be generated according to the order in the "AnalysisInput" worksheet.
For example,
ADLINE, ADX, ATR, CMF-21 ...
ChartInput worksheet
This worksheet allows you to generate and customize the different charts. The current spreadsheet allows up to a maximum of nine charts. The rationale behind this is most professional analysts have mentioned that they only rely on a handful of charts. Having too many charts will have a negative impact on their decisions. The charts will be generated in the "ChartOutput" worksheet.
- Chart Name* - This name will be used as the Chart Title in the "ChartOutput" worksheet. It is used for identifying a chart. If the name is left blank, no chart will be generated.
- Chart Columns (from AnalysisOutput)* - The columns from the "AnalysisOutput" worksheet to be used as the input source of the chart. Up to a maximum of six input columns are supported. The columns are specified using the column alphabet. For example, column "A" is the "Date" field, column "B" is the "Open" field and column "C" is the "High" field. Only column "A" to column "CZ" are supported.
- Clear Charts button - Delete all the charts in the "ChartOutput" worksheet.
- Chart It button - Generate the charts in the "ChartOutput" worksheet.
ChartOutput worksheet
The charts specified in the "ChartInput" worksheet are generated in this worksheet.
They are placed in the following order to provide an easy overview.
| Chart 1 | Chart 2 | | Chart 3 |
| Chart 4 | Chart 5 | | Chart 6 |
| Chart 7 | Chart 8 | | Chart 9 |
ExpertUIInternal worksheet
This is a worksheet that is used internally by the Technical Analysis Expert. Please do not delete or edit this worksheet.
Back to TraderCode Technical Indicators
|
|
 |
 |
