Thank you AIMStudent and Tom for your input. I've programmed this formulat into my spreadsheet and it worked great. Does it make a big difference whether you use log scale or linear scale to figure out the percentages? I've noticed at the bottom of the range the difference can be substantial - 19 points between the two scales.
Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.