I have backers who are interested in launching a fund around a strategy that I have built, but they don’t want to depend on P123, so does anyone know how to get data directly from Compustat? I would still use P123, but need to have access to the data directly as well for redundancies.
Compustat is Standard & Poors. Our S&P sales rep would be happy to help.
Note that P123 is not Compustat.
In car manufacturing analogy Compustat data is the raw materials. P123 makes the parts to assemble the car. The quality of each determines if you’ll end up with a Porsche or a DeLorean
when I looked into it last year (I was looking for European data while waiting till we get them on P123), I had been quoted US$ 12,000 per year as a minimum. This was with a London (UK) sales rep. They claimed they cannot disentangle European data from the rest so it was “all geographies or nothing” - which was of no interest to me.
S&P Capital IQ
20 Canada Square, Canary Wharf
London, E14 5LH
United Kingdom
Tel +44 (0) 207-176-1252
Fax +44 (0) 207-176-1203 www.capitaliq.com
This said, I would really emphasize Marco’s point and certainly not disregard the amount of time + expertise, he + team have spent understanding the data, its structure, its limitations, new issues popping up regularly with the weekly updates, etc… Not a small task.
I will look into ClariFi. How about Factset as a backup, anyone used them directly? I had Bloomberg for many years and the data is good, but they don’t have a backtesting engine, so it was a lot of Excel work and it’s 2k/month. I also used Zacks, which is a joke. Marco did such a great job with P123 so the bar is raised pretty high.
Hey I have an idea…Marco why don’t you launch a professional product called something else like “Portfolio Research Analytics”, add Euro data and make some other tweaks, make the interface better looking, and charge a lot more for it. I know several funds that would be interested in something like that.
Factset’s Alphatester could work but is not PIT, at least based on my last conversation with them a year ago.
Bloomberg’s backtesting is good, but P123 is actually much better in terms of building realistic strategies.
You could try to build your own simulation engine out of Quandl data with python + zipline etc., but you are then recreating the wheel.
I would suggest you look at ClariFI Modelstation Express, which is a web-hosted version of Modelstation. Maintaining Compustat data is a nightmare if you try to do it on your own servers, of which you will need two if you do an in-house version of Compustat data + Modelstation. Building factors in Modelstation is a fair bit of work, but the flexibility of their scripts is profound and the market impact feature is very necessary for small cap and very large capital strategies.
All of these ‘backups’ are expensive. Stick with P123 and have an approximation in a FinViz screen + manual processes to back you up.
Holy cow. It was not PIT when I worked with it in the late '90s, but I assumed they got there by now. I they told you “no” a year ago, I suspect it would still be “no” today.
I suppose that may also mean that the FactSet ranking system is probably as limited as it was when I used it (only one or two factors, as I recall).