Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet
Financial Databases and Research - Using lists to search a database through Wharton
Financial Databases and Research

Using lists to search a database through Wharton

Posted in Wharton

Wharton is an interface / portal which offers several options to search in databases. One of the standard options is usually searching a financial database using a list of companies. A list is a simple text file containing company identifiers like Tickers, GVKEYs or something comparable. The identifier depends on the database you are searching in. Each identifying code is listed on a separate line. For some databases there are also specific tools which allow you to search data using company lists combined with a date.

Example CRSP Event Lookup file:  



The identifier lists usually are text files created from datasets with company information which was downloaded earlier from another database. If you created the text file using a file created with a Microsoft program like Excel or Word, you may run into a problem if the text file was not saved as a plain text file.

Specifically: when you are creating a text file from a Microsoft program you have to watch out that the text file which you save is anything other than as a text file coded in ANSI. If you try to load a different text file, for instance a Unicode text file, the Wharton interface will not be able to understand this file and you will not get any data. The solution is converting the Unicode text file into an ANSI text file using the Notepad program on your computer. Open the text file in the Notepad program and save it again as an ANSI file. Example:


Author information: LinkedIn

09:51 PM - 14 June 2008

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

User Profile
--- Amadeus
--- Company.Info
--- Datastream
--- 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