# Get your Capital.com trade history into a spreadsheet

Independent and unofficial. Not affiliated with or endorsed by any broker or platform named here. Educational only: nothing here is advice, and nothing here recommends a broker or a trade.

This is the markdown version of https://openbrokerapi.com/guides/capital-com-trade-history, written from the same records as that page.

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.

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.

- Checked: 2026-09-18
- For: Non-coders
- About: [Capital.com](https://openbrokerapi.com/brokers/capital-com)

## Steps

### 1. Open Statements on the web

Click LIVE in the top right corner, then Statements.

Status: verified. Source: [help.capital.com](https://help.capital.com/hc/en-us/articles/23198403966226), checked 2026-09-18.

### 2. Start a new statement

Select the account, then click New statement.

Status: verified. Source: [help.capital.com](https://help.capital.com/hc/en-us/articles/23198403966226), checked 2026-09-18.

### 3. Pick the timeframe

Choose the period you want and click Generate.

Status: verified. Source: [help.capital.com](https://help.capital.com/hc/en-us/articles/23198403966226), checked 2026-09-18.

### 4. On the mobile app

Go to Account, then Statements, then New statement, then Generate.

Status: verified. Source: [help.capital.com](https://help.capital.com/hc/en-us/articles/23198403966226), checked 2026-09-18.

### 5. 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.

Status: unverified. Source: [help.capital.com](https://help.capital.com/hc/en-us/articles/23198403966226), no checked date recorded.

### 6. 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.

Status: verified. Source: [open-api.capital.com](https://open-api.capital.com/), checked 2026-09-18.

## Sources

- Status: verified. Source: [Capital.com help: statements](https://help.capital.com/hc/en-us/articles/23198403966226), checked 2026-09-18.
- Status: verified. Source: [Capital.com Public API](https://open-api.capital.com/), checked 2026-09-18.
- Status: verified. Source: [gov.uk: Self Assessment tax returns, deadlines](https://www.gov.uk/self-assessment-tax-returns/deadlines), checked 2026-09-18.

## More on the Capital.com API

- [Capital.com API quickstart](https://openbrokerapi.com/brokers/capital-com/quickstart): From credentials to a first call on a demo account, step by step.
- [Capital.com API error codes](https://openbrokerapi.com/errors/capital-com): 24 decoded, each with what it means, and the fix where the source gives one.
- [Capital.com API endpoints](https://openbrokerapi.com/brokers/capital-com/endpoints): 36 documented, each with its method, path, parameters and source.
- [Capital.com messages](https://openbrokerapi.com/brokers/capital-com/messages): 7 documented, each with its fields and source.
- [Capital.com API page](https://openbrokerapi.com/brokers/capital-com): The full record: access, authentication, limits and the source for each.
- [Capital.com API with Python](https://openbrokerapi.com/guides/capital-com-api-python): Guide

## Licence and how to cite

The records behind this page are all rights reserved. This file is the page itself, at its own address, in another format. It is not part of the CC BY 4.0 downloads listed at https://openbrokerapi.com/data. Quote from it with a link to the page.

Cite as: Get your Capital.com trade history into a spreadsheet. Broker API Hub, https://openbrokerapi.com/guides/capital-com-trade-history, newest check 2026-09-18.

Where you rely on a single figure, cite the source and the checked date printed beside it as well. Where this page and a broker's own documentation differ, the documentation wins.