need excel formula help

abuhar

New member
Joined
Jan 21, 2012
Messages
1
I have a series of numbers that represent derivative prices. the derivative prices are generated as follows: actual price (Future) TYH2 130.08 which is 130.08/32---- actual price (option) call price is 1.15 which is 15/64's. the numbers are given to me as follows for the future price of 130.08 the price generated is 130.25 (8/32 = .25) for the option price 1.16 the price generated is 1.25 (16/64 = .25). In summary 130.08 = 130.25 and 1.16 = 1.25. The problem i need help with is; what formula in excel can i use to isolate the number on the right of the decimal; use that number to multiply by 32 or 64 depending on it being an option or a future and then put it back to the right of the decimal. EX--- "130.25" I want to isolate the .25 multiply it by 32 then put that back on the right of the decimal ending up with the actual future price of 130.08: same with the option call price 1.25 I want to isolate the .25 multiply it by 64 then put that back on the right of the decimal ending up with the actual option price of 1.16. thank you for your help.
 
Last edited:
I have a series of numbers that represent derivative prices. the derivative prices are generated as follows: actual price (Future) TYH2 130.08 which is 130.08/32---- actual price (option) call price is 1.15 which is 15/64's. the numbers are given to me as follows for the future price of 130.08 the price generated is 130.25 (8/32 = .25) for the option price 1.16 the price generated is 1.25 (16/64 = .25). In summary 130.08 = 130.25 and 1.16 = 1.25. The problem i need help with is; what formula in excel can i use to isolate the number on the right of the decimal; use that number to multiply by 32 or 64 depending on it being an option or a future and then put it back to the right of the decimal. EX--- "130.25" I want to isolate the .25 multiply it by 32 then put that back on the right of the decimal ending up with the actual future price of 130.08: same with the option call price 1.25 I want to isolate the .25 multiply it by 64 then put that back on the right of the decimal ending up with the actual option price of 1.16. thank you for your help.

Excel has a function called ROUNDDOWN

This function will give you the number left of decimal point. Then you subtract this number from the original number to get your number right of the decimal point.

suppose your number was 123.25 in cell A1

Then =Rounddown(A1,0) will give you 123
 
excel

to do that in excel, if you have the analysis toolpack installed (tools, add-ins)

use =dollarFR(the number you want to convert, 32 )

rounddown if needed
 
Top