Google Sheets Stock Price API Formula Generator
Generate free Google Sheets formulas to import live stock prices. No signup required.
Type any stock ticker symbol to generate the formula
=IMPORTDATA("https://www.pocketportfolio.app/api/price/AAPL?key=demo_key")This formula will return the current price of AAPL stock. Replace "AAPL" with any ticker symbol.
How to Use
- Copy the formula above
- Open your Google Sheet
- Paste the formula into any cell
- The cell will automatically update with the current stock price
Need unlimited calls? Get a personal API key for £5/mo. Become a Patron →
How It Works
1
Enter Ticker Symbol
Type any stock ticker (e.g., AAPL, TSLA, MSFT) and we'll generate the formula instantly.
2
Copy Formula
Copy the generated formula and paste it directly into your Google Sheets cell.
3
Get Live Prices
Your Google Sheet will automatically update with live stock prices using the IMPORTDATA function.
Example Formula
=IMPORTDATA("https://api.pocketportfolio.app/price/AAPL?key=demo_key")This formula will return the current price of Apple (AAPL) stock. Replace "AAPL" with any ticker symbol.