How to Create a Google Sheets Trading Journal (Step-by-Step for Beginners)

📊 Build Your Own Google Sheets Trading Journal – Beginner Friendly Tutorial

In this video, I’ll show you how to create a clean and practical trading journal using Google Sheets. We’ll cover every essential column — from pip gain to profit tracking — plus keyboard shortcuts and formulas you can use right away.

🎯 TIMESTAMPS:
00:00 - Intro
00:10 - Step 1: Create Your Journal Sheet
01:28 - Step 2: Add Pip Gain, R:R, and Trade Notes
03:36 - Step 3: Track Win/Loss Results
04:29 - Step 4: Log Profit/Loss in Dollars
05:31 - Step 5: Example Entry Overview
06:43 - Final Tip: Review Weekly
07:45 - Outro & Subscribe

---

📥 Google Sheets Formulas (Simplified for YouTube – Replace Quotes Manually)

🔹 **Pips Gained**
=IF(C2 = XAU/USD,
 IF(D2 = Buy, (H2 - E2) * 10, (E2 - H2) * 10),
 IF(C2 = BTC/USD,
  IF(D2 = Buy, (H2 - E2), (E2 - H2)),
  IF(D2 = Buy, (H2 - E2) * 10000, (E2 - H2) * 10000)
 )
)

🔹 **Risk-to-Reward Ratio**
=IF(E2 not empty AND F2 not empty AND G2 not empty,
 ABS((E2 - F2) divided by (E2 - G2)), "")

🔹 **Profit (Editable)**
=IF(I2 and J2 are not empty,
 ROUND(I2 multiplied by J2 multiplied by 10, 2), "")

🔹 **Win/Loss Result**
=IF(E2 or H2 or D2 is empty, "",
 IF(I2 is greater than 0, Win,
  IF(I2 is less than 0, Loss, Breakeven)))

📌 These are simplified. Replace `AND`, `OR`, and `""` with real Excel symbols in your Google Sheet.

---

📈 Like this tutorial?
Subscribe for more raw and beginner-level trading content.
No fluff, no signals — just documenting the learning process.

📌 Copy-friendly versions of the formulas are shown in the video and linked in the template. Comment "TEMPLATE" if you want it!
---

#tradingjournal #googlesheets #forexjournal #beginnertrader #justtrynatrade8 #piptracker #tradelog #journaltemplate

Видео How to Create a Google Sheets Trading Journal (Step-by-Step for Beginners) канала JustTrynaTrade8