help on PAIR TRADING

do any one have knowledge on pair trading and co-integration

and also with the help of ms excel for auto updation in pair trading

plz help

Hi,
I am also looking for some excel file on pair trading.

Hi

I want keep track of about 100 Scripts.
I want to import the EOD prices for my selected 100 companies in my excel sheet every evening from BSE/NSE.
I shall be grateful if the members can recommend a method to do the same
or uploade the excel file which will automatically update the stock prices
I do now want any fancy analysis or historical data, just plain simple closing prices for my scripts.

Hi

Am uploading excel sheet which is not mine. If it is helping you then its good.
b'cos i don't understand the terminology which plotted their.

http://www.4shared.com/account/home.jsp#dir=6dskvk1G

This for example of pair selection i guess. You can check with following web site will give you more ideas about pair trading
techpaisa. com

Happy trading and thought sharing

Thanks to TraderJi:thumb:

Siva

Dear Siva

Please share the excel sheet, as we r not able to retrieve the same. giving permission error.

Dear Siva

Please send the EXCEL File once again, as it won't downloaded , givig some permission issue.

Thanks in advance....

Hello

Don't know much about trading pairs but looks like BNF & NF co-relation must be deviating big time from historical values.

How would be this pair

Short Nifty Future & Long Bank Nifty Future,

Can anyone in known give more inputs on this?

Thanks

Happy