General Topics
Technical Topics
Brokerage Firms
Community Lounge
Site Support

# Determining Whether a Basket is Trending

Discussion in 'Strategy Development' started by mahras2, Feb 16, 2006.

1. ### mahras2

Well I though a hybrid price would be the answer to figuring out whether a basket of securities as a whole is trending or not. However, after I took a nap and looked at it I realized that although the hybrid price of the three securities may be flatlining the components may be trending opposite in direction to each other.

So has another tried to figure out statistically whether a basket of different securities is "trending" overall or not? Can it be done?

2. ### stephencrowley

Yes of course.. do some searches on "cointegration" and prepare to read.. and read.. and then read some more..

3. ### mahras2

Hey Stephen,

Thanks for the lead. I will check out some works on conintegration + multicointegration later tonight.

4. ### mahras2

Question> Stephen as you have some experience with this could you link me to some resources explaining how to run multicointegration analysis on excel for multiple series of data? I have found this tutorial on gummy stuff which was helpful but is there any others dealing with multicointegration calculations and techniques on excel? http://www.gummy-stuff.org/cointegration.htm

5. ### stephencrowley

Multivariate cointegration is too tough for excel to handle.. you'll need some more specialzed software, or get matlab and checkout the library at http://www.spatial-econometrics.com

6. ### granville

Could one of you here 'bite size' / explain cointegration for me? What is it used for in layman's terms?

Granville

7. ### granville

Got it... the 'gummy' material was easier to digest then the wall of math in the other paper.

It looks to me like this stuff would be very useful in pairs trading.

8. ### mahras2

Thanks Stephen. I do have matlab but have never really played with it all that much. I will check out that link and see if I can get the calculations done in Matlab.

ET IS FREE BECAUSE OF THE FINANCIAL SUPPORT FROM THESE COMPANIES: