Import security prices from an ASCII file

Legacy KB ID: 3153

Question

How can I import security prices in RA Personal

Answer

CSV format for security prices

The data must be in standard ASCII format with one symbol/price/date per line, separated by either commas or double spaces (using only one type of separator per line).

These import formats are all acceptable. Note that RA Personal can handle quotation marks:

  • ABC, 123.456
  • ABC, 123.456, 12/31/05
  • ABC  123.456  12/31/05
  • "ABC", 123.456, "12/31/05"

Once you have the file in this format you can then import it into RA Personal;

  1. Choose Investing menu > Portfolio View.
  2. Choose File menu > Import > Import Prices.
  3. Enter the name or path of the ASCII file that contains the price data. The data must be in an acceptable CSV format.
  4. Change the date information, if necessary, and then click OK.

If the file does not contain specified dates, import the prices to the date entered here. The currently selected date in Portfolio View is the pre set display in this field.

RA 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.

For more information regarding setting up and editing security; see the help index under 'securities'.


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/

How did we do?

Deleting the recently used files from the recently opened file list in Reckon Account Personal (RAP)

Cannot email an invoice – no default email client or cannot fulfill the messaging request

Related Articles

QIF file from St George Bank does not import
The file contains non-ASCII characters error when validating or lodging the Taxable Payments Annual
Strange files and folders appear on my desktop after I import QIF file into QuickBooks.
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)