Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet
Financial Databases and Research
Financial Databases and Research

Using a specific list of companies in Zephyr

Posted in Zephyr

Zephyr is a database containing information on: Mergers & Acquisitions, Initial Public Offerings Venture Capital transactions. The database covers transactions & deals worldwide. The database offers many search options. An important search option for looking up a list of preselected companies is "Identification numbers". The company identification numbers that can be used are:
- BVD ID Number
- Ticker symbol
- ISIN Number
.

 

 

The identification numbers that can usually be used in other databases as well are the Ticker symbols, and the ISIN numbers. After choosing the option "Identification numbers" you can use the button Load from disk (on the left side in your screen) to open a text or Excel file with a list of (one of) these codes. It is also possible to select whether the codes should match one or more of the company types: Acquirer and/or Target and/or Vendor.

 

 

NB: The BVD ID Number is a proprietary number of companies in online databases created by Bureau van Dijk.

 

Author information: LinkedIn

 

01:22 PM - 2 December 2011


World Bank Commodity Prices - update October 2011

New and updated information on commodities have been published in the November monthly pink sheet. The new pink sheet can be downloaded through the website on commodity markets. It is available as a PDF file (no longer as a separate monthly excel file).

The World Bank also offers an updated complete historical monthly commodity price series starting from 1960. The overview can be downloaded as an excel file and has the new monthly price data up until October 2011.

 

 

Author information: LinkedIn

 

01:08 PM - 4 November 2011


Trading weekdays in Datastream

Posted in Datastream

Stock exchanges in Europe and many other nations have a working week and allow trading in stocks to take place from Mondays to Fridays. There are also many countries with stock exchanges that have different working weeks. These may run from Sundays to Thursdays. Examples of these are stock exchanges in Oman, Saudi Arabia, Kuwait and Dubai. In their case the non-trading days are Fridays and Saturdays.

When I download Price information from Datastream on stocks or indices from the Abu Dhabi stock exchange I do, however, get prices on non-trading days like Friday.
Example:



I asked the Thomson Reuters helpdesk how this could be and I was told that data from the Datastream database is reported according to the European trading/workweek. Prices on Sundays are placed in the previous Fridays.
For Example: 23rd Oct 2011 (Sunday) prices will be updated for 21st Oct 2011 (Friday).
This explains the result I got for the index of Abu Dhabi in the above example download.

Author information: LinkedIn


 

05:07 PM - 21 October 2011


World Bank Commodity Prices - update September 2011


New and updated information on commodities have been published in the October monthly pink sheet. The new pink sheet can be downloaded through the website on commodity markets. It is available as a PDF file (no longer as a separate monthly excel file).

The World Bank also offers an updated complete historical monthly commodity price series starting from 1960. The overview can be downloaded as an excel file and has the new monthly price data up until September 2011.



Author information: LinkedIn



12:50 PM - 6 October 2011


Credit ratings & Bonds in Datastream

Posted in Datastream

In an earlier post I explained how you can get credit rating information on bonds/borrowers from the database Datastream. Ratings information is available from Moody's, S&P and a few composite Datastream ratings. What may not be immediately clear is the fact that the rating information is truly static: only the latest rating information available. The information you can download is not of the time series type.

Each data type has got the indicator Static. What may be confusing is the way the data can be downloaded. If you download all available rating data types (33) for more than one bond/borrower you get output that looks as follows:



Almost all ratings data types are given default names/codes/mnemonics that do not look like the original mnemonics in the Datastream Navigator! The downloaded type names are RD001, RD001 etc. and they seem to be repeated with different dates. Yersterday I called the Thomson Reuters helpdesk and they confirmed that the only rating information they carry is of the static type. It is not possible to get time series credit rating information from Datastream!

Author information: LinkedIn

 


12:44 AM - 30 September 2011


Last Page
Next Page
Description
This weblog will deal with all kinds of tips and tricks on the use of several financial databases.

Home
User Profile
Sections
--- Amadeus
--- Company.Info
--- Datastream
--- Factiva.com
--- GMID
--- General
--- International Statistics
--- LexisNexis
--- SDC Platinum
--- S&P Indexes
--- Wharton
--- Zephyr
Recent Entries
- Announcement: New Blog
- International Human Development Indicators
- Global Reporting Initiative
- WorldScope company coverage update
- World Bank Commodity Prices - update November 2011



External Links:
--- NYSE Euronext
--- Finabase Blog
--- VU Law Blogspot