elCashFlow
Summary
The elCashFlow function retrieves the cash flows of your positions.
Examples
=elCashFlow("expected-values","positions","USP1400MAC21",1,"USD","2025-09-18","2028-01-01","daily",TRUE,TRUE,FALSE,FALSE)
Retrieves expected cashflows for a given asset from 2025-09-18 until 2028 with daily time aggregation.
=elCashFlow("expected-values","positions",A1,A2,"USD","2025-09-18","2028-01-01","daily")
Retrieves the metric for the identifier in a cell.
Syntax
elCashFlow(measure, granularity, assetIds[], quantities[], currency, startDate, endDate, timeAggregation, displayCashflowType, displayDates, allDates, rowDirection)
| Argument name | Default | Description |
|---|---|---|
| measure | The measure to use (Allowed values: expected-value) | |
| granularity | The granularity at which the results should be calculated (individual asset, portfolio). | |
| assetIds | Single or multiple asset identifiers (ISIN, FIGI, currency ISO, Edgelab ID). | |
| quantities (Optional) | 1 | quantities of the assets. |
| currency | The ISO code of the reference currency for deriving the calculation results. Specify "local" to use the instruments native currency where appropriate. It is mandatory to specify a currency when the granularity is "portfolio". | |
| startDate (Optional) | Current date | The end of the window or the period to use (Format: YYYY-MM-DD). |
| endDate (Optional) | Maximum date | End of the measure period (Format: YYYY-MM-DD or Yx, Mx e.g. Y5 - 5 years, M3 - 3 months). |
| timeAggregation (Optional) | daily | Time aggregation (Allowed values: daily, monthly) |
| cashflowType (Optional) | FALSE | Whether to display the type of the cashflows |
| allDates (Optional) | FALSE | Whether to generate all the dates |
| displayDates (Optional) | TRUE | Whether to display the date along the cashflows |
| rowDirection (Optional) | TRUE | Whether dates are in row direction |