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.

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

Search This Blog


Loading Zephyr data into Amadeus * Old format *

When a company overview is desired also, after creating a deal set from Zephyr, it is possible to retrieve these data from Amadeus. Although it demands some steps.

This blog thread describes how it is done in the old Amadeus format.
After exporting the Zephyr search (i.e. a deal list) to a dedicated directory:

1. Open Excel
2. Load the export file
3. Look up the BvDep identifiers that were retrieved from the format change option in Xephyr, Targets or Acquirors.
Identifiers like ISIN and Ticker symbol won't work.
4. Remove empty cells by using the autofilter (TAB data > filter > auto filter)

Select all files in the column with CTRL-SHIFT ARROW Down
CRTL-C (copy), open Note Pad, paste CTRL-V and save as a text file.

!! Go to the save directory and change extension into .bvd !!

Start Amadeus (Bureau van Dijk)
Note: the Wharton portal may give problems uploading the file(s)

Select ' Load company file' from the menu at the left hand side of the screen.

Next, Amadeus will show a list of companies it couldn't find (memorize these or write them down, for manual search)

Next result

Finally, click TABS List and Company Reports (a page for every file in the work set):

Back to Making Zephyr files readable in Amadeus < click link

No comments:

Post a Comment