Importing Your Trading History Shouldn't Be This Hard

You've been trading on the ASX for a few years now. You've got positions across Stake, maybe some old CommSec trades, perhaps even a dabble with Interactive Brokers. Now you want to see your actual performance, track your cost base properly, or just answer the simple question: "What did I pay for my BHP shares?"

Good luck with that.

The Broker Data Nightmare

Every broker thinks they're being helpful by giving you trade data. What they actually give you is a headache.

Stake exports an XLSX file with "Execution Date" in one column and "Settlement Date" in another. CommSec gives you a CSV that calls the same thing "Trade Date" and "Settlement Date". Interactive Brokers? They hand you a multi-section report where your actual trades are buried between cash flow summaries and dividend reinvestments.

Then there's the missing information. Some brokers don't include brokerage fees in the export. Others split buy and sell transactions into separate rows without clear linking. One popular discount broker gives you everything in a single text dump that looks like it was designed by someone who's never seen a spreadsheet.

You spend your Saturday morning trying to import this mess into Excel, only to discover that half your BHP trades show up as "BH" because someone at the data export team doesn't understand ticker symbols.

What Actually Matters in a Trade Record

Strip away the noise, and every trade needs just five essential pieces of information:

Ticker symbol — The proper ASX code (BHP, not "BHP LTD" or "BROKEN HILL PROPRIETARY")

Trade date — When you actually executed, not when it settled three days later

Quantity — How many shares you bought or sold

Price per share — What you actually paid, not the closing price that day

Total fees — Brokerage, exchange fees, the lot

Everything else is commentary. You don't need the company name (you can look that up). You don't need the current market value (it changes every second). You don't need the broker's internal reference numbers or the settlement bank details.

But try explaining this to broker export systems that think you want seventeen columns of metadata and forget to include the brokerage fee.

Why Most Investors Give Up

Here's the dirty secret: Most ASX investors have no idea what their actual returns are. They know roughly whether they're up or down, but they can't tell you their CAGR or their tax position or even their cost base on most holdings.

It's not because they're lazy. It's because proper record-keeping is genuinely hard when every data source speaks a different language.

You start with good intentions. You download the CSV from Stake, spend two hours cleaning it up, import it into Excel, and feel satisfied. Three months later, you want to add some CommSec trades. The date formats are different. The column headers don't match. The fee calculations work differently.

By the sixth month, you're back to estimating your performance based on broker screenshots and gut feel.

This isn't sustainable if you're serious about share trading record keeping.

The Manual Data Entry Trap

Some investors give up on imports entirely and just enter trades manually. This works fine when you're making one trade per month. It becomes unsustainable when you're dollar-cost averaging into three positions and rebalancing quarterly.

Manual entry also introduces errors. You fat-finger a price. You forget to include brokerage. You enter a buy as a sell. Now your cost base is wrong and you won't notice until tax time.

The solution isn't to avoid technology. It's to find technology that actually works with the messy reality of ASX broker data.

AI Changes Everything

Here's what's finally possible: AI can read any format and extract the trading data that actually matters.

Paste in your Stake XLSX file, your CommSec CSV, even a PDF statement from Interactive Brokers. The AI identifies the trades, standardises the format, and presents you with clean data to review. No more wrestling with column mappings or trying to remember whether "Net Amount" includes fees or not.

The key is the human review step. AI can parse broker exports better than any rule-based system, but you still need to verify that it correctly identified your BXN purchase at $0.041 versus your sale at $0.065. Financial data is too important to import blindly.

Trade Thesis uses AI to extract trades from any broker format — paste your data, review the extracted trades, and import with automatic parcel creation and FIFO cost base tracking.

Getting Your Data House in Order

If you're ready to stop guessing at your performance, here's the systematic approach:

Start with your current broker. Most investors have 80% of their trades with their primary broker. Get this data clean first.

Export everything. Don't try to cherry-pick recent trades. You need the full history for proper cost base calculations.

Review before importing. Whatever tool you use, always check that the parsed trades match your expectations. AI is good but not perfect.

Set up ongoing capture. The best system is one that stays current. Monthly imports beat annual reconstruction projects.

The goal isn't perfect data archaeology going back to your first $500 CommSec trade in 2019. The goal is accurate tracking from today forward, with enough historical context to make informed decisions.

Your portfolio deserves better than spreadsheet archaeology and broker statement guesswork. Importing your ASX trading history doesn't have to be painful — and when it's not, there's no excuse for flying blind on your performance.

This is general information only, not personal financial advice. Consider your own circumstances and consult a licensed financial adviser before making investment decisions.