Blog2Blog Maak je eigen Blog2Blog | Gratis je eigen blog c.q weblog op internet
Financial Databases and Research - Using Calculated dates in a Request Table
Financial Databases and Research

Using Calculated dates in a Request Table

Posted in Datastream

 

In the post before this one I explained how Excel can be used to easily calculate dates for doing event research. I have noticed that using these calculated dates by copying them in a new Datastream Request table worksheet in Excel does not always work very well. The dates may be automatically formatted when copied into the Excel worksheet.

 

There is an easy way to prevent Excel from formatting the new dates: save them as a text file and open them again in Excel as text. When you then copy the dates into the Datastream Request Table worksheet the dates are kept in the correct format and can be used for the Datastream search request. In the video (±1 min.) below it is explained how you can do this:

 

 

Author information: LinkedIn

 

10:49 PM - 9 December 2010


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