Lesson 1: Introduction to Google Finance Functions
📚 Scenario
In this module, we explore the practical aspects of using Google Finance within Google Sheets to analyze stocks. This tool helps fetch real-time and historical data, allowing you to analyze stocks both from a fundamental and technical perspective.
Key Points
- Google Finance Function: Pulls real-time and historical stock data using simple functions in Google Sheets.
- Attributes: Fetch data such as stock prices, market cap, P/E ratios, 52-week highs and lows, and more.
- Use Case: Whether analyzing U.S. or Indian stocks, Google Finance helps you pull data using ticker symbols.
- Scenario: Simulate having a set investment amount and compare different stocks to decide where to invest based on real-time data.
🎥 Video Guide
✍️ Practice Task
Download the provided Google Sheet and practice pulling real-time data for various stocks. Explore Google’s documentation on Google Finance.
Think about these questions to reinforce your understanding of stock market basics.
Lesson 2: Pulling in Historical Data
📚 Scenario
In this module, we will build upon our previous session, where we retrieved real-time stock data using Google Finance. Now, we’ll explore how to pull historical stock data to identify trends and make informed decisions.
Key Learnings:
- Real-Time Data vs. Historical Data: While real-time data provides current prices and instant updates, historical data helps in understanding past trends.
- Google Finance Function for Historical Data: The Google Finance function allows you to pull stock data for any specific time period.
🎥 Video Guide
✍️ Practice Task
Download the provided Google Sheet and practice pulling historical data for various stocks. Modify the timeframes, attributes, and intervals to understand how different data points impact stock analysis. This will set a strong foundation for making data-driven decisions in future modules.
Lesson 3: Retrieving in stock price for a specific date
📚 Scenario
You will learn how to retrieve the stock price for a specific date, such as 5, 7, or 10 days back, using the Google Finance function. This will help you track the performance of your investments over time, allowing you to assess whether you’ve made gains or losses based on your initial purchase date.
Key Learnings
- Retrieving Historical Data for a Specific Date: You can pull in stock prices from specific past dates (e.g., 10 days back) using the Google Finance function in Google Sheets.
- Calculating Gains or Losses: By comparing today’s price with the price on a specific date, you can quickly determine how much money you’ve made or lost over that time period.
🎥 Video Guide
✍️ Practice Task
In the provided Google Sheet, practice pulling prices from different dates (e.g., 5, 7, or 10 days back) for various stocks.