390 likes | 410 Views
Discover how CSSI can help optimize your performance reports by customizing and automating Axys utilities, with tools like Account Translation Utility, ClientBuilder, and more. Learn how to create detailed reports and improve presentation with CSSI's guidance.
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