Home / Skills / Finance / Stock Analysis
Finance

Stock Analysis

AIBarsOriginalSkill language: English
License verifiedIncludes scriptsNeeds external service
DemoReal run · claude-sonnet-5-5 · October 2026
Use the stock-analysis skill to analyze Google (Alphabet). I'd like to know how the price has been moving recently and whether the valuation looks stretched.
Skill: stock-analysis

Analyzing GOOGL – Alphabet Inc. (Nasdaq, USD)

1. Snapshot

Last close was $341.80 on 2026-10-20. Market cap is about $4.18T. The sector is Communication Services (Internet Content & Information).

2. Price action (90 days)

  • Trend: The price is roughly flat to slightly down, at -4.91% since 2026-06-12 ($359.45). It is down 2.67% over 20 sessions and 3.39% over the last 5.
  • Range: The window high was $377.41 (Aug 4) and the low was $317.49 (Jul 23). The price is about 9% below the high and about 8% above the low.
  • Moving averages: The price sits just under the 20-day average ($345.41, -1.0%) and the 50-day average ($343.98, -0.6%). That is a sideways, consolidating pattern.
  • 52-week range: $244.15 to $408.61. The price is about 16% below the high and about 40% above the low, so it is well off its peak after a big run.
  • Volume: The last session had 6.2M shares against a 28.3M average. That is light, though the data may be partial for the day.

3. Fundamentals and valuation

Strong

  • Revenue is $445.9B (TTM), growing 24.2%.
  • Operating margin is 34.0% and gross margin is 60.9%.
  • ROE is 48.7%.
  • Leverage is moderate (Debt/Equity 18.86).

Valuation

  • Trailing P/E is 17.15 and forward P/E is 22.27. Neither looks stretched for a company growing this fast, though I have no peer data to compare against.
  • The forward P/E is higher than the trailing one. That means analysts expect EPS to fall next year.
  • The reason is probably that the 54.8% net margin is inflated by one-off gains, such as investment marks. A net margin that far above the 34% operating margin is a flag. Trailing EPS of $19.93 may overstate the underlying earnings power, so the 17x trailing figure looks cheaper than it really is. The data doesn't confirm the cause.
  • P/B is 6.72, which is high in absolute terms. That is normal for an asset-light, high-ROE business.
  • Free cash flow is only $22.7B, about 5% of revenue and very low against the earnings. That points to heavy capital spending, which the news also hints at (AI spending). On a market cap of $4.18T, the FCF yield is about 0.5%.
  • Dividend yield is 0.26%. Beta is 1.21, so the stock is somewhat more volatile than the market.

Verdict on "stretched": Earnings multiples look moderate, not stretched. The thin free cash flow relative to the $4.18T market cap is the stretched part. The valuation depends on the AI investment turning into much higher cash generation.

4. Analyst view

  • Consensus is strong buy from 54 analysts: 13 strong buy, 43 buy, 5 hold, 0 sell, 0 strong sell.
  • The mean target is $430.05, about 25.8% above the current price. The low target is $340.00, essentially at the current price (-0.5%). The high target is $515.00 (+50.7%).
  • Ratings are nearly unanimous. That tends to mean good news is already widely expected.

5. News

All headlines are from Oct 20 (via Yahoo RSS, so I have read titles only).

  • Relevant: "Alphabet's Cloud Growth, TPU Sales Could Drive Q3 Upside, BofA Says" suggests earnings expectations are positive.
  • Relevant: "Google Says Services Are Recovering After U.K. Cloud Outage Hits Businesses" is an operational issue.
  • Relevant: "Microsoft, Alphabet Bar Their Tokenized Shares From OKX-ICE Venue…" is a niche item.
  • Market-wide: "The $1 Trillion AI Spending Boom Could Force the Fed to Raise Rates…" is about macro and rates, not Alphabet specifically.
  • The other items (Citigroup, Bitcoin, Amazon, Ultima Genomics) are unrelated or only loosely related.

6. Risks and what to watch

  1. Q3 earnings: Expectations look high. Watch cloud growth and TPU sales, and whether the guidance for 2027 EPS explains the higher forward P/E.
  2. Capex versus free cash flow: A 0.5% FCF yield leaves little room if AI returns disappoint.
  3. Earnings quality: Check how much of the 54.8% net margin comes from non-operating gains.
  4. Rates: The AI spending and rate-hike headline is a reminder that higher rates hit long-duration, high-multiple stocks.
  5. Technicals: The $317 to $320 area (the July low) is the nearest support in the data, and the 50-day average ($344) is the nearest resistance. The stock sits right on it.

7. Bottom line

Alphabet has strong growth, margins and returns. Over the past three months the price has drifted sideways to lower while it consolidates below its highs. On earnings multiples the valuation looks reasonable, not stretched. The stretch shows up in cash flow terms, and trailing earnings are likely flattered by non-operating items. Analyst sentiment is very bullish, which also means expectations are high.

Yahoo data can be delayed about 15 minutes and is sometimes incomplete. The earnings-quality point above is my inference from the margin gap and the forward P/E.

This is an automated summary of public market data, not investment advice.

Real run with Claude Code. Only the Skill, Read and one allowed command (python3 scripts/fetch.py) were enabled. The script pulled live Yahoo Finance data for GOOGL, so the numbers are a snapshot of that moment and will differ when you run it. Output is shown verbatim, including the model's own inferences, which it marks as inferences. Run once on a single US stock; other markets were not tested in this run.

What it does
Analyzes one listed stock you name. A bundled script fetches a live snapshot from Yahoo Finance, then the model writes the analysis from that data only: nothing is estimated or filled in from memory, and missing fields are reported as missing.

How it works

  1. Resolves your company name or ticker (a built-in table of popular companies first, then a Yahoo search; bare A-share and HK codes get the right suffix).
  2. Runs the script to get the company profile, valuation and financials, price action, analyst ratings and recent headlines.
  3. Writes seven parts: snapshot, price action, fundamentals and valuation, analyst view, news, risks to watch, and a balanced bottom line.
  4. Ends every answer with "This is an automated summary of public market data, not investment advice."

Good for
A quick, structured read on a stock you already have in mind: how the price has moved, whether the valuation looks stretched, what analysts think and what the news says.

Limits
It analyzes one stock per run and never recommends stocks. It gives no buy, sell or hold instruction and no price predictions. Yahoo data can be delayed about 15 minutes and is sometimes incomplete; the script has no peer data, so sector comparisons stay general. News is read by headline only.

Notes & risks

Medium risk: includes one Python script that makes read-only requests to Yahoo Finance (via the yfinance library, plus Yahoo's public RSS feed for news). It writes nothing to disk, reads no local files and needs no account, broker connection or API key, and it never places trades. The company name or ticker you type is sent to Yahoo. You need to let your agent run python3 and install yfinance (pip install yfinance). Output is an automated summary of public market data and is not investment advice. Data may be delayed, wrong or incomplete.

SKILL.md original4 files in this package