Search This Blog

Wednesday, September 14, 2011

Spreadsheet Library: Peer Analysis

Make unlimited use of pre-built analytic spreadsheets from Telemet’s Spreadsheet Library: Click on Help > Contents > Spreadsheet Library

The Peer Analysis workbook is ideal for comparing a particular stock with its peers:
  1. As with all workbooks with links to Orion, ensure that Telemet’s Orion is open and running before opening the workbook
  2. In the Peer worksheet, enter the ticker of interest into cell B4
  3. Click on the Refresh Data button just below cell B4 
NOTE:  The data in the sheet will populate in a couple of waves, so give it a minute or two.  Do not change anything in the SIC or Config worksheets.

The peer companies, based on S&P industry, are displayed in the Peer worksheet in lines 13, 14, and so on.  The industry statistics are show in rows 9 through 12.  The Comparison worksheet displays a detailed, side-by-side, comparison of the ticker of interest and all the peers.

No comments:

Post a Comment