Day Count Basis in Excel

R

RICH09

New Member
Joined
Jun 6, 2011
Messages
2
Hi, could anyone please advise how the day count basis works in excel? I have an example and use PRICE() funtion. Strangely, I can't replicate by choosing day count basis=2 (act/360) and 3 (act/365) and when you look into act/360, the price even returns more than 100.

=PRICE("2012/12/22","2012/12/24",0,0.1,100,2,2)

ps. btw, i have checked HELP file and seems not matching. Thanks
 
Last edited:

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Sort by date Sort by votes
In my help on PRICE it says:

Important Dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2008,5,23) for the 23rd day of May, 2008. Problems can occur if dates are entered as text.
Click to expand...

So before going any further I would suggest you do not enter dates as text - then post again if you still have problems.

ξ
 
Upvote 0
xenou said:
In my help on PRICE it says:



So before going any further I would suggest you do not enter dates as text - then post again if you still have problems.

ξ
Click to expand...

Thanks. It returns the same value when I changed to date value. I don't think it's text format to cause the problem.
 
Upvote 0
Okay,

When you say you "can't replicate by choosing day count basis=2 (act/360) and 3 (act/365)" exactly what is it that you cannot replicate?

Also, why is the rate in this problem zero? That seems an unusual rate.

Note that it *is* possible to for a price to be more than 100 (i.e., bond is selling at a premium).

ξ
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
An Excel for calculating the days off of my work.
Replies
4
Views
298
dkar75
D
P
  • Question
workday, but even more flexible
Replies
6
Views
374
KRice
K
S
  • Question
To count the number of profitable days when there are multiple entries for the same day with profits and losses
Replies
6
Views
373
Dave Patton
D
P
  • Question
Excel pivot with milestones across the various dates to show as a months on the left and a count of that milestone on the right
Replies
1
Views
229
POLACOLOCO
P
A
  • Solved
Counting Sick day occurrences based on name
Replies
1
Views
286
Kerryx
K

Forum statistics

Threads
1,215,746
Messages
6,126,638
Members
449,325
Latest member
Hardey6ix

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top