Quick Answer & Formula
Sheets
Beginner
=GOOGLEFINANCE("NASDAQ:AAPL", "price") | =GOOGLEFINANCE("CURRENCY:USDEUR") GOOGLEFINANCE pulls real-time and historical financial data from Google Finance directly into cells. For live stock price: =GOOGLEFINANCE("AAPL", "price"). For forex exchange rate: =GOOGLEFINANCE("CURRENCY:USDGBP").
Google Sheets GOOGLEFINANCE Function
The GOOGLEFINANCE function turns Google Sheets into a live, institutional-grade market data feed for stock portfolios, forex tracking, and investment modeling.
1. Live Stock & ETF Quotes
| Metric | Formula | Example Output |
|---|---|---|
| Current Price | =GOOGLEFINANCE("NASDAQ:NVDA", "price") | $128.50 |
| Today’s % Change | =GOOGLEFINANCE("NASDAQ:NVDA", "changepct") / 100 | +3.42% |
| Market Capitalization | =GOOGLEFINANCE("NASDAQ:NVDA", "marketcap") | $3.15T |
| P/E Ratio | =GOOGLEFINANCE("NASDAQ:NVDA", "pe") | 44.8 |
| 52-Week High | =GOOGLEFINANCE("NASDAQ:NVDA", "high52") | $140.76 |
2. Real-Time Currency Exchange (Forex)
To convert $1,000 USD into Euros (EUR):
= 1000 * GOOGLEFINANCE("CURRENCY:USDEUR")3. Mini In-Cell Trendlines with SPARKLINE
To embed a clean 1-year historical price chart inside a single cell:
=SPARKLINE(GOOGLEFINANCE("AAPL", "close", TODAY()-365, TODAY()))
?
Frequently Asked Questions
How often are prices updated in GOOGLEFINANCE?
Quotes may be delayed up to 20 minutes as per Google Finance data provider policies. Values recalculate periodically.
How do I fetch the historical closing price of Apple over the last 30 days?
Use =GOOGLEFINANCE("AAPL", "close", TODAY()-30, TODAY(), "DAILY").