MarketXLS Formulas
200 Day Moving Average
Returns the 200-day moving average.
=TwoHundred_dayMovingAverage("MSFT") |
50 Day Moving Average
Returns the 50-day moving average.
=Fifty_dayMovingAverage("MSFT") |
52 Week High
Returns the highest price of a security over a one-year period.
=tos52WeekHigh("MSFT") |
52 Week Low
Returns the lowest price of a security over a one-year period.
=tos52WeekLow("MSFT") |
52 Week Range
Returns the 52-week price range
=FiftyTwo__weekRange("MSFT") |
Accounts Receivable (Historical)
Returns the amount of money due to a company in the short-term, represented as an asset account on the balance sheet. This function is referred to as Accounts Receivable (Historical).
=hf_Accounts_receivable("MSFT",2022) |
=hf_Accounts_receivable("MSFT",2022,2) |
Accrued Expenses (Historical)
Returns the incurred but unpaid expenses recognized within a specific accounting period.
=hf_Accrued_expenses("MSFT",2022) |
=hf_Accrued_expenses("MSFT",2022,2) |
Accrued Liabilities (Historical)
Returns the amount of expenses that a business has incurred but not yet paid, also known as Accrued Liabilities (Historical).
=hf_Accrued_liabilities("MSFT",2022) |
=hf_Accrued_liabilities("MSFT",2022,2) |
Accumulated Depreciation And Depletion (Historical)
Returns the cumulative depreciation and depletion expense incurred by an asset up to a specific point in its life.
=hf_Accumulated_depreciation_and_depletion("MSFT",2022) |
=hf_Accumulated_depreciation_and_depletion("MSFT",2022,2) |
Accumulated Other Comprehensive Income (Historical)
Returns the total unrealized gains and losses on investments, pension plans, and hedging transactions that are netted below retained earnings in the equity section of the balance sheet.
=hf_Accumulated_Other_Comprehensive_Income("MSFT",2022) |
=hf_Accumulated_Other_Comprehensive_Income("MSFT",2022,2) |
Accumulated Retained Earnings Deficit (Historical)
Returns the accumulated retained earnings deficit (historical), which represents the negative balance that occurs when cumulative losses exceed cumulative profits in a corporation's retained earnings account. This reflects a situation where the entity has sustained more losses than profits over time, indicating financial challenges.
=hf_Accumulated_Retained_Earnings_Deficit("MSFT",2022) |
=hf_Accumulated_Retained_Earnings_Deficit("MSFT",2022,2) |
Additional Paid In Capital (Historical)
Returns the amount of money an investor has paid above the par value price of a stock, known as Additional Paid-In Capital (Historical).
=hf_Additional_paid_in_capital("MSFT",2022) |
=hf_Additional_paid_in_capital("MSFT",2022,2) |
Adjustments To Revenue (Historical)
Returns the Company's revenue for a specific Performance Period based on the Company's standard practices and procedures as documented in its financial statements.
=hf_Adjustments_to_revenue("MSFT",2022) |
=hf_Adjustments_to_revenue("MSFT",2022,2) |
Advertising (Historical)
Returns the amount of expense incurred for advertising, sales, and marketing captured by the Advertising (Historical) function.
=hf_Advertising("MSFT",2022) |
=hf_Advertising("MSFT",2022,2) |
Altman Z Score
Returns a numerical score that assesses the likelihood of bankruptcy for a company, primarily in the manufacturing sector.
=AltmanZScore("MSFT") |
Amortization (Historical)
Returns the gradual reduction of the initial cost of an asset over time, typically calculated through scheduled payments or depreciation methods.
=hf_Amortization("MSFT",2022) |
=hf_Amortization("MSFT",2022,2) |
Amortization (Historical)
Returns the average number of shares issued and actively held by stockholders from the beginning of the year.
=hf_Amortization("MSFT",2022) |
=hf_Amortization("MSFT",2022,2) |
Amortization Of Intangibles (Historical)
Returns the calculation of expensing the cost of an intangible asset over the projected life of the asset for tax or accounting purposes.
=hf_Amortization_of_intangibles("MSFT",2022) |
=hf_Amortization_of_intangibles("MSFT",2022,2) |
Amortization of intangibles (Historical)
Returns the average number of shares issued and actively held by stockholders from the beginning of the year, factoring in all convertible securities.
=hf_Amortization_of_intangibles("MSFT",2022) |
=hf_Amortization_of_intangibles("MSFT",2022,2) |
Angel One Buy Quantity
Returns the real-time buy qunatity
=AngelOneBuyQuantity("TCS:IN") |
Angel One High
Returns the real-time high price for the day
=AngelOneHigh("TCS:IN") |
Angel One Last
Returns the real-time last price
=AngelOneLast("TCS:IN") |
Angel One Low
Returns the real-time low price for the day
=AngelOneLow("TCS:IN") |
Angel One Open
Returns the open price
=AngelOneOpen("TCS:IN") |
Angel One Previous Close
Returns the previous close
=AngelOnePrevious Close("TCS:IN") |
Angel One Sell Quantity
Returns the real-time sell quantity
=AngelOneSellQuantity("TCS:IN") |
Angel One Volume
Returns the real-time volume
=AngelOneVolume("TCS:IN") |
Angelone Get History
=angelone_gethistory() |
Ask (On Demand)
Returns the ask price at which a shareholder is willing to sell a security.
=QM_ask("MSFT") |
Ask Historical
Returns the historical ask price
=ask_historical() |
Ask Price
Returns the lowest price at which a dealer is willing to sell a specified number of shares for US and Canadian stocks, ETFs, and options or contracts.
=ask("MSFT") |
Ask price
Returns the price a seller is willing to accept for a security.
=tosAskPrice("MSFT") |
Ask price
Returns the price a seller is willing to accept for a security.
=ibAskPrice("MSFT") |
Ask Price
Returns the price a seller is willing to accept for a security.
=rt_ask("MSFT") |
Ask Size
Returns the quantity of a security that a market maker is offering to sell at the ask price.
=AskSize("MSFT") |
Ask size
Returns the quantity of a security a market maker is offering to sell at the ask price.
=tosAskSize("MSFT") |
Ask size
Returns the quantity of a security a market maker is offering to sell at the ask price.
=ibAskSize("MSFT") |
Ask Size
Returns the quantity of a security a market maker is willing to sell at the ask price.
=rt_askSize("MSFT") |
Ask Size (Refresh on Demand)
Returns the quantity a market maker is willing to sell at the ask price.
=qm_AskSize("MSFT") |
AskX
Returns the ask price and the exchange publishing that price.
=tosAskX("MSFT") |
Asset turn over indicator (Historical)
Returns the asset turnover indicator (historical) which calculates changes in asset turnover and predicts its direction.
=hf_Asset_turn_over_indicator("MSFT",2022) |
=hf_Asset_turn_over_indicator("MSFT",2022,2) |
Asset Turnover (Historical)
Returns the asset turnover ratio, which quantifies how effectively a company generates revenue in relation to its assets. Higher ratios denote greater efficiency in revenue generation from assets, while lower ratios suggest inefficiency in asset utilization for sales generation.
=hf_Asset_Turnover("MSFT",2022) |
=hf_Asset_Turnover("MSFT",2022,2) |
Assets Non Current (Historical)
Returns information about a company's long-term investments that won't fully realize their value within the current accounting year. Noncurrent assets are typically highly illiquid, meaning they are not easily converted into cash.
=hf_Assets_Non_Current("MSFT",2022) |
=hf_Assets_Non_Current("MSFT",2022,2) |
Assets Turnover
Returns the ratio of the company's total sales to its average total assets.
=AssetsTurnover("MSFT") |
Auditor's name aud. name and aud. op. (Historical)
Returns details about the specified company's auditor's name and operation in a historical context.
=hf_Auditor's_name_aud._name_and_aud._op.("MSFT",2022) |
=hf_Auditor's_name_aud._name_and_aud._op.("MSFT",2022,2) |
Auditor's Report aud. name and aud. op. (Historical)
Returns the auditor's report for the company, specifically related to the auditor's name and opinion on historical data.
=hf_Auditor's_Report_aud._name_and_aud._op.("MSFT",2022) |
=hf_Auditor's_Report_aud._name_and_aud._op.("MSFT",2022,2) |
Auditors Name Aud Name And Aud Op (Historical)
Returns the name of the auditor and their opinion regarding historical data.
=hf_Auditors_Name_Aud_name_And_Aud_op("MSFT",2022) |
=hf_Auditors_Name_Aud_name_And_Aud_op("MSFT",2022,2) |
Auditors Report Aud Name And Aud Op (Historical)
Returns the name and opinion of the auditor in the historical auditor's report.
=hf_Auditors_Report_Aud_Name_and_Aud_Op("MSFT",2022) |
=hf_Auditors_Report_Aud_Name_and_Aud_Op("MSFT",2022,2) |
Average Assets (Historical)
Returns the average total assets calculated based on the assets recorded on a company's balance sheet at the end of the current year and the preceding year. This metric is commonly used to assess the efficiency of asset utilization in supporting sales, where a lower asset level relative to sales suggests effective asset management by the company's team.
=hf_Average_Assets("MSFT",2022) |
=hf_Average_Assets("MSFT",2022,2) |
Average Daily Volume
Returns the average trading volume of the stock over a specified period.
=AverageDailyVolume("MSFT") |
- Previous 1/26
- Next