Pierson Library - UvA - Business & Economics

New interface Bureau van Dijk products

Bureau van Dijk has developed a new, easier to use, interface for their products. Amadeus and Bankscope. This interface will be released in 2010 and will replace the old interface of the databases.

Be prepared. DEMO

Wharton WRDS new interface

Wharton has developed a very user friendly new interface for their WRDS databases.

Which can be found HERE

 The old interface can still be used for a while but at the beginning of december 2009 the library of the University of Amsterdam will switch to the new interface.

 

From then on, ip access will not be possible anymore. Registered users with their own WRDS account will have no problems logging in.

For ip access users: When logging into WRDS, Users will be asked to enter an email account with your institution’s domain (uva.nl). WRDS will then send an email message to that email account to verify that the account is valid. This email will contain an “Access Pass” link which the User can click on to get direct access into WRDS.

There are three primary reasons they are making this change. First, data vendor partners are asking for increased assurances that the data is not being used by unauthorized Users or for commercial, non-research uses. They have had several incidences where Users who had left WRDS Subscriber institutions continued to use IP-authenticated resources to inappropriately access data. Open, unmonitored terminals with access to contractually licensed data have been a potential legal liability which has been ignored historically in the interest of User convenience. In today’s more litigious environment, additional security is required.

Datastream Helpdesk

If you are having trouble finding certain data in Datastream, FIRST come to the librarian in the Pierson Library. He can help you find any kind of data.

If the librarian isn't there, busy or otherwise unable to help you, you can call the Datastream Helpdesk:

Call: 020 504 5995

Exporting to Datastream from Amadeus, Zephyr, etc.

Question: How do I export a list of companies from Amadeus or Zephyr to Datastream?

Answer: If you have a list of companies in Amadeus or a list of target companies in Zephyr, you have to set up an export format first.

• Click on Format at the bottom of the screen and Modify
• In Amadeus go to section Header and add ISIN number to the format
• In Zephyr go to section Stock data and add ISIN number to the format
• Save the format, and click OK
• Now you can export the list to Excel
• In the Excel export file you will see the column ISIN number
• If you select these ISIN numbers you can make a local list out of them in Datastream
• Datastream -- Tools - Create list from range

Calculating LOG in Datastream

Question:  How can I calculate LOG of price or return or whatever in Datastream?

Answer: The LOG is a function that you have to type in manually in the search screen of Datastream.

• For the LOG of the Return of Shell, for example

• Go to Time series and type in the Series/list field: LOG#(H:RDSA(RI))
• LOG# = logarithm, H:RDSA = Shell, RI = datatype Return
• For another company or another datatype, look the codes/mnemonics up first
• You can also use LOG# on an index: LOG#(FTSE100)

Depending on the LOG you want to calculate you can also use: LN#

Which companies in AEX ?

Question: Where can I find historical AEX indexes to see which companies were listed in for example 1990?

Answer: Here: AEX lists

Numbering of rows in Excel

Question: How can I automatically number the rows in my Excel sheet?

Answer:

• Number the first two rows with 1 and 2
• Select the first cell with the 1 in it and look at a small square at bottom right of the selected cell
• Push the Ctrl key and click the small square at the same time
• Now drag the selection over the rows you want to number

Personal local list in Datastream

Question: Last time I made a personal list in Datastream, but the List Picker can't find it anymore.

Answer: Local lists are stored on the C: of that particular computer that you are working on. If you use the exact same computer the second time, the list will be found. Otherwise you have to manually put the local list on the C: of the next computer.

Workaround:

• Local lists are stored in a certain folder on C:. You can put it on USB and the next time put it in the folder on the computer you are working on then.
• Be sure to put it in the exact same folder on the next computer
• C: --> Program files --> Datastream --> Datastream Advance --> User --> .LLT files

Convert from Word to PDF

Question: How do I make a pdf document out of a Word document?

Answer 1: Within the UvA domain you can print a document to printer Adobe PDF

Answer 2: or Go to this website and receive the converted file in your email for free:

ZAMZAR

Using multiple lists at the same time

Question: How can I do a search using 2 indexes at the same time? For example AEX and FTSE100.

Answer:

• Go to Time Series
• Type in the  Series/List field: *LAMSTEOE,*LFTSE100
• using an asterisk and a comma, an L and the code of the index
• Leave "TS for each item in list" empty