Tags » Business Databases

Advanced support for using the Bloomberg Excel add-in


This post is a collection of frequently and infrequently asked questions about the Bloomberg¬†Professional API, most specifically the Bloomberg Excel Add-in. For the most part, it should be considered for experts, so please don’t be disheartened if it is too advanced for you; it’s effectively everything I know about the topic. 1,350 more words

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