A.I.M. Users Bulletin Board

[Vitaali]

Hi Everybody! I’m working on Excel spreadsheet to help me with scale trading calculations. I’ve run into a math problem I can’t solve on my own. I hope maybe someone here knows how to solve it.
I do a lot of stock’s price range calculations. Currently I use the following equation to figure out the percentage of current stock price in relationship to its historic top and bottom range. ( LOG (current price) - LOG (top of range) ) / (LOG (bottom of range) – Log (top of range) ).
With this equation all I do is input the current stock price and it tells me where that price is in relationship to the top and bottom price range expressed in percentage terms. It’s very useful.

Now instead of entering the stock’s price, I want to input a specific percentage of the range and have the equation express it as the stock price. For example, let’s say we have a historic price range of a stock with the low of $16 and the high of $43. $16 is 0% and $43 is 100%. I want to be able to input into the equation a number 29%, and have it tell me where this percentage falls within the price range of $16 and $43. Express 29% as a specific price level. Also, it has to be calculated using a Log scale. Is this doable or unrealistic to accomplish?

Thank you in advance if you can help me with this.