| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Difference in Values for Price function in Excel
Hi I am trying to calculate the Price of a bond using the function as pe the Excel and calculating the price manually as per the formula give in excelhelp however there appears to be a difference in the same. can anyone help me on this please? Best Regards Abh -- abhi_2 ----------------------------------------------------------------------- abhi_23's Profile: http://www.excelforum.com/member.php...fo&userid=3051 View this thread: http://www.excelforum.com/showthread.php?threadid=50162 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Difference in Values for Price function in Excel
Might be more helpful if you give both sets of equations so we can help.
Unless someone already knows and can answer your question without more info. "abhi_23" wrote: Hi I am trying to calculate the Price of a bond using the function as per the Excel and calculating the price manually as per the formula given in excelhelp however there appears to be a difference in the same. can anyone help me on this please? Best Regards Abhi -- abhi_23 ------------------------------------------------------------------------ abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511 View this thread: http://www.excelforum.com/showthread...hreadid=501625 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Difference in Values for Price function in Excel
Hi GB I am attaching the sample file for your reference. Any inputs are welcome. Best Regards Abh +------------------------------------------------------------------- |Filename: Sample for query.zip |Download: http://www.excelforum.com/attachment.php?postid=4223 +------------------------------------------------------------------- -- abhi_2 ----------------------------------------------------------------------- abhi_23's Profile: http://www.excelforum.com/member.php...fo&userid=3051 View this thread: http://www.excelforum.com/showthread.php?threadid=50162 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Difference in Values for Price function in Excel
Hi I have attached the help document of the price function in excel, If any one can help me with this. Best Regards Abhijit +-------------------------------------------------------------------+ |Filename: Sample for query.zip | |Download: http://www.excelforum.com/attachment.php?postid=4227 | +-------------------------------------------------------------------+ -- abhi_23 ------------------------------------------------------------------------ abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511 View this thread: http://www.excelforum.com/showthread...hreadid=501625 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Difference in Values for Price function in Excel
For one reason or another I am unable to get to the files that are attached
to your posts. Maybe someone else still can. :\ "abhi_23" wrote: Hi I have attached the help document of the price function in excel, If any one can help me with this. Best Regards Abhijit +-------------------------------------------------------------------+ |Filename: Sample for query.zip | |Download: http://www.excelforum.com/attachment.php?postid=4227 | +-------------------------------------------------------------------+ -- abhi_23 ------------------------------------------------------------------------ abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511 View this thread: http://www.excelforum.com/showthread...hreadid=501625 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Difference in Values for Price function in Excel
Hi, I have made some changes to the attachments so as to make me query to be understood better. Anyone who can help me on this. just to brief you people again on this my query is as follows: I am trying to calculate the Price of a bond using the price formula there apprears to be a difference in the results when the Price is calculated as per the formula and when one calculates the Price using the Definition of the Formula ( Excel help ) manually. Refer the attachments for the sample calculations as well as the formula definitions Thanks Abhi +-------------------------------------------------------------------+ |Filename: Sample for query.zip | |Download: http://www.excelforum.com/attachment.php?postid=4234 | +-------------------------------------------------------------------+ -- abhi_23 ------------------------------------------------------------------------ abhi_23's Profile: http://www.excelforum.com/member.php...o&userid=30511 View this thread: http://www.excelforum.com/showthread...hreadid=501625 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is there 0.01 difference when I set up sum function in excel? | Excel Worksheet Functions | |||
| Help: Need Excel formula to return correct price from price history table | Excel Discussion (Misc queries) | |||
| Seperating Rows By Price Difference | New Users to Excel | |||
| Increasing values in Price column | Excel Worksheet Functions | |||
| Price function difference in Output formula vis a vis Manual Calculation | Excel Worksheet Functions | |||
Linear Mode
