STRASMORE/EXPLORE 3,293 QUERIES

valuation_trend

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-10-24, from msft-stock-price-analysis.

as of scalar 1×4read in context →
last reading
2026/10/22
pe trailing
28.9
ps ratio
11.7
ev ebitda
19.6
Rows × columns
1 × 4
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for valuation_trend, derived from the stored result.
ColumnTypeRangeNotes
last_reading text 1 distinct value (2026/10/22)
pe_trailing number every row is 28.9
ps_ratio number every row is 11.7 ratio or rate
ev_ebitda number every row is 19.6

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    formatDateTime(date, '%Y/%m/%d')              AS last_reading,
    round(toFloat64(price_to_earnings), 1)        AS pe_trailing,
    round(toFloat64(price_to_sales), 1)           AS ps_ratio,
    round(toFloat64(ev_to_ebitda), 1)             AS ev_ebitda
FROM global_markets.stocks_ratios
WHERE ticker = 'MSFT'
  AND date >= today() - 400
  AND date < today()
  AND price_to_earnings > 0
ORDER BY date DESC
LIMIT 1
⌘/Ctrl + Enter

在你的 AI 助理中使用這些資料

開啟即可查詢，已帶入本頁資料。免費，無需帳號。

Claude ChatGPT Gemini Muse 你自己的代理