Where to get ASX Historical Price History Data in CSV for use in Reckon Accounts Personal

Options
Datarec_ReckonLtd
Datarec_ReckonLtd Reckon Staff Posts: 1,110 Reckon Staff

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

Comments

  • Mark_7838462
    Mark_7838462 Member Posts: 16 ✭✭
    edited May 17
    Options

    Thanks for this. Does this mean that all users of Reckon 2022 will not be able to Download Historical Prices or is there somethng peculiar with my configuration?

  • Mark_7838462
    Mark_7838462 Member Posts: 16 ✭✭
    Options

    Further to this when I used this online as a test:

    ANR,0.039,---,28/03/24,---,0.042,0.035,128557,*

    also

    ANR,0.039,---,28/03/2024,---,0.042,0.035,128557,*

    and set the date to 28/3/24

    I get:

  • Mark_7838462
    Mark_7838462 Member Posts: 16 ✭✭
    Options

    I can now report that thje problem was simple to solve; there was carriage reurn/new line in the file. All is good now.

    However, it is important for me to know whether Diwnload Historical Prices is permanently broken for everyone and, if so, will it be fixed?

    If it is peculiar to my configuration, please advise why.

  • Datarec_ReckonLtd
    Datarec_ReckonLtd Reckon Staff Posts: 1,110 Reckon Staff
    Options

    Thank you for sharing your findings to resolve the issue with the import.

    For the other enquiry relating to download of historical prices, using the Sample file we can see that the historical prices are only picking up US Securities as indicated in the screen.

    There is no preference or other setting to enable it for Australian securities historical prices.