1
$\begingroup$

I'm trying to find a good source for global equities for EOD data (historical and forward basis), currently using Bloomberg's back office data, but it is very hard to normalize it for corporate actions (ticker changes are painful, specially when same tickers are re-used by different companies) - I'm applying all the corporate actions but still it is not the best dataset. There has to be a better source and better way to do it. I know there are lot of sources, but what I'm really looking for is a robust solution that has a very good way to apply corp actions etc.

$\endgroup$
  • $\begingroup$ I doubt you will get this for free but I can name a few alternative vendors if you'd like. $\endgroup$ – pyCthon May 15 '15 at 22:37
  • $\begingroup$ What backtesting platform/programming language are you using? $\endgroup$ – Norgate Data May 16 '15 at 0:27
  • $\begingroup$ I'm not looking for a free source, willing to pay. I'm willing to use any programming language - preferable ones are c#, python, but most preferred way would be storing the data into our database first. $\endgroup$ – WhoIsNinja May 16 '15 at 2:04
  • $\begingroup$ Do you really need "Global equities" or just a subset? $\endgroup$ – Norgate Data May 16 '15 at 10:29
  • $\begingroup$ Global Equities $\endgroup$ – WhoIsNinja May 20 '15 at 21:21
2
$\begingroup$

You can try premiumdata.net. Among several sources I used this provides most clean data. They account for splits and dividends. Delisted securities are present in the data. This is not free but the price is modest for this quality for my point of view. They provide EOD data for US, Australian and Singapore stock exchanges.

$\endgroup$
  • 1
    $\begingroup$ I think a good possibility is to combine CRSP for USA with Datastream for outside USA stocks. This is what most academics use on their papers. An example of a top paper that uses this two data bases is Asness, Moskowitz and Pedersen (2009), but there are several other references. Let me know if you are interested. $\endgroup$ – phdstudent Jul 21 '15 at 17:41
1
$\begingroup$

If you are using Bloomberg then you can pull prices adjusted for corporate actions such as splits, dividends, and other capital adjustments, assuming this meets your needs (i.e. momentum based quant strategies). If you know which global equity indices to track then you can pull the historical constituents to minimise survivorship bias. In Bloomberg, MSCI index constituent lists requires a subscription whereas S&P index members are readily available.

From there you can create a security master list of all the unique tickers in your global universe and pull their adjusted/unadjusted historical data in a specified currency.

Admittedly the tickers can change after your download which requires management if you intend to run a real-time database for production purposes via this process, but it is possible to manage that process.

Otherwise you could look at e.g. Thompson-Reuters, CapitalIQ, Factset, etc. but these can be very expensive. I find Bloomberg data via the terminal to be quite a cost effective solution for global equities, albeit far from perfect. Ideally one would have a loader that auto populates your DB tables each day and manages ticker/ security ID changes.

Hope this is helpful.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.