IG Index Live Positions, Transactions and Activity History Download

The Excel Price Feed Add-in enables you to easily download your live IG Index / IG Markets positions as well as your transaction/trade history and account activity history into Excel.

To get started, launch the Configuration Pane, select the IG Index tab then the "Account Data" tab:

IG Index / IG Markets Download Live Positions and Trade History to Excel Screen

Live Positions

To download your live positions, select which fields you would like to download (such as epic, size, limit etc.) and press the "Download Positions" button. Your live positions will then be downloaded to your Excel spreadsheet starting at the selected cell.

For example, here I have downloaded my live positions to Excel where I can add a formula to calculate my current P&L:

IG Index / IG Markets Download Live Positions to Excel

Trade / Transaction History

To download your transaction history, first specify the date range of the history you are interested in. Also, specify whether you want to download "Trades Only" or "All" transactions. Next press the "Download History" button. Your transaction history will then be downloaded to your Excel spreadsheet starting at the selected cell.

Transaction History includes not only your trading history but also deposits/withdrawls to/from your account as well as interest payments for holding positions overnight.

For example, here I have downloaded my latest trade history to Excel where I can add a formula to calculate my total P&L over the period as well as some Excel Data Bars to help me visualize where I have made/lost money:

IG Index / IG Markets Download Trade History to Excel

Account Activity

Account Activity includes all activity that has ocurred on your account, including opening and closing positions as well as stop/limit adjustments etc.

To download your activity history, first specify the date range of the history you are interested in. Next press the "Download Activity" button. Your activity history will then be downloaded to your Excel spreadsheet starting at the selected cell.

IG Index / IG Markets Download Account Activity to Excel