Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

MarketXLS Formulas

Explore our market data and analysis functions
Already a customer?
AI AssistantGet XLSolve AI to help on formulas
Login to Access
Categories
Source
1257 formulas found

200 Day Moving Average

Returns the 200-day moving average.

=TwoHundred_dayMovingAverage("MSFT")
ID: fn_00538

50 Day Moving Average

Returns the 50-day moving average.

=Fifty_dayMovingAverage("MSFT")
ID: fn_00537

52 Week High

Returns the highest price of a security over a one-year period.

=tos52WeekHigh("MSFT")
ID: fn_00630

52 Week Low

Returns the lowest price of a security over a one-year period.

=tos52WeekLow("MSFT")
ID: fn_00631

52 Week Range

Returns the 52-week price range

=FiftyTwo__weekRange("MSFT")
ID: fn_00543

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)
ID: fn_00341

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)
ID: fn_00367

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)
ID: fn_00368

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)
ID: fn_00360

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)
ID: fn_00226

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)
ID: fn_00222

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)
ID: fn_00379

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)
ID: fn_00296

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)
ID: fn_00298

Altman Z Score

Returns a numerical score that assesses the likelihood of bankruptcy for a company, primarily in the manufacturing sector.

=AltmanZScore("MSFT")
ID: fn_01322

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)
ID: fn_00301

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)
ID: fn_00392

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)
ID: fn_00302

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)
ID: fn_00393

Angel One Buy Quantity

Returns the real-time buy qunatity

=AngelOneBuyQuantity("TCS:IN")
ID: fn_01533

Angel One High

Returns the real-time high price for the day

=AngelOneHigh("TCS:IN")
ID: fn_01537

Angel One Last

Returns the real-time last price

=AngelOneLast("TCS:IN")
ID: fn_01532

Angel One Low

Returns the real-time low price for the day

=AngelOneLow("TCS:IN")
ID: fn_01538

Angel One Open

Returns the open price

=AngelOneOpen("TCS:IN")
ID: fn_01536

Angel One Previous Close

Returns the previous close

=AngelOnePrevious Close("TCS:IN")
ID: fn_01539

Angel One Sell Quantity

Returns the real-time sell quantity

=AngelOneSellQuantity("TCS:IN")
ID: fn_01534

Angel One Volume

Returns the real-time volume

=AngelOneVolume("TCS:IN")
ID: fn_01535

Angelone Get History

=angelone_gethistory()
ID: fn_01833

Ask (On Demand)

Returns the ask price at which a shareholder is willing to sell a security.

=QM_ask("MSFT")
ID: fn_00051

Ask Historical

Returns the historical ask price

=ask_historical()
ID: fn_01604

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")
ID: fn_00001

Ask price

Returns the price a seller is willing to accept for a security.

=tosAskPrice("MSFT")
ID: fn_00615

Ask price

Returns the price a seller is willing to accept for a security.

=ibAskPrice("MSFT")
ID: fn_00654

Ask Price

Returns the price a seller is willing to accept for a security.

=rt_ask("MSFT")
ID: fn_01173

Ask Size

Returns the quantity of a security that a market maker is offering to sell at the ask price.

=AskSize("MSFT")
ID: fn_00067

Ask size

Returns the quantity of a security a market maker is offering to sell at the ask price.

=tosAskSize("MSFT")
ID: fn_00616

Ask size

Returns the quantity of a security a market maker is offering to sell at the ask price.

=ibAskSize("MSFT")
ID: fn_00655

Ask Size

Returns the quantity of a security a market maker is willing to sell at the ask price.

=rt_askSize("MSFT")
ID: fn_01174

Ask Size (Refresh on Demand)

Returns the quantity a market maker is willing to sell at the ask price.

=qm_AskSize("MSFT")
ID: fn_00964

AskX

Returns the ask price and the exchange publishing that price.

=tosAskX("MSFT")
ID: fn_00618

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)
ID: fn_00494

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)
ID: fn_00227

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)
ID: fn_00208

Assets Turnover

Returns the ratio of the company's total sales to its average total assets.

=AssetsTurnover("MSFT")
ID: fn_00159

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)
ID: fn_00424

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)
ID: fn_00425

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)
ID: fn_01295

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)
ID: fn_01292

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)
ID: fn_00228

Average Daily Volume

Returns the average trading volume of the stock over a specified period.

=AverageDailyVolume("MSFT")
ID: fn_00100