DATA RECOVERY: Where to get ASX Historical Price History Data in CSV for use in Reckon Accounts Per

Datarec_ReckonLtd

DATA RECOVERY: Where to get ASX Historical Price History Data in CSV for use in Reckon Accounts Personal range (Intermediate/Advanced users)


If you are interested in adding historical ASX prices to your data file you can use the site below to acquire price history data in CSV format

http://www.asxhistoricaldata.com/


The information is provided as ZIP archives containing text files with the following structure.

Security Name, Date, Open, High, Low, Close, Volume

Example only: 

AMC,20190323,14.7,14.7,14.47,14.55,2214918


Notes:
-Dates are in YYYYMMDD format
-Do not include a header line


The Reckon Accounts Personal range software accepts CSV price history in a specific format.
You would need to re-structure the ASX historical price data into a comma-separated format with the following structure.

SECURITYNAME, PRICE, SEPARATOR, DATE(in DD/MM/YYYY), SEPARATOR, HIGH, LOW, VOLUME, END-OF-LINE

THE PRICE value would be the closing (Close) amount
The SEPARATOR consist of three dashes ---
The ENDOFLINE marker consist of an asterix character '*'
The VOLUME value needs to be Volume/100


Example only: 
AMC,14.7, ---, 23/05/2019,---,14.47,14.55,2214918,*


Notes: 
-Dates are in DD/MM/YYYY format, which means you need to transform the date
-Do not include a header line

Below is another support article with relevant info that will assist you.

Importing Share Price Data into Reckon Personal using the CSV (Comma Seperated Value) file format


Regards,

Data Recovery Team