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.
Lesson 4: Advanced Google sheets functions
📚 Scenario
In this section, you’ll learn how to retrieve the average stock price over a set number of days using the Google Finance function combined with other Google Sheets functions, such as DAVERAGE. This method will help you analyze stock trends over time by comparing averages over short and long periods (e.g., 7-day vs. 20-day averages).
Key Learnings
- Aggregate Data Calculation: You can calculate average, minimum, or maximum prices over a specific period using Google Finance and Google Sheets functions like DAVERAGE.
- Tracking Trends: By comparing averages, you can analyze trends in stock prices, such as whether the 7-day average price is moving up or down compared to a longer-term 20-day average.
🎥 Video Guide
✍️ Practice Task
In the Google Sheet, calculate the 7-day and 20-day averages for a set of stocks. Compare the two averages to determine whether the stock is trending upward or downward.
Lesson 5: Creating a Stock Dashboard
📚 Scenario
Creating stock dashboards using Google Sheets and Google Finance allows investors and traders to track stock performance with real-time data, making it easier to visualize trends and make informed decisions. The use of Google Sheets formulas enables automatic updates and comparisons, reducing the need for manual tracking.
Key Aspects
- Leveraging Google Sheets with Google Finance for real-time stock data
- Using Sparkline for visual indicators of stock trends
- Fetching 20-day and 200-day moving averages
- Comparing stock price trends over time
🎥 Video Guide
✍️ Practice Tasks
Open a new Google Sheet and create a stock dashboard using the GOOGLEFINANCE function to track real-time prices of 10 different stocks from different sectors.