Trading spreadsheet alternative for US stocks and ETFs

Replace your trading spreadsheet with a journal that replays every trade.

Import your trades from any broker that exports a CSV, see what's working, and replay any trade to see exactly what happened.

Start freeNo card required.

Or open the chart, no account needed

Journal · Import CSV

Example: AAPL, NVDA and SPY, Sep 1 to 21, imported.

Free template

A trading journal spreadsheet for Excel, Google Sheets and Numbers.

It works out your win rate, expectancy, profit factor and drawdown, by setup and by weekday.

Download the template (.xlsx)No email needed.

Save the Trades sheet as a CSV and TraderPier imports it as it is, with no columns to match.

Spreadsheet or journal

A spreadsheet records what happened. It can't show you why.

Your spreadsheetTraderPier

Getting trades inTyped or pasted, row by rowImported from your broker's CSV

Your statsFormulas you build and maintainEquity curve, calendar and expectancy, built in

Seeing the tradeA row of numbersThe trade on its chart, entry and exit marked

Trying it againNot possibleReplay the day and trade it again

Edge or luckA column you fill inTest a strategy for overfitting before you trade it

Journal

See what's working and what isn't.

Find out which setups actually make you money.

See the journal

Journal · trades on the chart

Example: META and NVDA, replayed.

Trade replay

Find out what happened after you got out.

Play back any trade bar by bar and see exactly where it went right or wrong.

See market replay

Journal · META · Sep 29, 2026

Example: META, Sep 29, replayed.

Edge or luck

A good month in a spreadsheet can't tell you if it was luck.

That takes knowing how many versions you tried. Test your strategy for overfitting before you trade it.

What the deflated Sharpe ratio measures

Strategy Tester · SMA Crossover · SPY 15m

Example: SMA Crossover on SPY, Jan 2 to Oct 1, 80 variations.

Questions

Which brokers can I import from?

Any broker that lets you download your trade history as a CSV. Each row should be one fill, with the time, symbol, side, quantity and price.

Is the journal really free?

Yes. It costs nothing, needs no card and has no time limit.

What can I journal?

Trades in US stocks and ETFs.

Do I need to install anything?

No. TraderPier runs in your browser.

A free trading journal that replays every trade.

Start free. No card required.

Start free Sign in