GOOGLEFINANCE

The GOOGLEFINANCE function in Google Sheets is a powerful tool to fetch current or historical securities information from Google Finance. Whether you're tracking stock prices, analyzing financial data, or creating dynamic dashboards, the GOOGLEFINANCE function simplifies the task. Dive into our comprehensive guide to master its application.

Function Syntax and Parameters

Syntax: GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

Parameters:

• ticker: The stock symbol or stock market index.
• attribute: [Optional] The financial metric or statistical characteristic to fetch.
• start_date: [Optional] The start date for fetching historical data.
• end_date|num_days: [Optional] The end date or number of days for fetching historical data.
• interval: [Optional] The time interval between data points for historical data.

Step-by-Step Tutorial

1. Fetching Current Data:

   • Example: =GOOGLEFINANCE("GOOG", "price")
   • Result: Returns the current stock price for Google (GOOG).

2. Fetching Historical Data:

   • Example: =GOOGLEFINANCE("GOOG", "close", "1/1/2020", "12/31/2020", "DAILY")
   • Result: Returns the closing prices of Google (GOOG) stock for each day in the year 2020.

Use Cases and Scenarios

1. Stock Price Tracking: Monitor the current and historical prices of stocks.
2. Financial Analysis: Calculate metrics like market cap, P/E ratio, or dividend yield.
3. Portfolio Management: Evaluate the performance of investment portfolios.

Related Functions

N/A

Related Articles

N/A