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 — an Excel workbook 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 Excel workbook. 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.
Fetch SHARADAR dividend fundamentals for all tickers in my Excel sheet and populate columns with quarterly dividend per share and trailing dividend yield for the last 8 quarters
What You Get
- Quarterly DPS and trailing dividend yield for the last 8 quarters, written into adjacent columns with quarter-end dates as headers
- Tickers with no dividend history flagged with "No dividend data" rather than zero, which would distort yield calculations
- Payout ratio written as a decimal (0.62, not 62%)
- Values sourced from the SHARADAR fundamentals database and consistent across all 35 tickers
What If the Data Is Not Quite Ready
Some tickers are ADRs and the DPS is in local currency
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 need 8 quarters of history, not just the most recent
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
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 Excel workbook 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.