Importing Trades

Complete guide to importing your trading data into Riskr

Overview: 4 Ways to Import

Riskr supports multiple import methods to accommodate different workflows and data sources:

1. API Integration (Coming Soon)

• Direct connection to your broker's API
• Real-time data synchronization
• Automated trade capture
Currently disabled - contact support for early access

2. CSV Import (Recommended)

• Upload CSV files from your broker
• Support for Excel (.xlsx, .xls) and IBKR Flex XML files
• Interactive mapping wizard
• Batch processing with error handling

3. Email Forwarding (Coming Soon)

• Forward trade confirmations to a unique email address
• Automatic parsing and import
• Works with most broker email formats
Currently disabled - contact support for early access

4. Manual Entry

• Add individual executions by hand
• Perfect for quick fixes or odd cases
• Immediate trade matching and P&L calculation
Available now

How to Export from Common Brokers

Robinhood

1. Log into your Robinhood account
2. Go to Account → History
3. Click Export → Download CSV
4. Select date range and download
5. Upload to Riskr using CSV Import

Interactive Brokers (IBKR)

1. Log into Client Portal
2. Go to Reports → Activity → Trades
3. Set date range and click Generate Report
4. Download as CSV or Flex XML
5. Upload to Riskr using CSV Import

Fidelity

1. Log into Fidelity.com
2. Go to Accounts & Trade → Account Positions
3. Click History → Download
4. Select CSV format and date range
5. Upload to Riskr using CSV Import

Charles Schwab

1. Log into Schwab.com
2. Go to Accounts → Trade → Order Status
3. Click Export → CSV
4. Select date range and download
5. Upload to Riskr using CSV Import

E*TRADE

1. Log into E*TRADE.com
2. Go to Accounts → History
3. Click Export → CSV
4. Select date range and download
5. Upload to Riskr using CSV Import

Tastyworks

1. Log into Tastyworks platform
2. Go to Account → History
3. Click Export → CSV
4. Select date range and download
5. Upload to Riskr using CSV Import

Mapping Wizard Tips

The Mapping Wizard helps you connect your broker's column names to Riskr's standardized fields.

Required Fields

• Timestamp: When the trade occurred
• Symbol: Stock/option/futures symbol
• Side: Buy, Sell, Short, or Cover
• Quantity: Number of shares/contracts
• Price: Execution price per share/contract

Date Formats

Riskr accepts most common date formats:

• MM/DD/YYYY (e.g., 12/25/2024)
• YYYY-MM-DD (e.g., 2024-12-25)
• MM-DD-YYYY (e.g., 12-25-2024)
• DD/MM/YYYY (e.g., 25/12/2024)

Time Formats

• HH:MM:SS (e.g., 14:30:00)
• HH:MM (e.g., 14:30)
• HH:MM:SS AM/PM (e.g., 2:30:00 PM)

Decimal Separators

• Use periods for decimals: 150.25
• Commas are automatically removed: 1,500.25 → 1500.25
• Negative values in parentheses: (150.25) → -150.25

Common Column Mappings

Riskr Field	Common Broker Names
Timestamp	Time, Date, DateTime, Execution Time
Symbol	Symbol, Ticker, Security, Instrument
Side	Side, Action, Buy/Sell, Transaction Type
Quantity	Quantity, Shares, Contracts, Size
Price	Price, Execution Price, Fill Price
Fees	Commission, Fees, Total Fees
Currency	Currency, CCY
Venue	Exchange, Market, Venue
Order ID	Order ID, Order Number, Reference
Execution ID	Execution ID, Fill ID, Trade ID

Why Email/API are Disabled

Some import methods are currently disabled due to feature flags and domain requirements:

API Integration

• Status: Disabled by BROKER_APIS_ENABLED flag
• Reason: Requires broker API credentials and OAuth setup
• Timeline: Available for enterprise customers
• Contact: Support for early access

Email Forwarding

• Status: Disabled by INBOUND_EMAIL_ENABLED flag
• Reason: Requires dedicated email domain and MX records
• Timeline: Available for enterprise customers
• Contact: Support for early access

Cron Jobs

• Status: Disabled by CRON_ENABLED flag
• Reason: Requires server-side scheduling infrastructure
• Timeline: Available for enterprise customers
• Contact: Support for early access

Privacy & Deletion

Data Storage

• All imported data is stored securely in your private database
• Data is encrypted in transit and at rest
• We never share your trading data with third parties
• Your data is isolated by user account

Deleting Import Runs

To delete an import run and all associated data:

1. Go to Dashboard → Import → History
2. Find the import run you want to delete
3. Click View Details
4. Click Delete Import Run (if available)
5. Confirm deletion

What Gets Deleted

When you delete an import run:

✅ Raw import items
✅ Associated executions
✅ Generated trades (if no other executions exist)
✅ Import run record
❌ Other trades that share executions with this run
❌ Instrument records (may be used by other trades)

Troubleshooting

Common Import Errors

"Invalid date format"

• Check your date column mapping
• Ensure dates are in a recognized format
• Try reformatting dates in your spreadsheet

"Missing required field"

• Review the required fields list above
• Check your column mappings in the wizard
• Ensure all required columns are mapped

"Duplicate execution detected"

• This execution was already imported
• Check your import history for previous runs
• The system prevents duplicate data

"Invalid price/quantity"

• Check for non-numeric characters
• Remove currency symbols and commas
• Ensure positive values (negative in parentheses)

Getting Help

If you're still having trouble:

1. Check the logs: Import runs show detailed error messages
2. Try manual entry: For a few trades, use the manual entry form
3. Contact support: Include your import run ID and error details
4. Join our community: Get help from other users

Support Information

Email: support@tradejournal.com

Documentation:docs.tradejournal.com

Community:community.tradejournal.com

Status:status.tradejournal.com

Last updated: January 2025