The Factsheet report is really five reports in one: a relative performance summary, growth of 10k, asset allocation, top weights, and top returns. Both tabular formats and charts are used to represent the data.
This report can be run on any month end.
Advanced Report Profiles
Egl Prf Performance Factsheet
Options
None
Data Used by Report
The following table shows data used by the report.
| Report Element | Data Mart Table | Data Mart Column | Underlying Field Attribute |
|---|---|---|---|
Fund Name | FUND_SUMMARY | ENTITY_NAME | eglEnt-Entityname |
Fund Base Currency | FUND_SUMMARY | BASE_CURRENCY | eglEnt-EntityBaseCurrency |
Benchmark | FUND_SUMMARY | BM1_NAME | eglPan-Bm1Name |
Inception Date | FUND_SUMMARY | INCEPTION_DATE | eglEnt-InceptionDate |
Returns Section | |||
Account Returns - Month to Date | PERF_TOTAL_SUMMARY | MTD_RETURN | eglPlk-D-MtdGrossReturn |
Account Returns - Quarter to Date | PERF_TOTAL_SUMMARY | QTD_RETURN | eglPlk-D-QtdGrossReturn |
Account Returns - Year to Date | PERF_TOTAL_SUMMARY | YTD_RETURN | eglPlk-D-YtdGrossReturn |
Account Returns - 1 Year | PERF_TOTAL_EXTENDED | Y1_RETURN | eglPlk-M-Y01GrossReturn |
Account Returns - 3 Years (Ann.) | PERF_TOTAL_EXTENDED | Y3A_RETURN | eglPlk-M-Y03aGrossReturn |
Account Returns - 5 Years (Ann.) | PERF_TOTAL_EXTENDED | Y5A_RETURN | eglPlk-M-Y05aGrossReturn |
Account Returns - 10 Years (Ann.) | PERF_TOTAL_EXTENDED | Y10A_RETURN | eglPlk-M-Y10aGrossReturn |
Account Returns -Since Inception (Ann.) | PERF_TOTAL_EXTENDED | ITDA_RETURN | eglPlk-D-ItdaGrossReturn |
Benchmark Returns - Month to Date | PERF_TOTAL_SUMMARY | MTD_BM1_RETURN | eglPlk-D- Bm1MtdGrossReturn |
Benchmark Returns - Quarter to Date | PERF_TOTAL_SUMMARY | QTD_BM1_RETURN | eglPlk-D- Bm1QtdGrossReturn |
Benchmark Returns - Year to Date | PERF_TOTAL_SUMMARY | YTD_BM1_RETURN | eglPlk-D- Bm1YtdGrossReturn |
Benchmark Returns - 1 Year | PERF_TOTAL_EXTENDED | Y1_BM1_RETURN | eglPlk-M- Bm1Y01GrossReturn |
Benchmark Returns - 3 Years (Ann.) | PERF_TOTAL_EXTENDED | Y3A_BM1_RETURN | eglPlk-M- Bm1Y03aGrossReturn |
Benchmark Returns - 5 Years (Ann.) | PERF_TOTAL_EXTENDED | Y5A_BM1_RETURN | eglPlk-M- Bm1Y05aGrossReturn |
Benchmark Returns - 10 Years (Ann.) | PERF_TOTAL_EXTENDED | Y10A_BM1_RETURN | eglPlk-M- Bm1Y10aGrossReturn |
Benchmark Returns -Since Inception (Ann.) | PERF_TOTAL_EXTENDED | ITDA_BM1_RETURN | eglPlk-D-Bm1ItdaGrossReturn |
Value Added - Month to Date | PERF_TOTAL_SUMMARY | MTD_RETURN_VS_BM1 | eglRca -D-MtdGrossReturn VsBm1 |
Value Added - Quarter to Date | PERF_TOTAL_SUMMARY | QTD_RETURN_VS_BM1 | eglRca -D-QtdGrossReturn VsBm1 |
Value Added - Year to Date | PERF_TOTAL_SUMMARY | YTD_RETURN_VS_BM1 | eglRca -D-YtdGrossReturn VsBm1 |
Value Added - 1 Year | PERF_TOTAL_EXTENDED | Y1_RETURN_VS_BM1 | eglRca -M-Y01GrossReturn VsBm1 |
Value Added - 3 Years (Ann.) | PERF_TOTAL_EXTENDED | Y3A_RETURN_VS_BM1 | eglRca -M-Y03aGrossReturn VsBm1 |
Value Added - 5 Years (Ann.) | PERF_TOTAL_EXTENDED | Y5A_RETURN_VS_BM1 | eglRca -M-Y05aGrossReturn VsBm1 |
Value Added - 10 Years (Ann.) | PERF_TOTAL_EXTENDED | Y10A_RETURN_VS_BM1 | eglRca -M-Y10aGrossReturn VsBm1 |
Value Added -Since Inception (Ann.) | PERF_TOTAL_EXTENDED | ITDA_RETURN_VS_BM1 | eglRca -D-ItdaGrossReturnVsBm1 |
Growth of 10K Section | |||
Account Return Since Inception | PERF_TOTAL_EXTENDED | ITD_RETURN | eglPlk-D-ItdGrossReturn |
Benchmark Return Since Inception | PERF_TOTAL_EXTENDED | ITD_BM1_RETURN | eglPlk-D-Bm1ItdGrossReturn |
Asset Allocation Section | |||
Asset Class | PERF_ASSETCLASS_MTD | INVESTMENT_TYPE_GRP | The name of the grouping in the Asset Class group table |
Weight | PERF_ASSETCLASS_MTD | D1_WEIGHT | eglPlk-D-GrossWeight |
Top 5 Weight Section | |||
Description | SECURITY_DETAILS | ISSUE_NAME | eglSec-IssueName |
Weight | PERFORMANCE_DETAILS | MTD_BF_SCNTR | eglGag-Mtd-Bf-BaseCondFnd |
Report DLL
The report DLL is named PerformanceFactsheet.dll.
Add Comment