Get your Capital.com trade history into a spreadsheet
Capital.com generates statements on the web and in the app. The steps are confirmed; the file format is not, and neither is a separate spreadsheet export of trades.
Risk warning: CFDs and spread bets are complex instruments and come with a high risk of losing money rapidly due to leverage. You can lose money on these products, and each provider publishes its own loss figure under FCA rules. You should consider whether you understand how they work and whether you can afford to take the high risk of losing your money. Automated and API trading can amplify losses through bugs, connectivity failures and runaway orders.
Steps
Open Statements on the web
Click LIVE in the top right corner, then Statements.
help.capital.comchecked
Start a new statement
Select the account, then click New statement.
help.capital.comchecked
Pick the timeframe
Choose the period you want and click Generate.
help.capital.comchecked
On the mobile app
Go to Account, then Statements, then New statement, then Generate.
help.capital.comchecked
Check the file format
We could not confirm the file format of the statement, or whether Capital.com offers a separate trade history spreadsheet export.
Unverifiedhelp.capital.com
Pull the same records with the API
GET /api/v1/history/activity allows at most 1 day between from and to, so loop day by day; /api/v1/history/transactions defaults to the last 10 minutes, so always pass dates. Keep under 10 requests per second and log in again after 10 idle minutes.
open-api.capital.comchecked