Cointegration and Pairs Trading with Econometrics Toolbox

Demo files from the webinar of same title.

Description

Files used in the April 14, 2011 webinar titled Cointegration and Pairs Trading with Econometrics Toolbox.

It is recomended that you watch the recording of the webinar: http://www.mathworks.com/wbnr55450

• Required Products: Econometrics Toolbox
• MATLAB release: MATLAB 7.12 (2011a)

[Lars]

Great contribution! This actually gave me the nugde to write a thesis about the subject. However, I struggle with accessing the odbc material on win7 x64, r2011a. I have spent too much time on troubleshooting now, I found some discussions online but never an resolution. I was hoping someone in here have had the same issue, and have resolved it. Thanks!

[Fuzhi Cheng]

Expecting to see the use of Johansen procedure in the determination of cointegrating relationship in a multiple-assets stat arb trading environment. The pairs trading part of the webinar still focused on two series and EG -- no big change from previous webinar.

[Andy]

I am having problems running the code for some reason. I get errors trying to run the egcitest(series). "Error using ==> Lagmatrix at 25 lagmatrix: wrong # of input arguments. If anyone could help, it would be greatly appreciated.

[PAvlos Giannakopoulos]

 

[Cathal fLANAGAN]

Guys, similar to Andy, i am getting the "Error using ==> Lagmatrix at 25 lagmatrix: wrong # of input arguments issue.....

Any ideas?

[Suny Mou]

Is it possible to see a format of the data file as I don't have the odbc download capability?

[lee]

??? Undefined function or method 'fetch' for input arguments of type 'struct'.

Error in ==> getMinuteDataFromDB at 25
e = fetch(e);

help！help！help！
 I don't know how to solve,anyone can help me,it would be greatly appreciated!!!

[Kittikorn Tongnimitsawat]

When you down load files, you shall see MS Access file in a folder. This code will connect to this database.

Therefore you will have to create ODBC to connect to MSAccess.

Hope this helps.

[lee]

thank you,yes,now I know how to do;but I want to know there is someone use it to trade in futures markets,by .m to dll;I come from China,maybe someone can give me useful information,

[Michael Nam]

I am missing Data_Canada needed in Demo1_CIWebinar.m from the zip file.

[Stuart Kozola]

Data_Canada is in Econometrics Toolbox. You need a R2011a in order to run the demo.

[Jason]

for those who got this kind of error messages: "Error using ==> Lagmatrix at 25 lagmatrix: wrong # of input arguments," you must be using the MFEToolbox which calls in the lagmatrix function from the USCD toolbox. From R2011a or -b, Matlab has introduced a built-in function with the same name. That should be why.

[Patrick Lee]

it's cooool~

[Mate 2u]

Using demo 2, if I have second-second data from 2.30pm to 9pm what adjustments would need to be made to create and backtest a strategy?

[Fuad]

When calculating the trading ratio should the first leg qty be calculated as -1/reg1.coeff(2) instead of just -reg1.coeff(2)? Since the second leg is fixed at 1 we are effectively dividing through by the coeff of the second leg or have I miss interpreted the script...

[Fuad]

When calculating the trading ratio should the first leg qty be calculated as -1/reg1.coeff(2) instead of just -reg1.coeff(2)? Since the second leg is fixed at 1 we are effectively dividing through by the coeff of the second leg or have I miss interpreted the script... (This is in the pairs.m function)

[Shichang]

Fuad: Agree with you, should be -1/reg1.coeff(2)

[David Snaphaan]

Dear Community,

I have the same problem as Lee in Aug 2011: ??? Undefined function or method 'fetch' for input arguments of type 'struct'.

Error in ==> getMinuteDataFromDB at 25
e = fetch(e);

Unfortunately the hint is no help for me. Do I have to change s.th. in the M-file?

Many Thanks,

Dave

[Semin Ibisevic]

 

[Andrew Baxter]

Please be aware that this demo is not representative of what is achievable in reality. The demo has look ahead bias as it looks at future data to determine the trading signal to use on that data.

See pairs.m "Compute residuals over the next N days"

[gill0055 yeremenko]

Thats very very true Andy. It contains forward data contamination bias.

[Fuzhi Cheng]

I do not think there is a forward bias, but it indeed is a kind of curve-fitting based on historical data. I did simulated trading based on this strategy on a daily and intra-day basis, and it has been a losing one.

[Carl Sutcliffe]

Stuart, I am having problems with downloading the intra-day data from the access db. I receive the error "??? Undefined function or method 'getMinuteDataFromDB' for input arguments of type 'char'."
Is there anyway to fix this?

[Peter Park]

Hi,
Could you explain what does it mean if the date is 734548.554861111 in Access file? In other words, what is year,month,date,hour,minutes,second?
Thank you so much.