Importing share data via a CSV file.

Kevin_9915502 · November 10

Hi All,

I am looking into importing my share tranactons into Personal Plus via CSV. I have read a HELP articile at: https://help.reckon.com/article/an97ixs3z8-kba-3203-importing-share-price-data-into-quicken-using-the-csv-comma-seperated-value-file-format.

However I find the article lacking critical format information. It provides some number examples, but without a header line, I don't know what part of the days prices the numbers are referring to. This is the example given:

RKN,2.34,---,2/2/12,---,2.36,2.30,150123,*

I would like to see a header string like:

TICKER, DATE, OPEN, HIGH, LOW, CLOSE, VOLUME.

Does anyone in our community know what the format should actually be?

Cheers Kevin

GerryWinter · November 10

It can be done here for manual entry.

Kevin_9915502 · November 10

Thanks Gerry,

Appreciate the prompt reply. One question, "Price", would that be for the "OPEN" or "CLOSE"?

Cheers, Kevin

Datarec · November 10

There is no header line.

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 *
The VOLUME value needs to be Volume/100

Example:

AMC,14.55,---,23/03/2015,---,14.7,14.47,22149.18,*

Some related help articles.

Importing Share Price Data into Reckon Accounts Personal range using the CSV (Comma Seperated Value) file format - Reckon Help and Support Centre

Converter for ASX price data in CSV format to QIF File — Reckon Community

How to Import Securities - DATE, PRICE, HIGH, LOW, VOLUME- Data into Quicken? — Quicken

Importing share data via a CSV file.

Comments

Categories