Dividend History Data
Collection and Conversion

http://www.tradingroom.com.au/apps/qt/index.ac

We need to download our historic dividend data. The above website has free ASX historical dividend data available as webpages (ie. Go to Quotes & Charts link above, Type stock code, Select Dividend Details, Hit Go). We will need to scrape these webpages for the historical dividend data.

There are two components to this section. One will download of all the historical dividend data files. The other will convert the downloaded data into an Amibroker compatable format. Both these processes are fairly time consuming – Be patient.

Warning, These are dumb converters tailored for Trading Room website dividend data. They will not handle incorrect files or bad data.

Data errors and Corrections

NOTICE: Data is never perfect and you will need to inspect and correct any errors in your CONVERTED data.
Here are some KNOWN data errors you will need to correct in your converted data files:

Search for 00-00-0000 Dates.
Check for problems with stocks named CON, PRN, AUX, NUL.

Prepair the Ticker list

TR-DivData relies on a list of ASX stocks to operate. You must export your list of current ASX stocks to the ASX.tls ticker list in the TRDivData folder. The example ticker list (ASX.tls) is supplied containing active ASX stocks at the time of this archive release.

Once you have your ASX.tls file ready, You may then proceed to download the associated tickers dividend data.

Download of ASX Dividend data

This will download a Dividend data html page for each stock in the ASX.tls list. Once downloaded, these pages can then be converted to Amibroker format.

Download and setup the “TR-DivData-Get.js” script from the above archive. Be sure to keep the existing directory structure. And remember to set the initial directory under Amibroker tools customisation.

Operation of this script is basic. Simply run the script and it will read the ASX.tls then download the Dividend data files. This process can take a long time. You will find the data placed in the StoreRAW directory.

We can now use the data stored in the StoreRAW directory to convert into AmiBroker format. Continue to the next section.

Conversion of ASX Dividend data

This will convert the Dividend data html pages for each stock downloaded based upon the stocks in the ASX.tls list.

Download and setup the “TR-DivData-Conv.js” script from the above archive. Be sure to keep the existing directory structure. And remember to set the initial directory under Amibroker tools customisation.

Operation of this script is basic. Simply run the script and it will read the ASX.tls then convert the Dividend data files. This process can take a long time. You will find the data placed in the StoreDivData directory with the current date attached to the file name.

You must now inspect your Amibroker ready data for errors. If you do find any, Correct the error by editing the converted data file and referring to the corresponding ticker html file for data correction assessment.

We can now use the data stored in the StoreDivData directory to import into AmiBroker. Read the section on importing data.

Errata on Trading Room Dividend data

Data used from source:
Ticker
ExDate (Type 1)
Amount
Franking%
Book Close (Type 2)
Payable (Type 3)