Case study · Straight Through Processing

Publish government securities prices on Bloomberg

Government securitiesExcelPricesBloomberg
The challenge

From a spreadsheet to every customer's screen

We use Excel to calculate our own prices for on-the-run government securities. There has to be a way to show these prices to our customers and to all the traders on the desk.

All of our customers want to see our prices on Bloomberg. Our challenge is to take the prices from our Excel spreadsheet and show them on a Bloomberg single dealer page, which is the best way for us to reach all of our customers.

Because these prices are time sensitive, the connection between our spreadsheet and Bloomberg must be as fast as possible.

The solution

Street Systems STP

Use our native Excel formulas to publish each price change.

Use the STP Message Hub to capture each price change and convert it to Bloomberg format.

The Bloomberg connector links the STP Message Hub to Bloomberg.

Bloomberg displays your prices in ALLQ or on a single dealer page.

Capabilities used

What made it work

Excel add-in

Street Systems native Excel formulas capture and publish each price change.

Straight Through Processing

Street Systems STP technology collects data from any of your vendors.

Message delivery

Connect to Bloomberg and show your prices to Bloomberg users.