Ruble Regression: Exploring Correlations with Bloomberg.

In June 2014, the price of oil began to fall from its high of $115 a barrel. The value of the Russian Ruble, as well as the currencies of all major petroleum exporting countries began to drop along with the price of oil. Bloomberg has several correlation modules that allow us to examine the link between market variables. For example, we can quickly explore the relationship between exchange rates and oil prices using Bloomberg’s HRA program.

To plot the Russian Ruble / US Dollar exchange rate against the price of oil in Bloomberg, type:  HRA <GO>

Ruble regression value latest

Continue reading

All over the RMAP: Bloomberg’s New Company Information Display

Bloomberg describes RMAP (Relationship Map) as a high level overview of market and industry relationships. It is a graphical display with links to key functions that show fundamental performance data. To display RMAP for Merck & Co, for example:

MRK < EQUITY > RMAP < GO>

Rmap mrk1

The map shows 12 key variables (Bloomberg calls them “Data Nodes”) that are largely self-explanatory. NEWS, for example, shows the top 40 news stories. EVENTS, shows events from one month in the past to two months in the future. Clicking on the group name will launch an in-depth search using Bloomberg mnemonics. Here are some categories and their related codes.

Indices – WGT
Peers  – RV
Holders –  HDS
Analyst Ratings – ANR
Board/Executives – MGMT
Balance Sheet  – FA BSBAR
CDS (Credit Default Swaps) –  CG
Exchanges  – QM
Options  –  OMN

Some additional features of RMAP

  • Bloomberg uses color coding to indicate degree of change. The names of Merck’s Peers, for example, are shown in green if their stock price has increased, and red if it has fallen.
  • Mouse over the center company display for its current value, volume and price Continue reading

Bloomberg Highlights: Round 2

Bloomberg HighlightsThis is the second installment of our Bloomberg Highlights series. If you missed us the first time, click here to view
Round 1. There is a lot of data available on Bloomberg and unless you are looking for something specific, you may never come across some of Bloomberg’s most interesting modules. Below are a few more of Bloomberg’s Best.

Industry Analysis

Bloomberg covers more than 200 industries, and includes data on market share, key data releases, macro data, news, and more. Many industries include an Industry Primer and specialized data for that industry (e.g. drug pricing in the Health Care industry).

Type BI <GO> for access.

Industry BBerg

Bloomberg Career Center

Type JOBS <GO> to screen for jobs by variables such as region/city, roles/category, salary, experience level, degrees required, and languages. The screenshot below shows the results (52 pages) for a screen on Finance or Economist or Analyst positions in All Regions. Continue reading

Bloomberg Highlights: Round 1

Bloomberg HighlightsBloomberg is a key source for current and historical pricing on equities, fixed income securities, foreign exchange and commodities, as well as indicative and fundamental data, customized analytics, and business news. Bloomberg has many supplementary modules that add to its value as a financial resource. This is our first installment of Bloomberg Highlights where we show off some of Bloomberg’s most interesting features.

Bloomberg’s Mapping Module (BMAP)

BMAP allows you to map world wide energy assets (oil, gas fields, pumping stations and pipe lines) and mines (coal, gold and other minerals) as well as individual vessels in ports. Energy assets can be displayed as points on a map or in table format. Below is a map of natural gas pipelines, shown in red, overlaid with US shale basins in blue.

For access, type BMAP and hit the green <GO> key

BMap1

Supply Chain Analysis

Bloomberg provides data (when available) on a company’s suppliers and customers. Use the SPLC function to locate a specific company’s supply chain.  For example, to find Merck’s suppliers, customers, and peers type the following into the command line: Continue reading