SendTopBook function MPF

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

Syntax

=SendTopBook(Security Identifier, Bid, Bid Size, Offer, Offer Size)

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.
Bid
A cell reference that refers to a cell containing a bid price represented in decimal form, with a period as a digit separator for non-integer values.
Bid Size
A cell reference that refers to a cell containing a bid quantity represented in integer form.
Offer
A cell reference that refers to a cell containing an offer ("ask") price represented in decimal form, with a period as a digit separator for non-integer values.
Offer Size
A cell reference that refers to a cell containing an offer ("ask") quantity represented in integer form.

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.