Skip to main content

QUOTE

Get the latest quote for a given stock. Quote includes price, volume, and other data.

Syntax

=OBB.EQUITY.PRICE.QUOTE(symbol)

Examples

=OBB.EQUITY.PRICE.QUOTE("AAPL")

Parameters

NameTypeDescriptionRequired
symbolTextSymbol to get data for. Multiple comma separated items allowed.True

Data

NameDescription
symbolSymbol representing the entity requested in the data.
asset_typeType of asset - i.e, stock, ETF, etc.
nameName of the company or asset.
exchangeThe name or symbol of the venue where the data is from.
bidPrice of the top bid order.
bid_sizeThis represents the number of round lot orders at the given price. The normal round lot size is 100 shares. A size of 2 means there are 200 shares available at the given price.
bid_exchangeThe specific trading venue where the purchase order was placed.
askPrice of the top ask order.
ask_sizeThis represents the number of round lot orders at the given price. The normal round lot size is 100 shares. A size of 2 means there are 200 shares available at the given price.
ask_exchangeThe specific trading venue where the sale order was placed.
quote_conditionsConditions or condition codes applicable to the quote.
quote_indicatorsIndicators or indicator codes applicable to the participant quote related to the price bands for the issue, or the affect the quote has on the NBBO.
sales_conditionsConditions or condition codes applicable to the sale.
sequence_numberThe sequence number represents the sequence in which message events happened. These are increasing and unique per ticker symbol, but will not always be sequential (e.g., 1, 2, 6, 9, 10, 11).
market_centerThe ID of the UTP participant that originated the message.
participant_timestampTimestamp for when the quote was generated by the exchange.
trf_timestampTimestamp for when the TRF (Trade Reporting Facility) received the message.
sip_timestampTimestamp for when the SIP (Security Information Processor) received the message from the exchange.
last_pricePrice of the last trade.
last_tickWhether the last sale was an up or down tick.
last_sizeSize of the last trade.
last_timestampDate and Time when the last price was recorded.
openThe open price.
highThe high price.
lowThe low price.
closeThe close price.
volumeThe trading volume.
exchange_volumeVolume of shares exchanged during the trading day on the specific exchange.
prev_closeThe previous close price.
changeChange in price from previous close.
change_percentChange in price as a normalized percentage.
year_highThe one year high (52W High).
year_lowThe one year low (52W Low).
price_avg_5050 day moving average price.
price_avg_200200 day moving average price.
avg_volumeAverage volume over the last 10 trading days.
market_capMarket cap of the company.
shares_outstandingNumber of shares outstanding.
epsEarnings per share.
pePrice earnings ratio.
earnings_announcementUpcoming earnings announcement date.