Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

Note:
All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog

2/04/2010

Making Zephyr work sets readable in Amadeus (Old format)

Databases are not always compatible with each other. Even between databases Zephyr and Amadeus (same publisher) this is the case (particularly old format Amadeus).
This cook book will show a work around.

Open Zephyr and make the following deal selection:






Quoted stocks


Acquiror, Target and Vendor > all Netherlands


Time period: 1/01/2000 - 31/12/2005







Result:


Now press Button List of deals in the top Bar (second left)



Sort the deals by deal value: (clickable link)



Adjust format of the presented data.
1.

2.

3.


With the drop down option in the top it's possible to select on deal type, company roles, stock data etc. The latter is important for selection Identifiers like ISIN and Ticker Symbol.

4.


Result List of deals:


Export the deal set (top bar button on the right):



In this example we export the 50 largest deals (hence the sort by)



From this point there are two options:
First: uploading into Amadeus Old format (press link)

Second: uploading into Amadeus New Format 2010 (press link)

No comments:

Post a Comment