Archived and Closed
This conversation is no longer open for comments or replies and is no longer visible to community members.
The issue which has been located on the ASX side of things is still ongoing. The ASX tech team are currently working on this matter. I will post an update for you all, as soon as the issue is resolved.
In the meantime, please see the below link to obtain import files for the last few days of share prices. This page will also run through the steps for how a import is performed.
A link will be provided later in the day for yesterdays share trade (14/07).
This thread has been opened to provide updates and not for discussion - discussion will continue in the ongoing thread.
Thank you all for you understanding and patience during the matter.
The problem must be the link between the ASX database and Reckon, so how about a bit of transparency regarding what the problem really is?
When will it be fixed? It's now Wednesday and downloads for Australia haven't worked since last Friday.
Why can't Reckon put in a little effort so that the .csv files you provide are in a format that is compatible with QPP ?
I reviewed teh download for 10th July in the link you indicated above.
Apart from providing a lot of rubbish (4,269 records for 10th July which are not 10th July), you have provided a .csv file which has code, closing price, date and volume (1,582 records for 10th July).
I was not aware that this format could be read by QPP. ( Please let me know if I am wrong!)
The date has not been converted from yyyymmdd to dd/mm/yyyy
volumes are not divided by 100
This info order is not documented as a valid .csv format for QPP
However, it should have been an easy update for Reckon to provide a useful .csv file in the format :
This would make it much easier for your QPP 2015 clients to obtain the info you have not provided automatically, while all the other sites that provide this info have not reported any problem providing the info.
The following link shows how easy it could be for the valid data.
Our development team is continuing to work with the ASX Technical Support Team to determine the cause of the issue and to then find a resolution.
We are investigating ways to ensure this type of issue doesn’t occur again in the future.
We’ll continue to keep you updated on this issue via the Community and will continue to provide end of day files for manual import into Reckon Account’s Personal via the Knowledge Browser until the issue is resolved.
Sample taken from 20150714.csv
Could you please provide answers as to how the above sample taken from 20150714.csv is read by QPP, especially:
- Is this .csv file structure supported by QPP ?
I assume the field structure is: "Code,Close,yyyymmdd,volume,"
Code appears to be a 6 character field
Price appears to be a 9 character field and has leading zeros, assumed closing price
Date is typically a 8 character yyyymmdd field or can be omitted. Is this recognised?
Volume appears to NOT be divided by 100, as per previous formats.
Your notes indicate that a default date should be provided, so what happens for example with 20150706,0 above ? Are they all replaced by the default date ?
It would be a help to understand what .csv formats are supported by QPP as the format that I have been using; "Code,Close,---,Date,---,High,Low,Volume,*" does have known problems with reading volume.
It would be helpful to us users to know if other formats are available to solve this problem.
still waiting on a response re todays price download 16th July,
11am AEST Friday 17th July
We are still continuing to have problems communicating with the ASX Server. Please be assured this issue is priority number one and further updates to come throughout the day. Our technicians continue to liaise with those from the ASX in an effort to resolve this issue, and restore the share price downloads as soon as possible. We thank you for your ongoing understanding and patience in this matter.
Share prices for the 16th can be found here:
* The KB which holds all the previous days prices will also updated to include these shortly.
On the iPad I use the Bloomberg App which is free. Can set up Portfolios and Watchlists etc from any exchange anywhere.
Thanks Doris for your info on the app. The way Reckon is going, I must seriously consider something more reliable.
17/07/2015 4pm AEST
Hi all, as some users may have noticed, July the 15th is available to download. This as a result of the ongoing work being carried out on the system by our technicians. We will continue work on this matter and we're aiming to have tonight's service restored. Please stay tuned for further notifications as they arrive.
UPDATE 17/07/2015 9:25PM:
Share price update for Friday 17th is available via the one step update.
You may suggest to technical support that they look at the alternate format I provided 2 days ago, for 10th July prices and volumes of 1500 ASX codes. They should provide a .csv file in this format for other days to provide the information that users are missing from the automatic share price download.
While they are at it they should also:
a) confirm that the volume input has a bug and
b) generate better documentation of the available .csv file formats, which should be available.
The response so far from Reckon is a disgrace.
You should be acting on the user's behalf and seeking better performance from technical support.
BEWARE of importing new company codes!!
I have tested the alternative format of "Code,Close,---,Date,---,High,Low,Volume,*"
I generated a .csv file for 10th to 17th in this format (over 10,000 records) then I imported the records into QPP 2013 and found a problem. All the new codes were stored in the .qph file. By the end my company codes had increased from 190 to over 2,500 which is not a good thing. I found this by scanning the new .qph file which increased in size by about 1 mb.
The reltan.com utility can verify this. I don't know an easy way in QPP to report how many different codes are in the .qph file, as there are many stored that are not reported.
Presumably (hopefully) the more concise format of only "code" and "price" does not store new codes. I have not checked this. (note date and volume are ignored.)
Reckon technical support should know of this!
In the past I have always applied a filter to the .csv files I generate and only supply price records to QPP for codes I have in my database.
I generated this new .csv file to provide a link for QPP users to a .csv file that has all information that has been lost. However based on this test, I would be careful to read in a large .csv file with codes not in my database.
I was able to recover my database from backup\qdata1.* and only loose a few days input. I'd recommend that you should backup before importing these large .csv files.
The absence of any timing on an update suggests that the programmers involved have no idea of how to fix it.
I should have said that I am very conversant with Excel and have no problem with importing csv files etc. but the litany of errors and incorrect data tells me to stay away from those.
When will a software update that captures the missing dates be released Mirko?
On Friday 17th July the One Step share Price Download was successful for that day’s trade. Previous days have not been recovered.
For the prices from the 10th to 16th of July, you would need to import these manually. The steps and files can be found here: https://community.reckon.com/reckon/topics/how-to-import-share-prices-csvs
The import file merely provides Closing price and date in the event of a data loss – it is not formatted. Only the One Step Download offers the full range of data.
Some of the issues with this import file raised by users are further explained below;
Import file provided does not support Volume.
Dates – some users have mentioned that dates within the import file do not match the date of the trade. This date is reflective of the last change in price. Reckon Personal does not read this information. It only uses the closing price and date selected when importing.
does that mean it will never be fixed for those dates? We have held off trying updates waiting for a full and complete resolution. Have you given up on that?
mine for 17-7-15 will not update.
please supply the links like you have in the past.
been on holidays so haven't had to worry about this until today.
This conversation is no longer open for comments or replies.
This conversation is no longer open for comments or replies.