Companies and Greenhouse Gas Emission Trading

Today Bas de Groot, a student at the Vrije Universiteit, gave me a great tip for when you are doing research on companies & greenhouse gas emissions. In January 2005 the European Union Greenhouse Gas Emission Trading System (EU ETS) was in operation. Allowances traded in the EU ETS are not printed but held in accounts in electronic registries set up by Member States. The registries system keeps track of the ownership of allowances in the same way as a banking system keeps track of the ownership of money. These registries are overseen by a Central Administrator at EU level in the Community independent transaction log. The website offers information as well as links to the member registries. In these registries you can find out exactly which companies in Europe are registered and for which installations.

Author information: LinkedIn

04:52 PM - 23 June 2010

Compustat Global financial data & currencies

The following variables/codes  identify the currency in which the company's financial data is available in the Compustat Global databases. When this item is not equal to CURNCD, Compustat has translated the data from CURNCD to CURCD (or CURCDQ) using the translation rate found in the variable: CURRTR.

Mnemonic: CURCD
Periodicity: Annual
Format: Code

Mnemonic: CURCDQ
Periodicity: Quarterly
Format: Code

The historic exchange rates can be found by obtaining the variable exratd and applying it with the appropriate ‘tocurd’ and ‘fromcurd’ variables. The data manual for Compustat Global (Understanding The Data) has much more information in a specific chapter called: Chapter 8: Currency. This section of the manual says a lot about recalculating using exchange rates and gives variable options depending on the section of the Financial statements.

Author information: LinkedIn

10:52 PM - 18 June 2010

SDC VentureXpert Report problem: supplemental

A short while ago I reported that there is a problem with one of the standard reports that are available in the VentureXpert database of SDC Platinum. The problem has been reported to the Thomson company and they are currently working on it. Earlier, I thought the problem would be fixed in days or a week at most. It seems the problem is harder to fix than I thought because today I was told that it will take several Months before the problem is fixed. It may be that it will take until the end of the year. I hope that the problem will be fixed sooner, though!

In the mean time maybe you can try contacting the helpdesk of your organization (or the owner Thomson Reuters) If you need the data from this report and cannot get it any other way.

Author information: LinkedIn

06:06 PM - 14 June 2010

SDC VentureXpert Report problem

At the moment there appears to be a problem with one of the standard reports that are available in the VentureXpert database of SDC Platinum. The problem concerns the report "Cumulative Performance / Cumulative Internal Rate of Return (IRR)". When I do a search a search and call up the report I get an empty report with no cumulative data.

Below you see an example of a search + Report combination that shows the problem:
- Database Selection: Performance
- Search menu
- United States
- 3. All private Equity Funds
- No limitations on fund characteristics
- Report: Cumulative Performance / Cumulative Internal Rate of Return (IRR)
- Annual
- From date: december 1984
- To Date: december 2009

The problem has been reported to the Thomson company and they are currently busy investigating the problem.

Author information: LinkedIn

11:39 AM - 9 June 2010

Datastream changes: S&P Historical Indexes

In the latest quarterly Infostream publication it is announced that additional historical constituent lists of S&P indices have recently become available on Datastream. This includes specific historical Citigroup S&P lists.

Access to the Names and identifiers of the securities that are part of the indices, is unrestricted for the new lists. Other data types such as constituent weights, number of shares and free-float data are restricted, and customers are required to have a direct end-user agreement with S&P.

Below you see a list of some of main historical index lists with their names/mnemonics.

List Mnemonic: LS&P100I
Description: S&P 100
Data added from: LS&P100I0989
Start month and year: Sep 89

List Mnemonic: LS&PMIDC
Description: S&P 400 (Mid Cap)
Data added: LS&PMIDC1294
Start month and year: Dec 94

List Mnemonic: LS&PCOMP
Description: S&P 500 Composite
Data added: LS&PCOMP0989
Start month and year: Sep 89

List Mnemonic: LS&P600I
Description: S&P 600 (Small Cap)
Data added: LS&P600I1294
Start month and year: Dec 94

List Mnemonic: LS&P900I
Description: S&P 900 Index
Data added: LS&P900I0295
Start month and year: Feb 95

List Mnemonic: LS&P10XX
Description: S&P 1000 Index
Data added: LS&P10XX1294
Start month and year: Dec 94

List Mnemonic: LS&P15XX
Description: S&P 1500 Super Composite
Data added: LS&P15XX1294
Start month and year: Dec 94

Author information: LinkedIn

11:42 PM - 8 June 2010