Consumer Discretionary Earnings Tracker Excel: Q1 2026 Consumer Spending Watchlist

Consumer Discretionary Earnings Tracker Excel is exactly what you want open on your second monitor during the last week of April 2026, because this is the stretch when the biggest names in the sector all print at once. Amazon, Tesla, Home Depot, Lowe's, McDonald's, Starbucks, Nike, and Booking Holdings are all reporting inside a narrow window, and each result changes the picture investors have of real consumer spending, pricing power, and how tariffs are flowing through to the income statement. Instead of jumping between headlines, this guide walks through a live MarketXLS tracker that rolls valuation, income, trend, and margin signals into a single scoreable watchlist.

The goal is educational: build a repeatable framework to read Q1 2026 consumer discretionary earnings with structure instead of gut feel. Every formula shown is a live MarketXLS function, verified through the internal function registry, and the two downloadable templates at the end let you drop your own tickers and portfolio size into the same workflow.

Q1 2026 consumer discretionary earnings snapshot

Here is the watchlist at a glance as of April 24, 2026. The numbers in the tracker itself update live when the template is opened in Excel with the MarketXLS add-in signed in. This table is a static reference so the post is readable without Excel.

A few things stand out immediately. McDonald's and Booking are hugging their 52-week highs, Home Depot and Lowe's are lagging the broader market even though housing turnover has started to thaw, and Tesla is carrying the highest beta and multiple in the group into a print that just landed. That spread of setups is exactly why a single scoring framework helps: it prevents you from reading each ticker in isolation.

Why consumer discretionary earnings matter more than usual this quarter

Every earnings season has a main character. In Q1 2026, it is the consumer. Three threads come together inside the discretionary bucket.

1. Tariff pass-through. Tariff adjustments announced in late 2025 and early 2026 are now showing up in gross margins. Pricing studies, supply chain realignments, and inventory mix are all visible in guidance commentary, and Home Depot, Lowe's, and Nike are particularly exposed.
2. Real wage trend. Labor market softening in the first quarter has put pressure on discretionary wallets. Quick-service restaurants like McDonald's and Starbucks read the value-seeking consumer in real time through traffic and mix.
3. Rate path. Rate expectations have shifted multiple times this quarter. Housing-linked retail and travel names are the most sensitive to the next move because multiple expansion or compression hits them first.

Because these threads pull in different directions, a scoring table that blends valuation, income, trend, and margin signals into one number is the fastest way to sort the group into defensive, balanced, and high-beta buckets. That is what the MarketXLS tracker is built for.

How the MarketXLS consumer discretionary earnings tracker is structured

The workbook has six sheets. Each sheet has a MarketXLS branding header, a "MarketXLS Functions Used" reference box, and clear input cells in yellow so you can plug in your own portfolio size and thresholds.

Because the template uses only MarketXLS functions, you can rename tickers, add or remove rows, and every downstream sheet recalculates automatically. The sample file has the same structure but with static values pre-filled so you can see what a finished snapshot looks like before switching to the live version.

The MarketXLS formulas that power the tracker

Every price, ratio, and fundamental data point in the tracker is a live MarketXLS formula. These functions are the building blocks for any Excel-native earnings workflow, and they are the exact ones wired into the downloadable template.

=QM_Last("AMZN")                     // Current price
=PERatio("AMZN")                     // Trailing P/E
=DividendYield("AMZN")               // Trailing dividend yield (decimal)
=Beta("AMZN")                        // Stock beta vs market
=MarketCapitalization("AMZN")        // Market cap in USD
=Revenue("AMZN")                     // Trailing revenue
=EarningsPerShare("AMZN")            // Trailing EPS
=OperatingMargin("AMZN")             // Operating margin
=SimpleMovingAverage("AMZN", "50")   // 50-day SMA trend reference
=RelativeStrengthIndex("AMZN")       // RSI momentum
=FiftyTwoWeekHigh("AMZN")            // 52-week high
=FiftyTwoWeekLow("AMZN")             // 52-week low
=Sector("AMZN")                      // Sector classification

For a full deep-dive on these building blocks, the MarketXLS features page groups them by category. The point here is that nothing in the tracker is a lookup or a manual copy paste: every cell refers back to a MarketXLS function that refreshes on open or on manual recalculation.

The score formula that drives the watchlist

The Main Dashboard's composite Score blends six lenses. It is an educational framework, not an investment recommendation, so the weights below are a starting point to tune for your own preferences.

=ROUND(
  (1 - (PE / MAX(PE_range)))   * 20 +   // valuation: lower P/E scores higher
  (Yield / MAX(Yield_range))   * 15 +   // income: higher yield scores higher
  (OpMargin / MAX(OpMargin_range)) * 20 +  // quality: higher margin scores higher
  IF(Price > SMA50, 10, 0)     +        // trend: price above 50D SMA adds points
  (Price / High52)             * 20 +   // strength: closer to 52W high scores higher
  (1 - (Beta / MAX(Beta_range))) * 15,  // risk: lower beta scores higher
2)

The output is a 0 to 100 number that gives you a consistent way to rank the names against each other. The dashboard sheet uses conditional formatting to color the Score column from red to green, so the visual read is immediate.

Scenario analysis: five regimes for Q1 2026 consumer earnings

Rather than trying to pick a single macro outcome, the Scenario Analysis sheet maps five regimes with implied revenue and EPS moves and a watchlist bias.

Pairing the Score column with these scenarios is where the framework earns its keep. A high-Score name inside a Bear regime still needs to clear a higher bar than a high-Score name inside a Bull regime. Scenario-aware scoring helps avoid the trap of treating rank as destiny.

Walking the watchlist: what to watch in each Q1 2026 earnings print

The point of an earnings tracker is not to predict the number. It is to know which lines to read first when the release hits. Here is how the tracker frames each name going into the print.

Amazon (AMZN) - April 30

AMZN prints the day most market participants will have already priced in a base case. Watch the AWS revenue growth reacceleration, advertising revenue, and operating margin mix between AWS and North America retail. On the tracker, AMZN sits near the high end of the valuation range but also near the high end of the operating-trend range.

Tesla (TSLA) - April 23 (already reported)

TSLA printed earlier in the window and is the clearest example of how multiple, margin, and delivery guidance interact. The tracker's Score for TSLA is dragged down by a high P/E and high beta, and lifted by its position relative to the 50-day SMA. Post-print, the relative read to the rest of the group is what matters: if TSLA guidance weakens, the rotation into quality discretionary names intensifies.

Home Depot (HD) and Lowe's (LOW) - May 20 and 21

HD and LOW are the pair trade of the sector. Same end market, different mix: HD skews more Pro, LOW more DIY. Watch same-store sales, big-ticket (over a thousand dollars) transaction growth, and gross margin. The tracker shows both stocks trading in the low-20s P/E band, with HD carrying a slightly higher yield and comparable beta.

McDonald's (MCD) and Starbucks (SBUX) - April 29

MCD and SBUX both print on the same day and both read the value-seeking consumer. On MCD, US traffic vs value menu uptake and international comps matter most. On SBUX, the turnaround program and US same-store traffic are the key lines. The tracker flags MCD as the lowest-beta name in the group, which is consistent with how it often trades through soft consumer prints.

Nike (NKE) - June 25

NKE's next official print lands in June but the Q1 2026 calendar window includes investor day commentary and apparel peer reads in late April. Inventory health, direct-to-consumer mix, and China commentary are the lines to watch. The tracker keeps NKE as a core-tier candidate when beta is under 1.0 and operating margin is above 12%.

Booking (BKNG) - May 1

BKNG caps the window with a pure read on travel demand. Room nights booked, gross bookings growth, and take-rate stability are the three lines. The tracker shows BKNG as the highest priced stock in the group (denominator effect on the dashboard) but also the strongest on the percent-of-52W-high lens.

How to use the score to build a paper watchlist

The Portfolio Allocation sheet is where inputs meet output. Set your portfolio size in B4 on the Main Dashboard, your max position weight in B5, and the allocation sheet will proportionally size each name by its Score, capped at your max weight. Yield contribution and weighted beta update on the fly.

Two important notes on this step:

• The allocation is educational and is not an investment recommendation. It is a structured way to translate the Score into a hypothetical sizing framework so you can reason about concentration.
• Earnings date matters. You probably do not want to take a full-size position into a print. The Strategy / Positioning sheet includes a "Review Trigger" column that nudges you to re-score each name after its Q1 2026 earnings release.

A quick tour of the two downloadable templates

Download the templates:

• - Pre-filled with current data so you can see the finished layout
• - Live-updating MarketXLS formulas only

Both files use the same six-sheet structure and the same scoring logic. The sample file has a clear "Data as of 2026-04-24" stamp on the dashboard, and every sheet lists the MarketXLS functions used so you can recreate any column yourself. The template file is the workhorse: plug in your own tickers, resize the range, and let the MarketXLS add-in refresh the fundamentals.

Pair the tracker with the MarketXLS stock screener to move beyond this watchlist. The screener can surface other discretionary names that score similarly on the six lenses used above.

Educational framing and risk notes

Everything in this post is educational, not a stock recommendation. Consumer discretionary earnings are noisy. Prints beat or miss, guidance lands above or below consensus, and the market reaction can diverge from the fundamentals in the near term. The tracker is a way to reason about earnings season with structure, not a way to predict returns.

A few practical notes on using the tracker:

• Refresh before you analyze. Always hit "Refresh All" in the MarketXLS ribbon when the workbook opens so the dashboard reflects current data.
• Check the function list. Every sheet has a MarketXLS Functions Used box at the bottom. If a formula returns an error, the most common cause is a mistyped ticker or an expired session. In the latter case, sign out and back into the MarketXLS add-in.
• Tune the weights. The Score formula weights valuation, yield, quality, trend, strength, and beta at fixed weights. Change them to fit your own framework.
• Keep the watchlist small. Eight names is a good default for a Q1 2026 earnings tracker. Once you go past fifteen names the scoring noise starts to outweigh the signal.

Building your own variant

If you prefer to build this from scratch rather than edit the template, the core of the tracker is about fifteen formulas. Open a new Excel workbook, put a ticker in A2, and drop the following formulas in B2 across:

B2:  =QM_Last(A2)
C2:  =PERatio(A2)
D2:  =DividendYield(A2)
E2:  =Beta(A2)
F2:  =MarketCapitalization(A2)
G2:  =Revenue(A2)
H2:  =EarningsPerShare(A2)
I2:  =OperatingMargin(A2)
J2:  =SimpleMovingAverage(A2, "50")
K2:  =RelativeStrengthIndex(A2)
L2:  =FiftyTwoWeekHigh(A2)
M2:  =FiftyTwoWeekLow(A2)
N2:  =Sector(A2)

Copy the row down for each ticker, add a score column that blends a few of the lenses above, and you have a minimum-viable earnings tracker. The download provides a more complete version with scenario, strategy, portfolio, and correlation sheets wired in, plus conditional formatting and a "Data as of" stamp.

FAQ: Consumer Discretionary Earnings Tracker Excel

What is a consumer discretionary earnings tracker Excel file?

A consumer discretionary earnings tracker in Excel is a workbook that pulls live price, valuation, income, and fundamentals data for the biggest discretionary spending stocks so you can read Q1 2026 earnings in one place. With MarketXLS, every cell is a live formula like =QM_Last("AMZN") and =PERatio("HD") that refreshes on open.

Which stocks are in the Q1 2026 consumer discretionary watchlist?

The template ships with Amazon (AMZN), Tesla (TSLA), Home Depot (HD), Lowe's (LOW), McDonald's (MCD), Starbucks (SBUX), Nike (NKE), and Booking Holdings (BKNG). The list is editable, so you can swap in any ticker you cover and every downstream sheet recalculates automatically.

Do I need the MarketXLS add-in for the template to work?

Yes. The template file uses live MarketXLS formulas such as QM_Last, PERatio, DividendYield, Beta, OperatingMargin, SimpleMovingAverage, and RelativeStrengthIndex. Without the add-in installed and signed in, those cells will not refresh. If you want to see a pre-populated version first, start with the sample file, which has static values next to each formula reference.

How often do the MarketXLS formulas refresh?

MarketXLS formulas refresh when the workbook opens, when you click "Refresh All" in the MarketXLS ribbon, and when you trigger a recalculation on a specific cell. For streaming prices, look at functions such as Stream_Last. For snapshot reads during earnings, QM_Last is the standard.

Can I use the tracker for other sectors?

Yes. The structure is sector-agnostic. Every formula takes a ticker as the argument, so you can swap in industrials, healthcare, semiconductors, or any other group. Scoring weights may need tuning because what matters for a semiconductor name (for example inventory cycle, gross margin trend) differs from what matters for a discretionary name.

Is the score a buy or sell signal?

No. The score is an educational ranking that blends valuation, yield, quality, trend, strength, and beta into one number. It is a way to compare names inside the watchlist on a consistent basis. It is not a recommendation to buy or sell anything.

How do I change the weights in the score formula?

Open the Main Dashboard sheet, click on the Score cell in column Q, and edit the weights directly in the formula. The default weights are 20, 15, 20, 10, 20, and 15. Changing one weight automatically recalculates the entire column.

The bottom line

Consumer Discretionary Earnings Tracker Excel is the fastest way to read a packed Q1 2026 earnings window with structure instead of noise. Between April 29 and May 21, most of the biggest discretionary names in the US market are going to print, and each result rewrites the story for consumer spending, pricing power, and the rate path. Rather than reacting headline by headline, the MarketXLS tracker lets you compare every name on the same six lenses, pre-score the watchlist, map it against five macro regimes, and translate the output into a structured allocation framework you can reason about.

Start with the sample workbook to see the finished layout, then open the template version and plug in your own tickers or your own weights. All of the formulas are live MarketXLS functions. If you want to build more sophisticated models on top of this foundation, visit MarketXLS.com to explore the full function library, or book a demo to see how advisors use these formulas across earnings season.