Data Requirements
To calculate your temperature score and portfolio coverage, the tool requires several types of data.
Portfolio data: information on a security level about your investments such as name, identifiers, and investment values.
Data about the investee companies
Fundamental data
Reported GHG emissions
Target data: information about GHG emissions reduction targets set by individual companies.
SBTi status of the companies invested in (i.e. whether these companies have targets approved by the SBTi or not).
Portfolio data
When using the WWF Finance Tool for Temperature Scoring and Portfolio
Coverage, the user needs to supply information about the portfolio. This
must be a list of all investee companies on a security level, including
name, identifiers, ISIN codes, and the value invested in each individual
company. The company identifier is used to link the data from the
portfolio, the fundamental data and the reported targets to each other.
This can be any identifier the user wants to deploy, if the same
identifier is used in all files. The ISIN codes are required to
determine the SBTi status of the companies to calculate the Portfolio
Coverage.
See portfolio data template for an example portfolio file.
For additional analyses, you can supplement this data with additional fields, which are available for import. For example, you can add the market cap buckets, investment strategies or asset classes of each individual security and then analyze the aggregated temperature score per these additional fields/categories.
Company data
The tool needs information about each individual company in the portfolio. We split this data in three categories: financial data, emissions, and target data.
All three categories are available for import via a single Excel file.
Here is a template here.
Note
Please note that the tool requires the data in a specific format. For more detail, see the data provider template and the Data Legends for the required data formats and expect values.
Fundamental data
The fundamental data tab in Excel includes all company wide data including GHG emissions per scope and ISIC codes. This open source industry classification standard is used to map the targets to different regression models. For more information, see https://siccode.com/page/what-is-an-isic-code. Other financial data is required in order to aggregate individual temperature scores to a portfolio temperature score, which depends on the method you choose. The table below outlines required data for all aggregation methods.
Aggregation Method |
Required Financial Data |
|---|---|
Weighted average temperature score (WATS) |
None |
Total emissions weighted temperature score (TETS) |
None |
Market Owned emissions weighted temperature score (MOTS) |
Company market cap |
Enterprise Owned emissions weighted temperature score (EOTS). |
Company enterprise value |
EV + Cash emissions weighted temperature score (ECOTS) |
Company enterprise value and cash equivalents |
Total Assets emissions weighted temperature score (AOTS) |
Company total assets |
Revenue emissions weighted temperature score (ROTS) |
Company revenues |
The financial data used should be regarding the same period as the reported emissions. Preferably the latest reported. For more information about the requirements, see the guidance documentation.
Target data
This should include all publicly announced GHG emissions reduction targets for each company in the portfolio. For each target, information is required on target type, currently we only score absolute or intensity-based GHG emissions reduction targets. For intensity-based targets, information is needed about the metric used. Additionally, for each target, information on scope(s), level of coverage, level of reduction ambition, and begin and end year of the target must be included in the file.
The temperature score is calculated for Scopes 1 + 2 and 3. In order to convert targets that only cover scope 1 or scope 2, additional information is required on GHG emissions per scope at the base year for scope 1 and 2 to convert such targets to targets.
Specific attention should be given to intensity metrics as there currently lacks consensus in reporting method. For the tool, all intensity metrics have to be mapped to one of eight categories. Please refer to the [link to guidance] for more detail on how to do this.
SBTi status
The tool downloads the per-company CTA Excel file from
https://sb-ti.files.svdcdn.com/staging/files/companies-excel.xlsx.
It uses company_name, isin, lei and near_term_status.
Companies with Validated Targets in near_term_status count towards
portfolio coverage; the previous label Targets set is also supported.
Commitment to Set Targets (previously Committed),
Commitment Removed and empty status cells do not count as validated.
Status labels are matched without case sensitivity or surrounding whitespace.
Missing required columns or unknown nonempty statuses raise a descriptive error.
Companies are matched using LEI when available in the portfolio, otherwise ISIN. Validated companies receive a score of 100 and other companies receive 0. The selected portfolio aggregation method supplies the weights; for WATS these are investment values from the portfolio data.
The downloaded file is cached at
~/.itr-tool/current-Companies-Taking-Action.xlsx and normally refreshed
after one week. If downloading fails, the tool uses an existing cached file
or, when unavailable, a bundled fallback file that may be outdated.
To use a specific local file, pass cta_file_path to PortfolioCoverageTVP.
This provides current status coverage, not a reconstruction of historical status.