Discussions about the testing and simulation of mechanical trading systems using historical data and other methods. Trading Blox Customers should post Trading Blox specific questions in the Customer Support forum.

Anthony, I wonder if I could trouble you to run a stock test for me, I dont think it would be much work. I do not have the necessary stock data. You may have already done this anyways. These are the rules:

The above was with an average lookback over a longer period. Here is the 3 month only look back.
CAGR%:
MAD DD%:
Around 1000 listed and de-listed stock chosen solely on grounds of the highest liquidity.

Sometimes it benefits you AND your employees when you give them little side-projects that expand their knowledge. For example, you could give one of your employees the project "Estimate the CAGR and the MaxDD of the equity curves just posted by Anthony Garner".

Yes. But the portfolio was only around 1,000 stocks I seem to recall which had been preselected by liquidity. I think the better approach is to select ALL stocks you have access to and then filter by 90 day liquidity or some such as you go along. I selected all non OTC US stocks with a history of at least 1 year from the CSI database; it came to 14,000 stocks. I have reached no conclusions yet since it is painful running tests on a portfolio of that size with my 16 GB ram laptop. Once my new 64 GB arrives I'll try and remember to publish some results.

So, here is what I did. I queried the CSI sdbfacts.csv file and extracted the 14,000 listed US stocks on NYSE, NASDAQ and AMEX which had a trading history of over 1 year. You can see below how many instruments this consists of on a time series basis (obviously the stocks had different start and end date since they included de-listed stocks and of course stocks coming to the market over the years). Note that the current total of around 8,000 instruments greatly exceeds the number of companies listed on US markets (around 5,500 including foreign stocks) and this is because different share classes as well as preference shares and so forth are included. No matter.

I then ran a monthly rotational stock system on the top 300 from 1987 (an institutional kind of size) and got very pleasing results : CAGR 13%+, Max DD 27%, very high Rsq.

I put a filter in which chose to trade only the top 50% in terms of liquidity. Liquidity measured once a quarter and based on turnover.

I will write the tests up in full and put them on my website.

Disappointingly, using a much smaller figure for X, the number of stocks into which to rotate, provided unacceptable results. I am looking at why in depth.

I am a little concerned at CSI's coverage and am left wondering how complete it is in the early years. As ever in back testing the data is always the biggest problem. When it comes to curve fitting however, one can rest reasonably assured that the portfolio has NOT been cherry picked.

Anthony, I wonder if I could trouble you to run a stock test for me, I dont think it would be much work. I do not have the necessary stock data. You may have already done this anyways. These are the rules: