Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Treasury Bond Pricing conversion
As you may know that T-Bonds price format is xxx-xxx (e.g 110-16 which is equivalent to 110 16/32 or 99-245 which is equivalent to 99 24.5/32) Now I need to do some calaculaltions while trading Bonds and I want to do in excel 03. I was given a hint that I need to convert the above price format first in decimal value and then format the result in xxx-xxx. e.g 110-16 is in cell A1 then formula for converting to decimal would be: =Left(A1,3)+Right(A1,3)/320 Since I have been out of touch with excel for long time I am having hard time how to format back in xxx-xxx. So I am giving an example below to do calculations to do price difference: say cell A1 has value of 110-160 say cell B1 has value of 99-245 The answer is 10-235. Now how can I get this calculations done in excel. Detail formulas would be appreciated. Thank YOu -- pakeez ------------------------------------------------------------------------ pakeez's Profile: http://www.thecodecage.com/forumz/member.php?userid=278 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=92522 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return on a bond | Excel Worksheet Functions | |||
Smart Tag Treasury | Excel Discussion (Misc queries) | |||
Need help with bond yields | Excel Discussion (Misc queries) | |||
Need help with bond yields | Excel Worksheet Functions | |||
I need a Treasury Bill calculator | Excel Discussion (Misc queries) |