1 / 39

Spicing Up Your Performance Reports

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

timothynelson
Download Presentation

Spicing Up Your Performance Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advent Users GroupAtlanta, May 2005Diane HerreraClient Server Specialists, Inc.dherrera@cssi.org Spicing Up Your Performance Reports

  2. 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

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. CSSI Result • …a two period performance report • QTD • YTD Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  12. 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

  13. 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

  14. 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

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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

  20. CSSI Result • Still more work to do Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  21. 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

  22. CSSI Result • Getting closer… Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  23. 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

  24. 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

  25. 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

  26. 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

  27. 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

  28. 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

  29. 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

  30. 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

  31. 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

  32. CSSI Cash Adjusted Performance • Cash Allocated Across Equity/Fixed Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  33. CSSI Managed Assets Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  34. “Super Category” performance

  35. CSSI After Tax performance Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  36. CSSI To Get This Presentation Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  37. CSSI Enter Userid and Password • Conference code -- asdf Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  38. CSSI Download Presentation Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

  39. CSSI Q&A Client Server Specialists, Inc. www.cssi.org Tel: (610) 992-9287 Fax: (610) 992-9289

More Related