How to export a thinkorswim Account Statement, and why the clock is ignored

A dozen named sections, a time in a zone the file does not reliably state, and no expiration row anywhere.

The steps

step 1
In thinkorswim open the Monitor tab, then Account Statement.
step 2
Before exporting, right click the table and choose Customize, then Load Defaults. The export contains only the columns that were visible, which is how a statement arrives with no resolutions in it.
step 3
Set the date range and use Export to File, CSV.

What you get, and what it means

what you get
Account Trade History
5/10/19 08:05:37   BACKRATIO   SELL -3   SPX 22 MAY 19 2830 PUT @40.35
(blank)   BUY +7   SPX 22 MAY 19 2750 PUT @16.90   CREDIT
what it means
one order, two legs, a back ratio
the second leg inherits the time and the order above it
22 May is not a third Friday, so the root is SPXW

read as two orders, this is two positions that never existed

Traps in this file

The clock is not used, and that is deliberate

The statement renders times in the account's own zone and names one only in the prose of a balance row. Read as US Central, a sample statement's 07:46 NDX fill lands 44 minutes before that market opens. Rather than shift by a label that does not survive checking, FillStub keeps the date, keeps the observed time on the row where you can read it, and declines to place the fill at a minute.

A spread puts its time on the first leg only

The rows under it have a blank Exec Time and a Net Price of CREDIT or DEBIT. They belong to the row above and inherit its order, which is what rebuilds a condor from four rows.

The trade history writes SPX for contracts that are SPXW

Its Symbol column carries the underlying, not the root. A third Friday is the monthly and everything else is the weekly, and the root decides both cash settlement and when trading stops.

No public statement carries an expiration or a settlement

Both reported wordings are matched, and a statement that spans an expiry without one is reported as incomplete rather than treated as a book that had none. Load Defaults before exporting.

Both eras are read, the TDA statement with its REF # column and the Schwab-era one. Outright futures are not options and are not journaled; futures options are left out because their expiry column is a product code that the statement never resolves to a date.

Drop your thinkorswim file