首页 / Skills / 金融与财务 / 股票分析 Stock Analysis
金融与财务

股票分析 Stock Analysis

AIBars原创Skill 语言: 英文
协议已核对含脚本依赖外部服务
演示真实运行记录 · claude-sonnet-5-5 · 2026年10月
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.

它做什么
分析你指定的一只上市股票。内置脚本会从 Yahoo Finance 实时取一份数据快照,模型只依据这份数据写分析:不估算、不凭记忆补数,缺失的字段会如实写成缺失。

工作方式

  1. 解析公司名或股票代码(先查内置的热门公司表,再走 Yahoo 搜索;A 股、港股的纯数字代码会自动补上正确后缀)。
  2. 运行脚本,取得公司概况、估值与财务、价格走势、分析师评级和最近新闻标题。
  3. 按七个部分输出:概览、价格走势、基本面与估值、分析师观点、新闻、风险与关注点、平衡的结论。
  4. 每次回答的结尾都带上:“This is an automated summary of public market data, not investment advice.”

适合什么场景
对一只你已经有想法的股票,快速得到结构化的了解:价格最近怎么走、估值是否偏高、分析师怎么看、新闻在说什么。

限制
一次只分析一只股票,不会替你推荐股票;不给买入、卖出或持有的指令,也不预测价格。Yahoo 数据可能有约 15 分钟延迟,偶尔不完整;脚本没有同行数据,所以行业对比只能是笼统的说法;新闻只读标题。

说明与风险

中风险:包含 1 个 Python 脚本,会向 Yahoo Finance 发起只读请求(通过 yfinance 库,新闻部分另用 Yahoo 公开的 RSS)。它不写磁盘、不读本机文件,不需要账号、券商连接或 API 密钥,也不会下单交易。你输入的公司名或股票代码会发送给 Yahoo。需要允许代理运行 python3,并安装 yfinance(pip install yfinance)。输出是对公开市场数据的自动摘要,不构成投资建议;数据可能延迟、有误或不完整。

SKILL.md 原文包内共 4 个文件