Inicio / Skills / Finanzas / Stock Analysis
Finanzas

Stock Analysis

AIBarsOriginalIdioma del Skill: Inglés
Licencia verificadaIncluye scriptsRequiere un servicio externo
DemostraciónEjecución real · claude-sonnet-5-5 · octubre de 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.

Qué hace
Analiza una acción cotizada que indiques. Un script incluido obtiene una instantánea actual de Yahoo Finance y el modelo redacta el análisis usando solo esos datos: no estima ni completa datos de memoria e indica qué campos faltan.

Cómo funciona

  1. Identifica el nombre de empresa o símbolo (primero con una tabla de empresas populares, después con una búsqueda en Yahoo; añade el sufijo adecuado a códigos de acciones A y de Hong Kong).
  2. Ejecuta el script para obtener el perfil de la empresa, valoración y datos financieros, evolución del precio, opiniones de analistas y titulares recientes.
  3. Redacta siete partes: instantánea, evolución del precio, fundamentales y valoración, opinión de analistas, noticias, riesgos que vigilar y una conclusión equilibrada.
  4. Termina cada respuesta con «Este es un resumen automatizado de datos públicos de mercado, no asesoramiento de inversión».

Para qué sirve
Una lectura rápida y estructurada de una acción que ya tienes en mente: evolución del precio, posible sobrevaloración, opinión de analistas y noticias.

Límites
Analiza una acción por ejecución y nunca recomienda acciones. No da instrucciones de compra, venta o mantenimiento ni predicciones de precio. Los datos de Yahoo pueden tener unos 15 minutos de retraso y a veces están incompletos; el script no incluye datos de empresas comparables, por lo que las comparaciones sectoriales son generales. De las noticias solo lee los titulares.

Notas y riesgos

Riesgo medio: incluye un script Python que consulta Yahoo Finance en modo de solo lectura (mediante yfinance y el RSS público de noticias de Yahoo). No escribe en disco ni lee archivos locales. No necesita cuenta, conexión a un bróker ni clave API, y nunca realiza operaciones bursátiles. Envía a Yahoo el nombre de empresa o símbolo que introduzcas. Debes permitir al agente ejecutar python3 e instalar yfinance (pip install yfinance). El resultado es un resumen automatizado de datos públicos de mercado, no asesoramiento de inversión. Los datos pueden tener retrasos, errores o carencias.

SKILL.md original4 archivos en este paquete