The Scenario
You run income investments for a family office. Thirty dividend-paying stocks, tracked in Excel. Every quarter you sit down to update the dividend calendar — ex-dates, pay dates, declared amounts — so the family can anticipate cash flows. You started the update an hour ago. You're on ticker 11.
Your process involves opening each company's investor relations page, finding the declared dividend, and typing the dates and amount into the workbook. Some companies have changed their dividend schedule since last quarter. Two don't have their next ex-date posted yet.
Nineteen tickers to go. The quarterly cash flow planning meeting is at 2 PM.
The bad version:
- Navigate to the next company's investor relations site. Find the dividend section. Note the ex-date, pay date, and declared amount. Type all three into the workbook.
- Repeat, discover that two companies declared a special dividend this quarter that doesn't appear in the regular schedule, and have to go back to add a second row for those tickers.
- Pull up a separate site for earnings dates and work through the list again — because the investor relations site only has dividend information, not earnings dates.
Two separate pass-throughs for 30 tickers, all typed by hand.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the 30 tickers in column A and, through its built-in Twelve Data integration, fetches dividend history and earnings dates for each holding and writes the calendar data into the workbook.
Fetch dividend history for the past 12 months from Twelve Data for each ticker in column A. Write ex-date into column B, pay date into column C, and dividend amount into column D. Fetch the next scheduled earnings date and write into column E.
What You Get
- Ex-dividend date, pay date, and declared dividend amount for each holding's most recent 12-month history.
- Next earnings date in column E for each equity holding.
- ETFs in the list get a note in column E instead of an earnings date since ETFs don't report quarterly.
- Holdings with no dividends paid in the past 12 months get a note in column B instead of a blank, so you can tell the pull ran correctly.
What If the Data Is Not Quite Ready
If you want the last 8 earnings reports with EPS data
Fetch the last 8 earnings reports from Twelve Data for each stock in column A. Write report date into column B, EPS estimate into column C, actual EPS into column D, and the beat/miss difference (actual minus estimate) into column E.
If you want to project quarterly cash flow using dividend amounts and share counts
Fetch upcoming dividend data from Twelve Data for each ticker in column A. Write next ex-dividend date into column B and next dividend amount into column C. Multiply by the share count in column D and write the projected dividend payment into column E. Sum column E and write the total projected quarterly dividend income into a summary cell.
If you want to flag positions with a dividend cut in the past 12 months
Fetch the last 4 quarters of dividend history from Twelve Data for each ticker in column A. Compare each quarter's dividend amount to the prior quarter. In column B, write CUT if the most recent quarter's dividend is lower than the prior quarter, INCREASED if it's higher, and STABLE if it's the same. Flag CUT positions in a separate summary list at the bottom.
Kill-chain: refresh dividend calendar, flag upcoming ex-dates, and project annual income
Fetch 12 months of dividend history from Twelve Data for each ticker in column A and write ex-date, pay date, and amount into columns B, C, D. Sum the last 12 months of dividends per ticker and write the trailing annual dividend into column E. Multiply by shares in column F and write projected annual income into column G. Flag any ticker with an ex-dividend date within the next 14 calendar days with UPCOMING in column H. Sort the workbook so UPCOMING rows appear at the top.
Try It
Get the 7-day free trial of SheetXAI and open your income portfolio workbook with tickers in column A, then ask it to build the full dividend and earnings calendar before your 2 PM planning meeting. Also see pulling fundamental data and the full Twelve Data overview.