Import Trades from CSV Files
Auto-Validate and Calculate P&L

Upload your stock and options trades from any broker or spreadsheet. OptionsVault validates every row, detects duplicates, and calculates P&L automatically — so you can focus on trading, not data entry.

Why Import Trades from CSV?

Not every broker supports automatic sync. If you trade with a broker that isn't connected to OptionsVault yet, or if you want to import historical trades from a spreadsheet, CSV import is the fastest way to get your trade data into your options trading journal.

CSV import is also ideal for traders who prefer not to connect their brokerage account directly. You stay in full control of what data gets imported — export from your broker, review the file, and upload only the trades you want to track.

Common reasons traders use CSV import:

  • Unsupported broker — Your broker isn't available for auto-sync yet, but you can still export trades as CSV
  • Privacy preference — You want to track trades without connecting your brokerage credentials
  • Historical data — Import months or years of past trades to build a complete journal from day one
  • Bulk entry — Faster than entering trades one by one, especially for active traders with dozens of trades per week

Whether you're moving from a spreadsheet, switching from another journal, or just getting started, CSV import gets your trade history into OptionsVault in minutes.

How CSV Import Works

1

Prepare Your CSV

Export trades from your broker or spreadsheet. Include columns for date, symbol, action (buy/sell), quantity, and price. Options trades need the full OCC symbol or separate strike/expiration fields.

2

Upload the File

Drag and drop your CSV file or click to browse. OptionsVault accepts standard CSV format with headers in the first row. Files up to 5MB are supported.

3

Review and Validate

OptionsVault validates every row — checking dates, symbols, quantities, and prices. Duplicates are flagged automatically. Review the validation summary before importing.

4

Import and Calculate

Confirmed trades are imported into your journal. P&L is calculated automatically for closed positions, and strategies are detected across your full trade history.

Supported Trade Types and Formats

OptionsVault accepts CSV files with stock and options trades. Here are the columns your CSV should include:

Required Columns

ColumnDescriptionExample
dateTrade execution date2025-03-15
symbolStock ticker or OCC option symbolAAPL or AAPL250321C00180000
actionTrade directionBUY, SELL, BTO, STO, BTC, STC
quantityNumber of shares or contracts100 or 1
pricePrice per share or per contract182.50 or 3.25

Optional Columns

ColumnDescriptionExample
typeSTOCK or OPTION (auto-detected from symbol if omitted)STOCK
feesCommission and fees for this trade0.65
notesYour notes or comments about the tradeEarnings play

Supported actions: BUY, SELL, BTO (Buy to Open), STO (Sell to Open), BTC (Buy to Close), STC (Sell to Close). OptionsVault maps these to the correct trade direction automatically.

Smart Validation and Duplicate Detection

Every row in your CSV is validated before import. OptionsVault catches errors early so bad data never enters your journal.

Date Validation

Validates date formats and rejects future dates or malformed entries. Supports MM/DD/YYYY, YYYY-MM-DD, and other common formats.

Symbol Verification

Checks that stock tickers and option symbols are properly formatted. OCC option symbols are parsed to extract strike, expiration, and type.

Duplicate Detection

Compares incoming trades against your existing journal entries. Exact duplicates are flagged so you never double-count a trade.

Error Reporting

Each row is validated independently. Errors are shown with the specific row number and reason, so you can fix issues in your CSV and re-upload.

Partial Imports

Valid rows can be imported even if some rows have errors. You don't have to fix every issue before importing the trades that are ready.

Format Flexibility

Handles different column orders, optional columns, and common variations in action labels (BUY/SELL, BTO/STO/BTC/STC, OPEN/CLOSE).

CSV Import vs Manual Entry vs Broker Sync

OptionsVault supports three ways to add trades. Choose the method that fits your workflow — or combine them. Many traders use broker sync for their primary account and CSV import for trades from Robinhood or other platforms.

FeatureCSV ImportManual EntryBroker Sync
Setup timeMinutesNoneMinutes
Trade entry speedBulk (100+ at once)One at a timeAutomatic
Error riskLow (validated)Higher (typos)Lowest
Works with any broker
Historical data import
No broker login required
Real-time sync
Duplicate detection
P&L auto-calculation

CSV Import Pricing

CSV import is available on all plans. Free users can import up to 2 CSV files per month — enough to get started and evaluate the feature. Pro users get unlimited CSV imports along with broker auto-sync and full analytics.

Free Plan

$0/month

  • 2 CSV imports per month
  • Validation and duplicate detection
  • Automatic P&L calculation
  • Broker auto-sync

Pro Plan

$6.99/month

  • Unlimited CSV imports
  • Broker auto-sync
  • Full analytics and strategy detection
  • Unlimited trade history

See the full plan comparison on the pricing page.

Who Is CSV Import For?

CSV import is designed for any trader who wants to get trade data into OptionsVault without connecting a broker account. It's particularly useful for:

  • Traders with unsupported brokers — Export from your broker's platform, import into OptionsVault, and get the same analytics as auto-synced accounts
  • Privacy-conscious traders — Keep your brokerage credentials separate. CSV import requires no account linking or OAuth connection
  • Historical data importers — Bring in months or years of past trades to see your full performance history from day one
  • Platform testers — Try OptionsVault with your real data before committing to a paid plan or broker connection

Once your trades are imported, OptionsVault treats them exactly like auto-synced trades. You get the same P&L calculations, the same strategy detection for wheel strategies and covered calls, and the same analytics dashboard.

Start free with 2 CSV imports per month, or upgrade to Pro for unlimited imports and full broker sync. Your trade data stays yours — export anytime.

Start Tracking Your Options Trades Today

Join options sellers who use OptionsVault to track strategies, analyze performance, and grow their portfolio. Free to start.