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
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