I am in the midst of a trial of the TradeStation platform.  It is a wonderful system that allows you to quickly develop your own trading strategies, and then backtest them against historical data.  TradeStation will then create a Performance Report that shows you everything from your win/loss ratio to your Equity performance graph (showing how your initial capital grows/shrinks over time).

It seemed perfect for what I needed — except.  Except they don’t have historical options data.  They do have six months worth of historical options intraday data for NON-expired options.  But it doesn’t do you much good if you’re trying to backtest an option trading strategy based in front-month contracts only.

So, I am cobbling together a solution that is full of hacks and workarounds.  And I am discovering the beauty of using VBA macros in Excel in order to sew said hacks together.  John Walkenbach’s book at right is helping me do it.

I never really appreciated VBA.  Sure, I tried it in college during my days in the New Media Lab, and I knew many people utilized it for tactical matters, but as a former C#/.NET developer, I was far too “good” for anything as low as VBA.  But VBA is quick, dirty, simple, and plugable.  You can manipulate your data in the very spreadsheets that data sits in.  And it’s easy to get Excel — and that’s all you need to have to access their VBA editor, debugger and help documentation.  Not so for C#, which requires the highly computer-intensive, and wallet-draining, Visual Studio (although there is a free alternative).

But all of this hacking and sewing is really not what I want to be doing, educational though it may be.

Does anyone know of a good backtesting system with both the features and the historical data needed to do option backtesting?

Most of us can understand at an emotional level how people were feeling about the markets in September:  many of us were, for starters, incredibly nervous about the fate of financials.

• Lehman Brothers had declared bankruptcy
• Merrill Lynch was bought by Bank of America
• There were only two investment banks left in the United States!
  • Morgan Stanley in particular looked very vulnerable.
  • When Morgan’s stock dipped below 20, everyone was wondering “will they be the next one to go?”

Compare the collective sentiment surrounding Morgan Stanley in September with with how people were probably feeling about Coca-cola.

Coca-cola a soda company. Sure, perhaps people may drink less soda in a rough economic period, but since soda is so cheap and people don’t like to change their habits if they don’t have to, soda-drinkers will probably keep drinking soda for the next few years. Your 401(k) tanking? Your mutual funds worth nose-diving? The least you can do is treat yourself to a soda for lunch.

Compared to Morgan Stanley, emotions around Coca-Cola’s stability were certainly more calm, more subdued.

But these are just feelings — fear about Morgan Stanley, calm about Coca-Cola — what did the market think about this? How did the market display all of the emotion and fear and uncertainty we had about Morgan Stanley during the week of September 15th?

The answer is volatility.

Read more »