13.9.3 From Instrument to Instrument
Instrument-to-Instrument is a common use case.
- For each instrument, calculate and update a target column as a fixed relationship to some other column. For example, calculate a loan loss reserve as a fixed percentage of the current balance of each mortgage loan.
- For each instrument, calculate a rate times a balance and multiply it by an accrual basis factor and divide it by 100 to update a revenue or expense column. This allocation uses Expression as a Source where the expression contained a rate times balance calculation. The Static Driver would consist of (1) an accrual basis macro and (2) and factor of 0.01.