Create Daily Periodic Interest Rate Index from Monthly Summary

BSwan

New member
Joined
Aug 25, 2016
Messages
8
Reaction score
0
Points
0
Hello,

I'm looking for assistance in utilizing PQ to create a tabular dataset that will list the daily periodic interest rate for bank loans, given monthly summaries (typical bank 360 day year used to divide annual rate). Please see the simple example attached.

Any suggestions would be great!

Thanks!

-Blake
 

Attachments

  • DailyInterestExample.xlsx
    12.6 KB · Views: 13
There needs to be a small adjustment to the Calendar table, update the following line:

NumberOfDates = Duration.Days(EndDate-StartDate),

to

NumberOfDates = Duration.Days(EndDate-StartDate) + 1,
 
Hi Comfy,

This is precisely what I was looking for -- thanks very much for your prompt reply to this!
 
You're very welcome.
 
Back
Top