Bloomberg Launchpad Formula Guide
Bloomberg Launchpad Formula Guide
Bloomberg Launchpad Formula Guide
Launchpad Monitors
T
1) Intro &Getting
There
2
2) Column Formula VS. Cell
Formula..3
3) The
basics
...4
4) IF/OR/AND/Nested IF.
..5
5) Mathematics & Other common formulae
Average/Min/Max
7
6) Date and
Times
...8
7) Subtracting
Dates
..9
9) NEW!
fields/Return/Historic
Wherever
you seeInterval
a
icon, it means you can click on it
to load a sample monitor in the Bloomberg Terminal.
....14
Once its loaded, you can save a copy, and then go to monitor
10) Creating
a Matrix
import
to insert your own
custom list of securities. Lets get started!
values
1
....15
This switches the monitor into a formula mode allowing you to create
formulae just like you would in Excel.
Column
formula
Cell
formula
3) The basics
Space for you to write your
expression.
4) IF/OR/AND/Nested IF
IF
Basic logical statements such as IF/OR/AND work exactly the same in Excel as in the
Launchpad Monitor. Below are some examples of what you can do, with a description of
you
have typed
out with
your
what the statement is saying. These can be inserted into Once
a blank
column
and used
expression
in
the
orange
box,
column formulae, as described in part 2).
hit update and watch your
If
the
figure in column
B is
cells
automatically
pull in
greater
than 100, then IF
data.
If/Or/And/Nested
populate myMonitor
blank4column
with BUY. If this is not the
case, populate the cell with
SELL.
AND
If the figure in column B is
greater than 100, AND the
figure in column C is greater
than 100, then populate my
corresponding cell with BUY. If
this is not the case, populate
the cell with SELL.
OR
If the figure in column B is
greater than 100, OR the
figure in column C is greater
than 100, then populate my
corresponding cell with BUY. If
this is not the case, populate
the cell with SELL.
NESTED IF
INT(value)
- returns the integer part of the value
Eg: INT(5.69) returns 5
MID(text,start number, number of characters)
- returns a specific number of characters from a text string, starting at the
position you specify, based on the number of characters you specify
Eg: =MID("bloomberg",3,2) returns oo
LEN(cell)
-returns the number of characters in that cell
Eg: =LEN("bloomberg") returns 9
RIGHT(text,number of characters)
LEFT (text,number of characters)
-returns the first/(last) character or characters in a text string, and then x many
other characters to the right/(left)
Eg: =RIGHT("bloomberg",4) returns berg
Eg: =LEFT("bloomberg",5) returns bloom
MIN(range)
- displays the smallest value in array
Eg: =MIN(B2:B10)
MAX(range)
- displays the larger value in array
Eg: =MAX(B2:B10)
SUM(range)
Eg: = SUM(B2:B10)
AVERAGE(range)
Eg: = AVERAGE(B2:B10)
7) Subtracting Dates
Counting Between
Days Example
Monitor
=dateformat(TODAY(),
=dateformat(TODAY(),
=dateformat(TODAY(),
=dateformat(TODAY(),
"d1")
"d2")
"d3")
"d4")
8) Manipulating Update
Times
A common request is being able to show which tickers
have been updated in a monitor within the last few
minutes.
Or more likely, which tickers havent updated for
some time.
10
11
Update Within
Timeframe
12
Interval Monitor
To add your interval field use the following steps from your
monitor: click view --> manage columns --> search for the
interval field you would like to use --> (interval percent
change/interval high/interval max/min) add selected. You can
then edit the date range and currency overrides via --> edit
overrides.
You can also do this directly by double clicking on the column
headings until it turns amber. There you can enter the field
mnemonic or keywords for the interval field and hit <GO> to
add. Finally, right click on the column and choose Edit
column overrides.
13
Now
that tricky
you have
The only
thingthese
here is
formulae
in
all
the
top
cells
of
making sure you lock the
cells
each
column,
you can
right
correctly
by using
the $
key.
click on each one and choose
filldown
Once youformula
go into the =f(x)
mode, double click in the first
Finally, you can right click on
cell of each column and put in
each of the column headings
the formulae shown above.
and rename them to the
country list on the left hand
side
15
C# is a useful command
that tells the monitor that the
range ends at the last row
where there is data, so you
dont have to specify this
yourself.
Perfect if you are adding or
12) RESOURCES
Go to your Launchpad
toolbar and type
Sample Monitors in
Enter Keywords.
This will load up the
sample monitors
component showing a
list of commonly used
monitors broken down
by asset class.
Those with 3 stars
indicate that they are
commonly requested
by users. Simply
search for a keyword,
16
check out the
preview, and if you
like it, choose Launch
Sample Monitors
17
Real-time Portfolio
Monitor
Global Monitor
Global Monitor
Market Buzz
Market Buzz
Technical Strategy
Technical Strategy
18
13) COLOURING
WITH
A
ENJOY
FORMULA
Now that you have got your monitor bringing
in all the data you need, we need to make it
visual!
THE
POSSIBILI
TIES ARE
ENDLESS
19
20