The Scenario
You're the third person in three months to own the dividend coverage model. The analyst who built it left, the one who maintained it moved to a different fund, and now it's yours — a Google Sheet with 35 tickers in column A, a set of columns that are supposed to have quarterly DPS, yield, and payout ratio, and no clear record of where the data was supposed to come from.
The bad version:
- Search the Nasdaq Data Link documentation for the SHARADAR dividend tables, figure out the difference between
SHARADAR/SF1andSHARADAR/DAILY, identify which one has the dividend fields. - Write a query for the first ticker, check that the field you got is quarterly DPS and not annual, realize the payout ratio requires dividing two separate fields.
- Repeat across 35 tickers, making sure the trailing yield calculation is consistent and that the currency isn't mixed for any of the international ADRs in the list.
This model needs to go to the income committee by end of week. You're starting from scratch on data plumbing that should already be done.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the ticker list, calls Nasdaq Data Link SHARADAR on your behalf, and populates the dividend metrics directly — no table identification, no field math, no currency normalization.
For each ticker in column A, pull dividend history from Nasdaq Data Link SHARADAR and write the most recent quarterly DPS, dividend yield, payout ratio, and cash flow from dividends into columns B, C, D, E
What You Get
- Columns B–E populated with a header row: Quarterly DPS, Dividend Yield, Payout Ratio, Cash Flow from Dividends
- Most recent quarter's values for each ticker, sourced from SHARADAR fundamentals
- Tickers with no dividend history (growth stocks, non-dividend payers) flagged with "No dividend data" in column B rather than zero, which would distort yield calculations
- Payout ratio written as a decimal (0.62, not 62%)
What If the Data Is Not Quite Ready
You need 8 quarters of history, not just the most recent
The income committee wants to see the trend, not a snapshot.
For each ticker in column A, pull the last 8 quarters of dividend per share and trailing dividend yield from Nasdaq Data Link SHARADAR and write them into adjacent columns — label each column with the quarter-end date in row 1
Some tickers are ADRs and the DPS is in local currency
You want the dividend figures normalized to USD for comparison.
For each ticker in column A, pull quarterly DPS from Nasdaq Data Link SHARADAR — if the company reports in a currency other than USD, note the original currency in an adjacent column; write USD-equivalent DPS into column B using the exchange rate noted in column C
The payout ratio looks wrong for a few tickers — you want to see the underlying earnings data too
For each ticker in column A where the payout ratio in column D is greater than 1.0, pull the underlying earnings per share and dividends per share from Nasdaq Data Link SHARADAR and write them into columns F and G so the ratio can be verified
You want the full dividend profile plus a coverage flag in one pass
For each ticker in column A, pull quarterly DPS, dividend yield, payout ratio, and cash flow from dividends from Nasdaq Data Link SHARADAR into columns B through E — then add column F with "Covered" if payout ratio is below 0.75 and cash flow from dividends is positive, "At Risk" if payout ratio is above 1.0, and "Review" otherwise
Fetch and classify in one prompt. The flag lands next to the data rather than requiring a formula column written separately.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a list of dividend stock tickers, then ask it to pull SHARADAR dividend metrics from Nasdaq Data Link across all 35 positions at once. You can also look at the spoke on pulling SHARADAR fundamentals for valuation modeling or the Nasdaq overview.