| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Financial Function : Price
When it comes to the price function, there is this act/act and act/365. Can anybody explain to me how does this work for excel. Price(Settlement,Maturity,Rate,Yield,Redemption,Fr equency,Basis) Settlement = 31 Mar 2006 Maturity = 14 Jul 2014 Rate = 6% Yield = 5% Redemption = 100 Frequency = 2 Basis : Act/365 = 3 Act/Act = 1 I am trying to do a manual calcualtion based on these 2 basis. I managed to recalculate the Act/Act but i cant do the Act/365. I believe it has something to do with my period calcualtion.  Can anybody help me out? Thanks in advance.:) -- Infinity ------------------------------------------------------------------------ Infinity's Profile: http://www.excelforum.com/member.php...o&userid=32725 View this thread: http://www.excelforum.com/showthread...hreadid=525601 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value or function as result.... | Excel Worksheet Functions | |||
| Date & Time | New Users to Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
