Data and Other Files
This page provides various resources for investors. These resources add value to my methods, which are fully explained in Building Wealth in the Stock Market. Please read the book before using these resources unless you are perfectly clear on their use.
Some of the files on this page are provided in self-extracting zip files. I am using this process to handle large files and multiple file sets. This is of considerable assistance to users who are not yet able to obtain broadband connections. It also obviates the need for zip software on readers' PCs. Although the process of opening self-extracting zip files is very simple, some readers have reported problems with it. I have written some detailed instructions, which are in a PDF file. To open it, click this link:
Instructions for self-extracting zip files
I take all care to calculate and update these spreadsheets and data files, but they may contain errors, which will be fixed when discovered. If you are relying on these files for investment decisions, you are advised to carry out your own checks of their accuracy. If errors are found, I appreciate being advised.
Coppock Spreadsheets
Part of my investment plan uses the Coppock Indicator. There is a full description of the indicator and the way I use it in my book Building Wealth in the Stock Market. Unless you are very familiar with my methods, please read the book before attempting to use the Coppock indicator.
I have created an Excel Workbook containing spreadsheets for the calculation of the Coppock indicator, for the Australian market, based on the ASX All ordinaries Index and for the other major world stock market indexes: Dow Jones Industrial Average (DJIA), S&P500, NASDAQ Composite, FTSE100 (UK), Nikkei225 (Japan) and Shanghai All Ordinaries (China). The calculation steps are shown across the top of the columns, so they may be updated by hand if necessary. The workbook is in xlsx format (Office 2007 and 2010). If working in an earlier version, please first download the free compatibility pack from Microsoft's web site at http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en
This file is a selfextracting zip file.
Australian Fundamental Data
The file containing Australian fundamental ratios is called AUSYIELDAFR. The data are monthly. The file has the following fields:
10YBY(10 year bond yield).
90DBY (90 day bill yield)
These data were originally sourced from a variety of sources, including The Australian Financial Review and Australian Reserve Bank publications and should be taken as indicative only. The file is now being sourced from the Reseve Bank of Australia website and The Australian Financial Review .
ORDSDY (All Ordinaries dividend yield).
ORDSPE (All Ordinaries price earnings ratio).
These data were originally sourced from Shares magazine. Since July 2001, these data have been sourced from The Australian Financial Review. The ratios for the last date in the file will sometimes be slightly earlier than the last day in that month, because the figure for the date closest to the end of month was not available in time. That ratio will be updated to the closest to end of month figure in the file published at the end of the following month.
EY (All Ordinaries earnings yield). This has been calculated by dividing 100 by the ORDSPE field.
There is also a file containing the number of new floats on the ASX. This data file is called NEWFLOATS. These data are monthly.
These data were originally sourced from Shares magazine and AFR Smart Investor magazine. These data are now collected from the ASX web site.
The files are provided in both Insight Trader and ASCII format.
All these files are in a single self-extracting zip file.
Insight Trader Format Data
Copy ALL of the files beginning with A into your Winit/A folder. Copy ALL of the files beginning with N into your Winit/N folder. To plot the files enter the filename as if it was a security code. There are additional instructions on how to plot the fields in this file in the Ask Colin section of the website at (click here).
ASCII Format Data
These are essentially text files. They can be opened in Microsoft Word by setting the file type to All Files. They can also be brought into an Excel spreadsheet using Data/Import External Data.
ASX New High - New Low Index Data and Spreadsheet
I am calculating New High - New Low Index data for the Australian stock market (ASX). There is a spreadsheet which is used to record the data and transcribe it into a data file for charting. The data file is in two formats: Insight Trader and ASCII.
All three files are in a single self-extracting Zip file.
ASX New High - New Low Data and Spreadsheet
Position Size Calculators
I have developed two spreadsheets for the calculation of position size:
Original Position Size Calculator: There is a full description of my investment plan and the way in which I use the original position size calculator in my book Building Wealth in the Stock Market. Unless you are very familiar with my methods, please read the book before attempting to use the position size calculator.
It is in an Excel xlsx (Office 2007 or 2010) spreadsheet file.
The spreadsheet has been created with all care, but I disclaim any responsibility for errors that it may inadvertently contain. You should check the underlying logic carefully and ensure you completely understand it before using it.
Original Position Size Calculator
New Position Size Calculator: In July 2011, I announced and explained some modifications to my investment plan in Members' Newsletter 004. There is additional explanation and examples of its use in the presentation to Sydney ATAA on 18 July 2011. Both of these documents are on the Members' website.
It is in an Excel xlsx (Office 2007) spreadsheet file.
The spreadsheet has been created with all care, but I disclaim any responsibility for errors that it may inadvertently contain. You should check the underlying logic carefully and ensure you completely understand it before using it.
My Insight Trader Chart Arrangement
The way in which I look at charts of stocks is based on a template. Below is al ink to a PDF file which contains instructions on how to create my template and use it.
How to create my Insight Trader chart arrangement
Technical Analysis Filter 23 June 2004
(See Chapter 11 of Building Wealth in the Stock Market)
To download the PDF file, click on the link below:
Technical Analysis Filter 23 June 2004
Fundamental Analysis Filter 15 September 2004
(See Chapter 11 of Building Wealth in the Stock Market)
To download the PDF file, click on the link below: