r squared formula?

does anyone know the formula for the r squared indicator. I have got the metastock version but it doesn't make any sense. I just need the mathematical equation to put into a sierra worksheet.

Welcome to T2W 73sand.

The formula is here, and there are also plenty of other formulae in case you feel adventurous.

http://www.mtsu.edu/~stats/dictionary/formula.htm#r

and this link has the formula already done in TradeStation language:

http://klub.chip.pl/tsfp/t-pb-R-Squared.html


R Squared in Metastock is:

pwr(corr(cum(1),C,5,0),2)
or
Pwr(Corr(Cum( 1 ),C,14,0),2)
or, for a smoothed version:
Mov(Pwr(Corr(Cum( 1 ),C,14,0),2)*100,14,S)

I believe that probably the most indepth analysis of this is in book The New Technical Trader by Chande & Kroll. I've not got the book though, so I cannot confirm this.

nothing is ever easy,is it . Transferring meta-stock to sierra seems impossible.The formula has components within components that need to be worked out. Thanks for the formula .Thank god I studied pure maths.