Report
The Report() function returns the output from a Quintessence report. The function provides the required parameter values as set up in the report configuration.
ReportAsync() works the same way as the Report() function but calculates in the background (asynchronously from Excel). This is useful for larger reports, as Excel work can continue while the report computes. Once the data is ready it is displayed in Excel.
Syntax
Report (Report, Headers, Arg1, Arg2, Arg3 … Arg16)
| Report | The name of a Quintessence report |
| Headers | This parameter has been deprecated and can be left blank. |
| Arg1 … Arg16 | The values of the parameters, in order, as set up in the report configuration |
Note:
Input parameters can consist of Quintessence functions. This includes functions that return ranges in cases where a parameter value can be a range.
Examples
Note:
How your system administrator configured Quintessence determines which function parameters are required. In most implementations, administrators configure functions so that certain parameters default to specific values when left blank.
An example report is set up in the Quintessence application to return instrument statistics for a specified portfolio. The report can be accessed from Excel and takes the following parameters:
Entity code, Start date and End date:
| Function |
| =Report(“InstrumentStatsReport”, ,”ABC123″, “24 June 2015”, “27 June 2015”) |
| Output | ||||
| Minimum | Maximum | Average | Median | |
| XDU | 1343 | 1360 | 1351 | 1350 |
| VRR | 825 | 850 | 838.334 | 840 |
| LEF | 18607 | 19359 | 18981.667 | 18979 |
| THT | 28200 | 28657 | 28452.334 | 28500 |
| GTE | 10793 | 11036 | 10924 | 10943 |
| JWQ | 8633 | 8823 | 8738 | 8758 |
Example 2. Market value report
An example report is set up in the Quintessence application to return market values for specified entities on a specified date. This report takes the following parameters: Entity code(s), Date:
| Function |
| =Report(“MarketValueReport”, ,”LMN345″, “1 May 2015”) |
| Output | |||||
| Fund | Instruments | Sector | Subsector | Date | Value |
| LMN345 | GMP | Basic materials | Platinum | 2015/10/01 | 26401 |
| LMN345 | QGW | Consumer goods | Furnishing | 2015/10/01 | 9189 |
| LMN345 | XDU | Consumer services | Airlines | 2015/10/01 | 8217 |
| LMN345 | JWQ | Financials | Banks | 2015/10/01 | 2407 |
| LMN345 | UAG | Industrials | Marine transportation | 2015/10/01 | 2157 |