A.I.M. Users Bulletin Board

[AIMStudent]

Hi Vitaali, Excel spreadsheet...

The calculation would be:

Dollar Amount = [Desired % * ($ High Price - $ Low Price)] + $ Low Price

To prove using your example:

[ 0% * ($43 - $16)] + $16 = $16
[100% * ($43 - $16)] + $16 = $43

For the Log case (e.g. Dollar Amount returned as LOG):

Dollar Amount as Log = [Desired % * (LOG($ High Price) - LOG($ Low Price))] + LOG($ Low Price)

Hope that helps.

-AIMStudent