A slow RSI.I'm trying to develop a system that is long something until the price goes parabolic. I have had no luck with that Parabolic SAR, is there any indicator designed to measure price acceleration?
There are some issues with using these indicators in my dataset (a lot of stocks go parabolic quite early in the data so there is not much time to calculate previous results for the indicators).
What I was thinking was to convert the stock price over a certain period of time into an angle, the closer that angle is to 90 degrees, the more parabolic. Does anyone know how to do this conversion in excel?
I solved the problem with the formulaThe Parabolic SAR is quite flexible, and has 3 parameters to it. Have you understood and worked on each one?
A price|time combination becomes a single point on a graph of time. An angle is a ratio, not a single point.
If what you wish is a function which 'increases at an increasing rate' (something which could be termed 'parabolic'), then you want an exponential function -- as in FVn = PV*(1+r)ⁿ
I solved the problem with the formula
=DEGREES(ATAN(LINEST(J4:J5)))
J4 is the Price 1 and J5 if the subsequent price in which I want to see the angle. Its working quite well in terms of showing me when a parabolic move is happening
)%%I'm trying to develop a system that is long something until the price goes parabolic. I have had no luck with that Parabolic SAR, is there any indicator designed to measure price acceleration?