According to wiki PI ratio 3.14 defines the multiple between the total winding
length of a river and the straight as the crow flies distance from the source
of the river to the mouth of the river. This would imply that the PI ratio
would be useful in the stockmarket where share movements are comparable to a
river.
I need help with the relevant formula to determine price points where the PI
ratio of 3.14 meets the regression line equivilant of the straight as the crow
flies distance. Also I thought that half of the PI ratio 3.14 divided by two
ie. 1.57 might define price extremes before the price returns to the regression
equivilant ratio of PI 3.14. Any advice regarding the regression price being
met and the price extremes would be helpful.
I've tried this formula which has not yielded anything useful:-
When(C,>=,ValueWhen(1,When(Sum((H-L),30),>=,(C-Ref(C,-29)*3.14)),C)) AND
When(Ref(C,-1),<,ValueWhen(1,When(Sum((H-L),30),>=,(C-Ref(C,-29)*3.14)),C))
