IG Markets

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 - Download your IG transaction history file

2 - Go to ChatGPT

3 - Upload the file

4 - Copy paste the prompt below

Column mapping & rules
Column A – Trade date
Header: Trade date
Source: Trade date / Date column in the file
Format all dates as YYYY-MM-DD
Column B – Instrument code
Header: Instrument code
Populate the ticker symbol based on the company name in the file
Use the appropriate exchange based on the market country (see Column C)
Column C – Market code
Header: Market code
Determine the market using the currency column
Use Sharesight’s supported market codes from:
https://www.sharesight.com/au/supported-stock-exchanges-managed-funds-mutual-funds/
Examples:
AUD → ASX
USD → NASDAQ or NYSE
GBP → LSE
Column D – Trade type
Header: Trade type
Use the Buy / Sell (or Direction) column
Values must be BUY or SELL
Column E – Brokerage
Header: Brokerage
Calculate by summing:
Commission
Charges
If one value is missing, treat it as zero
Column F – Quantity
Header: Quantity
Use the Quantity value from the file
Do not change the sign unless required by Sharesight
Column G – Price
Header: Price
Convert prices from cents to dollars
Example: 13.00 → 0.13
Column H – Exchange rate
Header: Exchange rate
Use the Conversion rate column
Column I – Brokerage currency
Header: Brokerage currency
Same value as the Currency column
Row filtering
Remove any rows where Activity equals Corporate action
Output requirements
Output must be a CSV file
Headers must match exactly
File should be ready for direct import into Sharesight

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 new trades

Sharesight supports IG using the trade confirmation emails feature. Read more about how to forward your contract notes in this guide.