FactSet

Top  Previous  Next

Description

FactSet provides fundamental data on international companies with results, estimates and recommendations.

Data content included per company the in FactSet package:

Net Sales
EBITDA
EBIT
Net Profit
EPS (Earnings per share)
DPS (Dividends per share),
CFPS (Cash-flow per share)
P/E (Price / Earnings)
Yield Percent
P/CF (Price / Cash-flow)
Recommendations
Last year’s reported result
Next year’s estimated numbers (median)

Requirements

Subscription to a FactSet package

How to access

In an FactSet Consensus Estimates section the Details page of the Symbol Window
As columns in the Market and Composite windows
As DDE or RTD links

FactSet Consensus Estimates section

The FactSet Consensus Estimates is included as a section in the Details page of the Symbol Window.

FactSetinSymbolWindow

Each line in the grid shows last year’s result (or actual), next year’s estimated, number of contributors, nominal change and percentage change for each of the available key figures. The last column shows the percentage change graphically. This gives a quick overview of the expected changes in the coming year.

The date in the upper left corner of the grid shows the date the estimates was last updated. Note that all key figures may not be available (or applicable) to all companies.

Currency conversions
For some results and estimates, the currency of the original values differ from the stock's trading currency. In these cases, the application will convert the values back to the trading currency, using historical currency rates (from the fiscal year end or estimated date). The currency crosses and rates used are then displayed above the other key figures.

The currency cross values used are the closing value from a historical date. For actual results, the date is the end of fiscal year date (say December 31st 2008). For estimated values, the date is the date of the estimation update (say June 12th 2009).

Recommendation bar

At the bottom of the section is a graphical representation of the recommendations from the analysts. It shows up to 5 different level of recommendations: Strong buy, Buy, Hold, Sell and Strong Sell. Each level is color-coded with shades of green for buy, yellow for hold and shades of orange and red for sell.

The number of votes in each category is shown and the width of the color bar is relative to the total number of votes. The middle of the recommendation bar is indicated with a small black arrow and indicates the balance point or average recommendation value. The same value is shown numerically in the label to the left of the bar. The average recommendation value range is from 0 (Strong sell), via 2 (a neutral Hold) to 4 (Strong Buy).

Hover the mouse over the recommendation bar to see the date of the recommendations and full descriptions of all values.

Hints with more detailed information

If you hover the mouse over the value columns, additional information will be shown for that value.

FactSetHint

FactSet columns

All FactSet  values displayed in the Symbol window are also available as columns in the Market or Composite windows. All these columns are prefixed with FactSet in the Select Columns dialog.

FactSetColumnsSelection

In the column captions the FactSet fields are prefixed with an "F" - this is to distinguish them from the corresponding SME Direkt Level 1 fundamental fields.

Double-clicking a fundamental column value will open the the Details page for that symbol.

The background color of the Recommendation columns indicates what direction the value represents (strong buy, buy, hold, sell, strong sell).

You may want to consider using some of the Merged fundamental columns instead.

Extended Cell Hints

Some columns will show additional information in the cell hint. This way you have quick access to more detailed information without adding too many columns.

FactSetMultiHint

List of FactSet columns

The following is a sorted list of all available FactSet columns included in the  package.

Actual CFPS (Cash-flow Per Share)
Actual Currency Rate
Actual DPS (Dividend Per Share)
Actual EBIT (Earnings before interest and taxes)
Actual EBITDA (Earnings before interest, taxes, depreciation and amortization)
Actual End Date
Actual CFPS (Cash-flow Per Share)
Actual Currency Rate
Actual DPS (Dividend Per Share)
Actual EBIT (Earnings before interest and taxes)
Actual EBITDA (Earnings before interest, taxes, depreciation and amortization)
Actual End Date
Actual EPS (Earnings Per Share)
Actual Net Profit
Actual Net Sales
Actual P/CF (Price/Cash-Flow Ratio
Actual P/E (Price/Earnings Ratio)
Actual Start Date
Actual Yield% (100 * DPS / Last)
Change in CFPS (Cash-flow Per Share)
Change in DPS (Dividend Per Share)
Change in EBIT (Earnings before interest and taxes)
Change in EBITDA (Earnings before interest, taxes, depreciation and amortization)
Change in EPS (Earnings Per Share)
Change in Net Profit
Change in Net Sales
Change in P/CF (Price/Cash-Flow Ratio
Change in P/E (Price/Earnings Ratio)
Change in Yield% (100 * DPS / Last)
Currency Cross
Estimated CFPS (Cash-flow Per Share)
Estimated Currency Rate
Estimated Date
Estimated DPS (Dividend Per Share)
Estimated EBIT (Earnings before interest and taxes)
Estimated EBITDA (Earnings before interest, taxes, depreciation and amortization)
Estimated End Date
Estimated EPS (Earnings Per Share)
Estimated Net Profit
Estimated Net Sales
Estimated P/CF (Price/Cash-Flow Ratio
Estimated P/E (Price/Earnings Ratio)
Estimated Start Date
Estimated Yield% (100 * DPS / Last)
Number of Contributors Estimated CFPS (Cash-flow Per Share)
Number of Contributors Estimated DPS (Dividend Per Share)
Number of Contributors Estimated EBIT (Earnings before interest and taxes)
Number of Contributors Estimated EBITDA (Earnings before interest, taxes, depreciation and amortization)
Number of Contributors Estimated EPS (Earnings Per Share)
Number of Contributors Estimated Net Profit
Number of Contributors Estimated Net Sales
Original Currency
Percentage change in CFPS (Cash-flow Per Share)
Percentage change in DPS (Dividend Per Share)
Percentage change in EBIT (Earnings before interest and taxes)
Percentage change in EBITDA (Earnings before interest, taxes, depreciation and amortization)
Percentage change in EPS (Earnings Per Share)
Percentage change in Net Profit
Percentage change in Net Sales
Percentage change in P/CF (Price/Cash-Flow Ratio
Percentage change in P/E (Price/Earnings Ratio)
Percentage change in Yield% (100 * DPS / Last)
Recommendations Average score
Recommendations Buy
Recommendations Hold
Recommendations Sell
Recommendations Strong buy
Recommendations Strong sell
Recommendations Total

 




Mail us feedback on this topic! 

22/02/2016