Weekly Dividend Tracker: High-Yield ETFs & Payout Schedule

Disclaimer
Overview and Data Scope
Column Definitions and Data Flow
Data Tables: YieldMax Funds (Sample)
Data Tables: Defiance and Roundhill Funds
Change Log and Formulas
Change Date Comments
Notes on Data Use and How to Apply
Images

---

Disclaimer

DISCLAIMER:This is not financial advice, I am not a financial planner. Made by The MAUI Weatherman.

Please refrain from requesting Edit Access for this Sheet. Instead, you can make a

copy of this Sheet and edit your own version.

With the change to weekly distributions on October 15, the formula for Average Dividend will be skewed for a while.

Averages have been reset due to change to weekly.

This document contains a comprehensive spreadsheet-style data dump intended to track weekly dividend payouts across a large universe of income-focused exchange-traded funds (ETFs) and funds managed by YieldMax, Defiance, Roundhill, GraniteShares, ProShares, iShares, Tuttle, and other issuers. The data includes, but is not limited to:

Pay Week (Day) and Pay Schedule (Weekly, Bi-Weekly, or Weekly with a distinct cadence)
Company / Ticker / Website and related links (Total Real Returns Link and Stock Analysis Link)
Ex-Date (Auto Fetched) and Current Price
3-Month Trailing Average Dividend (Auto Fetched) and Last Dividend Paid (Auto Fetched)
Estimated Target Buy Price and YOC/ROI (Dividend per Dollar)
Shares Needed for $1K, $2.5K, and $5K monthly income, plus the corresponding costs
Data entries span multiple weeks and weeks are grouped by the cadence (e.g., Weekly (5-Fri), Weekly (4-Thu), Weekly (Wed-Fri), etc.)

The dataset is large and includes many rows for YieldMax, Defiance, Roundhill, GraniteShares, ProShares, Nicholas, iShares, Tuttle, and Cornerstone among others. The values shown reflect the state of the sheet around the change to weekly distributions and the subsequent recalibration of averages and payout expectations. The data include several historical entries with dates like Nov-19, Nov-20, and updates to weekly schedules across multiple funds.

Note: The document contains several repeated disclaimer blocks and large blocks of tabular data. The content below preserves all data sections and retains the exact values and structure as found in the source document where possible, while maintaining a readable Markdown presentation.

The following sections reproduce the core content blocks and data in a readable, navigable format with anchors for in-page linking.

Column Definitions and Data Flow

Below is a high-level description of the column headers and data relationships as they appear in the source sheet. The exact column order may vary slightly between sections as new funds were added and cadences adjusted, but the definitions remain consistent across the dataset:

YM Group / Pay Week: The schedule cadence and group label (e.g., Weekly (5-Fri), Weekly (4-Thu), Week 1, Week 2, etc.)
Pay Week (Day): The specific pay day and cadence (e.g., Fri, Wed-Fri, Mon) depending on the fund.
Company: Issuer or fund sponsor (e.g., YieldMax, Defiance, Roundhill, GraniteShares, ProShares, etc.)
Ticker: The trading symbol for the ETF or fund (e.g., ABNY, AIYY, AMDY, etc.)
Website: The issuer or fund’s page (often hyperlinked names in the original sheet)
Total Real Returns Link: Link to the total real returns page for the instrument
Stock Analysis Link: Link to stock analysis page for the instrument
Ex-Date (Auto Fetched): The ex-dividend date as automatically fetched by the sheet
Current Price: The instrument’s current price as fetched by the sheet
3-Month Trailing Average Dividend (Auto Fetched): The trailing 3-month average dividend per share
Last Dividend Paid (Auto Fetched): The most recent dividend payment per share
Estimated Target Buy Price: A calculated target buy price based on yields and price trends
YOC/ROI DIV / Dollar: Yield-on-Cost or ROI per dollar invested, a derived percentage
Shares Needed for $1K month: Number of shares needed to generate $1,000/month in income
Cost for $1K Month: Cost to acquire the above number of shares
Shares Needed for $2.5K month: As above for $2,500/month
Cost for $2.5K Month: Cost to acquire
Shares Needed for $5K month: As above for $5,000/month
Cost for $5K month: Cost to acquire

The data are repeated for each fund entry and cadence, and include weekly, bi-weekly, or other cadence entries where applicable.

Data Tables: YieldMax Funds (Sample)

The YieldMax rows illustrate the weekly cadence entries, with the first few lines shown as an example of the data structure. The table contains the following columns (as above): Pay Week, Company, Ticker, Website, Total Real Returns Link, Stock Analysis Link, Ex-Date, Current Price, 3-Month Trailing Average Dividend, Last Dividend Paid, Estimated Target Buy Price, YOC/ROI Dividend per Dollar, Shares Needed for $1K, Cost for $1K, Shares Needed for $2.5K, Cost for $2.5K, Shares Needed for $5K, Cost for $5K. The first few rows demonstrate the cadence:

Weekly (5-Fri) YieldMax ABNY ABNY ABNY Nov-20 Thu $9.31 $0.40440 $0.09110 $9.22 50.88% $0.010 2,472.7992 $23,021.76 6,181.9980 $57,554.40 12,363.9960 $115,108.80
Weekly (5-Fri) YieldMax AIYY AIYY AIYY Nov-20 Thu $1.96 $0.12360 $0.02940 $1.93 78.00% $0.015 8,090.6149 $15,857.61 20,226.5372 $39,644.01 40,453.0744 $79,288.03
Weekly (5-Fri) YieldMax AMDY AMDY AMDY Nov-20 Thu $9.31 $0.68950 $0.14670 $9.16 81.94% $0.016 1,450.3263 $13,502.54 3,625.8158 $33,756.35 7,251.6316 $67,512.69
Weekly (5-Fri) YieldMax AMZY AMZY AMZY Nov-20 Thu $14.21 $0.69710 $0.10670 $14.10 39.05% $0.008 1,434.5144 $20,384.45 3,586.2860 $50,961.12 7,172.5721 $101,922.25
Weekly (5-Fri) YieldMax APLY APLY APLY Nov-20 Thu $13.85 $0.41800 $0.06470 $13.79 24.29% $0.005 2,392.3445 $33,133.97 5,980.8612 $82,834.93 11,961.7225 $165,669.86

The subsequent lines continue for dozens of YieldMax funds, showing similar structure, with values varying by ticker and date. The data for each entry includes the same set of fields, and the cadence changes across rows as shown in the original sheet.

Data Tables: Defiance and Roundhill Funds

Following the YieldMax sample are entries for Defiance, Roundhill, and other issuers. These sections mirror the same column structure and include a broad array of tickers such as QLDY, MST, SMCC, HOOI, QQQY, and many others. The purpose of these sections is to provide a complete, row-by-row view of the weekly and bi-weekly schedules, ex-dates, current prices, dividend values, and the calculated income targets. The rows illustrate cadence shifts, such as Weekly (4-Thu), Weekly (5-Fri), and other weekly combinations. This portion of the sheet is extensive and contains many hundreds of rows across multiple weeks.

Change Log and Formulas

The document includes sections describing formulas for calculating dividend yields, YOC/ROI, and dollar-denominated income targets. A representative set of example formulas is provided in the Types section:

Ex-Date 3-Month Trailing Average Dividend Last Dividend Paid (Auto Fetched)
High Dividend ETFs MSTY
iferror(query(importhtml(CONCATENATE("https://stockanalysis.com/etf/",$C16,"/dividend/"),"table", 1),"Select Col1 order by Col1 desc limit 1",""),"No Data")
iferror(query(importhtml (CONCATENATE("https://stockanalysis.com/etf/",$C16,"/dividend/"),"table",1),"Select Col2 order by Col1 desc limit 3",""))

The Change Date section lists a chronological series of updates, including additions of new funds, updates to weekly schedules, and changes to the YOC formula. The section contains nuanced notes about modifications that occurred on specific dates (e.g., 10/24/2025, 8/12/2025, 7/15/2025, etc.) and describes the rationale for changes like shifting to weekly distributions and updating ex-date logic.

Change Date Comments

10/24/2025 updated formula for YOC on the YieldMax sheet
10/23/2025 temporarily edited the 3-Month trailing average formula for the YieldMax funds to only use the dividends being paid weekly
10/12/2025 added Defiance QLDY with a new formula for the twice a week Ex-Date
10/12/2025 added YieldMax CRCO, DRAY, GMEY, HIYY, RBLY, RDYY
10/12/2025 added Kurv KGLD, KSLV (no dividends yet)
10/12/2025 added NEOS IAUI, IYRI
10/12/2025 added iShares LQDW, TLTW, HYGW
10/12/2025 updated YM dates to new weekly schedule
10/12/2025 updated distribution schedule for Kurv and other funds
10/12/2025 updated weekly funds list
10/12/2025 added a variety of new funds and weekly entries
10/12/2025 codified weekly pay cadence across the dataset
8/12/2025 Updated YOC formula for YieldMax Group A/B/C/D funds as per comment on Reddit
8/1/2025 added Bitwise IGME
7/22/2025 corrected payout date for GraniteShares weekly funds
7/17/2025 added Nicholas BLOX to Weekly section
7/15/2025 updated YOC formula for Roundhill YETH and GraniteShares NVYY, TQQY, TSYY, XBTY due to the shift to weekly
7/7/2025 moved Roundhill YETH to Weekly section
7/22/2025 added Roundhill AMZW, BRKW, NFLW, METW to Weekly section
6/29/2025 added NEOS BTCI to 'Other ETFs'
6/26/2025 added Bitwise IMST, ICOI, IMRA
6/23/2025 IGME added but no dividend payment yet
6/22/2025 Split Weekly Paid ETFs to a new sheet.
6/22/2025 added REX Shares CEPI
6/22/2025 added REX Shares TSII, MSII, COII, Defiance GLDY, and Global X BCCC
6/22/2025 moved Defiance USOY to Weekly section
6/22/2025 added YieldMax RNTY to 'Other ETFs'
6/10/2025 added YieldMax HOOY, REX Shares NVII
6/10/2025 changed GraniteShares NVYY, TQQY, TSYY, XBTY and YSPY to Weekly section

5/24/2025 added WNTR
5/23/2025 added XPAY to 'Other ETFs'. Updated distribution schedule since XPAY has a different schedule to the others
5/23/2025 added MST
5/17/2025 added new GraniteShares YieldBOOST funds, TQQY, YSPY
5/15/2025 added MAGY
4/23/2025 added CHPY
4/1/2025 changed SQY to XYZY
3/23/2025 added RDTY
3/15/2025 changed ULTY to weekly. Formula for the average has been reset due to the shift
3/7/2025 added new Roundhill WeeklyPay funds, NVW, TSW, AAPW, COIW, PLTW
2/28/2025 added QDTY
2/24/2025 added SDTY
2/17/2025 added TSYY to 'Other ETFs'
2/6/2025 Added GPTY
1/29/2025 Updated distribution dates for Kurv funds
1/24/2025 Updated formulas for LFGY, FEAT, FIVY to pull data from SA site
1/22/2025 Added LFGY, FEAT, FIVY
1/18/2025 Temporarily entered the first dividend until Stock Analysis updates
1/17/2025 Tweaked 3-month trailing average formula for Defiance weekly funds. Enough weekly payments now to use the same formula (13 weeks x 4)
1/9/2025 Moved QQQT and SPYT to 'Other ETFs'
1/3/2025 Updated distribution Schedules for some other funds
1/2/2025 Updated some more distribution dates
12/30/2024 Updated Distribution Schedules for YieldMax, Roundhill, Volatility etc
12/7/2024 Renamed ZIVB to ZVOL
11/20/2024 Removed QYLD
11/10/2024 Added PLTY
11/19/2024 Split High-Yield funds to two tabs. New tab for lower yielding funds
10/11/2024 Added Dividend / Dollar column
10/11/2024 Updated Google Finance price formula to include the exchange code (BATS, NASDAQ, NYSE)
9/23/2024 Added RDTE, changed YMAX/YMAG to weekly, tweaked formula for weekly Ex-Dates, added Kurv dates to the schedule
9/24/2024 Removed TRES, moved Weekly funds to the top, added YieldMax Groups, added new funds, fixed YM dates per group
9/26/2024 Moved IWMY, QQQY and JEPY to Weekly, changed JEPY to WDTE
10/13/2024 Removed URAX
10/10/2024 Updated Google Finance price formula to include the exchange code (BATS, NASDAQ, NYSE)
10/11/2024 Added column for StockAnalysis link, updated formula for Total Returns link
10/11/2024 Added Dividend / Dollar column
10/11/2024 Updated: Conditional formatting to YOC/ROI
10/11/2024 Changed "Shares for $xxx" and "Cost for $xxx" formula to use the 3 month average price
10/9/2024 Removed WEEL
9/26/2024 Moved IWMY, QQQY and JEPY to Weekly, changed JEPY to WDTE
9/24/2024 Removed TRES, moved Weekly funds to the top, added YieldMax Groups, added new funds, fixed YM dates per group
9/23/2024 Added RDTE, changed YMAX/YMAG to weekly, tweaked formula for weekly Ex-Dates, added Kurv dates to the schedule


### Change Date Comments (continued) {#change-date-comments-continued}

- 11/20/2024 Removed QYLD
- 11/10/2024 Added PLTY
- 11/19/2024 Split High-Yield funds to two tabs. New tab for lower yielding funds
- 10/13/2024 Removed URAX
- 10/10/2024 Updated Google Finance price formula to include the exchange code (BATS, NASDAQ, NYSE)
- 10/11/2024 Added column for StockAnalysis link, updated formula for Total Returns link
- 10/11/2024 Added Dividend / Dollar column
- 10/11/2024 Updated Google Finance price formula to include the exchange code (BATS, NASDAQ, NYSE)
- 9/23/2024 Added RDTE, changed YMAX/YMAG to weekly, tweaked formula for weekly Ex-Dates, added Kurv dates to the schedule
- 9/24/2024 Removed TRES, moved Weekly funds to the top, added YieldMax Groups, added new funds, fixed YM dates per group
- 9/26/2024 Moved IWMY, QQQY and JEPY to Weekly, changed JEPY to WDTE


### Images {#images}

The document contains and references multiple images that illustrate the tables and data blocks. The three embedded screenshots show different views of the weekly dividend data, cadence schedules, and change logs. The images help visualize the cadence and formatting of the data:

- Image 1: Screenshot of the primary data table (Pay Week, Company, Ticker, etc.) showing the weekly cadence and several rows for various funds.
- Image 2: Screenshot of a condensed version focusing on weekly pay schedules for a subset of funds.
- Image 3: Screenshot of weekly and bi-weekly cadence splits and a portion of the Change Date section.

### Data Blocks: Full Data Tables (Preserved Style) {#data-blocks-full-data-tables-preserved-style}

Below are data blocks preserved from the source, reflecting the exact formatting and values where possible. Due to the size of the dataset, the full content is displayed in a compact but faithful representation and includes the first several lines to demonstrate structure. The complete sheet contains hundreds of lines across multiple cadences and funds, and is intended to be used in conjunction with the original sheet for exhaustive review. The following blocks illustrate the layout and data types present in the document.

Weekly (5-Fri) YieldMax ABNY ABNY ABNY Nov-20 Thu $9.31 $0.40440 $0.09110 $9.22 50.88% $0.010 2,472.7992 $23,021.76 6,181.9980 $57,554.40 12,363.9960 $115,108.80

Weekly (5-Fri) YieldMax AIYY AIYY AIYY Nov-20 Thu $1.96 $0.12360 $0.02940 $1.93 78.00% $0.015 8,090.6149 $15,857.61 20,226.5372 $39,644.01 40,453.0744 $79,288.03

Weekly (5-Fri) YieldMax AMDY AMDY AMDY Nov-20 Thu $9.31 $0.68950 $0.14670 $9.16 81.94% $0.016 1,450.3263 $13,502.54 3,625.8158 $33,756.35 7,251.6316 $67,512.69

Weekly (5-Fri) YieldMax AMZY AMZY AMZY Nov-20 Thu $14.21 $0.69710 $0.10670 $14.10 39.05% $0.008 1,434.5144 $20,384.45 3,586.2860 $50,961.12 7,172.5721 $101,922.25

Weekly (5-Fri) YieldMax APLY APLY APLY Nov-20 Thu $13.85 $0.41800 $0.06470 $13.79 24.29% $0.005 2,392.3445 $33,133.97 5,980.8612 $82,834.93 11,961.7225 $165,669.86


For brevity, the remainder of the first table includes numerous additional rows for other tickers such as BABO, BRKC, CONY, CRSH, CRCO, CVNY, DIPS, and many more, following the same column structure.

Bi-Weekly (Wed/Fri) Defiance QLDY QLDY QLDY Nov-19 Wed $48.86 $0.78225 $0.19370 $48.67 20.61% $0.004 1,278.3700 $62,461.16 3,195.9249 $156,152.89 6,391.8499 $312,305.79

Weekly (4-Thu) Defiance MST MST MST Nov-19 Wed $3.18 $0.56135 $0.06880 $3.11 112.50% $0.022 1,781.4076 $5,664.88 4,453.5190 $14,162.19 8,907.0379 $28,324.38

Weekly (4-Thu) Defiance SMCC SMCC SMCC Nov-19 Wed $10.04 $1.44585 $0.21490 $9.83 111.30% $0.021 691.6325 $6,943.99 1,729.0813 $17,359.98 3,458.1625 $34,719.95