It’s a measure of the importance of Bloomberg trading terminals, that when they went down in April 2015, the market was thrown into a panic. “Bloomberg being down has finally made me understand how teenagers feel when Facebook crashes,” commented Ireland’s chief economist Philip O’Sullivan; “We’re flying blind…and catching up on admin,” said Louis Gargour, the chief investment officer at LNG Capital; “The markets are so overexposed to Bloomberg,” complained a trader in Hong Kong, “So many people are married to it.”
Whether you’re betrothed to your terminal or not, however, you may not be using it to its full advantage. There’s a good reason why banks pay $21k a year for markets professionals to have terminal access: they’re immensely powerful machines that can cut and dice information on every area of the market, if you know the right codes.
Helpfully, therefore, for all those who might not be putting their terminals to best affect, the Bloomberg Institute has just published a 40 page document of all the exercises used in its investment, financial markets, fixed income, and derivative classes. You can access it here, or here. Or, if you don’t have time to read the whole thing, you can test yourself on the exercises we’ve selected below.
For equities traders:
1. ‘Short Interest is the total amount of shares of stock that are sold short and have not been repurchased to close out the position. High levels of short interest indicate that numerous sellers have sold the stock short and are expecting a downturn in the share price. The SI Screen displays monthly short interest information for a selected equity security that trades on the exchanges. Use the SI screen for several stocks of interest to determine whether or not there is a bullish or bearish sentiment regarding the stocks.’
2. ‘The MBTR monitor screen displays institutional equity transactions of 10,000 shares/lots or more (block trades) on exchanges worldwide. Set up the screen to monitor the stocks in an index (e.g., Russell 3000 (RAY) and the minimum volume (e.g., 100,000 or 500,000). Select one of the stocks that is trading on heavy volume and try to determine if there is an explanation for the size of the trade. Screens to consider from the stock’s menu screen: Company News (CN), intraday price graph (GIP), bid and asked spreads and quotes (QR, BQ, and QMC), short interest (SI), dealers’ interest (SIDE), and brokers’ reported volume (IOIA).’
3. ‘Select a stock of interest and examine its historical regression with the S&P 500 over different periods and frequencies using the Beta screen: Stock Ticker and click BETA. In your examination note the stock’s regression parameters, qualifiers, and adjusted beta. Find the stocks β+, β–, and convexity by clicking Beta +/– checkbox on the BETA screen (on the new screen, click the red “Details” tab to find β+, β–, and convexity).’
For fund managers:
1. ‘Evaluate the fund’s performance using PORT. Performance tab, “Total Return,” “Portfolio vs Index” (e.g., INDU), Time = MTD, YTD, and Custom (for Custom, the select time period must match the period history of the portfolio created in PRTU).Performance tab, “Statistical Summary,” “Portfolio vs Index” (e.g., INDU). Using your selected fund’s RV screen, compare the fund with other similar funds in terms of Sharpe, Treynor, and Jensen ranking indexes. On the RV screen, click the custom tab and then type in Sharpe, Treynor, and Jensen to find those indexes.’
2. ‘The performances of funds by type (e.g., mutual, hedge funds, ETFs, and unit investment trust) can be found on Bloomberg’s Fund Heat Map screen, FMAP. Use the screen to identify the top performers based on total return for several types: FMAP , click “Fund Type” in “View By” dropdown.’
3. ‘Create your own fund of funds portfolio: a. Using the FMAP screen, select funds with different styles: FMAP ; View by = Objective; Region = United States; Analyze by = Last 3-Year Total Return. b. Create a portfolio of your funds in PRTU and analyze the portfolio using PORT. c. Create a basket of your portfolio returns and make it an index in CIXB. As an index, use HRA to determine its regression relation with the S&P 500. d. Examine each fund’s alpha, beta, and R2 using The CORR Screen:: Enter CORR ; click “Create New” tab; select data time period; in the “Matrix Securities” unclick “Symmetric Matrix” button, import portfolio from “Add from Source” tab and click update; in Column Securities Box, add stock index (e.g., S&P 500) by typing index ticker and index moniker (e.g., SPX ) and then click the “Next” tab; name your CORR Screen. On your portfolio’s CORR screen select the data time period for analysis and then use the Calculation tab to find each stocks R2 , alphas, and betas. e. Use the Markowitz Excel Program to determine the best efficient portfolio.’
For risk managers (and fund managers):
1. ‘Evaluate your portfolio’s past performance relative to an index (e.g., DJA, INDU) using the PORT screen over different times periods: Performance tab, “Total Return,” “Portfolio vs Index” (e.g., INDU), Time = MTD, YTD, and Custom (for Custom, the select time period must match the period history of the portfolio created in PRTU).’
2. ‘Use the MRA screen to run a multiple regression of the returns of a stock or index of interest. For your explanatory variables consider the S&P 500 (SPX ) and long-term Treasury yields (USGG30YR ): MRA ; select a set for inputting information; on the set screen select dependent and independent variables; save the set by typing 1 and hitting and select the time period and frequency (daily, weekly, etc.) by hitting 2 . For an example, see Bloomberg box: “MRA: Bloomberg’s Multiple Regression Screen.”’
3. ‘Select a stock of interest and compare its historical volatility for different periods (30-day, 60-day, etc.) using the HVT screen.’
For fundamental analysts and technical analysts:
1. ‘Conduct a relative analysis of your portfolio companies by customizing an RV screen showing the stocks’ DDM values, market prices, and economic value added (EVA). Bring up the RV screen for one of the stock’s in your group; on the RV screen, pull the other stocks from the Comp source dropdown (portfolio, index, or EQS search); customize the screen creating columns for DDM value, EVA, and price..’
2. ‘On the GP screen, use the “Annotate” button on the grey toolbar at the top of the price chart to bring up the annotations palette. On the palette, select regression from the pointer box (top right corner of the palette), span the regression pointer over the time period of interest and then click to create the regression band. Create several regression bands and study their beginning and ending prices and regression slope. To obtain information in a band area, move your curser to band line to bring up an information box with price and regression information.’
3. ‘Technical analysis can be applied to study trends and breakouts for other exchanges, indexes, currencies, commodity prices, and portfolios. Select an index representing foreign stocks or an exchange rate and construct a moving average band for a time period of interest. For a moving-average envelope for a loaded index or currency, type GPO MAENV. See if there are reversal and confirmation signals.’
For bond traders and rates traders:
1. ‘Select an intermediate-term to long-term speculative-grade corporate bond. Using the bond’s GY or GP screen, examine its price, yield to maturity, yield to next call (if applicable) and spread over its benchmark over the past year. Click the “Event” checkbox and set the event settings to see if the spikes in spreads can be explained by certain events.’
2. ‘Use the FWCV screen to determine forward rates one, two, and three years forward. Given your projected one-year forward rates determine your one-year expected total return for different maturity investments using the IYC9 screens and inputting your forward rates.’
3. ‘Use the Bloomberg RATC screen to identify bonds that have had recent ratings changes. On the RATC screen, you may want to limit your search to bonds in a particular industry (select industry from the red “Search” dropdown). Examine one of the bonds with ratings changes using the RSKC, CRPR, and DRSK screens. Comment on the ratings changes and information you find from the screens, such as Altman Z-score, probability of default, changes in financials, CDS spreads, and litigation. ‘
Can you complete the exercises above? Congratulations – you’ve passed the test.
Unfortunately, this is only the start, however – there’s plenty more at the links above.