Importing Share Price Data into Reckon Accounts Personal range using the CSV (Comma Seperated Value) file format
Legacy KB ID: 3203
Question
What is the right CSV file format to import share price data into my Reckon Accounts Personal range Portfolio?
Answer
Symbol, Closing Price, ---, Date, ---, Hi, Lo, Vol/100, *
Example:
ABC,123.456,---,12/31/02,---,123.111,123.995,150123,*
Note: The volume information is not imported if it exceeds 200,000,000.
Example:
column A: stock code (no trailing blanks, just 3 character code, as you should have in Quicken / Reckon Accounts Personal)
column B: closing price
column C: separator '---'
column D: European date as dd/mm/yyyy
column E: separator '---'
column F: high price
column G: low price
column H: =round(volume/100,0)
column I: end of line '*'
The following import formats are acceptable:
ABC, 123.456
ABC, 123.456, 12/31/02
ABC 123.456 12/31/02
ABC, "ABC", 123.456, "12/31/02"
"ABC", "123.456", "12/31"
Test the import in a copy of your live file where possible (or backup first in case something goes wrong and you need to restore from the last known good copy).
We Recommend using a text editor or Microsoft Excel to edit and manipulate these file types
Detail Instructions
Before you start we suggest to create a couple of backups of your file.
Import security prices from a text file
A text file (or CSV file) is a simple comma-delimited file with the extension .txt or .csv. When you have created your file you must save it in the *.txt file extension.
You can import this file into Reckon Accounts Personal range using the following procedures:
1. Choose Investing menu > Portfolio.
2. Click on File > File Import > Import Prices.
3. In the Import Price Data window, in the File field, enter the full path of the file with your price data.
4. In the Date field, change the date information if necessary.
If the file doesn't contain specified dates, import the prices to the date entered here. The currently selected date in Portfolio is the preset display in this field. Reckon Accounts Personal matches prices with your securities if they have the same symbol. If your securities don't have symbols, you'll need to edit them first so they do.
5. Click OK.
Need more help?
Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts
Or
Log a Support Ticket: https://www.reckon.com/au/support/
