Using Stochastic formula find highest or lowest

Formula for stochastic is (Last Number(x) - Lowest Low)/(Highest High - Lowest Low) * 100.
I want to find what is x when the answer is 0/100.
I can use this formula and fill in the x value with any number and slowly find the highest or lowest value for x.

I wonder if you can reverse the formula and put in the excel.

Said my working data is 1, 2, 3, 4, 5, x. To get 0, x is 1 and below. To get 100, x is 5 and above.

Thank you for your help.

This was put up yesterday, viewed 24 times but no reply yet.

HTML Code: 

Originally Posted by MrShorty

I will preface by saying that I am not familiar with a "stochastic formula". I see from Wikipedia that some financial analysts use a "stochastic oscillator" function when deciding when to buy and sell, and perhaps this is the function you are referring to.

Based on what you have posted here, simple algebra should be able to solve this function.

y=(lastprice-low)/(high-low) -- solve for lastprice. Can we assume that your algebra skills are up to this solution? Or is it more complicated than this?

If find y, we use (lastprice-low)/(high-low). If I want to find lastprice when y = 0 or 100. I would tried to reverse the formula. But there is lastprice in Lowest and Highest because Lowest and Highest is a range of data. For this post, Said my working data is 1, 2, 3, 4, 5, last price. Hope is clear now.

Thank you, bebo for your interest.

MrShorty;4221427]So is your question more about how to find lowest and highest?

>>>Nope. I looking for the last price when y = 0 or 100. [Coming back from the last part, the answer is yes].

For finding lowest and highest, you should be able to use the MAX() and MIN() functions for the desired range. Once you can find lowest and highest, then it should be simple algebra to find lastprice.

>>>Data of MAX() and MIN() has to include the value x. Thus my data value is 1, 2, 3, 4, 5, x for this post.

A question back at you: Won't last price always equal lowest price for y=0 and always equal highest price for y=100?

>>> Hmmm, you got some point there. If you can plot it in your excel, when x = 1 or below, y = 0; x=2, y=25; x=3, y=50; x=4, y=75; and x=5 and above (that include 100 and more) , y=100. So x is equal to lowest when y=0 and x is equal to highest when y=100. Conclusion is I just have to use MIN() for y=0 and MAX() when y=100. This proof to be true. You replace x with lowest and highest to the equation. (H-L)/(H-L)*100=100. (L-L)/(H-L)*100=0.


What you think?

Good to talk to you. Thank you for your advise. It's very helpful. Have a wonderful day.