Formulas
Last Price
Learn more →Returns the last traded price for any symbol
=Last("AAPL") |
=Last("^SPX") |
Ask Price
Learn more →Returns the current ask price for any symbol
=Ask("AAPL") |
=Ask("MSFT") |
Bid Price
Learn more →Returns the current bid price for any symbol
=Bid("AAPL") |
=Bid("MSFT") |
Open Price
Learn more →Get the opening price for a stock symbol
=Open("AAPL") |
=Open("AAPL") |
Previous Close
Learn more →Returns the previous trading day's closing price
=PreviousClose("AAPL") |
=PreviousClose("SPY") |
52-Week High
Learn more →Returns 52-week high price
=FiftyTwo_weekHigh("AAPL") |
52-Week Low
Learn more →Returns 52-week low price
=FiftyTwo_weekLow("AAPL") |
Beta
Learn more →Returns the beta coefficient measuring stock volatility vs market
=Beta("AAPL") |
=Beta("MSFT") |
Option Chain
Learn more →Returns the full option chain for an underlying stock
=QM_GetOptionChain("AAPL") |
=QM_GetOptionChain("SPY") |
Implied Volatility
Learn more →Returns the implied volatility for a stock
=ImpliedVolatility("AAPL") |
=ImpliedVolatility("TSLA") |
Revenue
Learn more →Returns total revenue
=Revenue("AAPL") |
=Revenue("MSFT") |
Book Value
Learn more →Returns the book value per share for a stock
=BookValue("AAPL") |
=BookValue("BRK-B") |
200-Day Moving Average
Learn more →Returns 200-day moving average
=TwoHundred_dayMovingAverage("AAPL") |
5-Year EPS Growth Rate
Learn more →Returns the consensus 5-year projected EPS growth rate from analyst estimates
=EPSGrowth5Y("AAPL") |
=EPSGrowth5Y("MSFT") |
50-Day Moving Average
Learn more →Returns 50-day moving average
=Fifty_dayMovingAverage("AAPL") |
52 Week Range
Learn more →Returns the 52-week price range as a formatted string
=FiftyTwo__weekRange("AAPL") |
=FiftyTwo__weekRange("MSFT") |
Accounts Receivable (Historical)
Learn more →Returns accounts receivable from historical balance sheets
=hf_Accounts_receivable("AAPL", 2023, 4) |
=hf_Accounts_receivable("MSFT", "ly", 2) |
Accrued Expenses (Historical)
Learn more →Returns accrued expenses from historical balance sheets
=hf_Accrued_expenses("AAPL", 2023, 4) |
Accrued Liabilities (Historical)
Learn more →Returns accrued liabilities from historical balance sheets
=hf_Accrued_liabilities("MSFT", 2023, 4) |
Accumulated Depreciation And Depletion (Historical)
Learn more →Returns accumulated depreciation and depletion
=hf_Accumulated_depreciation_and_depletion("AAPL", 2023, 4) |
=hf_Accumulated_depreciation_and_depletion("MSFT", "ly", 2) |
Accumulated Other Comprehensive Income (Historical)
Learn more →Returns historical accumulated other comprehensive income
=hf_Accumulated_Other_Comprehensive_Income("AAPL", 2023) |
=hf_Accumulated_Other_Comprehensive_Income("MSFT", 2023, 2) |
Accumulated Retained Earnings Deficit (Historical)
Learn more →Returns historical accumulated retained earnings or deficit
=hf_Accumulated_Retained_Earnings_Deficit("AAPL", 2023) |
=hf_Accumulated_Retained_Earnings_Deficit("MSFT", 2023, 2) |
Actual EPS
Learn more →Returns the actual reported earnings per share for the most recent quarter
=EPSActual("AAPL") |
=EPSActual("MSFT") |
Additional Paid In Capital (Historical)
Learn more →Returns additional paid-in capital from historical balance sheets
=hf_Additional_paid_in_capital("AAPL", 2023, 4) |
Adjustments to Revenue (Historical)
Learn more →Returns revenue adjustments
=hf_Adjustments_to_revenue("AAPL", 2023, 4) |
Advertising Expense (Historical)
Learn more →Returns advertising expense
=hf_Advertising("PG", 2023, 4) |
Altman Z Score
Learn more →Returns the Altman Z-Score for bankruptcy prediction
=AltmanZScore() |
=IF(AltmanZScore()>2.99,"Safe","Review") |
Amortization (Historical)
Learn more →Returns historical amortization expense
=hf_Amortization("AAPL", 2023) |
=hf_Amortization("MSFT", 2023, 2) |
Amortization of Intangibles (Historical)
Learn more →Returns intangibles amortization
=hf_Amortization_of_intangibles("IBM", 2023, 4) |
Analyst Consensus
Learn more →Returns the number of analysts providing estimates in the consensus
=AnalystConsensus("AAPL") |
=AnalystConsensus("MSFT") |
Ask Historical
Learn more →Returns the historical ask price for a symbol on a specific date
=Ask_Historical("AAPL", DATE(2024,1,15)) |
=Ask_Historical("MSFT", "2024-03-01") |
Ask Price (On Demand)
Learn more →Gets current ask (offer) price on-demand from QuoteMedia
=QM_Ask("AAPL") |
=QM_Ask("MSFT") |
Ask Size
Learn more →Returns the number of shares available at the ask price
=AskSize("AAPL") |
=AskSize("MSFT") |
Asset Turn Over Indicator (Historical)
Learn more →Returns asset turnover trend indicator
=hf_Asset_turn_over_indicator("AAPL", 2023) |
Asset Turnover (Historical)
Learn more →Returns historical asset turnover ratio
=hf_Asset_Turnover("AAPL", 2023) |
=hf_Asset_Turnover("WMT", 2023, 2) |
Assets Non Current (Historical)
Learn more →Returns historical non-current (long-term) assets
=hf_Assets_Non_Current("AAPL", 2023, 4) |
=hf_Assets_Non_Current("MSFT", "ly") |
Assets Turnover
Learn more →Returns the total assets turnover ratio
=AssetsTurnover("AAPL") |
=AssetsTurnover("MSFT") |
Auditor's Report (Historical)
Learn more →Returns the auditor's report type for a company's financial statements
=hf_Auditors_Report("AAPL", 2023) |
=hf_Auditors_Report("MSFT", 2023, 2) |
Auditors Name Aud Name And Aud Op (Historical)
Learn more →Returns the name of the auditing firm for a company's financial statements
=hf_Auditors_Name("AAPL", 2023) |
=hf_Auditors_Name("MSFT", 2023, 2) |
Average Assets (Historical)
Learn more →Returns historical average total assets for the period
=hf_Average_Assets("AAPL", 2023) |
=hf_Average_Assets("MSFT", 2023, 2) |
Average Daily Volume
Learn more →Returns the average daily trading volume for a stock
=AverageDailyVolume("AAPL") |
=AverageDailyVolume("MSFT") |
Average Equity (Historical)
Learn more →Returns the historical average equity for a company
=hf_Average_Equity("AAPL", 2023) |
=hf_Average_Equity("MSFT", 2023, 2) |
Average Hourly Earnings - Private
Learn more →Returns average hourly earnings for private sector employees
=HourlyEarnings() |
Average Price Between 2 Dates In History
Learn more →Returns the average price between two specific dates
=custom_dates_average("AAPL", DATE(2024,1,1), DATE(2024,3,31)) |
=custom_dates_average("AAPL", DATE(2024,1,1), DATE(2024,3,31), "close") |
Average True Range (ATR)
Learn more →Returns the Average True Range (ATR) volatility indicator
=AverageTrueRange("AAPL") |
=AverageTrueRange("AAPL", "14") |
Average Vol/OI Ratio
Learn more →Returns the average volume to open interest ratio over a specified number of days
=opt_Vol_OI_Avg("AAPL", 5) |
=opt_Vol_OI_Avg("MSFT", 10, "Call") |
Average Volume (Options)
Learn more →Returns the average options trading volume over a specified number of days
=opt_VolumeOptionsAverage("AAPL", 5) |
=opt_VolumeOptionsAverage("MSFT", 10, "Call") |
Average Volume 1 Year
Learn more →Returns 1-year average volume
=VolumeAverageOneYear("AAPL") |
Average Volume 15 Days
Learn more →Returns 15-day average volume
=VolumeAverageFifteenDays("AAPL") |
Average Volume 2 Years
Learn more →Returns 2-year average volume
=VolumeAverageTwoYears("AAPL") |