Free local tool
Check your trading CSV before you journal
Broker exports can contain blank rows, missing fields or partial fills. This free preflight checker flags common issues in your browser before you bring the file into a journal.
ZIP · 7 KB · No sign-up. Extract it, open greenwick-csv-preflight.html in a current browser, then choose a CSV exported from your broker.
What it checks
- Whether common date, symbol, side, quantity and price fields are present
- Blank lines, missing symbols, invalid numbers and dates it cannot parse
- Repeated order IDs and fee-only rows, which can be normal with partial fills
- Order IDs displayed in scientific notation, which may mean a spreadsheet rounded or changed a long ID; compare with the original broker export
- Timestamps without an explicit time zone; the checker flags the missing zone but cannot infer the broker’s time zone
It counts rows and lets you download a short issue summary. It does not calculate profit and loss, reconcile fills, or decide whether a trade is correct.
Your CSV stays on your device
The checker reads the file locally in your browser. It does not upload trade rows to Greenwick or connect to your brokerage account. The download is the checker itself; extract and open it to use it.
How to use it
- Export a CSV from your broker and keep the original unchanged.
- Download and extract the checker ZIP.
- Open the HTML file, select the export, and review any flags.
- Compare flagged rows with the broker’s order history before importing or editing your journal.
Broker exports differ. A flag is a prompt to inspect a row, not proof that the data is wrong. Avoid sharing screenshots or files containing account numbers or other personal details.
Get the free Excel and Google Sheets trading journal to record trades and review your results.
See the full Greenwick Journal for a more complete offline journaling workflow.
Educational utility only. It is not investment advice, and checking a CSV does not verify that an export is complete or accurate.