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.

Bulk CSV import step 5

5 – Select ‘Choose file’.

Bulk CSV import step 4

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

Bulk CSV import step 6 & 7

8 – Select you are importing ‘trades’ from the dropdown menu.

Bulk CSV import step 8 opening balance

9 – Click ‘Upload’.

Bulk CSV import step 9 trade

10 – Select the date format preference. International: DD/MM/YYYY.

Bulk CSV import step 10

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 fileSharesight columns
TypeTrade Date
CodeInstrument Code
Security NameSkip
ExchangeMarket Code
DateTrade Date
QuantityQuantity
Native AccruedSkip
Cost Per UnitPrice in Dollars
Total AmountSkip
Accrued InterestSkip
Cost Base UnknownSkip
Charged BrokerageSkip
GST On BrokerageSkip
Brokerage & GST importBrokerage (this is the column you created)
Other ChargesSkip
GST Other ChargersSkip
GST ClaimableSkip
Settlement DateSkip
Disposal MethodSkip
Notescomments
Confirmed?Skip
Buy Back?Skip
Deemed AmountSkip
Broker NameSkip
Contract Note Nbr/Trans RefSkip
Basis of MovementSkip
Cash MatchedSkip
Maturity DateSkip
MatchedSkip
Entry DateSkip
Amendment DateSkip

12 – Once all columns have been matched with the correct Sharesight field or ‘Skip this column’. Click ‘Start import now’.

Bulk CSV import step 11 & 12

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

Bulk CSV import step 13 & 14

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.

Now that you have populated your portfolio we recommend you verify and confirm automatically generated data and set up the broker email import feature to automatically import future trades.

Bulk CSV import step 15

Last modified on December 3, 2018 UTC