Bloomberg

{Omniscope Professional and Enterprise Editions only}

Note: Omniscope will connect to Bloomberg only if Omniscope is running on a PC which has Bloomberg Terminal software installed, together with a local copy of Excel and the Bloomberg DDE Server and Add-In for Excel installed.

To determine if the Bloomberg Add-in for Excel is installed on your machine, follow these steps:

In Excel (pre-2007), click the Tools menu item, expand the menu fully, and select Add-In
In Excel 2007, click the Office Button > Excel Options > Add-ins > Manage > COM Add-ins > Go
In the Add-ins window, look to see if there is an item called “Bloomberg” and that it is ticked.

If the Bloomberg Add-in appears but is not ticked, then simply tick it and restart Excel. Otherwise, you will have to install the Bloomberg Add-in. Download and install the DDE Server and the Excel Add-in from the Bloomberg Software Support page, then do the test above to determine if it has worked. If it has, then you are ready to use the Omniscope Bloomberg import and export functions via the DDE Server and Excel Add-in.

Importing data from Bloomberg

You can add refreshable Bloomberg fields to your Omniscope files using the Bloomberg data import wizard.

Note: To populate your Bloomberg fields with live Bloomberg data imported into Omniscope, you must use the Refresh command: File > Import into current file > Refresh Bloomberg Data (or you can use the keyboard shortcut F6)

The Bloomberg data import wizard is accessed from File > Import to current file > Import fields from Bloomberg:

Bloomberg search formula- choose from four common formulae, or cut and paste your own formula from a working spreadsheet. (each of the options is further explained below) Select Ticker/ISIN/ID field- your data set must contain a field that can be used by Bloomberg to match to their data. Securities identifiers like ISIN or SEDOLs, or Bloomberg tickers, etc. Bloomberg fields to import- depending on your licensing arrangements with Bloomberg, there are many thousands of fields of data you can import and refresh directly into Omniscope files: (   Bloomberg fields list) If you do not see the field you want listed in the dialog, check the Bloomberg list to make sure it is available and note its exact name. Add new field- type in the exact name of the Bloomberg field you wish to import and click add new field. It will be added to your list of import and refresh options and ticked. Select record set- select which data universe of data you wish to import the specified Bloomberg fields for. In the example at left, we are importing Bloomberg fields for only 16 securities in the basket, rather than the 72 in the IN universe or the 43,975 in this reference file for this class of instrument.

Search/import formulae options:  

Choose the form of Bloomberg search/import formulae that best suits your data and requirements.

Bloomberg Ticker Formula-  =BLP(%ROW%,%COL%)

Typical BLP string which submits the Omniscope field value selected for ID, then the Bloomberg field names being requested, i.e those ticked below

Bloomberg ISIN Formula-  =BLP(CONCATENATE(%ROW%," Corp ISIN"),%COL%)

This formula is for submitting ISINs from Omniscope in the form 'XS0109263607 Corp ISIN', then the Bloomberg field names being requested, i. e. those ticked below

Example (string concatenation)-  =CONCATENATE(%ROW%," ",%COL%)

This formula can be used to test/demonstrate this function on machines which are not actually running Bloomberg.

User defined- choose this option to specify your own formula, using %ROW% to represent the Omniscope column values selected under Select Ticker/ISIN/ID field, and %COLUMN% to represent the Bloomberg fields you have ticked under Bloomberg fields to import.

Note: If you are importing fields for many records, you may have to manually refresh several times to ensure that all values have been imported. See Refreshing data from Bloomberg below.

Refreshing Data from Bloomberg

The best method of refreshing data, both in your own desktop, and in copies of the files you send to others who also have access to Bloomberg from their machines depends on your requirements, especially record (row)  count, update/refresh speed and performance.

If you or recipients of your files want to refresh Bloomberg fields in Omniscope on a manual, as-needed 'pull' basis, using the File > Import to current file > Refresh from Bloomberg should perform well enough. Indeed, when you first import Bloomberg fields into an Omniscope file, you may have to refresh manually a couple of times to fully populate the file. This form of refresh is best for small portfolios and for less-than real-time updates, for example daily closing prices.

Because auto-refresh from Bloomberg has not yet been fully implemented in Omniscope, if you want to refresh a very large number of records on an automated 'push' real-time basis, use Create Bloomberg spreadsheet to generate a stand-alone automatic price-monitoring Excel spreadsheet that may perform better for large portfolios requiring frequent real-time updates. This situation will change in future.