Bloomberg


SWPM - swap interest rate calculator
WEI - World Equity-Indices


GIP GBPEUR CURNCY - intraday graph currency


FXC - current exchange rates



bloomberguichartsevents
blpsmarthost.exe
blpaddinhost.exe
bloomberg.taskpane.host-dll



http://researchguides.smu.edu.sg/content.php?pid=128903&sid=1117575



Bloomberg Excel Tools Add-in

The Excel addin is installed in the following location:


C:\blp\API\



Checking for updates, type UPGR
download and install the following - BBComm, DDE Server, Excel add-ins



blp.exe - C:\blp\API\dde\blp.exe


wintrv.exe ??



Versions

v2 - 10 June 2009 - Build 8537
v - 7 January 2009 - Build 7256
v3 - 9 October 2009 - Build 9673




Bloomberg DDE Server


C:\blp\api\dde\ bbcomm.exe


What is the bbcomm.exe ?



Addins Dialog Box

SS
There should only be a single entry in the Add-ins dialog box





Bloomberg Excel Tools - BloombergUI.xla

VBA Project Name - BloombergUI
C:\blp\API\Office Tools\BloombergUI.xla


This automatically loads all the other add-ins in blue
The add-ins dialog box is not updated to reflect that these add-ins are now loaded in the current session.
The registry "Add-in Manager" and "Options" keys are also not dynamically updated




Drop-Down Menu - Bloomberg

SS



Import Data
Opens the


Scenario Builder
Lets you perform financial calculations in your workbooks for multiple securities


Fundamental Analysis



Template Library
Lets you search, filter, provide feedback or open a bloomberg template.


Equity Screening



Function Builder



Field Search



Populate Table
Use this to create an automatically updating table of data using column and row headers



Refresh




Formula Conversion Tool



IBES/Best Estimate Conversion Tool



Options



Previous Menu



Help




Live Chat









Toolbar - Bloomberg Tools

SS



Toggles Realtime Updates On/Off -


Refresh All Workbooks -


Import Data -


Scenario Builder -


Fundamentals Analysis -


Equity Screening -


Function Builder -


Field Search -


Populate Table -


Contact Bloomberg -






VBA Addins



BlpMain.xla -
VBA Project Name - Bloomberg
C:\blp\API\dde\BlpMain.xla



Bloomberg Data Functions.xla
VBA Project Name - BloombergDataFunctions
C:\blp\API\Office Tools\Bloomberg Data Functions.xla



Blph.xla
VBA Project Name - BloombergHistory
C:\blp\API\dde\Blph.xla



BloombergUI.xla
VBA Project Name - BloombergUI
C:\blp\API\Office Tools\BloombergUI.xla



BloombergV3Support.xla
VBA Project Name - BloombergV3Support
C:\blp\API\dde\BloombergV3Support.xla



BloombergVbe.xla
VBA Project Name - BloombergVbe
C:\blp\API\Office Tools\BloombergVbe.xla



Blp.xla
VBA Project Name - Blp.xls
C:\blp\API\dde\Blp.xla



Blpchart.xla
VBA Project Name - BlpCharting
C:\blp\API\dde\Blpchart.xla



BlpLib.xla
VBA Project Name - BlpLib.XLS
C:\blp\API\dde\BlpLib.xla



blprds.xla
VBA Project Name - blprds
C:\blp\API\Office Tools\blprds.xla




BTSAddin.zla
VBA Project Name - BTSAddin
C:\blp\API\Office Tools\BTSAddin.xla
C:\blp\API\Office Tools\BTSAddin.xll




BloombergOfficeToolsRibbonUI.xlam
Contains the Office 2007 Ribbon customisation




Notes


Securities are priced for each terminal and can use different pricing sources
(different people might like to see slightly different prices)



SWPM - swap interest rate calculator
WEI - World Equity-Indices
GIP GBPEUR CURNCY - intraday graph currency
FXC - current exchange rates
http://researchguides.smu.edu.sg/content.php?pid=128903&sid=1117575








Error Messages

#N/A Authorization - limited functionality or login is restricted


#N/A Connection - the connection between the BBCOMM and the RTD has been lost
Check that bbcom.exe is running in the task manager
Open Excel, select (Bloomberg > About Bloomberg Excel Tools). Select Diagnostics...
bbcomm running - but no data cannot be killed ??



#N/A Invalid Field - field mnemonic is not valid


#N/A End Date -
#N/A Field Not Applicable -
#N/A Invalid Parameter -
#N/A Invalid Screen Name -
#N/A Invalid Security -
#N/A Limit -
#N/A N/A -
#N/A Real Time -
#N/A Refresh Failed -
#N/A Refresh Pending -
#N/A Requesting Data -
#N/A Start Date -
#N/A Time Out -
#N/A Unknown -



blp("isin", CHG_NET_1D) - daily change %
blp("isin", CHG_NET_MTD) - month to date change %
blp("isin", CHG_NET_YTD) - year to date change %
blp("isin", PX_ASK) - offer price
blp("isin", PX_BID) - bid price
blp("isin", PX_LAST) - last price (either offer or bid)
blp("isin", PX_MID) - middle of (last bid and last offer)
blp("isin", YLD_TYM_MID) - blended YTM
blp("isin", YAS_YLD_SPREAD) - stripped spread
blp("isin", DUR_ADJ_ASK) - spread duration
blp("isin", DUR_ADJ_MID) - mod duration
blp("isin", DUR_ASK) - EIR duration
blp("isin", RTG_SP) - S&P rating
blp("isin", RTG_MOODY) - moody rating
blp("isin", CNTRY_OF_RISK) - country
blp("isin", SECURITY_DES) - description
blp("isin", CPN) - coupon



Bloomberg Data Type Library


C:\blp\API\activex\blpdatax.dll


Library BLP_DATA_CTRLLib



Classes
BlpData
BlpProps
lBlpData
lBlpData2
lBlpData3
lBlpDiagnostics
lBlpSnapShot




Custom Bloomberg


Dim oBlp As BLP_DATA_CTRLLib.BlpData
- Refresh Workbook Data - calls RefreshBBBloombergBook
- Refresh Worksheet Data - calls RefreshBBBloombergSheet
- Refresh Selection Data - calls RefreshBBBloombergSelection
- Active Mode - call BBBlpActiveMode
- Show Hide Comments - calls BBBlpShowHideComments
- Reset bbblp - call BBBlpReset



Refreshing Bloomberg Cells
Check the comment and see if it contains a BlueBay BLP style comment
Search the comment to see if it contains either "bbblp(" or "bbhblp("


Replace the contents of the cell with the corresponding formula


When the cell is then updated the bbblp function is called which call bloomberg and replaces this function with the corresponding value.




2 classes - BetterBlpClass - variable BBClass
- BetterBlpHistClass - variable BBClassH


global variable ActiveMode



BetterBlpMod - contains
Function BBBlp
Function BBHBlp


Sub RefreshBBBloombergSelection
Sub RefreshBBBloombergSheet
Sub RefreshBBBloombergBook
Sub BBBlpReset
Sub BBBlpActiveMode
Sub BBBlpActiveModeOn
Sub BBBlpActiveModeOff
Sub BBBlpShowHideComments


Function DeProtectSheet
Function ReProtectSheet


MenuMod - contains
Sub Auto_Open
Sub BBBCheckMenu
Sub FlipActiveBFace




© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top

PrevNext