Alternative Bloomberg Import Method

Advanced Bloomberg data import & refresh options

There is an alternative method for importing data from Bloomberg which by-passes the manual, non-persistent Importing using Bloomberg Data Import Wizard method described above. System set up and requirements are the same.

To use this method you must also be permitted to run macros within Excel. Create an Excel spreadsheet using the template available here:

Sample Excel Bloomberg Import & Auto-refreshTemplate

Within this spreadsheet you set up your Bloomberg data using the Excel Add-in for Bloomberg and set it to auto-refresh. The template contains a macro which will automatically save the file on a regular basis for as long as it is open. Once you are happy with the file, open it in Excel (permitting macros to run if asked) and you can minimise it to the bottom of your screen. Now launch Omniscope and open up the Excel file from the place on your hard-drive where you have it saved. When it is open you can set it to auto refresh and as the data in the Excel spreadsheet is populated from Bloomberg, the Omniscope will pull in that data and update to reflect it.

Alternatively, you can open an existing Omniscope file containing references such as ISINs or ticker symbols which are the same as those in your Excel spreadsheet and merge the values in. Then if you set up Live Update it will refresh the merge while retaining your own data.