Note: In order to use the spreadsheet examples, you need to download Business Functions
|FWeightSpreadH (Time, Base, Finish, Total, FromDates, Weights, [DatesHistory], [PmtsHistory], [DayCount], [Periods], [ProjMode])|
|FWeightSpread that uses historical data|
|FWeightSpreadH does a standard FWeightSpread, after allowing for PmtsHistory. In effect it does a MkPmts and then a FWeightSpread after adjusting for the payments made. The FWeightSpread starts upon the last date in the DatesHistory which has a non|
|Auto Array Function|
It is most important to realise over what timeperiod the remaining amounts are spread. The start of the forecast is the date of the last history payment that has a non-zero payment. The finish of the forecast is the date specified by Finish. This means that if you want zero overlap between the historic and future payments, you should put a small non-zero amount as the last historic payment, say 1e-9. That will mean that the next date will be the start of the forecast.