Ex-Dividend Date: Open Orders and Premarket
What happens to a resting buy limit when a stock goes ex-dividend, which open orders get reduced, and why premarket can look down before the open.
On the ex-dividend date, the orders you left resting overnight are handled before you get a say in it. Open buy limit orders and open sell stop orders are reduced by the cash amount of the dividend on the morning a stock trades ex, unless the order carries a "do not reduce" instruction. The same subtraction turns up in the reference close that percent-change displays lean on, which is why a stock can read lower in premarket on a morning when nothing else about it has changed.
The ex-dividend date explainer covers the timeline. What follows is the order handling: what the rulebook does to an order you already have working, and what a premarket quote on an ex-date is actually measuring.
What happens to open orders on the ex-dividend date?
An open order is one still working at the end of a session rather than filled or canceled, usually a good-till-canceled order. Time in force is covered in order time in force.
Before the ex-date session begins, the firm holding that order lowers its price by the dividend. The requirement sits in FINRA Rule 5330, which every member broker is held to:
A member holding an open order from a customer or another broker-dealer shall, prior to executing or permitting the order to be executed, reduce, increase, or adjust the price and/or number of shares of such order by an amount equal to the dividend, payment, or distribution on the day that the security is quoted ex-dividend, ex-rights, ex-distribution, or ex-interest, except where a cash dividend or distribution is less than one cent ($0.01).
FINRA Rule 5330, Adjustment of Orders. Checked against the FINRA rulebook on September 25, 2026; last amended by SR-FINRA-2009-084, effective April 19, 2010.
Two details in that sentence reach a retail order. A cash dividend under one cent is left alone entirely. And the subtraction runs first, with the rounding applied after it:
Unless marked "Do Not Reduce," open order prices shall be first reduced by the dollar amount of the dividend, and the resulting price will then be rounded down to the next lower minimum quotation variation.
Say a stock closes at $100.00 the evening before it goes ex on a $0.75 quarterly dividend. The reference close for the next session is $99.25. A buy limit resting at $98.00 is repriced to $97.25, and the same order marked "do not reduce" stays at $98.00. Those are hypothetical round numbers, picked to keep the arithmetic visible. Real dividends are not round, as the panels below show.
Which orders get reduced, and which are left alone
Rule 5330(d) defines an open order as an order to buy or an open stop order to sell, and paragraph (e) carves out open stop orders to buy along with open sell orders. In plain terms, the orders resting below the current price get reduced: buy limits and sell stops. Orders resting above the market, sell limits and buy stops, stay where you put them.
The "do not reduce" instruction applies only to ordinary cash dividends. A stock dividend or a split is handled by the same rule on the size side, where the share count is increased unless the order is marked "do not increase".
Brokers then add their own layer on top. Some cancel working orders around a corporate action rather than reprice them, and the hour at which the overnight adjustment runs varies between firms. Your order confirmation, not the exchange rulebook, is the record of what actually happened to your order.
The size of the adjustment is simply the dividend, so it is worth seeing how large that is in practice. The panel below takes a basket of large, regular payers and lines up the next dated ex-dividend each one has on the calendar.
| ticker | ex_date_label | dividend_usd | reduction_pct |
|---|---|---|---|
| JPM | Oct 6 | 1.65 | 0.485 |
| CSCO | Oct 2 | 0.42 | 0.392 |
| MSFT | Nov 19 | 0.98 | 0.197 |
The exact SQL behind every number
WITH
upcoming AS
(
SELECT
ticker,
min(ex_dividend_date) AS ex_date,
argMin(cash_amount, ex_dividend_date) AS dividend_usd
FROM global_markets.stocks_dividends
WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
AND cash_amount > 0
AND ex_dividend_date >= today()
AND ex_dividend_date <= today() + 120
GROUP BY ticker
),
last_price AS
(
SELECT
ticker,
argMax(close, date) AS px
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'PG', 'XOM', 'CVX', 'HD', 'JPM', 'PEP', 'CSCO', 'MRK')
AND date >= today() - 30
GROUP BY ticker
)
SELECT
u.ticker AS ticker,
formatDateTime(u.ex_date, '%b %e') AS ex_date_label,
round(toFloat64(u.dividend_usd), 2) AS dividend_usd,
round(100 * toFloat64(u.dividend_usd) / toFloat64(p.px), 3) AS reduction_pct
FROM upcoming AS u
INNER JOIN last_price AS p ON p.ticker = u.ticker
ORDER BY reduction_pct DESC3 of those names carry a dated ex-dividend inside the next four months. The largest reduction on the list belongs to JPM: a $1.65 dividend going ex on Oct 6, which measures 0.485% of its latest close. In dollar terms these are small numbers, and that is exactly the trap. A buy limit set within a few cents of the market spends the ex-date working at a lower price than the one you typed.
How big is the adjustment, historically?
One name over time shows the shape better than a single date does. Coca-Cola, ticker KO, has lifted its quarterly dividend on a steady cadence, and each lift enlarges the overnight reduction that travels with it.
| ex_date | dividend_usd | reduction_pct |
|---|---|---|
| 2023-06-15 | 0.46 | 0.756 |
| 2023-09-14 | 0.46 | 0.787 |
| 2023-11-30 | 0.46 | 0.79 |
| 2024-03-14 | 0.485 | 0.794 |
| 2024-06-14 | 0.485 | 0.77 |
| 2024-09-13 | 0.485 | 0.681 |
| 2024-11-29 | 0.485 | 0.753 |
| 2025-03-14 | 0.51 | 0.733 |
| 2025-06-13 | 0.51 | 0.706 |
| 2025-09-15 | 0.51 | 0.761 |
| 2025-12-01 | 0.51 | 0.697 |
| 2026-03-13 | 0.53 | 0.683 |
| 2026-06-15 | 0.53 | 0.641 |
| 2026-09-15 | 0.53 | 0.593 |
The exact SQL behind every number
WITH
px AS
(
SELECT
date,
max(close) AS close_px
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'KO'
AND date >= today() - 1300
GROUP BY date
),
daily AS
(
SELECT
date,
any(close_px) OVER (ORDER BY date ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_close
FROM px
),
divs AS
(
SELECT
ex_dividend_date AS ex_date,
max(cash_amount) AS dividend_usd
FROM global_markets.stocks_dividends
WHERE ticker = 'KO'
AND cash_amount > 0
AND ex_dividend_date >= today() - 1200
AND ex_dividend_date < today()
GROUP BY ex_dividend_date
)
SELECT
toString(v.ex_date) AS ex_date,
round(toFloat64(v.dividend_usd), 4) AS dividend_usd,
round(100 * toFloat64(v.dividend_usd) / toFloat64(d.prior_close), 3) AS reduction_pct
FROM divs AS v
INNER JOIN daily AS d ON d.date = v.ex_date
ORDER BY ex_date ASCAcross the 14 quarters in view, KO's most recent dividend of $0.53 measured 0.593% of the prior close, against 0.756% at the start of the window. Both ends sit under one percent, which is why the ex-date adjustment is easy to miss on a price chart. A limit order pinned within a few cents of the market does notice it.
Why a stock can look down in premarket on the ex-date
Every percent-change number needs a reference price, and on an ex-date there are two defensible ones. The raw prior close is what the stock actually printed the day before. The adjusted reference is that close minus the dividend, the same number the open orders were moved to. One trade, measured against each, produces two different percentages.
| ex_date | vs_prior_close_pct | vs_adjusted_close_pct |
|---|---|---|
| 2023-06-15 | -0.41 | 0.35 |
| 2023-09-14 | -0.34 | 0.45 |
| 2023-11-30 | -0.46 | 0.33 |
| 2024-03-14 | -0.88 | -0.09 |
| 2024-06-14 | -0.97 | -0.2 |
| 2024-09-13 | -0.55 | 0.13 |
| 2024-11-29 | -0.64 | 0.12 |
| 2025-03-14 | -1.59 | -0.87 |
| 2025-06-13 | -0.65 | 0.06 |
| 2025-09-15 | -0.49 | 0.27 |
| 2025-12-01 | -0.71 | -0.01 |
| 2026-03-13 | -0.18 | 0.51 |
| 2026-06-15 | -1.86 | -1.23 |
| 2026-09-15 | -0.92 | -0.33 |
The exact SQL behind every number
WITH
px AS
(
SELECT
date,
max(open) AS open_px,
max(close) AS close_px
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'KO'
AND date >= today() - 1300
GROUP BY date
),
daily AS
(
SELECT
date,
open_px,
any(close_px) OVER (ORDER BY date ASC ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prior_close
FROM px
),
divs AS
(
SELECT
ex_dividend_date AS ex_date,
max(cash_amount) AS dividend_usd
FROM global_markets.stocks_dividends
WHERE ticker = 'KO'
AND cash_amount > 0
AND ex_dividend_date >= today() - 1200
AND ex_dividend_date < today()
GROUP BY ex_dividend_date
)
SELECT
toString(v.ex_date) AS ex_date,
round(100 * (toFloat64(d.open_px) - toFloat64(d.prior_close)) / toFloat64(d.prior_close), 2) AS vs_prior_close_pct,
round(100 * (toFloat64(d.open_px) - (toFloat64(d.prior_close) - toFloat64(v.dividend_usd)))
/ (toFloat64(d.prior_close) - toFloat64(v.dividend_usd)), 2) AS vs_adjusted_close_pct
FROM divs AS v
INNER JOIN daily AS d ON d.date = v.ex_date
ORDER BY ex_date ASCThe two series track each other, offset by roughly the size of the dividend in percent. On the most recent ex-date in the panel, KO's opening print measured -0.92% against the raw prior close and -0.33% against the adjusted reference. Neither is wrong. They answer different questions, and most screens do not tell you which one they picked. How much of the dividend usually shows up in the open is the subject of why stocks drop on the ex-dividend date.
Premarket is where this gets confusing, since the session is thin and the reference is invisible. The panel below takes KO's most recent ex-dividend morning and measures each 15 minute bucket from 07:00 ET through the first half hour of regular trading, once against each reference.
| et_time | ex_dividend_label | vs_prior_close_pct | vs_adjusted_close_pct |
|---|---|---|---|
| 07:00 | Sep 15, 2026 | -0.92 | -0.33 |
| 07:15 | Sep 15, 2026 | -0.94 | -0.34 |
| 07:30 | Sep 15, 2026 | -1.01 | -0.42 |
| 07:45 | Sep 15, 2026 | -0.94 | -0.35 |
| 08:00 | Sep 15, 2026 | -0.85 | -0.26 |
| 08:15 | Sep 15, 2026 | -0.93 | -0.34 |
| 08:45 | Sep 15, 2026 | -0.88 | -0.29 |
| 09:00 | Sep 15, 2026 | -0.81 | -0.21 |
| 09:15 | Sep 15, 2026 | -0.96 | -0.37 |
| 09:30 | Sep 15, 2026 | -1.19 | -0.6 |
| 09:45 | Sep 15, 2026 | -1.14 | -0.55 |
The exact SQL behind every number
WITH
(
SELECT max(ex_dividend_date)
FROM global_markets.stocks_dividends
WHERE ticker = 'KO'
AND cash_amount > 0
AND ex_dividend_date BETWEEN today() - 200 AND today() - 3
) AS ex_date,
(
SELECT max(toFloat64(cash_amount))
FROM global_markets.stocks_dividends
WHERE ticker = 'KO'
AND ex_dividend_date = ex_date
) AS dividend_usd,
(
SELECT toFloat64(argMax(close, date))
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'KO'
AND date >= today() - 220
AND date < ex_date
) AS prior_close
SELECT
formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 15 MINUTE), '%H:%i') AS et_time,
formatDateTime(ex_date, '%b %e, %Y') AS ex_dividend_label,
round(100 * (avg(toFloat64(close)) - prior_close) / prior_close, 2) AS vs_prior_close_pct,
round(100 * (avg(toFloat64(close)) - (prior_close - dividend_usd))
/ (prior_close - dividend_usd), 2) AS vs_adjusted_close_pct
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'KO'
AND window_start >= today() - 210
AND toDate(toTimeZone(window_start, 'America/New_York')) = ex_date
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York'))) >= 420
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York'))) < 600
AND volume > 0
GROUP BY et_time, ex_dividend_label
ORDER BY et_time ASCOn Sep 15, 2026, the 07:00 ET bucket measured -0.92% against the raw prior close and -0.33% against the adjusted one. The gap between the two series holds across every bucket, hours before a single share of the regular session has traded. A premarket quote on an ex-date carries that same ambiguity: the number on the screen depends on which reference the screen picked. Premarket trading also runs on a fraction of the day's volume, and a handful of small prints can land anywhere inside a wide spread.
When the entitlement and the price adjustment come apart
Most of the time the two line up. Buy on the ex-date and you do not receive the dividend, and the reference price for that session has already been reduced. Under T+1 settlement the ex-date is the record date itself, set by FINRA Rule 11140(b)(1) and the matching Nasdaq Equity Rule 11140, both amended for T+1 with an operative date of May 28, 2024. Who fixes that date is covered in who sets the ex-dividend date.
One case splits them apart. For a distribution worth 25% or more of the value of the security, Rule 11140(b)(2) puts the ex-date on the first business day following the payable date. Through that window the stock trades with a due bill attached, a claim that follows the shares to whoever buys them, and the entitlement travels on a different day from the price adjustment. Due bills walk through the same machinery for large stock splits.
FAQ
What happens to a limit order on the ex-dividend date?
An open buy limit order is reduced by the cash dividend before the ex-date session, then rounded down to the next quotable price, unless it is marked "do not reduce". A sell limit order is left at the price you set.
What does "do not reduce" mean on an order?
It is an instruction that holds the order's price where you put it through an ordinary cash dividend. It covers cash dividends only. Share-count adjustments for stock dividends and splits are governed by the separate "do not increase" instruction.
Are stop orders adjusted on the ex-dividend date?
Open sell stop orders are, on the same terms as buy limits. Buy stop orders are not, under the exceptions in Rule 5330(e).
Why does my stock show a loss in premarket on its ex-dividend date?
A percent-change display needs a prior-close reference, and on an ex-date the raw close and the dividend-adjusted close differ by the dividend. The same premarket print can read flat against one reference and lower against the other.
Does my broker follow the exchange rule exactly?
Handling varies between firms. Some cancel working orders around a corporate action instead of repricing them, and the timing of the overnight adjustment differs. The order confirmation is the record of what happened to yours.
Rule citations and how these panels are built
- FINRA Rule 5330, Adjustment of Orders, quoted above, was checked against the FINRA rulebook on September 25, 2026. Its most recent amendment is SR-FINRA-2009-084, effective April 19, 2010.
- FINRA Rule 11140 and the matching Nasdaq Equity Rule 11140 set the ex-date itself. Both were amended for the move to T+1 settlement with an operative date of May 28, 2024.
- NYSE ran its own version for decades as Rule 118, "Orders to be Reduced and Increased on Ex-Date". That standalone rule is no longer carried in the NYSE rulebook, and the instruction now travels with the order as a do not reduce modifier. Cite Rule 5330 for the current requirement rather than Rule 118.
- The KO panels take the prior close from the last daily close before each ex-date, and the adjusted reference as that close minus the cash dividend recorded for the date. Premarket buckets are 15 minutes of ET clock time, averaged across the minute bars that printed.
Every panel here ships with the SQL that produced it, expandable underneath the table. To check where a ticker's next ex-date falls, or what its last few adjustments measured, ask the question in plain English on the Strasmore terminal.