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.

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.