Category Archives for "Data"
I have done several posts about trading XIV & VXX. In these posts (here, here and here) I refer to using synthetic data before these ETFs started trading. I supported the use of the data due to the very high correlation of daily returns during the overlap period. With a correlation of .97, I thought great the data should be good to use for backtesting.
In my last post I showed research on how optimization results can be mean reverting. Sometimes, my research keeps getting side tracked as I think of random ideas to look at. In this post, we look at the random walk my research took starting from my mean reverting optimization research. I will show how changing the start date can have a big change in the results, correlation of 1990’s to now, and random data and how it correlates.
At the end of last year, I was working with a client and we were having problems with code I had written. We would get different results depending on who ran the code. After comparing trade lists and doing some debugging, we discovered that their database was missing several symbols. These symbols existed in my database but did not exist in theirs. We were both using Norgate’s Premium Data, which I highly recommend and can read my review here.
About once a month, someone asks how important it is to have dividend adjusted data. Or someone will comment they do not want to use Premium Data because they do not adjust for dividends (it does but it is not enabled by default). My answer has been “without dividend adjusted data, your results may be understated.” It has always bothered me that I could not give a better answer. In my post, “How much does not having survivorship free data change test results?” I covered other data issues but not this one. Since Premium Data makes it easy to have two databases, one with the dividend adjustments and one without, it was time to run tests and determine how much of a difference it makes.
I am frequently asked what data provider I use. A year ago my data provider was CSI Data. Then I heard about Premium Data from Norgate Investor Services and the one feature that enticed me to look at them closer: historical S&P500 index constituent data. At that time, I was maintaining the data by hand. Each month I would have to determine which stocks had been added or deleted from the index. I would need to look for name changes in the current and historical list. Not a hard task but time consuming and easy to make mistakes. The thought of not having to do this was very enticing.
This review will focus on US Stocks and AmiBroker integration. Premium data has data for the Australian and Singapore markets, integrate with multiple other platforms and have forex and futures data. For more information go to Premium Data from Norgate Investor Services.