|
What's In the Model
The model displays a table of the 30 equity instruments which compose
the Dow Jones Industrial Average. Along with the real-time quotes
such as the last price, daily percent change and volume. Bloomberg
has several other categories of fields from which financial information
can be retrieved into Excel. For example there is a category for
various types of fundamental analysis such as information from the
company’s balance sheet or income statement, as well as financial
ratios and pricing and valuation categories. Some of these financial
information categories are available only for specific instruments
or markets. In our table we included, the instrument’s closing price
for the previous year along with the Price
to Book, Price to Sales
and Price to Cash Flow ratios.
You can use Excel’s sorting feature to sort the data in any of
the columns in ascending or descending order. To see a visual display
of the year-to-date percent change, for each of the instruments
in the table, click on the Show Year-to-Date
Performance Chart button. This button runs some simple
macro code which changes the charts visible property from false
to true. Clicking on it again hides the chart.
An example of what we mean is shown below:
|
