InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
Subscribe Login/Register
S&P 500
5,487.03
(
0.25%
)
US TECH 100
19,430.40
(
0.14%
)
Dow Jones
38,834.86
(
0.15%
)
Brent Oil
84.70
(
-0.11%
)
Bitcoin
64,869.44
(
-0.41%
)
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: AIMStudent post# 45068

Sunday, 02/14/2021 10:35:10 PM

Sunday, February 14, 2021 10:35:10 PM

Post# of 47132
Hi AIMStudent, Excel spreadsheet.
You were right, I did confuse dollar amount and Log value. After applying your fix the equation started to work beautifully. Thank you so much again. You saved me from a lot of frustration. Some day I'd like to understand math as well as you.

One more question. How do I combine these two equations into one:
10^2.0 = $100 and [100% * (LOG(100.00 - LOG(1.00))] + LOG(1.00) = 2.0
so that they take up only one cell in my spreadsheet? Right now I can only do it in two steps, and two cells.

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