390 likes | 398 Views
Advent Users Group Atlanta, May 2005 Diane Herrera Client Server Specialists, Inc. dherrera@cssi.org. Spicing Up Your Performance Reports. CSSI. About CSSI. Founded in 1995 Focus on customizing and automating Axys Utilities Account Translation Utility – Helps with unsupervised assets
E N D
Advent Users GroupAtlanta, May 2005Diane HerreraClient Server Specialists, Inc.dherrera@cssi.org Spicing Up Your Performance Reports
CSSI About CSSI • Founded in 1995 • Focus on customizing and automating Axys • Utilities • Account Translation Utility – • Helps with unsupervised assets • Helps separate equity and fixed income • ClientBuilder – helps manage clients and groups • Management Fee Utility – • Feeds into Quickbooks • Uploads to custodian • Reconciliation utilities Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI About CSSI • Interfaces, Interface cleanup • Scripting • Workflow analysis and recommendations • Custom reporting • See free reports on www.cssi.org • If you don’t find what you’re looking for…ask • Training • See free white papers on www.cssi.org • Training classes Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Today’s presentation – Performance • Take notes • Presentation will be available for download • Location • Instructions • Special password Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Create a Perf report in RPW • Change rows • Turn off “Hide When Zero” • Change Portfolio Value to all Text • Remove ACB, IRR • Add Quarter To Date column header • Three Lines – Date1, “To” , Date2 • Row Property Column Header • Add Column Underline as row of dashes Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Create a Perf report in RPW • Remove Header lines • Add column for dollar sign • Change Options to Single Page • Save as QTDPerf.rpw Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Create a 2nd Perf report in RPW • Start with QTDPerf.rpw • Remove Column1 • Remove Column2 • Save as YTDPerf.rpw Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Copy YTDPerf.rpw to .rep • Using Windows Explorer • Navigate to your rep folder • Locate ytdperf.rpw • Make a copy • Name the copy ytdperf.rep Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Open YTDPerf.rep in Notepad • Add two lines of code Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Create a macro • Put both reports on a single page • Add Compound Report Heading • Save • Then run the macro… Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Result • …a two period performance report • QTD • YTD Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Make another copy of ytdperf.rpw • Using Windows Explorer • Navigate to your rep folder • Locate ytdperf.rpw • Make another copy • Name this copy oneyear.rep Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Open oneyear.rep in Notepad • Add two lines of code Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Add oneyear.rep to macro • Put all three reports on a single page • Save • Then run the macro… Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Result • …a three period performance report • QTD • YTD • 12 months Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI We’re not done yet… • Make a copy of perhsum.rep • use Windows Explorer • Navigate to your rep folder • Locate perhsum.rep • Make a copy • Name the copy _myphsum.rep Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Add this report to your macro • Select same three time periods • QTD • YTD • OneYear • Same page as the other three reports • Put it at the bottom • Remove header information • Save and Run… Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Result • A TWR line at the bottom of the report • Needs a little bit of work… Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Open _myphsum.rep in Notepad • Change format c to format a • Change Portfolio to Time Weighted Return • Save • Run Macro Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Result • Still more work to do Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Open _myphsum.rep in Notepad • Change 11 to 30 • Two places • Save • Run Macro Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Result • Getting closer… Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Open _myphsum in Notepad • Change 32 to 49 • And 20 to 22 Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Result • Ta Da! • From here, adjust the YTD and One Year performance columns in the macro layout Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI A trick with perhsum.rep • You already know about $row1 to $row9 Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI You can keep going… • $rox0 to $rox9 • $roy0 to $roy9 • $roz0 to $roz9 Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI If you want to learn more… • Report Writing Language Programmer’s Guide • Available on Advent’s connection website • REPU34 • REPU351 • AUG Newsletter • Free White papers on www.cssi.org Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Training Classes… • Intro to Replang Programming • All about billing statements • Average market value • Fee deduction message • Writing to files • Trade blotters • Groups • Text files Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Training Classes… • Intermediate Replang Programming • Sorting • Turning portfolio style reports into management reports • 353-like • 406-like • Family Billing Statements • Performance History Reports Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Training Classes… • Advanced Replang Programming • Graphing • Hyperlinks • Complicated reports • 635-like Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Yes…it can be done • Performance by Security with Adjusted IRR Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Cash Adjusted Performance • Cash Allocated Across Equity/Fixed Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Managed Assets Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI After Tax performance Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI To Get This Presentation Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Enter Userid and Password • Conference code -- asdf Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Download Presentation Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289
CSSI Q&A Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289