Google Sheets Integration

Use =DIVV() just like GOOGLEFINANCE() - same syntax, better dividend data

🎉

Track Prices & Dividends for Free. Forever.

Most dividend investors never need to pay

stocks tracked

5x/day

price checks

forever

Free tier: 10,000 API calls/month • Your 20-stock portfolio uses ~3,000/month

Free tier includes:

PriceOpenHigh/LowDividend YieldDividend Amount

Want more? Upgrade for full access (PE ratio, volume, market cap, dividend history, etc.)

Try It Now

Current Data (Free Tier)

Instead of this:

=GOOGLEFINANCE("AAPL", "price")
=GOOGLEFINANCE("AAPL", "high")
=GOOGLEFINANCE("AAPL", "low")

Use this:

=DIVV("AAPL", "price")
=DIVV("AAPL", "dayHigh")
=DIVV("AAPL", "dividendYield")

Historical Data (Paid Tier)

GOOGLEFINANCE syntax:

=GOOGLEFINANCE("AAPL", "price",
  DATE(2024,1,15))

DIVV syntax:

=DIVV("AAPL", "close",
  "2024-01-15")

💎 Free tier includes: price, open, dayHigh, dayLow, previousClose, dividendYield, dividendAmount
📅 Historical data requires Starter tier ($9/mo) or higher

Installation (5 minutes)

Open Google Sheets Apps Script

In your Google Sheet, go to Extensions → Apps Script

Download the DIVV Script

Download our ready-to-use Google Apps Script file

Download DIVV.gs

Copy the Script Code

Open the downloaded file, select all (Cmd+A / Ctrl+A), and copy the code

Paste into Apps Script

Delete any existing code in the Apps Script editor and paste the DIVV code

Configure API Endpoint

Update the API_BASE_URL at the top of the script:

// For production (recommended)
const API_BASE_URL = 'https://api.divv.com';

// For local testing
const API_BASE_URL = {API_CONFIG.baseUrl};

Save and Test

Click Save (💾 icon), then go back to your sheet and try:

=DIVV("AAPL", "price")

Available Functions

`=DIVV(symbol, attribute, [startDate], [endDate])`

Get current or historical stock data with GOOGLEFINANCE() compatible syntax

Current Data (Free Tier):

=DIVV("AAPL", "price")           → 175.43
=DIVV("MSFT", "dividendYield")   → 0.89%
=DIVV("JNJ", "dividendAmount")   → 4.76
=DIVV("PG", "dayHigh")           → 168.85

📅 Historical Data (Paid Tier - $9/mo):

// Single date
=DIVV("AAPL", "close", "2024-01-15")         → 185.59
=DIVV("AAPL", "close", DATE(2024,1,15))     → 185.59

// Date range (returns 2D array)
=DIVV("AAPL", "close", "2024-01-01", "2024-01-31")
// Returns: [Date, Close] array for charting

// Cell reference
=DIVV("AAPL", "close", A1)  // A1 = 2024-01-15

Upgrade to unlock historical data

`=DIVVBULK(symbols, attribute)`

Get data for multiple stocks at once (more efficient)

Example:

=DIVVBULK(A2:A10, "price")
// Where A2:A10 contains: AAPL, MSFT, GOOGL, etc.

`=DIVVDIVIDENDS(symbol, limit)`

Get dividend history for a stock

Example:

=DIVVDIVIDENDS("AAPL", 12)
// Returns last 12 dividends with dates and amounts

`=DIVVARISTOCRAT(symbol, returnYears)`

Check if stock is a Dividend Aristocrat (25+ years of increases)

Examples:

=DIVVARISTOCRAT("JNJ")        → TRUE (is Aristocrat)
=DIVVARISTOCRAT("JNJ", TRUE)  → 61 (years of increases)
=DIVVARISTOCRAT("TSLA")       → FALSE

Supported Attributes

All GOOGLEFINANCE() attributes are supported, plus additional dividend-specific fields:

GOOGLEFINANCE() Compatible

priceCurrent price
high5252-week high
low5252-week low
peP/E ratio
epsEarnings per share
marketcapMarket capitalization
volumeTrading volume

Dividend-Specific

dividendYieldCurrent yield %
dividendAmountAnnual dividend
priceAvg5050-day MA
priceAvg200200-day MA
yearHigh52-week high
yearLow52-week low

💡 Tip: You can use either GOOGLEFINANCE() style names (e.g., high52) or Divv style names (e.g., yearHigh) - both work!

Advanced Features

🚀 Automatic Caching

Data is cached for 5 minutes to improve performance and reduce API calls. You can adjust this in the script configuration.

🔄 Retry Logic

Automatically retries failed requests up to 3 times with exponential backoff. Handles rate limiting gracefully.

🔑 API Key Support

Add your API key to unlock higher rate limits and premium features:

const API_KEY = 'your-api-key-here';

🧹 Clear Cache

Need fresh data? Run this in the Apps Script editor:

clearDivvCache()

Example: Dividend Dashboard

Here's how to build a simple dividend tracking dashboard in Google Sheets:

Symbol	Price	Yield	Aristocrat?
AAPL	=DIVV(A2,"price")	=DIVV(A2,"dividendYield")	=DIVVARISTOCRAT(A2)
JNJ	=DIVV(A3,"price")	=DIVV(A3,"dividendYield")	=DIVVARISTOCRAT(A3)
PG	=DIVV(A4,"price")	=DIVV(A4,"dividendYield")	=DIVVARISTOCRAT(A4)

Troubleshooting

#ERROR: Invalid symbol

Check that the symbol is correct and exists in our database. Symbols must be in UPPERCASE.

#ERROR: API error: 429

You've hit the rate limit. The function will automatically retry. Consider upgrading your plan or using DIVVBULK() for better efficiency.

Function not recognized

Make sure you saved the script and refreshed your Google Sheet. Try closing and reopening the sheet.

Authorization required

The first time you use the function, Google will ask for authorization. Click "Review Permissions" and grant access.

View Full API Documentation