AJ Bell
How to import historical trades
You can bulk import your historical buy and sell trades into Sharesight in a spreadsheet. Read this help guide for step-by-step instructions on how to bulk import your historical trades.
1 - Download your AJ Bell transaction history file
2 - Go to ChatGPT
3 - Upload the file
4 - Copy paste the prompt below
Task
Transform the input trading file into a CSV that is ready for direct import into Sharesight.
General rules
Output CSV only (no explanations, no markdown, no extra text).
Column headers must match exactly as specified below.
One output row per valid trade.
Row Filtering Rules
Include only rows where Transaction is:
Purchase
Sale
Ignore all other rows
Column mapping & transformation rules
Column A – Trade date
Header: Trade date
Source: Date column
Format: YYYY-MM-DD
Column B – Instrument code
Header: Instrument code
Source: Determine the ticker symbol based on the description column. If fund, use ISIN code
Column C – Market code
Header: Market code
Determine stock exchange using the Instrument code column
Use Sharesight-supported market codes only:
https://www.sharesight.com/au/supported-stock-exchanges-managed-funds-mutual-funds/
If the Instrument code is an ISIN, use the market code FundUK for GBP-denominated UK funds.
Mapping rules
If Instrument code is an ISIN → FundUK
If Instrument code is a ticker:
USD → NASDAQ or NYSE (choose the most appropriate based on the company)
GBP → LSE
No default or generic market codes are allowed (e.g. FUND, MUTUAL, OTHER)
Column D – Trade type
Header: Trade type
Source: Purchase / Sale or Transaction column
Valid values only: BUY or SELL (uppercase)
Column E – Brokerage
Header: Brokerage
Calculate as:
Amount (GBP) column - Quantity column * Price column
Value is always positive
Column F – Quantity
Header: Quantity
Source: Quantity column
Column G – Price
Header: Price
Source: Price column
Final validation
Headers must match exactly
File must be immediately importable into Sharesight without manual edits
5 - Download the formatted csv file
Please review and confirm that the instrument code (ticker or ISIN) is correct before importing, as incorrect codes can result in trades being matched to the wrong investment. Fund names and descriptions may not uniquely identify a single security.
6 – Login to Sharesight.
7 - On the Get your investments into Sharesight page, select the Upload a self managed CSV tile.
8 - Click the Upload a file button.
9 – Select the file.
10 - Click import.
How to import holding summary as opening balance
You can import your current holding summary in to Sharesight following Read this help guide the step-by-step instructions below.
1 - Download your AJ Bell portfolio summary as a spreadsheet file.
2 - Go to ChatGPT
3 - Upload the file.
4 - Copy paste the prompt below
Task
Transform the input trading file into a CSV that is ready for direct import into Sharesight.
General rules
Output CSV only (no explanations, no markdown, no extra text).
Column headers must match exactly as specified below.
One output row per valid trade.
Column mapping & transformation rules
Column A – Opening balance date
Header: Opening balance date
Source: Date column
Format: YYYY-MM-DD
Column B – Instrument code
Header: Instrument code
Source: Ticker column
Review the Ticker column. If a value is 3-4 letters (like BARC), treat it as a Ticker. If a value is 7 characters and alphanumeric (like B42NVC3), treat it as a SEDOL and map it to its corresponding ISIN.
Column C – Market code
Header: Market code
Determine stock exchange using the Instrument code column
Use Sharesight-supported market codes only:
https://www.sharesight.com/au/supported-stock-exchanges-managed-funds-mutual-funds/
If the Instrument code is ISIN, use the market code FundUK for GBP-denominated UK funds.
Mapping rules
If Instrument code is an ISIN → FundUK
If Instrument code is a ticker:
USD → NASDAQ or NYSE (choose the most appropriate based on the company)
GBP → LSE
No default or generic market codes are allowed (e.g. FUND, MUTUAL, OTHER)
Column D – Cost Base
Header: Cost Base
Source: Cost column * Quantity
Column E – Quantity
Header: Quantity
Source: Quantity column
5 - Download the formatted csv file
Please review and confirm that the instrument code (ticker or ISIN) is correct before importing, as incorrect codes can result in trades being matched to the wrong investment. Fund names and descriptions may not uniquely identify a single security.
6 – Login to Sharesight.
7 - On the Get your investments into Sharesight page, select the Upload a self managed CSV tile.
8 - Select Opening balances for each holding
9 - Click the Upload a file button.
9 – Select the file.
10 - Click import.
How to import new trades
Sharesight supports AJ Bell using the trade confirmation emails feature. Read here on how to get AJ Bell to send a contract note to your Sharesight portfolio.
-
Log into your AJ Bell account
-
Click Send a secure message
-
Request AJ Bell to send a copy of all future contract notes to your Sharesight portfolio email address.