Beginner
Using Google Finance and Yahoo Finance for Market Data
A practical, tool-first course for anyone who wants Indian market data on their own screen, not just on a broker app. Built for college students, first-time demat holders, salaried professionals, homemakers, and retirees who want to track prices, build a simple watchlist, and pull a company's numbers without paying for a data terminal. Covers reading and pulling live NSE and BSE quotes on Google Finance, using the GOOGLEFINANCE function in Google Sheets to build a live watchlist and portfolio tracker, and navigating Yahoo Finance for historical price downloads and company financials, using real Indian tickers throughout.
Google FinanceYahoo FinanceGOOGLEFINANCE FunctionGoogle SheetsNSE and BSE TickersMarket Data
MODULES
3
DURATION
4 Hours
TRACK
Stock Market Basics
What You'll Master
How to read a live stock quote correctly on Google Finance, including NSE versus BSE pricing differences
How to use the GOOGLEFINANCE function to pull live and historical prices into Google Sheets
How to build your own watchlist and portfolio tracker in a spreadsheet you control
How to find the correct Yahoo Finance ticker for an Indian stock using the .NS and .BO suffixes
How to download historical price data from Yahoo Finance as a CSV file
How to use Yahoo Finance's Statistics and Financials tabs to screen a stock before you research it further
Access Level
LEARNER
Everything included
Full Text Playbooks
Actionable Exercises
Mobile Reading Mode
Lifetime Updates