Quote from etfarb:
I;m not looking to do HFT arb.
I'm simply looking to make a basket from the 10-15 largest weightings in the nasdaq to help me decide when I should go long or short the index.
I swing trade so i use EOD data to backtest. I read an article that basically says you need to figure out what assets cointegrate with the index in order to figure out the weightings. I was wondering if there was an easier way to do this since i don't know R and don't own matlab
is there a way to test for cointegration in excel?