Commsec International
Quick links:
How to import historical trades
You can bulk import your historical buy and sell trades in to Sharesight by uploading a spreadsheet. Read this help guide for step-by-step instructions on how to bulk import your historical trades.
1 - Go to your Commsec International platform
2 - Select Performance & Report > Statement
3 - Select Activity
4 - Set date to cover all transactions
5 - Click Download next to CSV
6 - Go to Gemini
7 - Upload the file
8 - Copy paste the prompt below
Transform the provided trade file into a CSV that can be directly imported into Sharesight.
Output Requirements
Headers must match exactly
File must be ready for direct import into Sharesight
Exclude any rows that do not meet the filtering rules below
Format: Markdown Table (This allows me to use 'Open in Sheets')
Output the complete full table. Do not truncate the output or show a preview.
Row Filtering Rules
Strict Scope & Grounding: > * Act as a data parser. Process only the data contained in the provided file.
DO NOT use external knowledge or invent trades. If the criteria are not met, do not include the row.
Strictly Parse only: Locate 'Trades,Data,Order,Stocks'. If no rows match these four specific criteria simultaneously, return a message stating 'No valid trades found' rather than attempting to guess or use external data.
Section Targeting: * Locate the specific section starting with Trades,Header. * Ignore all other sections, specifically Open Positions, Mark-to-Market Performance Summary, and Transfers.
Row Filtering Rules:
Extract rows strictly where: * Column A = Trades * Column B = Data * Column C = Order * Column D = Stocks * Skip all SubTotal or Total rows within this section.
Column Mapping Rules
Column A – Trade date
Header: Trade date
Source column: Date/Time
Format: YYYY-MM-DD
Column B – Trade type
Header: Trade type
Source column: Quantity
Mapping:
If Quantity is positive, 'Trade Type' = BUY
If Quantity is negative, 'Trade Type' = SELL
Column C – Ticker code
Header: Instrument code
Source column: Symbol
Column D – Market code
Header: Market code
Determine market using the Currency column
Use Sharesight-supported market codes only:
https://www.sharesight.com/au/supported-stock-exchanges-managed-funds-mutual-funds/
Mapping rules
USD → NASDAQ or NYSE (choose the most appropriate based on the company)
GBP → LSE
Column E – Price
Header: Price
Source column: T. Price
Column F – Quantity
Header: Quantity
Source column: Quantity
Column G – Brokerage
Header: Brokerage
Source column: Comm/Fee
Column H – Brokerage currency
Header: Brokerage currency
Source column: Currency
Please double check the data is accurate. Gemini can hallucinate.
9 – Login to Sharesight.
10 - On the Get your investments into Sharesight page, select the Upload a self managed CSV tile. Or click Add investment > Upload via spreadsheet
11 - Click the Upload a file button.
12 – Select the file.
13 - Click import.
How to import ongoing trades
Sharesight supports Commsec International's trade confirmation report.
Manually forward the email to your portfolio email address. Or setup an email forwarding rule in your inbox to have it automatically forwarded to your portfolio email address.