pioneerbank
New Member
- Joined
- Sep 14, 2011
- Messages
- 2
I'd like to write my own functions to calculate effective yield based on either 30/360 or actual/actual, but the yield function is not what I'm looking for.
My known variables are average balance and YTD interest. For the 30/360 function I would divide by the number of months and multiply by 12, then divide by the average balance to find the effective yield.
For the actual/actual function, I would divide by the number of days (e.g. start date=12/31/10, end date=08/31/11, date difference "d") then multiply by 365 and divide by average balance.
I can do this manually once for each formula and just copy, but I'd prefer to write functions for them if anyone knows how.
My known variables are average balance and YTD interest. For the 30/360 function I would divide by the number of months and multiply by 12, then divide by the average balance to find the effective yield.
For the actual/actual function, I would divide by the number of days (e.g. start date=12/31/10, end date=08/31/11, date difference "d") then multiply by 365 and divide by average balance.
I can do this manually once for each formula and just copy, but I'd prefer to write functions for them if anyone knows how.
