PairTradeFinder

L

lordoftrades

Hi

I have a software called PairTradeFinder, and I try to replicate the correlation value. I have an excel-sheet with exactly the same values as in PTF, and I use built-in formula for CORREL in Excel.

I cannot get the same values as in PTF, does anyone know how this correlation is calculated in PTF software???

I have tried to split the data into groups of 100days, but when I check against different pairs my results seems random compared to PTF.

I have tried to measure correlation on open, on highs, on lows...

Let me know if you have any ideas on how to replicate the correlation formula. :-)
 
Hi , I am from India & also took a 1 month trial of pair tradefinder , it started some 3-4 day back . I am still working on it , I will let you know if I get some ......
 
Quote from Mukul:

Hi , I am from India & also took a 1 month trial of pair tradefinder , it started some 3-4 day back . I am still working on it , I will let you know if I get some ......
More...

Thanks. I have worked out an excel-sheet that can update the SQL database directly, such that I can add all 205 sectors, and the stocks without typing them step by step.

I'll PM you my email.

Have a nice day :-)
 
You must log in or register to reply here.
Back
Top