Getting Your Trades Into a Journal: Exports, Fills and Fees

Lesson 34 · The Journal

Getting Your Trades Into a Journal: Exports, Fills and Fees

Typing trades in by hand is the fastest way to stop journaling. Your broker already has the data. The job is getting it out cleanly.

Most brokers let you export executions as CSV or Excel. That file is the backbone of your journal.

Brokers record fills, not trades. One trade with partial fills can be five rows; your journal has to group them.

Include commissions, ECN and locate fees, or your results will look better than your account.

The first lesson in this series said to write five things per trade. That works for a week. After that, it gets skipped, usually on the exact day the record mattered most. The fix is to let the broker do the typing and keep your own input for the things only you know: the setup, the grade, the mood.

Find the export

Almost every broker has a way to download your trade history, usually called something like “trade history”, “executions”, “activity” or “account statement”, with an option for CSV or Excel. A few things to check the first time:

  • Actual fills, not just order records. You need the quantity, fill price and time of what executed. Some broker files are labeled “orders” and also include pending, working, cancelled or failed orders; those are not trades. Webull’s export is one example, so check the order status and filled quantity before calculating P&L.
  • Timestamps with seconds. You’ll need them for time-of-day analysis later.
  • Fees as their own columns if the broker offers them.
  • The time zone. Some exports use Eastern time, some use your local time. Know which, or your “9:45 trade” will show up at the wrong hour.

Example: export and check Webull trade records

Webull’s CSV is called an order-history export. Its help page says it can include filled, partially filled, pending, working, cancelled and failed orders. That means the file can contain useful fill records alongside rows that never executed. Check each row’s status and filled quantity before treating it as a trade.

In the Webull mobile app

  1. Tap Account and select the account you want.
  2. Open History.
  3. Tap Export Orders (the download icon at the top right).
  4. Confirm the delivery email and submit the request.

In Webull Desktop

  1. Open Account.
  2. In the Orders widget, open its three-line settings menu.
  3. Choose Export Orders, confirm the delivery email, and click OK.

Webull says it emails the CSV, usually within 5–10 minutes. Interfaces can change; use Webull’s current export instructions if the labels differ.

Before importing, separate actual fills from orders with no executed quantity. A partially filled order can produce multiple fills, so group entries and exits into one trade from flat to flat. Keep timestamps and fees when they are present, and compare a small sample with your order history or statement. If a field is missing, don’t infer it from the order status.

For fills around midnight, see how to record execution time, trade date and settlement date separately.

You can test a small file in the free Excel and Google Sheets journal. For repeated offline review, see the Greenwick Journal; it imports files manually and does not connect to Webull. File columns can vary, so confirm the import and totals against your broker records before relying on the summaries.

Fills are not trades

This is where most spreadsheet journals go wrong. If you bought 300 shares in three pieces and sold in two, your broker file shows five rows. Your journal should show one trade: in at an average price, out at an average price, one result.

The usual rule is simple: a trade starts when your position in that symbol goes from zero to something, and ends when it goes back to zero. Everything in between belongs to the same trade, including adds and partial exits.

Example fillsWhat the journal should record
Buy 100, buy 100, buy 100One entry of 300 shares at the average price
Sell 150, sell 150One exit at the average price, trade closed
ResultOne trade, one P&L, one R value

If you short, the same logic runs the other way: sell first, buy to cover, trade ends when you’re flat.

Fees go in, every time

For small accounts trading low-priced stocks, fees are not a rounding error. Per-share commissions, ECN charges, short locates and platform fees can turn a small green trade red. A journal that shows gross results will make your strategy look better than your account balance says it is. Always look at net.

Import, then add what only you know

Once the trades are in, spend your time on the fields no file contains: the setup name, whether it was an A, B or C setup, whether you followed the plan, one word for your state, and a mistake tag if there was one. That split is what keeps journaling sustainable: the machine handles the numbers, you handle the judgment.

You can do all of this in a spreadsheet with a pivot table. Tools like Tradervue and TraderSync, or the Greenwick Journal I built, can read the broker file for you, so you don’t retype anything. Whatever you use, check a few trades against your broker statement the first time.

Putting it together

  1. Export broker records as CSV or Excel. Keep actual filled quantities, timestamps and fees; filter out unfilled, cancelled or failed orders.
  2. Check the time zone of the export before you trust any time-of-day numbers.
  3. Group fills into trades: flat to position to flat is one trade.
  4. Always judge results net of every fee.
  5. Let the import handle numbers; spend your effort on setup, grade, plan and mood.

An honest word: a clean import makes journaling easier, but it’s still only data. The value comes from the fields you add and the reviews you actually do. Educational content only, not financial advice.

Free, by email

Get the journal series in your inbox

All 16 journal lessons in one email, then a short note when a new lesson goes up. Nothing else. Unsubscribe any time.

← Back to all lessons

← Previous: Why Your Memory Lies About Your Trading Next: Measure Every Trade in R, Not Dollars →
Want a ready-made spreadsheet? Download our free trading journal template for Excel and Google Sheets.