Broker API HubMenu

Get your OANDA trade history into a spreadsheet

OANDA's HUB exports transaction history straight to CSV. Set your timezone first, because it defaults to GMT -12. A mobile export is not mentioned on OANDA's help page.

Independent and unofficialChecked For: Non-coders

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

  1. Log in to the HUB

    Log in to OANDA's HUB in your web browser.

    help.oanda.comchecked

  2. Open Transaction History

    Go to Reports, then Transaction History.

    help.oanda.comchecked

  3. Set account, dates and timezone

    Choose the account, start date and end date. Change the timezone to your own first: it defaults to GMT -12.

    help.oanda.comchecked

  4. Export to CSV

    Click Show Transactions, then Export to csv. CSV is the only format offered, and it opens in Excel or Google Sheets.

    help.oanda.comchecked

  5. On the mobile app

    We could not confirm a mobile export: OANDA's help page does not mention the app. Use a browser for this one.

    Unverifiedhelp.oanda.com

  6. Pull the same records with the API

    GET /v3/accounts/{accountID}/transactions covers up to 365 days per request with pageSize up to 1000, and returns page links you fetch from /transactions/idrange.

    developer.oanda.comchecked

Sources

Sections