This reference lists 1 DAX financial functions, with frequently used functions marked 🔥. Each function includes syntax, an example and parameter notes.
| Function | Description | Syntax | Example |
|---|---|---|---|
ACCRINT |
Returns the accrued interest of a security that pays periodic interest | ACCRINT(<issue>, <first_interest>, <settlement>, <rate>, <par>, <frequency>[, <basis>[, <calc_method>]]) |
ACCRINT(DATE(2020,1,1), DATE(2020,7,1), DATE(2020,12,31), 0.05, 1000, 2) |
From Online Toolbox (www.vba.net)