MarketXLS Formulas

Returns the 200-day moving average.

The EPSGrowth5Y function returns the consensus analyst forecast for the company's earnings per share (EPS) growth rate over the next 5 years. This long-term growth rate is a key valuation metric used in models like the PEG ratio. It represents analysts' expectations for the company's earnings growth trajectory.

Returns the 50-day moving average.

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

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

Returns the 52-week price range

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).

Returns the incurred but unpaid expenses recognized within a specific accounting period.

Returns the amount of expenses that a business has incurred but not yet paid, also known as Accrued Liabilities (Historical).

Returns the cumulative depreciation and depletion expense incurred by an asset up to a specific point in its life.

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.

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.

The EPSActual function returns the actual earnings per share (EPS) that was reported by the company for the most recent completed quarter. This is the realized earnings figure that can be compared against analyst estimates to determine earnings surprises. You can optionally retrieve the reporting date by setting ReturnType to 'date'.

Returns the amount of money an investor has paid above the par value price of a stock, known as Additional Paid-In Capital (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.

Returns the amount of expense incurred for advertising, sales, and marketing captured by the Advertising (Historical) function.

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

Returns the gradual reduction of the initial cost of an asset over time, typically calculated through scheduled payments or depreciation methods.

Returns the average number of shares issued and actively held by stockholders from the beginning of the year.

Returns the calculation of expensing the cost of an intangible asset over the projected life of the asset for tax or accounting purposes.

Returns the average number of shares issued and actively held by stockholders from the beginning of the year, factoring in all convertible securities.

The AnalystConsensus function returns the total number of financial analysts who are currently providing earnings estimates for a given stock. This consensus number is important as it indicates the level of analyst coverage and can provide confidence in the reliability of consensus estimates. A higher number of analysts typically means more reliable consensus estimates.

Returns the real-time buy qunatity

Returns the real-time high price for the day

Returns the real-time last price

Returns the real-time low price for the day

Returns the open price

Returns the previous close

Returns the real-time sell quantity

Returns the real-time volume

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

Returns the 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.

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

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

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

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

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

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

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

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

Returns the ask price and the exchange publishing that price.

Returns the asset turnover indicator (historical) which calculates changes in asset turnover and predicts its direction.

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.

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.

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

Returns details about the specified company's auditor's name and operation in a historical context.

Returns the auditor's report for the company, specifically related to the auditor's name and opinion on historical data.

Returns the name of the auditor and their opinion regarding historical data.