You already have a record of every trade you have taken. It is sitting in your inbox, one broker confirmation at a time. Parseur reads those emails and writes each fill into Google Sheets or Excel, across every broker you use. Nothing gets plugged into your brokerage account.
The history your broker won't keep for you
Your broker shows your trade history in its own app, on its own terms. Some cap how far back you can look. Charting tends to be thin, the download tends to be thinner, and the record lives on their side of the login, not yours.
Trade through two brokers and there is no single view at all.
Own the log and that stops being their decision. Once every fill lands in Excel or Google Sheets, the pivot tables, win rate columns and profit and loss breakdowns are yours to build, over your full history and every account you hold.
One email in, seven fields out
Parseur is an email parser that reads your broker's confirmation emails and hands back the fields as structured data.
Here is one, as it arrives:
Parseur's AI engine reads it and pulls out:
- Contract or symbol
- Contract expiration date
- Transaction number
- Transaction date
- Direction: BUY or SELL
- Quantity
- Price
Those are the seven this broker sends. It is a forex contract, so it carries an expiration date. A stock fill comes back with the fields a stock fill has, and you decide which ones you keep.
There is no template to build. The AI engine reads each email on its own terms, so a BUY confirmation, a SELL confirmation and a cancellation notice from three different brokers all resolve to the same set of fields without you configuring anything per format. Add a new broker and its emails are parsed the same way, from the first one.
So there is no supported-broker list to check against. If your broker emails you a confirmation, that is the whole requirement.
Result with the confirmation above:
| Parsed data | |
|---|---|
| Contract expiration | Wed Jun 26 09:50:00 EDT 2017 |
| Contract name | USD/JPY 123.45 (5:10PM) |
| Direction | BUY |
| Price | 102.00 |
| Qty | 1 |
| Transaction date | Wed Jun 26 17:08:37 EDT 2017 |
| Transaction number | 201706261708G9QT012345678 |
| Received | 2017-06-26T19:34:39.082510+00:00 |
Parseur is not affiliated with any broker or trading platform.
When your broker's CSV is the better tool
Worth saying plainly: if your broker offers a clean data export, use it. Interactive Brokers has Flex Queries. Many brokers publish a daily trade activity CSV, a realized gain and loss report, or an OFX download. Those come straight from the source, and at tax time they are the right tool.
The export is fine until it isn't:
- Two brokers, three brokers, an old account you still hold positions in. One mailbox, one log.
- The row exists the minute the fill does, not after the close.
- Your export drops a field you care about, or only reaches back a few months.
- Nothing to remember. No download, no import, no Sunday evening catch up.
Set it up once, then leave it alone
Start by creating your Parseur account. Create a mailbox, forward one confirmation to it, and the AI comes back with the fields already found. Rename anything you would rather call something else. That is setup. Our guide to the AI parsing engine walks through it.
The only step that is real work is the last one: a filter in Gmail or Outlook that auto-forwards your broker's confirmations to that address. The auto-forward guides cover both. After that, every confirmation is parsed as it lands, and you go back to trading.
What it costs: the free plan covers 20 pages a month, enough to put a couple of weeks of your own fills through before you commit to anything. Paid plans are priced by the number of pages you process.
Where the rows land
Three ways out, and they are not equal:
- Download it and open it in Excel
- Pipe it into Google Sheets, where the sheet updates itself every time an email is processed. Pick this one. It is the version that runs without you.
- Push it anywhere else through our Zapier integration, in real time, including Excel online, QuickBooks and Xero
Your financial data stays yours
A confirmation email carries your account number and the size of your position. Asking where it ends up is the right instinct.
Parseur is GDPR compliant and SOC 2 Type II compliant, with the audit report available on request. Extracted data is sent only to the destinations you configure, such as your own spreadsheet or accounting tool, and nowhere else.
One habit worth keeping with any vendor: forward from a dedicated alias rather than opening up your whole inbox.
Start with the next fill
The log does not need catching up. It needs starting. Point your confirmations at a mailbox once and it fills itself from your next trade onward.
Create your free Parseur account, forward one confirmation, and see what comes back.
Last updated on