Back to brokers & apps

Questrade

Sharesight allows you to bulk import your historical buy and sell trades directly from Questrade in two ways:

How to connect your Questrade account via Snaptrade

Connect your Questrade account with Sharesight via SnapTrade to sync your historical and ongoing trades into your Sharesight portfolio. All Sharesight and Sharesight Professional users can connect their Questrade account to their Sharesight portfolio using SnapTrade's Integration.

Note: We only allow for the import of standard buy and sell trades via the integration. Short selling transactions, including short and cover trade types, are not supported. You can opt to import all historical trades during initial setup. Ongoing trades will be imported daily.

How to connect your broker account to Sharesight via SnapTrade

Your username/ID and password are required for the integration.

  1. Log into Sharesight.

  2. Click on the ‘Brokers’ tab.

  3. Search for and select Questrade.

Questrade 1

  1. Click the ‘Connect Questrade’ button.

Questrade 2

  1. When the pop-up displays, click ‘Continue’

(You can exit this process at any time by clicking the 'X' in the top right corner)

  1. Click ‘Continue’ again on the next page and you will be redirected to your broker’s website to authorise the connection

Questrade 3

  1. Enter the credentials for your broker account and click ‘Continue’.

Questrade 4

  1. Once logged in, you will be asked to authorize SnapTrade. Click ‘Allow’

(If you select ‘Deny’ you will be redirected back to Sharesight and the connection will not be made)

Alpaca 6

  1. You will be redirected back to Sharesight to choose the account/s you want to connect to.

Ensure you check the box under ‘Import Historical Trades’ if you want all trading history with your broker to be imported into your portfolio.

  1. Click ’Connect'

  2. Your account is now connected.

If you opted to import historical trades please note this process may take a few minutes. You will receive an email once the process is complete, alternatively you can check the transactions log under integration settings to see the outcome of historical trade import.

Ongoing Trades Daily buy and sell trades will be imported at 8am NZST each day and you will receive an email notification if you have set those to ‘on’ or ‘errors only' if any trades failed to be imported. The imported data will display in the transactions log.

Manage your connection The connection/s can be managed in your portofolio's integration settings.

Navigate to your portfolio settings and choose Integrations in the left menu.

The connection should show under ‘Configured Integrations’

Select the connection and the settings will show.

Connection status This shows the status of your connection, which can be either ‘Connected’ or ‘Broken’. If your connection is broken, please click the ‘Reconnect’ button and you will be directed through the process to reconnect.

Historical trades

If you opted to import all historical trades, this will show the earliest date trades were imported from.

Email notifications

You can choose whether or not you receive emails related to the daily import of trades.

Off = no notification when trades are imported

On = daily notification when trades are imported

Errors only = notification only when a trade fails to import

You can delete your connection to your broker by selecting ‘Delete integration’

FAQ

My connection is broken

If the connection is broken, navigate to the integration settings and select ‘Reconnect’, then you will be directed through the flow to reconnect to your broker.

How to connect another account?

Search for your broker in the ‘Brokers’ tab and select it. There will be an option to connect to another account.

How to connect another account with different credentials?

You will need to go to your brokers website within the same browser and log out first.

Historical trades have not come through

First check that you opted to import historical trades y navigating to integration settings. Beneath the historical trades heading this should say ‘Imported from DD/MM/YYYY’

If this says historical trades were not imported then you did not select the option during setup.

I wanted to import historical trades but didn’t select the option

You can delete the integration and reconnect, however this is not recommended if daily trades have already been imported as this may cause duplicate trades. Please contact support.

How to import your historical trades from Questrade to Sharesight via file import

  1. On the ‘Let's get you started with Sharesight’ page, select the 'Import from a Broker' tile and click on Questrade broker tile.

Questrade 1 Questrade 1-2

  1. From the 'Import your historical trade from your Questrade account' window, select the Questrade link.

Questrade 3

  1. In the Questrade ‘Account activity’ banner, select the date range of the period covering trades you would like to import into Sharesight.
Note: Any trades outside the selected date range will not be imported into Sharesight.
  1. Then select ‘Export to Excel’. This will download all buy and sell trades made by Questrade (in the date range selected) into a CSV file which can then be uploaded directly into Sharesight.
Note: If you have changed brokers and transferred the holdings to Questrade these trades will not be in the ‘Exported to Excel’ file and will not be imported into Sharesight. These trades and holdings can be added manually.

3 & 4 select date range & select export to Excel

  1. Upload the file in the Questrade broker tile.

Questrade 4

  1. The ‘Trades to import into Portfolio’ page will show an itemised list of all trades imported from the Questrade exported Excel file. Verify and edit the trade data as required. If trades appear in red, this means that Sharesight can’t upload the trade or the trade will cause errors in your portfolio. The solutions to common errors can be found here.

7 Once you have verified the trade data, select ‘Finish and Import All’.

Questrade 5

8 Once the trades are saved, your Sharesight portfolio will be populated and the Portfolio Overview Page will load.

Questrade 6

Your holdings will be calculated by Sharesight’s performance calculation methodology, which is a money-weighted return methodology, meaning the investment performance figures take account of the size and timing of cash flows. Sharesight will automatically create dividends and corporate actions for the holdings you have imported.

Now that you have populated your portfolio, we recommend you verify and confirm automatically generated data and set up the Trade Confirmation Email Import feature to automatically import future trades.