Find a MarketXLS formula

Returns the last traded price for any symbol

Returns the current ask price for any symbol

Returns the current bid price for any symbol

The price at which stocks first trade upon opening of the stock market (9:30 AM EST).

Get the opening price for a stock symbol

Returns the previous trading day's closing price

Returns 52-week high price

Returns 52-week low price

Returns the beta coefficient measuring stock volatility vs market

Returns the full option chain for an underlying stock

Returns the implied volatility for a stock

Returns total revenue

Returns the book value per share for a stock

Returns 200-day moving average

Returns the consensus 5-year projected EPS growth rate from analyst estimates

Returns 50-day moving average

Returns the 52-week price range as a formatted string

Returns accounts receivable from historical balance sheets

Returns accrued expenses from historical balance sheets

Returns accrued liabilities from historical balance sheets

Returns accumulated depreciation and depletion

Returns historical accumulated other comprehensive income

Returns historical accumulated retained earnings or deficit

Returns the actual reported earnings per share for the most recent quarter

return the list of added symbols

Returns additional paid-in capital from historical balance sheets

Returns the split/dividend adjusted closing price on the last trading day of a specified month

Returns the split/dividend adjusted closing price on the last trading day of a specified quarter

Returns the split/dividend adjusted closing price on the last trading day of a specified year

Returns revenue adjustments

Returns advertising expense

A message indicating the result of the operation or an error message.

A message indicating the result or an error message.

Returns the Altman Z-Score for bankruptcy prediction

Option price or error message

Returns historical amortization expense

Returns intangibles amortization

Returns the number of analysts providing estimates in the consensus

Returns the historical ask price for a symbol on a specific date

Gets current ask (offer) price on-demand from QuoteMedia

Returns the number of shares available at the ask price

Returns asset turnover trend indicator

Returns historical asset turnover ratio

Returns historical non-current (long-term) assets

Returns the total assets turnover ratio

Returns the auditor's report type for a company's financial statements

Returns the name of the auditing firm for a company's financial statements

Returns historical average total assets for the period

Returns the average daily trading volume for a stock

Returns the historical average equity for a company