What this actually does that a spreadsheet doesn't
Most brokers and prop firm platforms let you export your closed trade history as a CSV: symbol, entry time, entry price, exit time, exit price, size, P&L. You can build formulas in Google Sheets to calculate win rate and profit factor from that file, and you should. What a spreadsheet won't do on its own is look across hundreds of rows and notice that your position size tends to increase specifically after a losing trade, or that your holding time on winners has been shrinking over the last two months while losers get held longer. That kind of pattern-across-many-rows question is exactly what Claude can be asked to do with the same file.
Setting it up
- Export your trade history. From your broker or prop firm platform, export closed trades as a CSV with the standard columns: symbol, entry date/time, entry price, exit date/time, exit price, size, P&L.
- Upload the file directly in a conversation. Claude reads structured files like this and can run real calculations on the actual rows in front of it, not a generic estimate.
- Start with the standard numbers. Ask for total trades, win rate, profit factor, average win, average loss, and maximum drawdown, computed from the uploaded data specifically.
- Ask a specific behavioral question, not a vague one. "What do you notice" produces a generic answer. "Does my position size increase after a losing trade" or "is there a day of the week where my losses cluster" produces something you can actually check against your own memory.
- Verify anything surprising. If a pattern turns up, sizing increases on Fridays, holding time drops after two losses in a row, check it against what you remember about those specific sessions before treating it as settled fact.
The question worth actually asking
A generic prompt like "analyze my trades" tends to get a generic answer back: your win rate, your best month, a few surface observations. The more useful prompt names the exact behavioral question you actually suspect is true about yourself. If you already have a hunch that you oversize after a loss trying to make it back, ask that directly and let the data confirm or contradict it, rather than waiting for a general summary to happen to mention it.
The CSV can tell you what happened, row by row, with total accuracy. It cannot tell you why you did it. That part still needs a person, not a file.
What the analysis can't close for you
Claude can confirm, with real numbers from your own history, that you double position size after a loss more often than not. It can't tell you what makes that specific moment, a red trade sitting on the screen, feel like the one exception where the rule doesn't apply. That's a different kind of question, and it's the one that actually determines whether seeing the pattern changes anything about what you do next time.
Funded prop trader at Apex Trader Funding ($100K) and Alpha Capital Group ($100K). MA Psychology candidate at Chandigarh University, with clinical training under Dr. Nitin Sethi and at Japneet Bakhshi Clinic. Co-founded TradeRoot with Khushi Narwal to work at the source of behavioral trading patterns rather than their symptoms.