Tags » Business Databases

Use pairs in one VLOOKUP with historical exchange rates from Datastream

One of the most useful Excel functions I help students with is VLOOKUP – extremely useful to automatically bring in data from one table to another. 529 more words

Business Databases

Company Identifiers in Datastream.

Identifiers can take many forms (e.g. Company Name, Ticker, CUSIP, SEDOL, Datastream Code, ISIN) and be national, such as CUSIP for US / Canadian companies or international, such as ISIN (International Security Identification Number). 614 more words

Business Databases

Getting S&P 500 constituents from CRSP via WRDS Cloud using SSH and SAS

The title of this blog post uses far more abbreviations than I would like! Before I get into the purpose of this blog post I shall define them. 1,140 more words

Business Databases

Convert CRSP date YYYYMMDD to Excel true date

If you have a data file from CRSP (or many other sources), the date may be recorded as a text string of the form YYYYMMDD… 140 more words

Business Databases

Historical Index Constituents in Bloomberg

This post follows on from Historical Index Constituents (e.g. S&P 500) written in October 2014.

It is easy to find the current constituents for an equity index such as the FTSE 100 or S&P 500 but finding the historical members for a given date or range of dates requires more work. 637 more words

Business Databases

WRDS new interface for selecting output variables

Following on from the refresh last summer, the Wharton WRDS web portal has been updated again. It is now easier to find and select the output variables you want to use in your request. 346 more words

Business Databases

US tickers to Datastream mnemonics

If you have US tickers as output  from e.g. Compustat index constituents and you want to get stock prices from Datastream that’s possible. You can use a ticker to create a Datastream mnemonic.  125 more words

Datastream

Phil Reed reblogged this on Business Research Plus and commented:

A handy summary for those wishing to use a list of US companies Compustat in a Datastream query. In summary, a well-chosen prefix to the ticker symbol can be systematically added in Excel before creating a static or time series Datastream request. All you need to know is if the company is listed on Nasdaq or elsewhere. Thanks to EDSC for this post.