Skip to content

Guide · Export CSV · Fidelity

Export a Fidelity CSV — holdings, trades, and the 90-day download cap.

Fidelity is one of the more export-friendly brokerages. You get CSV for current holdings (one click) and CSV for transaction history (a few more clicks, with a per-download date cap). If you're moving a Fidelity brokerage, Roth IRA, or 401(k) into a new tool, here's the route — and a note on the 90-day cap that catches everyone off guard.

To export your Fidelity transactions or holdings as a CSV, sign in to fidelity.com on a desktop browser. For current holdings, open the Positions tab and click the small download icon — you get a one-click CSV of every position across your brokerage, IRA, 401(k), and HSA accounts. For transaction history, open Activity & Orders, set a date range, and click Download. Fidelity caps each transaction download at 90 days, which catches everyone off guard if you're migrating years of trade history — you'll need to run the export multiple times in 90-day chunks and merge the files. The holdings CSV includes columns for Symbol, Description, Quantity, Last Price, Current Value, and Cost Basis. The transaction CSV covers buys, sells, dividends, splits, and reinvestments. Fidelity exports separately per account, so multi-account households need one export per account.

Step-by-step: export current holdings (one click)

  1. Sign in at fidelity.com on a desktop browser.
  2. Open the Positions page (top nav under your account).
  3. Look in the upper-right corner of the positions table for the Download icon (small downward arrow).
  4. Click it. A CSV with your current holdings — ticker, quantity, cost basis, current value, % of portfolio — lands in your downloads.

Step-by-step: export transaction history (per-quarter)

  1. From the dashboard, select your account from the left panel.
  2. Click Activity & Orders → History.
  3. Set a Date Range. The dropdown defaults to "Past 30 days." Select Custom for a wider window — but each download caps at roughly 90 days of data.
  4. Click Apply. The transaction table populates below.
  5. Click the Download button (Excel icon, usually upper-right of the table).
  6. CSV lands in your downloads folder. Repeat for each quarter if you need more than 90 days.

For a full year, expect to run the export four times. For a full five years, twenty downloads. There's no way around the per-export cap.

What you'll get

  • Format (holdings): CSV with Account Number, Account Name, Symbol, Description, Quantity, Last Price, Current Value, Today's Gain/Loss Dollar, Total Gain/Loss Dollar, Cost Basis Total.
  • Format (history): CSV with Run Date, Account, Action, Symbol, Description, Type, Quantity, Price, Commission, Fees, Accrued Interest, Amount, Settlement Date.
  • Date range: 90 days per download for transaction history. Up to 5 years total archive if you stitch multiple quarters together.
  • Account types supported: Individual, joint, traditional IRA, Roth IRA, 401(k) — if the 401(k) plan permits exports. Some employer-sponsored plans restrict it.

Importing into Arden

Drop the holdings CSV onto /importand Arden imports each position with ticker, share count, and cost basis. The transaction-history CSV gives you the activity record — buys, sells, dividends, deposits, withdrawals — which Arden uses for your investment account's transaction log. Live prices on the Plus plan refresh from a separate market-data feed; the CSV is your historical record.

Quirks specific to Fidelity

  • 90-day cap is per-download, not per-account. You can pull five years of data — but it'll take 20 separate downloads. Plan accordingly.
  • The Action column is verbose. Values like "YOU BOUGHT" or "DIVIDEND RECEIVED" describe what happened; Arden's parser normalizes these into buy/sell/dividend/transfer types.
  • 401(k) exports depend on the plan. Some Fidelity-administered plans disable transaction CSV export entirely. If you don't see the Download button on your 401(k) account, that's why.
  • Symbol column uses CUSIPs for some mutual funds. Most rows show standard tickers (VTI, SPY); some bond and fund rows use the CUSIP. Arden imports both; the live-price feed may not have a quote for CUSIP-only securities.

FAQ

  • Can I export more than 90 days at once?

    No. Each download caps at ~90 days. Run multiple exports and stitch together client-side.

  • Does Fidelity offer OFX or QFX?

    Yes. The same download tool offers QFX (Quicken) and TXF (tax) formats. Arden ingests CSV — pick CSV.

  • Are dividends and interest in the transaction history export?

    Yes. The Action column distinguishes "DIVIDEND RECEIVED" and "INTEREST INCOME" from buys/sells. Arden surfaces dividend rollups on the investments page.

Exporting from other banks?

Or just drop any CSV, XLSX, OFX, or QFX onto /import and Arden handles the rest.