ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   yearfrac (https://www.excelbanter.com/excel-discussion-misc-queries/201005-yearfrac.html)

lena_form

yearfrac
 
Hello!
Sorry my english :)
Who can tell me what's the diference between the several basis number
--
HC

Pete_UK

yearfrac
 
I'm sorry, but can you try again? I don't understand what you want.

Pete

On Sep 2, 4:43*pm, lena_form
wrote:
Hello!
Sorry my english :)
Who can tell me what's the diference between the several basis number
--
HC



Fred Smith[_4_]

yearfrac
 
Basis 0 = NASD number of days in range / 360
Basis 1 = actual number of days in range / actual number of days in year
(365 or 366)
Basis 2 = actual number of days in range / 360
Basis 3 = actual number of days in range / 365
Basis 4 = European number of days in range / 360

Basis 0 and 4 really = number of months in range / 12. If you have a whole
month in the range (ie from the 1st of one month to the 1st of the next),
you will always get a Yearfrac of 0.083333 (ie, 1/12), regardless of the
number of days in the month. For periods of less than one month, Basis 0 and
4 = Basis 2.

Basis 0 and 4 differ in determining how long a month is. Under Basis 0, one
month is 30 days, so from Jan 1 to Jan 31 is a full month, therefore a
Yearfrac of 0.083333. Under Basis 4, one month is a full calendar month, so
Jan 1 to Jan 31 is .080556.

Regards,
Fred.


"lena_form" wrote in message
...
Hello!
Sorry my english :)
Who can tell me what's the diference between the several basis number
--
HC




All times are GMT +1. The time now is 04:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com