Your OKX cross-account real returns often seem wrong, not because the formula is too complex, but because you only exported part of your transaction history. OKX funds move between the "Funding Account," "Trading Account," and "Grow Account." If you only select "Trading Account History" when exporting, cross-account transfers, staking subscriptions, and redemptions will not appear in the file, causing your cost basis and profit/loss to be incorrect.
A leading global cryptocurrency platform,suitable for both beginners and experienced traders.
New user benefit: 20% off trading fees upon registration!！
First, Understand Where OKX Stores Your Cost Basis
OKX offers two types of cost basis calculations:
Overview Cost Basis: Covers the Trading Account, Funding Account, and Grow Account, calculated using the average cost method. Transferring assets between these three accounts does not change the cost basis.
Trading Account Cost Basis: Only reflects holdings within the Trading Account. You can switch between average cost or cumulative cost in settings.
If you usually keep your coins in the Funding Account or Grow Account, looking only at the Trading Account's cost basis will give you incorrect profit/loss numbers. When verifying real returns, you should use the Overview cost basis, as it includes assets across accounts.
You Must Download Two Files When Exporting History
OKX's export function is split into two separate entry points. Many people only download one of them.
First file: Trading Account History. Log in to OKX, go to Assets → Order center, select Trading account history, click Download, choose your date range, and export. This file contains spot trades, fees, and other trading records.
Second file: Funding Account History. On the same Order center page, switch to Funding account history and export it as well. This file contains deposits, withdrawals, and internal transfers between accounts.
Both files are essential. With only trading records and no transfer records, third-party tools cannot determine where your coins came from, and the cost basis will be broken. Waltio's help documentation also explicitly recommends exporting both Funding History and Trading Account History.
The Date Range is Another Pitfall
OKX's CSV export has a hard limit: you can only export a maximum of 3 months of data at a time. If your account has been open for more than 3 months, one file cannot cover your entire history.
You need to export multiple times, segmenting your history into 3-month periods, and download all files from the time you opened your account until now. When importing into third-party tools, you must upload all files, not just the most recent one.
The API import method supports data from the last 3 years, but if you have older records, or if certain transaction types (such as Earn or Loan) are not supported by the API, you will still need to supplement with CSV files.
How to Verify After Importing into Third-Party Tools
After importing the two CSVs into tools like CoinLedger, Waltio, or CoinTracking, do not simply trust the profit/loss numbers they calculate. Check two things first:
First, look for any "negative balance warnings." If the balance of a particular coin shows as negative, it means the imported history is incomplete; a buy or transfer-in record is missing. A negative balance is the most direct signal of missing data.
Second, use the tool's "Asset Balance Report" feature to reconcile. CoinLedger's Asset Balance Report can list every transaction affecting your balance, helping you locate exactly where the numbers start to mismatch. If the tool supports it, cross-check with the current balances shown in OKX's asset overview.
When importing into third-party tools, do not set a "start date" filter on your first import. CoinLedger's guide specifically warns that this feature is for preventing duplicate imports. It should not be enabled when first using your full history, as it will omit early records.
If the Tool's Numbers Are Still Wrong
First, check for duplicate imports from both API and CSV. If you imported the same time period using both API and CSV, the tool will show duplicate transactions, and your profit/loss will be magnified or distorted. In CoinTracking, you can open the "Import Date" column in the transaction list to investigate.
OKX's support for certain transaction types, such as Earn, Loan, and Jumpstart, is incomplete in both CSV and API. These require manual entry. If your main source of income is from Earn or lending, the cost basis calculated by the tool after import will deviate from reality. This part can only be corrected by manually checking the actual numbers on your OKX asset page.
A leading global cryptocurrency platform,suitable for both beginners and experienced traders.
New user benefit: 20% off trading fees upon registration!！
References
- MarketZones·Introduction to Spot, page publication or update date: not indicated; verification date: 2024-06-01.
- MarketZones·Introduction to Spot, page publication or update date: not indicated; verification date: 2024-06-01.
- CoinLedger·OKX (OKEx) File Import Guide, page publication or update date: not indicated; verification date: 2024-06-01.
- CryptoLinc·How to Download OKX (formerly OKEx) Trade History, page publication or update date: not indicated; verification date: 2024-06-01.
- Kryptos·OKX CSV Integration Guide, page publication or update date: not indicated; verification date: 2024-06-01.
- Waltio·OKX File Import Guide, page publication or update date: not indicated; verification date: 2024-06-01.
- CoinTracking·OKX Import Restrictions, page publication or update date: not indicated; verification date: 2024-06-01.
- CoinLedger·How the Portfolio Tracker Works, page publication or update date: not indicated; verification date: 2024-06-01.
- CoinTracking·FAQ, page publication or update date: not indicated; verification date: 2024-06-01.
