Quick answer
Use the free TradeStreamAI trading journal to record each decision, download its CSV, then import the file into Google Sheets with File → Import → Upload. The export includes Date, Market, Setup, Direction, Planned risk %, Result (R), and Lesson. The CSV is a snapshot; TradeStreamAI does not automatically sync journal entries with Google Sheets.
A practical workflow
- Step 1
Record decisions
Enter the date, market, setup, BUY/SELL/WAIT decision, planned risk percentage, result in R, and a specific lesson in the browser journal.
- Step 2
Download the CSV
Select Download CSV on the journal page. Keep the original file as a dated backup before editing it in a spreadsheet.
- Step 3
Import into Sheets
In Google Sheets choose File → Import → Upload, select the CSV, then confirm the import location and comma separator.
- Step 4
Review by setup
Filter by market and setup, compare planned risk with outcomes, and read the lessons for repeated execution mistakes.
At a glance
| Workflow | Where entries live | Best use |
|---|---|---|
| TradeStreamAI journal | In the current browser until cleared | Fast entry and CSV export without signup |
| Exported CSV | A file on your device | Portable backup and import into a spreadsheet |
| Google Sheets copy | In your chosen Google account | Filtering, formulas, charts, and shared review |
What columns does the CSV actually contain?
The export has seven columns in this order: Date, Market, Setup, Direction, Planned risk %, Result (R), and Lesson. Date is the decision date; Market identifies the instrument; Setup names the rule or pattern; Direction records BUY, SELL, or WAIT. Planned risk % is the proposed account risk, while Result (R) records the outcome relative to the initially planned money risk.
For example, a row might read 2026-09-26, EUR/USD, Range retest, WAIT, 0.5, blank, 'No candle close beyond resistance.' The blank result is intentional: a skipped setup did not produce a realized trade result. This is an illustrative row, not a historical trade or performance claim.
- Keep setup names consistent for useful filters
- Leave Result (R) blank for unexecuted decisions
- Record planned risk before the result is known
- Write one observable lesson rather than a vague feeling
How do you import the CSV into Google Sheets?
Open a blank Google Sheet, choose File → Import → Upload, and select the downloaded tradestreamai-trading-journal.csv. Choose whether to create a new sheet or replace an existing one, confirm comma as the separator, and inspect the preview before importing. Google's current help page documents the File → Import → Upload flow.
Check that the Date column retained the intended day and that the R values are numeric after import. Spreadsheet locale and automatic type detection can change how dates or decimal values appear. Keep the raw CSV as a backup so you can compare any suspicious cell with the original.
- Use a separate raw-data tab
- Check date and decimal formatting
- Freeze the header row for review
- Re-export and import manually when you want a newer snapshot
A weekly review that avoids misleading win rates
Filter to a single setup and market before interpreting an average. Count only executed BUY or SELL rows with an outcome when calculating a win rate; WAIT rows belong in a separate decision-quality review. A high average R over a handful of trades is a description of that sample, not a forecast.
Compare the planned risk percentage with the result and lesson. If losses come from entering before confirmation, changing stops, or ignoring the next resistance, those process errors are more actionable than a single aggregate P/L number. Keep notes about fees and slippage separately if they are not captured in Result (R).
- Group by setup and market
- Separate executed trades from WAIT decisions
- Review sample size before drawing conclusions
- Look for repeatable execution errors
What the export does not include
The CSV does not include screenshots, order IDs, exact entry and exit prices, fees, or an automatic account balance. Add columns for those fields in your own Sheet only if you can collect them accurately. Do not infer them from an AI assessment or from the Result (R) value.
The browser journal has no Google Sheets integration or automatic cloud backup. Export regularly if the entries matter to you; clearing browser storage can remove the local copy. A spreadsheet can help organize decisions, but it cannot validate a strategy without complete and consistently recorded outcomes.
Common questions
Is the TradeStreamAI journal a Google Sheets template?
It is a browser-based journal that exports CSV. Import that CSV into Google Sheets to create a spreadsheet copy; there is no automatic sync.
Can I open the CSV in Excel instead?
Yes. Excel can open or import CSV files. Check date, decimal, and delimiter interpretation after opening.
Should a WAIT decision have a result in R?
No realized trade result belongs on a skipped decision. Leave Result (R) blank and use the Lesson column to record why you waited.
What is one R in a trading journal?
One R is the money initially planned to be at risk on a trade. A +2R outcome is twice that planned risk before any adjustment you have not separately recorded.
Platform references
Educational decision support. Chart analysis cannot guarantee a result, and all prices, contract values, and execution conditions require independent verification.