Dividend History Data
Importing into Amibroker

We need to import our newly download/converted historic dividend data. For more information regarding the setup of import formats other than what is shown here, Please refer to the Amibroker documentation or online user support facilities.

Setup the Dividend Data Import Format in Amibroker

Locate the import.types.add file in the Dividend History Archive.

Locate the import.types file in your Amibroker/Formats directory (ie. Amibroker install location).

Copy the line from import.types.add and paste it into the import.types file.

Now copy the DivD_DMY_Import.format file to the Amibroker/Formats directory.

Import the data into Amibroker

Load Amibroker.

Select File/Import ASCII from the menubar.

Select Dividend Data DMY from the file types.

Locate/Select your converted Dividend Data file.

Select Open to import.

Go to menu Symbol/Organise Assignments and push DivD tickers into their appropriate categories.

Errata on TRDiv-data to Amibroker format conversion

TRDiv-Data → Amibroker Format:

Ticker FORMAT = TICKER-DivD

Eg. BHP-DivD

Date FORMAT = DD/MM/YYYY , DD-MM-YYYY

Eg. 31/03/2005 , 31-Mar-2005

Type FORMAT = 1 , 2 , 3

Date Types:
Type 1 = Ex Date
Type 2 = Book Close Date
Type 3 = Payment Date

Example:
Ticker,Date,TYPE(123),Value,Franking,0,0
AAB-DivD,24-Jun-2003,1,0.20,0,0,0
AAB-DivD,30-Jun-2003,2,0.20,0,0,0
AAB-DivD,29-Aug-2003,3,0.20,0,0,0
AAC-DivD,23-Oct-2003,1,0.04,100,0,0
AAC-DivD,29-Oct-2003,2,0.04,100,0,0
AAC-DivD,28-Nov-2003,3,0.04,100,0,0