Using the ‘Import Trade’ tool is a quick and easy way to import your historical buy and sell trades from your broker into a new or existing portfolio in Stock Doctor.
How to use the 'Import Trade' tool to import your full trading history from your broker into a new portfolio in Stock Doctor
- Navigate to stockdoctor.com.au
- Click the ‘Portfolio’ tab in the top blue menu bar.
- Create a new portfolio by clicking the 'Create New Portfolio' button.
- Enter the portfolio name.
- Select the trade allocation method you would like assigned to this portfolio
(Note: This trade allocation method will be applied to all sell transactions imported). - Click the ‘Tax’ tab.
- Check Tax treatment of the portfolio.
Learn more about recommended tax settings for different investors - Click ‘Save’.
- Click the newly created portfolio under ‘My Portfolio(s)’.
- Then, click the green 'Import Trade File' button, in the ‘Securities Held’ section.
This will start the import trades wizard. - Select your online broker from the list
(if your broker is not listed, see instruction on how to import trades from a generic CSV file). - Follow the instructions on screen describing how to download your historical transaction file from your broker.
- Then, either:
- Drag and drop the downloaded file into the ‘Upload to Stock Doctor’ panel, or
- Click the green ‘Browse’ button, select the downloaded file and click ‘Open’.
- You will see a box appear briefly with the message 'uploading and analysing files’.
- Next, you will need to review data to be imported. The Review screen contains up 3 tabs:
- Can be imported (no. of trades)
- Can't be imported (no. of trades)
- Can’t be read (no. of rows)
- If you are happy with the list of trades to be imported, click the green ‘Import’ button.
- Alternatively, if you need to amend any trades:
- Click the ‘Download Review Report’ button.
- Amend your downloaded broker file.
- Click ‘Upload’ to return to the upload step.
- Upload the amended file.
- You have now successfully imported your trades into your Stock Doctor portfolio.
- We suggest you click the green ‘Download Import Results’ button, especially if there were records that couldn’t be imported, that you will need to enter manually.
NOTE:
- Broker export files generally do not accommodate corporate actions and off-market transactions, so you may need to manually enter the following transactions:
- Transfers of holdings from another broker
- Off-market transfers
- Shares obtained in a float, dividend reinvestment plan, share purchase plan, bonus issues, or rights issue
- Shares buybacks
- Reconstructions (mergers, acquisitions and spin-offs)
- Splits and consolidations
- NAB confirmation files include cancelled buy and sell orders. These are not distinguished from actual buys and sells in the file, so these will be imported into portfolio manager. You will need to manually delete these cancelled trades after import.
How to use the 'Import Trade' tool to regularly maintain your trading history from your broker into an existing portfolio in Stock Doctor.
- Navigate to stockdoctor.com.au
- Click the ‘Portfolio’ tab in the top blue menu bar.
- Select the portfolio that needs to be updated by clicking its portfolio name.
- Next, use the transaction log report to identify the date of the last trade recorded in your portfolio (you will need to import trades after this date):
- Click the ‘Reports’ tab.
- Click ‘Transaction Log’.
- Set ‘Date range’ to ‘Since Inception’.
- Change date sort order from ‘Ascending’ to ‘Descending’.
- Click ‘Show’ and make a note the date of the transaction in the top row.
- Click the ‘Securities’ tab.
- Click the green 'Import Trade File' button in the Securities Held section.
This will begin the import trades wizard. - Select your online broker from the list
(if your broker is not listed, see instructions on how to import trades from a generic CSV spreadsheet file). - Follow the instructions on screen describing how to download your historical transaction file from your broker.
Specify a date range from the date you noted in Step 4 until today's date. Don't worry if there's a slight overlap in dates, as by default Stock Doctor will exclude any duplicate entries. - Then, either:
- Drag and drop the downloaded file into the ‘Upload to Stock Doctor’ panel, or
- Click the green ‘Browse’ button, select the downloaded file and click ‘Open’.
- You will see a box appear briefly with the message 'uploading and analysing files’.
- Next, you will need to review data to be imported. The Review screen contains up 3 tabs:
- Can be imported (no. of trades)
- Can't be imported (no. of trades)
- Can’t be read (no. of rows)
- If you are happy with the list of trades to be imported, click the green ‘Import’ button.
- Alternatively, if you need to amend any trades:
- Click the ‘Download Review Report’ button.
- Amend your downloaded broker file.
- Click ‘Upload’ to return to the upload step.
- Upload the amended file.
- You have now successfully imported your trades into your Stock Doctor portfolio.
- We suggest you click the green ‘Download Import Results’ button, especially if there were records that couldn’t be imported, that you will need to enter manually.
Now that you have imported your trades, we suggest you:
Review the trades imported as online broker export files generally do not accommodate corporate actions and off-market transactions, so you may need to manually enter the following transactions:
- Transfers of holdings from another broker
- Off-market transfers
- Shares obtained in a float, dividend reinvestment plan, share purchase plan, bonus issues, or rights issue
- Shares buybacks
- Reconstructions (mergers, acquisitions and spin-offs)
- Splits and consolidations