Download live - insead

BANKSCOPE PRESENTATION SOFTWARE
12.1.3. THE EXCEL ADD-IN FORMULA STRUCTURE
As any other Excel formula, the ADD-IN formula is recalculated whenever the
file is opened or if any of its parameters changes.
The ADD-IN formula structure is the following:
=BvD.GetCdData32 (“BANKSCOPE”,Index Number,Currency,Unit,Year,Line Number)
Let’s examine the parameters of this formula in details:
DISK
the name given to the CD-ROM : BANKSCOPE.
INDEX NUMBER the Index Number of the Bank (For example 10028 for Banque
Bruxelles Lambert -Consolidated).
CURRENCY
the ISO code (USD, DEM etc...) of the currency in which the data
will be displayed. If the reference cell just contains an apostrophe,
it means that the original currency of the statement will be
displayed.
UNIT
the settings of the units used. The following values can be used:
-1
3
6
9
YEAR
Original unit of the statement
Thousands
Millions
Billions
the year which corresponds to the data displayed.
For fixed Years, use :
Year-End Data:
“1998”
“1997”
“1996”
“1995”
….
Interim Data:
“1998/Q4”
“1998/Q3”
“1998/Q2”
“1998/Q1”
…
For relative years, use :
Year-End Data
“LY”
“LY-1”
“LY-2”
Interim Data
“LQ”
“LQ-1”
“LQ-2”
12 - 7