Google Sheets for Investors: Track Price % Change & Spot Big 2025 November Losers (2025-11-21 002)

Learn how to use Google Sheets to track stock prices like a pro.
In this video, I show you step-by-step:

1️⃣ How to pull current stock prices using Google Sheets
2️⃣ How to get historical prices for any date
3️⃣ How to calculate % price change automatically
4️⃣ A quick breakdown of 2025 November’s biggest losers — former AI & crypto high flyers that crashed hard

Whether you're building a portfolio tracker or just curious about how your stocks moved, this tutorial gives you everything you need.

🔧 Formulas Covered in This Video

✔️ Get real-time price:
=GOOGLEFINANCE("TICKER", "price")

✔️ Get historical price on a date:
=GOOGLEFINANCE("TICKER", "price", DATE(2025,1,2))

✔️ Calculate % change:
=(CurrentPrice - OldPrice) / OldPrice

📉 Why Some AI & Crypto Stocks Crashed This Month

At the end, I highlight several once-hot AI / crypto-related names that became November’s biggest losers — great reminder of market cycles and risk management.

❤️ If you found this helpful, please like & subscribe!

It helps more people discover the channel and supports future tutorials.

Видео Google Sheets for Investors: Track Price % Change & Spot Big 2025 November Losers (2025-11-21 002) канала Alfred Zhong