Track trades in Google Sheets or Excel

Are you a trader? Would you like to automatically track trades from your online broker accounts into a spreadsheet? We can help! Let's see how.

Trading and the rise of online brokers

Trading is one of the oldest jobs. In fact, it originated with human communication in prehistoric times! Of course, during those times, you would not buy Facebook shares, but just trade your goat for some strawberries.

Fast forward to today, with the advent of internet, individuals and professionals can trade any kinds of supports online:

Stock and bond market trading on NASDAQ, Dow Jones, etc.
Forex market trading (Foreign currency exchange): Euro - US dollar (EURUSD), British Pound - US Dollar (GPBUSD), Bitcoin - US Dollar (BTCUSD) etc.
Binary options trading such as trading on Indices, Jobless Claims, FED Funds Rate, Non Farm Payroll, Copper, Corn, Crude Oil, Gold, Natural Gas, Soybeans and Silver etc. Binary options have had a bad reputations for years because of their ease to start with for a beginner trader combined with and the many related scams. And indeed there has been (and still are) many scams flying around. But it is also possible to try to get some winnings out if you invest some effort in understanding what binary options are and how to profile your expected returns to avoid getting scammed.

Today, there are many platforms where one can trade. Some big player brokers include E*Trade, Ally Invest, Ameritrade or Nadex.

Note: we are not affiliated in any way with these platforms, nor do we have experience in trading using those platforms. Trading involves financial risk and may not be appropriate for everybody. Never trade more than you can afford to lose. You've been warned!

Why tracking your trades?

Most of online brokers offer to track your trade history directly in their app. However, many brokers restrict the extent of data analyses in some ways: some restrict the history retention period, some others have very poor analyses and charting tools and some restrict trade details when downloading your trading history.

Also, if you are trading using different brokers, you may want to be able to track all information and consolidate all your trades in a single dashboard.

This becomes especially true when you want to create your own custom charts and statistical analyses using a tool like Excel or Google Sheets. Then, you need a solution for feeding your spreadsheet with your trade orders as they are passed.

How Parseur can help track your trades in real time?

This is where Parseur can help. In fact, Parseur is an email parser service that extracts text in emails to any application. Our customers use Parseur to automatically extract data from their buy/sell trade order emails sent by their online brokers and export it to applications like Google Sheets, Excel, or their accounting application.

With Parseur, you can effectively track trades performance across multiple brokers in real time and use it to create your own custom charts and statistical analyses in your spreadsheet.

Let's see how that works. Here is an example of a trade confirmation email from Nadex:

Example of a BUY confirmation order email on Forex from Nadex

That email contains all information you need to track your trading performance:

Contract name
Contract expiration date
Transaction number
Transaction date
Direction: BUY or SELL
Quantity
Price

With Parseur you can consolidate trades from different brokers and different actions (Buy/Sell) by creating templates. A template tells Parseur where to find the data in the email. Each template will be used to extract data from a specific type of email (BUY order, SELL order, CANCEL order) but also any type of broker (ETrade, Nadex etc.). This way you consolidate all your trading activity in a single mailbox and send the consolidated data to your spreadsheet or application.

Want to see the details of how it works? Let's do this!

How to automatically track trades in a spreadsheet

First, create your Parseur account and you'll get started on our free plan.

Then, create a new mailbox, forward a sample email and point & click the data you are interested in. While creating your first mailbox, you will be guided through every step thanks to our interactive tutorial. For more information, we have also written an extensive article on how to set up your first Parseur mailbox.

Once completed, you should get a template similar to the one below:

Example of a parsing template to extract data from Nadex email

Now, for every similar email you send, Parseur will automatically extract the information you highlighted!

Result example with the Nadex email:

	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

And, if you want to handle different types of emails or brokers, just forward more emails and keep creating new templates. Parseur will tell you when it can't parse an email using existing templates and will asks you to create a new template for it.

Export your trading order data

The last step is to decide where you want to export trade orders to.

You have several options:

Download the data and open it in Excel
Automatically export your data in Google Sheet: the spreadsheet will be automatically updated every time a new email is processed, you won't have to do anything! This is perfect if you want to track trade performance with minimal manual involvement.
Automatically export your data in real time to the application of your choice like Excel online, QuickBooks, Xero and many more using our Zapier integration

Export Nadex trades to Excel

That's it ! You have now created a custom email parser to track trades centrally and chart your way to success. Happy trading!

Sylvestre Dupont LinkedIn

Co-Founder and CEO at Parseur

Sylvestre is the Co-Founder and CEO of Parseur, where he leads a fully distributed team spanning Asia, Europe, the US, Africa, and the Middle East. A software engineer by training, he honed his skills managing multimillion-dollar projects at a leading consulting firm before launching Parseur. Passionate about elegantly solving complex problems, Sylvestre thrives on building products that enable companies to automate and delegate tedious operational tasks to AI. When he's not steering Parseur, he's racing co-founder Sylvain to see who can visit the most countries. He's losing.

Last updated on June 30th, 2026

Ready to automate your
document data extraction?

Start free in minutes and see how Parseur fits into your workflow.

No model training required

Automates data entry from any document

Scales from point-and-click to API

Frequently Asked Questions

Common questions about using Parseur to automatically extract trade order data from broker emails and track it in a spreadsheet.

Parseur is an email parser that reads buy and sell trade confirmation emails sent by your online broker and extracts the fields you need, such as contract name, expiration date, transaction number, transaction date, direction, quantity, and price. Its built-in AI extracts the requested fields from any email layout, so you do not need a separate template for every broker or format. Once set up, every similar email is parsed automatically as it arrives.

Parseur can export trade order data to Excel, Google Sheets, and many other applications. With Google Sheets, the spreadsheet is updated automatically every time a new email is processed, so you do not have to do anything manually. You can also send data in real time to tools like Excel online, QuickBooks, and Xero through the Parseur Zapier integration.

Yes. Parseur extracts the specific fields you point and click on, such as contract name, expiration date, transaction number, transaction date, direction, quantity, and price. Because the built-in AI handles any layout, you can capture the same fields consistently even when different brokers format their emails differently. You can add or adjust the captured fields at any time.

Parseur uses its built-in AI to extract trade data accurately from your broker emails. You can review and correct extracted data as an optional manual step before it is exported, so you stay in control of what reaches your spreadsheet. If Parseur receives an email it cannot parse with your existing templates, it tells you so you can set up a new one.

Yes. Parseur lets you consolidate trades from different brokers and different order types in a single mailbox, including platforms like E*Trade, Nadex, Ally Invest, and Ameritrade. You forward your trade emails to one Parseur mailbox, and the extracted data from all sources is sent to the same spreadsheet or application. This gives you a single dashboard for all your trading activity across brokers.

Yes. Parseur processes each trade confirmation email as soon as it arrives and pushes the extracted data straight to your spreadsheet or chosen application. This means your tracking dashboard reflects your buy and sell orders in real time, with minimal manual involvement. It is well suited to feeding live custom charts and statistical analyses.

No. Setting up Parseur is a no-code process. You create a mailbox, forward a sample trade email, and point and click the data you want to extract, guided by an interactive tutorial. There is no programming required to start tracking your trades.

Parseur is GDPR compliant and follows strong data protection practices. A SOC 2 Type II audit is in progress, though Parseur is not yet SOC 2 certified. Your trade data is processed and exported only to the destinations you configure, such as your own spreadsheet or accounting tool.