How to import share prices CSVs

  • 5
  • Article
  • Updated 4 years ago
  • (Edited)
1.    Before you start we suggest you backup your datafile: File > Backup

2.    Create a folder on your C Drive called SPD (for share price download)
  • Browse to your C drive.
  • Right click on your mouse and create a new folder.
  • Once file is created right click on it and select rename.
  • Rename the folder to something easy. We recommend SPD. If you chose a different name, please make sure in all future steps you replace SPD with your chosen folder name.

3.    Make a backup of your datafile: File > Backup

4.    Download the share price data and save to your C:\SPD folder.

a.    Click on each link to download the share prices for those days;

b.    For options prices, click on these further links:

5.    Open Reckon Accounts Personal and import these files:

a.    Using the top menu options, Investing > Portfolio > File > File Import > Import Prices

b.    In the Import Price Data window, in the File field, type in the full path of the first share price data file:

                                          i.    For example:   C:\SPD\20150710.csv

                                         ii.    If you saved the file to your Desktop then the full path will be C:\Users\Your windows username\Desktop\20150710.csv

c.    In the Date field, enter the first date:  10/07/2015. - This is vital. You can only import one day/file at a time.

d.    Click OK to import the share prices

c.    If you track Options, repeat the same with the Options file.

6.    Repeat Step 5 with the next dates/import files.
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb

Posted 4 years ago

  • 5
Photo of Wally Hunter

Wally Hunter

  • 130 Points 100 badge 2x thumb
That worked OK except the share prices file for the 16/7/2015 had a reverse file name i.e 16072015.csv.
Photo of Andrea Gray

Andrea Gray

  • 122 Points 100 badge 2x thumb
How do I do the import with Home and Business 2015? Also gives an error on 20150716.CSV.
Photo of Wally Hunter

Wally Hunter

  • 130 Points 100 badge 2x thumb
Hi Andrea,

Check the file name is correct, please see my post above.
Photo of Andrea Gray

Andrea Gray

  • 122 Points 100 badge 2x thumb
There is no option:  Investing > Portfolio > File > File Import > Import Prices in this version. 
Photo of Andrea Gray

Andrea Gray

  • 122 Points 100 badge 2x thumb
I mean in Home and Business 2015.
Photo of Andrea Gray

Andrea Gray

  • 122 Points 100 badge 2x thumb
Please respond.
Photo of Wally Hunter

Wally Hunter

  • 130 Points 100 badge 2x thumb
Hi Andrea,

If you follow the steps above:


b.    In the Import Price Data window, in the File field, type in the full path of the first share price data file:

                                          i.    For example:   C:\SPD\20150710.csv

I had to change the file name to C:\SPD\16072015.csv instead of C:\SPD\20150716.csv

Hope that helps
Photo of Andrea Gray

Andrea Gray

  • 122 Points 100 badge 2x thumb
Don't worry have spoken to someone. 
Photo of Peter Marshall

Peter Marshall

  • 154 Points 100 badge 2x thumb
There are two Share Price files for 16/07/2015. Which one do we use?
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Good spot Peter! Updated to remove incorrect file.
Photo of Michop

Michop

  • 132 Points 100 badge 2x thumb
What a silly idea to not include "Browse" function for every file operation.
Photo of John Campbell

John Campbell

  • 4,042 Points 4k badge 2x thumb
The US version of QPP does support Browse. For some reason Reckon Aust took over the Australian users and then stopped any improvements.
Photo of Andrea Gray

Andrea Gray

  • 122 Points 100 badge 2x thumb
I agree - unnecessarily time-consuming to type it in each time.
Photo of John Evans

John Evans

  • 60 Points
Write a replyThere is no option:  Investing > Portfolio > File > File Import > Import Prices in my version Personal Plus 2015
Photo of Michop

Michop

  • 132 Points 100 badge 2x thumb
You actually put Reckon into Portfolio view and then use the "normal" File menu. The instructions seem to have extra ">".
Photo of Andrea Gray

Andrea Gray

  • 122 Points 100 badge 2x thumb
Where are Friday's files? Are you going to put these up?
Photo of Mirko

Mirko, Alum

  • 34,812 Points 20k badge 2x thumb
Hi Andrea, Friday the 17th should be available via the one step download. :)
Photo of Dale

Dale

  • 60 Points
That all worked fine. Just copy the file name and path into notepad, then copy it into the import box and change the last digit and the date picker. The data appears to be a partial solution. The files are only for closing price. Where is the high, low and volume figures? Is there another file format for the full set of data please?
Photo of Andrew Dowling

Andrew Dowling

  • 70 Points
One step download not working for me ...