InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,487.03
(
0.25%
)
US TECH 100
19,526.80
(
0.61%
)
Dow Jones
38,834.86
(
0.15%
)
Brent Oil
84.66
(
-0.05%
)
Bitcoin
65,693.09
(
1.12%
)
Post# of 47132
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Vitaali

Send PM Follow Ignore
Followers 0
Posts 70
Boards Moderated 0
Alias Born 01/15/2020

Vitaali

Re: None

Monday, 01/20/2020 10:58:07 AM

Monday, January 20, 2020 10:58:07 AM

Post# of 47132
Hi everybody! I’m building spreadsheet to help with AIM investing. I'm trying to figure out the price percentage in relationship to the trading range. Maybe for someone on this board this problem would be trivial. Your help would be greatly appreciated.

Imagine I have a price range that consists of two values. 4 is the bottom of the range and 15 is the top. 4 is 0% and 15 is 100% of the range. Let's introduce a 3rd value. It's somewhere in between the range. Let's say it's 7. How would I express number 7 as a percentage in relationship to that range. How far is 7 from being at 100% of the range? What is the math in calculating this?

Thanks for your help,

Vitali
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

Join the InvestorsHub Community

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.

Sign Up