Formulas
1284 formulasOpen Price
Learn more →The price at which stocks first trade upon opening of the stock market (9:30 AM EST).
Previous Close
Learn more →Returns the previous trading day's closing price
=PreviousClose("AAPL") |
=PreviousClose("SPY") |
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") |
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") |
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) |
Returns accumulated depreciation and depletion
=hf_Accumulated_depreciation_and_depletion("AAPL", 2023, 4) |
=hf_Accumulated_depreciation_and_depletion("MSFT", "ly", 2) |
Returns historical accumulated other comprehensive income
=hf_Accumulated_Other_Comprehensive_Income("AAPL", 2023) |
=hf_Accumulated_Other_Comprehensive_Income("MSFT", 2023, 2) |
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") |
Add Symbols
Learn more →return the list of added symbols
Additional Paid In Capital (Historical)
Learn more →Returns additional paid-in capital from historical balance sheets
=hf_Additional_paid_in_capital("AAPL", 2023, 4) |
Adjusted Close (Month End)
Learn more →Returns the split/dividend adjusted closing price on the last trading day of a specified month
=Adjusted_Close_MonthEnd("AAPL", 2025, 6) |
=Adjusted_Close_MonthEnd("MSFT", 2025, 12) |
Adjusted Close (Quarter End)
Learn more →Returns the split/dividend adjusted closing price on the last trading day of a specified quarter
=Adjusted_Close_QuarterEnd("AAPL", 2025, 4) |
=Adjusted_Close_QuarterEnd("MSFT", 2024, 2) |
Adjusted Close (Year End)
Learn more →Returns the split/dividend adjusted closing price on the last trading day of a specified year
=Adjusted_Close_YearEnd("AAPL", 2024) |
=Adjusted_Close_YearEnd("MSFT", 2023) |
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) |
AIPortfolio Optimize
Learn more →A message indicating the result of the operation or an error message.
AIPortfolio Predict Returns
Learn more →A message indicating the result or an error message.
American Option Value
Learn more →Option price or error message
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) |