axys tips and tricks - cssi · advent users group december 2005 diane herrera client server...

Advent Users GroupDecember 2005

Diane HerreraClient Server Specialists, Inc.

dherrera@cssi.org

Axys Tips and Tricks

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

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

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

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

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Yes…it can be done• Performance by Security with Adjusted IRR

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Cash Adjusted Performance• Cash Allocated Across Equity/Fixed

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Managed Assets

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

After Tax performance

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Today’s presentation• Trading Restriction Report• Creating Groups of Composites• Take notes• Presentation will be available for download

– Location– Instructions– Special password

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Create a Transaction report in RPW

• Make it Management Mode– Define Options

Management

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Add Columns

• Portfolio Code

• Post Date

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Filter on Post Date

• Data Filter

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Filter Out all except by/sl/li/lo

• Data Filter

• Watch parentheses

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Change Prompt on Dialog Box

• Define Dialog Text Ask Text

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Create Column for Manager ($mgr)

• Define

Columns User

Defined Create

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Add Column for Manager ($mgr)

• Define

Columns

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Create an enm file in Axys

• File New Added Security Data (number *.enm)

• Add list of restricted securities

• Value entered is not important except for use in report

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

In RPW, User Defined Column• #nfrestrict• “restrict” is the

filename of our enm file

• Create the user defined column, then add to report

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

In RPW, User Defined Column

• Restrplus column uses the “restricted” column

• Need this column for filter

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Add Filter

• Filter on• Restrplus = 1

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Test

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Cleanup• Remove “Restricted” columns• Change report title• Fix column spacing (1st/2nd)

Macro

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Script

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Creating Groups of Composites• File New

Grp• Navigate to

cpg folder• Filter *.cpg

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Add All• Important to

Add All• Otherwise,

won’t work• Then click

OK to Save

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Open the grp• Remove the

ones you don’t want

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Edit Replace• Replace

path name with &

• Replace All

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

All Done• Save and

Close

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

If you want to learn more…• AUG Newsletter• Free White papers on www.cssi.org• Report Writer Pro• Automating Axys• Connection Website

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

To Get This Presentation

CSSI Client Server Specialists, Inc. www.cssi.org

Tel: (610) 992-9287Fax: (610) 992-9289

Q&A