How to Import Your Schwab Options Trade History (And Actually Make Use of It)

Introduction

If you're a Schwab customer trading options, you've probably looked at your trade history and thought: "I have all this data — there has to be a better way to use it." You can see every trade you've made, but turning that raw history into meaningful portfolio analysis, especially for wheel strategy tracking, is a different challenge entirely.

Schwab provides trade history export, including a JSON format. The problem isn't getting the data out. It's what you do with it afterward.

What Schwab's Trade History Contains

When you pull your trade history from Schwab, you get the core details for each transaction: trade dates, buy/sell action, quantities, prices, ticker symbols, and for options trades, the contract details like strike price, expiration date, and put/call type.

This is useful data. It tells you exactly what happened and when. But it's structured as a flat list of individual transactions — each one standing alone with no relationship to the others.

For a wheel strategy trader, that's the gap. Your put sale on XYZ three weeks ago, the assignment last Friday, and the covered call you sold yesterday are all part of one wheel cycle. Schwab's export doesn't know that. It just shows three separate trades.

The Common Frustration

Here's what usually happens. You export your trade history because you want to answer a simple question: "How am I actually doing on my wheel positions?"

You open the data and see hundreds of rows. Options trades, stock purchases from assignments, dividend entries, maybe some trades from before you started running the wheel. Everything's mixed together chronologically.

To figure out your actual cost basis on a position — factoring in the original put premium, the assignment price, and all the covered call premiums since — you'd need to filter by ticker, sort by date, identify which transactions are part of the same wheel cycle, and manually calculate the running cost basis. For one ticker, that's tedious. For a portfolio of eight or ten wheel positions with months of history, it's a serious project.

Some traders paste the data into Excel and build elaborate spreadsheets. That works until you need to update it next month and spend another hour reconciling new trades against your existing formulas.

A Better Path: Automated Import

This is where having a purpose-built tool pays off. MyATMM has a Schwab bulk JSON import feature designed specifically for this workflow. You take your exported Schwab trade history in JSON format and import it directly. The system reads through your transactions and automatically creates the corresponding entries — puts sold, assignments, covered calls, share sales — and links them to the appropriate positions.

What the Import Handles

When you run the Schwab JSON import, MyATMM processes your trade data and:

  • Creates transactions for each trade — puts sold, calls sold, assignments, expirations, and share purchases/sales
  • Calculates cost basis by connecting related transactions on the same ticker into wheel cycles
  • Tracks premiums collected on each put and call separately, so you can see your income breakdown
  • Handles assignments by linking the put that resulted in assignment to the share purchase, adjusting your cost basis accordingly
  • Sets up positions so you can immediately see which tickers are in the put phase, which are in the call phase, and where each one stands

Instead of spending hours manually entering historical trades or building a spreadsheet to interpret raw data, you get a populated portfolio in minutes.

The Practical Workflow

Here's what it looks like in practice:

  1. Export from Schwab — Pull your trade history in JSON format from your Schwab account
  2. Import into MyATMM — Use the Schwab bulk import feature to upload the JSON file
  3. Review your positions — Your wheel positions are created with full transaction history and calculated cost basis
  4. Continue tracking — Going forward, log new trades as they happen (you can also use MyATMM's AI-assisted import by snapping a screenshot of your brokerage confirmation)

The biggest win is historical data. If you've been running the wheel for months but only tracking premium in your head or a basic spreadsheet, importing your Schwab history gives you a complete picture retroactively. You'll see your actual returns per position, your cumulative premiums by ticker, and your real cost basis — not the approximation you've been carrying around.

Why This Matters for Wheel Traders Specifically

Generic portfolio trackers can import brokerage data too. But they're built for buy-and-hold investors or active stock traders. They show you positions and P&L.

The wheel strategy has a specific flow: sell put, potentially get assigned, sell calls against shares, potentially get called away, repeat. A good tracker needs to understand that cycle and present your data in those terms. It's not enough to know you bought 100 shares of SOFI at $10.50 — you need to know that purchase was a put assignment, that you collected $0.75 in put premium bringing your effective basis to $9.75, and that you've since collected another $1.40 in call premiums reducing it to $8.35.

That's the context Schwab's raw export doesn't provide but a wheel-specific tool does.

Getting Started

If you've been meaning to get organized with your wheel tracking and you trade through Schwab, the bulk import is probably the fastest way to get up to speed. You can try MyATMM free with up to 3 tickers at myatmm.com — no credit card required. Import your Schwab history, see your positions laid out with real cost basis numbers, and decide if it's worth keeping in your workflow.

Start Tracking Your Options Positions Accurately

MyATMM provides purpose-built cost basis tracking for option sellers, with the flexibility to track covered calls, cash-secured puts, and wheel strategy positions.

Track up to 3 tickers completely free forever. No credit card required.

Create Your Free Account Today

Built for covered calls, cash-secured puts, and the wheel strategy

Original Content by MyATMM Research Team | Published: March 16, 2025 | Educational Use Only