Import Praemium trading history into Sharesight
Step by step guide to bulk importing your buy and sell trades from Praemium:
1 – Login to your Praemium account and download the Premium Trading History CSV file.
2 – Open up your Praemium file in your chosen spreadsheet software.
The file has the brokerage broken into the charge and GST. Recommend adding these columns together in a new column tilted ‘Brokerage & GST import’.
The file contains corporate actions and entitlements these will not be imported into Sharesight and will create errors. The corporate actions will need to be handled manually. We have help pages in our Help Centre to help you handle these. We recommend filtering these out to make the process of importing the trades and manually entering the corporate actions and entitlements easier.
3 – Login to Sharesight.
4 – On the ‘Let’s get started by adding some trades’ page, select the ‘Manual Import’ tab, on the right-hand side of the screen.
5 – Select ‘Choose file’.
6 – From the ‘Open file’ window, find and select your download Premium Trading History CSV file. The file will likely be in your downloads folder. Make sure it is a Comma Separated Values file. If necessary, convert your XLS or XLSX file to CSV format.
7 – Click ‘Open’.
8 – Select you are importing ‘trades’ from the dropdown menu.
9 – Click ‘Upload’.
10 – Select the date format preference. International: DD/MM/YYYY.
11 – On the ‘Bulk Trade Importer - Column Selection’ page; the left side column titles in blue are the Premium Trading History CSV file uploading titles. On the right is the Sharesight fields. Sharesight will automatically suggest Sharesight fields.
To change the selections, select from the dropdown menu to match the Sharesight Field to the Premium Trading History CSV file column content.
This is the mapping of the columns:
|Premium Trading History CSV file||Sharesight columns|
|Cost Per Unit||Price in Dollars|
|Cost Base Unknown||Skip|
|GST On Brokerage||Skip|
|Brokerage & GST import||Brokerage (this is the column you created)|
|GST Other Chargers||Skip|
|Contract Note Nbr/Trans Ref||Skip|
|Basis of Movement||Skip|
12 – Once all columns have been matched with the correct Sharesight field or ‘Skip this column’. Click ‘Start import now’.
13 – The ‘Trades to import into Portfolio:’ page will show an itemised list of all trades imported from the CSV 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.
14 – Once you have verified the trade data, click ‘Save all transactions’.
15 – Once the trades are saved, your Sharesight portfolio will be populated and the portfolio overview page will load.
Your holdings will be calculated by Sharesight’s performance calculation methodology which is a money-weighted return methodology, meaning the investment performance takes account of the size and timing of cash flows. Sharesight will automatically create dividends and corporate actions for the holdings you have imported.
The Premium trading history file contained all the corporate actions and entitlements to the portfolio these will not have been imported into Sharesight. Now work through the corporate actions and entitlements to manually add these to Sharesight. We have help pages in our Help Centre to help you handle these.
Last modified on December 3, 2018 UTC