Bloomberg Certification - Core Exam
Which Bloomberg Excel tool, wishing the Real-TIme/Historical wizard, would you select to
download historical weekly close data on a rolling basis of a security - ANSHistorical End of Day
What function allows you to create custom news pages for the topics, regions and markets that
are important to you? - ANSMYN <Go>
Where can you find important contact information and support resources for Bloomberg in one
place? - ANS<Cancel> key
While on a function like WEI <Go>, how can you get a user guide for that particular function? -
ANS<Help> key
With Bloomberg in Excel, you have the ability to customize the output of some BDP or BDS
formulas. For example, you can display the market cap for BMW is USD rather than EUR.
These are called overrides. How can you see the possible overrides for a field? - ANSOn
FLDS<GO>, Click a data field to see the possible overrides.
A quick way to create formulas for Excel is by using FLDS<GO>. Find the field "Last Price" in
FLDS for IBM. What is the quickest way to get this value into Excel from FLDS so that the price
of IBM updates automatically? - ANSClick anywhere in the row LAST_PRICE, then drag this
into your Excel file.
If you want news based on the major market sectors you follow, what function can you use? -
ANSSTNI <GO>
What are the two types of Bloomberg functions? - ANSNon-Security functions and
security-specific functions
If you want to explore all the information, functions, and resources available on the topic of "risk"
on the Bloomberg, what would you do? - ANSIn the command line, type RISK and press <Help>
If you want to analyze the historical performance of a security in a chart, what is the correct
order you should use in the command line? - ANSTicker <Asset Class> Function <GO>
What is the purpose of the command line? - ANSAll of the above.
-To access functions directly via mnemonics
-To load a security for analysis
-To search for functions or securities by keyword.
What news function gives you the headlines of the day's top worldwide stories? - ANSTop <GO>
Which Bloomberg Excel tool, wishing the Real-TIme/Historical wizard, would you select to
download historical weekly close data on a rolling basis of a security - ANSHistorical End of Day
What function allows you to create custom news pages for the topics, regions and markets that
are important to you? - ANSMYN <Go>
Where can you find important contact information and support resources for Bloomberg in one
place? - ANS<Cancel> key
While on a function like WEI <Go>, how can you get a user guide for that particular function? -
ANS<Help> key
With Bloomberg in Excel, you have the ability to customize the output of some BDP or BDS
formulas. For example, you can display the market cap for BMW is USD rather than EUR.
These are called overrides. How can you see the possible overrides for a field? - ANSOn
FLDS<GO>, Click a data field to see the possible overrides.
A quick way to create formulas for Excel is by using FLDS<GO>. Find the field "Last Price" in
FLDS for IBM. What is the quickest way to get this value into Excel from FLDS so that the price
of IBM updates automatically? - ANSClick anywhere in the row LAST_PRICE, then drag this
into your Excel file.
If you want news based on the major market sectors you follow, what function can you use? -
ANSSTNI <GO>
What are the two types of Bloomberg functions? - ANSNon-Security functions and
security-specific functions
If you want to explore all the information, functions, and resources available on the topic of "risk"
on the Bloomberg, what would you do? - ANSIn the command line, type RISK and press <Help>
If you want to analyze the historical performance of a security in a chart, what is the correct
order you should use in the command line? - ANSTicker <Asset Class> Function <GO>
What is the purpose of the command line? - ANSAll of the above.
-To access functions directly via mnemonics
-To load a security for analysis
-To search for functions or securities by keyword.
What news function gives you the headlines of the day's top worldwide stories? - ANSTop <GO>
