Sum of Squares

[petter]

Hi, I'm doing my master thesis now and I wondered if there is a way to calculate the sum of squred differenceof 87 stocks. I want the sum of AB, AC... BC, BD etc. Im doin pairs trading as topic

[EViews Gareth]

You'll have to either calculate each one manually, or write a quick program with a for loop to loop through them, using the @sumsq function.

[petter]

is it difficult to write such a program?

[EViews Gareth]

No.

Read the programming chapter of the Command and Programming Reference, and read through this thread:
viewtopic.php?f=5&t=1638

[petter]

is it possible to use this?
https://support.office.com/en-gb/articl ... n-GB&ad=GB

[EViews Gareth]

If you were using Excel...

[petter]

I can't figure out the programming, could you help me out?