Where to get ASX Historical Price History Data in CSV for use in Reckon Accounts Personal
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
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
Comments
-
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?
0 -
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:
0 -
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.
0 -
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.
Regards,
Reckon Data Recovery Team
How to ask good questions on the Reckon Community
0
Categories
- All Categories
- 6.8K Accounts Hosted
- 17 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 8 📢 Reckon Accounts Desktop - Announcements
- 1.5K Reckon Payroll
- 39 📢 Reckon Payroll - Announcements
- 15 Reckon Payroll Help Videos 🎥
- 30 Reckon Mate App
- 2.7K Reckon One
- 16 📢 Reckon One - Announcements
- 14 Reckon Invoices App
- 24 Reckon Insights
- 101 Reckon API
- 310 Point of Sale
- 1.9K Personal Plus and Home & Business
- 70 About Reckon Community