SendTopBookPrice_T function MPF

Publish a bid price and an offer (“ask”) price for a particular instrument, using fractional price notation.

Syntax

=SendTopBookPrice_T(Security Identifier, Fractional Bid, Fractional Offer)

Arguments

Security Identifier
A cell reference that refers to a cell containing a valid identifier ("ID") of an identifier type ("ID Type") recognized by Bloomberg. The identifier types recognized by Bloomberg are listed in "Table 7 – Identifier Types" in the Multi Product Feed Specification.
Fractional Bid
A cell reference that refers to a cell containing a bid price expressed in the fractional price notation that is conventional in the U.S. government bond market, with a hyphen separating the handle from the fractional value.
Fractional Offer
A cell reference that refers to a cell containing an offer ("ask") price expressed in the fractional price notation that is conventional in the U.S. government bond market, with a hyphen separating the handle from the fractional value.

Return Values

Successful
Data successfully sent by RocketSheet, upon initialization or most recent data update, to MPF Gateway for forwarding to Bloomberg. Per the MPF protocol, data may be in queue at MPF Gateway, awaiting acknowledgement of prior messages by the Bloomberg MPF parser.
Connection Failure
Data submission is prevented by a connectivity outage. This outage may be (i) between RocketSheet and MPF Gateway, (ii) between MPF Gateway and Bloomberg, or (iii) both between RocketSheet and MPF Gateway and between MPF Gateway and Bloomberg.
Not Contributing
The user has disabled data contribution in his Dashboard. Data will not be contributed to Bloomberg.
Unknown Instrument
The user has attempted to contribute data for an instrument not configured by the system administrator in the MPF Server's instruments file ("Instruments.csv"). Contact the system administrator to request configuration of the instrument.
Unhandled Function
This version of RocketSheet provides no support for this function.