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: