Lesson 1: 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 2: 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.