PerTrac PowerLink PowerLink Installation and User Manual
Contents
1. PerTrac Indexes DataVendorld 17 Fs 17 TimeSeries Monthly Fs Monthly 5s Performance A2 B77 137742 0 0527 37773 0 0128 378 Ready to process Sets the performance For the given Data Vendor s Name and Id and Time Series Type Performance Range of elements containing Date NAY and Return values Formula result Ready to process Help on this Function PowerLink Installation and User Manual 14 4 18 2013 ss PERTRAC an eVestment company E EVESTMENT 8 PerTracSetQualitativeValue Requires DataVendorName DataVendorld TableName ColumnName and Value Sets the qualitative field value parameters Function Argument l for writing your PerTracSetQualitativeValue qua litative or DataVendorName PerTrac Indexes Fla PerTrac Indexes quantitative single DataVendorld 17 B 17 fields into the TableName Information F amp Information PerTrac Analytical ere M e Platform Investment Value D3 Fe 0 lt zu a Information pages Sets the value for the given Data Vendor s Name and Id table and Ns i The Table Names Value Value to set the column to and Column Field Names are shown in section VII below Formula result Ready to process Help on this Function IX PERTRAC ANALYTICAL INVESTMENT INFORMATION PAGE NAMES amp MAPPING General Information Page Column Field Map User Defined Function Value PerTrac Information Window Information General Information2. an eVestment company PowerLink Installation and User Manual Version 1 4 3 April 18 2013 Sh dA SA F dii SE dE adii i eo C3 3 0 own ua uu AN e wer uu a ww PERTHR RJ PerlTrac PowerLink E hel dis l F uM b F uM bh ies Sli b a 33 PERTRAC an eVestment company EVESTMENT TABLE OF CONTENTS l INSTALLATION 3 ll POWERLINK OVERVIEW 3 Ill PERTRAC POWERLINK TOOL BAR 4 IV ADDING CONTENT TO YOUR EXCEL REPORT 6 V VIEWING THE OUTPUT IN EXCEL 7 VI DEFAULT LINKS ELEMENT WORKSHEETS 8 Vil PERTRAC OPTIONS WORKSHEET 9 Vill USER DEFINED FUNCTIONS 11 IX PERTRAC ANALYTICAL INVESTMENT INFORMATION PAGE NAMES amp MAPPING 15 X HELPFUL HINTS 18 PowerLink Installation and User Manual 2 4 18 2013 TE 33 PERTRAC E EVESTMENT an eVestment company l INSTALLATION Requirements e PerTrac PowerLink supports the following versions of Excel 2007 2010 and Deployed 2013 32bit Only e You must have a valid PerTrac Analytical Platform Program installed on each workstation using Powerlink e The setup file will install any required windows components that are missing on the workstation See PerTrac Analytical Platform installation documents on our website knowledgebase at www pertrac com e Have Excel closed during installation To download PerTrac PowerLink go to ww
3. 1 1 30 2009 e e Credit Suisse Tremont HFI Event Driven Distressed Pertrac Indexes 01 31 1994 11 30 2009 you can set links to these fields from other Credit Suisse Tremont HFI Fixed Income Arbtrage perrac Indexes 01 31 1994 11 30 2009 Credit Suisse Tremont HFI Global Macro PerTrac Indexes 01 31 1994 11 30 2009 references For example you could reference the End Date to another Q Frew Next O cence worksheet or workbook By default when you reconfigure the element the icons on the screenshot to the right indicate the links are good These icons indicate the status of the links and indicate if the links are valid or PowerLink Installation and User Manual 8 4 18 2013 i PERTRAC TE an eVestment company E EVESTMENT invalid Sometimes invalid formats are linked to these cells or the initial links have changed in the source reference There are two types of status icons is 4 Value linked by formula 1 The link notification message indicates the links adi RCRUM ME naga a DNE ice are good i End Date Common End Date 2 Your linked status is invalid This may have leid EEUU occurred if someone entered an invalid format WANG a a n MENT e or overwrote the original link with an invalid EE EIE NU D UN AMORE a UM MUS parameter If you continue through wizard wa when the link status is invalid the PowerLink EE end Of Data ML default values will be entered VII PERTRAC O
4. PowerLink Installation and User Manual 15 4 18 2013 ss PERTRAC an eVestment company al information for location Bf Notes egoies BA Memo as x Ej Information IV Categories C User information v User Cat for location FD for location F21 F22 3 F23 Toe F24 l F5 F25 FB F7 F27 FB n F29 F30 F10 FSI F3 antah F33 F34 N F35 d F36 E m j EE E ES F38 ET a rn x E F17 F40 E A F41 2 EN NEM Updated 10 27 2008 27 00 Source Use iD 700024 E EM c13 r co r c2 r cu I C26 quee r C15 l C2 ci C16 C28 cs F c M c29 C6 cis ca ER cis l c3 ce c20 Lr ce c9 r ca en C10 C22 M c34 Ree r C23 C35 c12 Co C36 FfStsts Floste Mars TA Related Funds Baexport Sport Ads pf Enable Edt ke soe General information Ext System User Information Page Column Field Map Userlnformation1 User Information Window 1 Userlnformation2 User Information Window 2 Userlnformation3 User Information Window 3 Userlnformation4 User Information Window 4 Userlnformation5 User Information Window 5 Userlnformation6 User Information Window 6 PowerLink Installation and User Manual 16 4 18 2013 3 PERTRAC EE an eVestment company ai Information for location Gomes a Arman Company for location Investment for location F1 i a F26 F2 o j F2 3 F3 F28 F4 F29 F5 F30 FE oo eg ae F3
5. tab you can update all sheets with new data Select any single sheet in your workbook and click Reconfigure Sheet to launch the wizard When the wizard opens you can select new calculation options for the report new investments benchmarks etc then click through the wizard On the last step of the wizard you will see a check box at the top Layout Options gt g Investments Fields Layout Field Orientation Update Options Sheet Use current wizard values for default values in this Horizontal Vertical O workbook Table Layout Horizontal Please note that this is For preview purposes only it does not represent actual data 4 A B C 1 Compound ROR Standard Deviation 2 PRS Portfolio 4 44 36 60 3 PRS Manager 1 12 25 14 83 4 If you check this box the settings will apply to all worksheets in your workbook provided all sheets are linked to the PerTrac Options worksheet If you DO NOT check this box the links to the option sheet will be used TIP If you overwrite a default options on any individual sheet the links to the PerTrac Options tab will be broken which is fine However if you change the report inputs explained above and then check the box to update the Options sheet the sheet s no longer linked to the PerTrac Options sheet will not update PowerLink Installation and User Manual 10 4 18 2013 ss PERTRAC LI an eVestment company E EVESTMENT Vill USER DEFINED FUNCTIONS
6. type to display a list of available tables 3 Chart The chart tab lists the available charts for PerTrac Analytical Platform and PerTrac Portfolio Manager Each section displays a chart sub type Click the arrow next to each sub type to display a list of available charts All charts added to your report are native Excel charts and can be formatted using Excel formatting options 4 Text The Text tab lists the available text box options for PerTrac Analytical Platform funds 5 Refresh Sheet Each time a chart table or text box is added to your report a new worksheet is added to your workbook For example if you add 5 tables 5 charts and 2 text boxes your workbook would contain 12 worksheets Each Excel plug in workbook will also contain a PerTrac Contents worksheet and a PerTrac Options worksheet The PerTrac Contents sheet is a table of contents that displays the number of worksheets in your workbook the name of worksheets and a status for indicating success or error Each individual element worksheet allows the user to change certain inputs for the element on that worksheet Time Series Start Date End Date Minimum Acceptable Return MAR Risk Free Rate Table layout PowerLink Installation and User Manual 4 4 18 2013 i PERTRAC TE an eVestment company E EVESTMENT Transposed horizontal or vertical and labels If you edit these options on a specific worksheet the Refresh Sheet icon will refresh your data on j
7. you configure your database s for the PerTrac applications you use you can start adding content to your report 1 PerTrac Analytical Platform Click the down arrow below the Table Chart or Text icons on the menu bar to drop down a list of available tables charts or text boxes When you select a table chart or text box that will be populated with PerTrac Analytical Platform data the following configuration wizard will open to select Investments Fields and Layout e Investments Investment Options allows for selecting your Time Series Monthly or Quarterly Start Date and End Date The Investments tab allows for selecting your Manager Benchmark and Peer universes depending on the type of chart table or text box you have selected Click Load Universe to select your universe If you would like to select funds other than those in a saved universe use the search field on the right side of the window You can search for funds by typing the name or partial name into the search field You can view all of your funds by clicking View AII or click the folder icon to open a universe from your Universe folder Note To add funds from the search results to the Manager Benchmark or Peer windows click the green 4 under the search results or select the funds in the search results then drag and drop them into the universe pane The Save icon to the right of Load Un
8. 1 F7 F32 F8 D un F33 F9 i eni F34 3 F10 pay ka Sp An ng Oe F5 F11 i F3 F12 u F37 F13 2 d MESE F38 Fd F39 MEE MEM F15 F40 A a 2 SES VU AE ORO F41 n EN F42 ud F18 g i F43 F19 FM E F20 F45 F21 F46 B CERAM MIA ux F4 F23 m F48 u F24 BEEN d F49 gt eS a Se wm F50 wi User Estas loa f chets W Rested Funds Ba spot finest Pca Lpf Enbecat ds Exit System User Category Page Column Field Map SystemCheck4 Category Window 4 PowerLink Installation and User Manual 17 4 18 2013 33 PERTRAC LU i an eVestment company UserCheck5 User Category Window 5 UserCheck6 User Category Window 6 al Information for location gue Company fot location Investment for location E EVESTMENT MD Information E User information Memo amp s b a ca cel C81 Kad r c2 r C32 Ce C9 c3 c3 C63 cs C4 M CA C64 C94 C5 cs C55 Cs CE C c3 M C66 F C rc c C57 P C97 C8 C38 C58 c c9 M C39 cs r cs cto cao C70 C100 CH cn r cn P Cil WEES c c72 ci C13 C43 K c73 C103 D CM Ca T CA I CNN C15 C45 C75 F C105 C6 M C46 M C76 C106 F cv M cq r c7 C107 M C18 cae C78 C108 M cs C49 c79 M C109 M C20 C50 C8 Cino r cz M C51 ca an c2 M C52 C82 C2 c23 C53 C83 C3 CAM C54 cee CI C25 C55 M C85 cis
9. 9 Collingham Investment Fund Class PRS Manager 6 User 01 31 2002 01 31 2009 Collingham Investment Fund Ltd x g a vid Ie nou Next 9 Cancel 2 Risk Table Configuration o r P 4 Qu T Select Fields a Investments Fields Layout Available Data Selected Fields Type Statistics 3 Active Premium amp Active Premium Down Markets amp Active Premium Up Markets amp Alpha 3 Alpha Down Markets amp Alpha Up Markets 9 Average Loss amp Benchmark Return Down Markets Pe 4 2 Benchmark Return Up Markets ae amp Benchmark Standard Deviation Down Markets amp Benchmark Standard Deviation Up Markets amp Beta amp Beta Down Markets amp Beta Up Markets amp Beta TStat amp Beta TStat Down Markets 2 2 amp Beta TStat Up Markets 49 Standard Deviation Since Inception 49 Sharpe Ratio Since Inception ka Max Drawdown Since Inception i Sortino Ratio Since Inception All Z Average Gain Since Inception Z Average Loss Since Inception XJ Kurtosis Since Inception 43 Skewness Since Inception 4 Compound ROR Since Inception ie J Value at Risk Since Inception a 49 Expected Tail Loss Since Inception K Value at Risk Modified Since Inception 49 Expected Tail Loss Modified Since Inception 49 Omega Ratio Since Inception inem gt ala Calmar Ratio Compound ROR w 4 18 2013 i PERTRAC etd an eVes
10. Insert Function Search for a function Type a brief description of what you want to do and then click Overview PerTrac PowerLink includes eight Go User Defined Functions to export data from Or select a category PerTrac Financial Solutions m the PerTrac Analytical Platform into Excel or to Select a function write data from Excel into the PerTrac ajamang pamer en rea rnt 5 Analytical Platform There are two types of ed a ii data available for importing or exporting with Sad Aeara am E the User Defined Functions time series and A ee ere mer DataVendorId x single value qualitative or quantitative fields Returns the Investment s Name For the given Data Vendor s Name and Id Time series data includes Return Date NAV Funds Managed and Estimate Yes No and are available in the following frequencies daily Help on this Function weekly weekly month to date estimates monthly and quarterly The first six user defined functions below are PerTracGet functions for importing data from the PerTrac Analytical Platform into Excel The last two functions are PerTracSet functions for exporting data from Excel into the PerTrac Analytical Platform Listed in parentheses after the name of each function are the arguments that you must enter to execute the function Hint When adding functions that provide multiple rows or columns of data you must set up an array to display that data If your array has too few or too m
11. PTIONS WORKSHEET The PerTrac Options worksheet is the master options worksheet for each PowerLink report When you open a new workbook and add your first element table chart text box the PerTrac Options tab is automatically generated There is only one PerTrac Options sheet per workbook By default each individual element worksheet is linked back to the PerTrac Options sheet The worksheet includes the following default options and default data sources options Time Series Start Date End Date Minimum Acceptable Returns Risk Free Rate PerTrac Analytical Platform PTAP Managers PerTrac Analytical Platform PTAP Benchmarks PerTrac Analytical Platform PTAP Peers PerTrac Analytical Platform PTAP Default Benchmark PerTrac Analytical Platform PTAP Default Rate Benchmark CMS Funds Portfolio Managers P A oo c ou a E P P PRP P WN P O Portfolio Benchmarks PowerLink Installation and User Manual 9 4 18 2013 33 PERTRAC TE an eVestment company E EVESTMENT 14 Portfolio Default Benchmarks 15 Portfolio Default Rate Benchmarks Changing any of the options on this tab will have an effect on all individual element sheets linked to this tab Once a PowerLink report has been created there is an option in the wizard that allows changing these options for all sheets in the workbook For example if you generate report that contains five tables and five charts where all options are linked to the PerTrac Options
12. Type Hint This function is a multiple result function You Function Areuments Ru MUST set an PerTracGetPerformance array for the DataVendorName PerTrac Indexes E PerTrac Indexes output For DataVendorld 15 Fs 15 example if you J TimeSeries Monthly E Monthly are exporting 5 AVALUE Returns the performance data for the given Data Vendor s Name and Id and Time Series Type years of return TimeSeries One of the following Daily MTDEstimate Monthly Quarterly or A lien data you will have to set an Formula result VALLE array for 60 rows Help on this Function for the returns and columns for the dates and returns 4 PerTracGetQualitativeValue Requires DataVendorName DataVendorld TableName and ColumnName Returns the Qualitative Value from the PerTrac field located per your entered parameters The Table Names and Column Field Names are shown in section VII below Function Areuments X PerTracGetQualitativeValue Data YendorName PerTrac Indexes Figs PerTrac Indexes DataVendorld 17 x 17 TableName Information Figs Information ColumnName F20 Fig F20 SP 500 TR Returns the Qualitative Value For the given Data Yendor s Name and Id Table s Name and Column s Name ColumnName Column s Name to get the value from Formula result SP 500 TR Help on this Function 5 PerTracGetUniverseNames Requires the universe file name path Returns the Names of th
13. any rows or columns click F2 highlight additional rows or columns then click Ctrl Shift Enter to populate your data Use the same process for removing rows or columns PowerLink Installation and User Manual 11 4 18 2013 33 PERTRAC an eVesiment company E EVESTMENT 1 PerTracGetlnvestmentName Requires DataVendorName and DataVendorld Returns the Investment s Name for the given Data Vendor s Name and Id Function Arguments PerTracGetInvestmentName DatavendorMame PerTrac Indexes Es PerTrac Indexes Datavendorld 17 B 17 SP 500 TR Returns the Investment s Name for the given Data Vendor s Name and Id Data endorId Data Vendor s Id Formula result SP 500 TR 2 PerTracGetlnvestmentVendorkey Requires investment Name Returns the Data Vendor s Name and ID for the given Investment s name Hint This function produces two results DataVendorName and DataVendorlD You MUST set a two cell array for this data Function Arguments PerTracGetInvestmentVendorkey Name S amp P 500 TR les Returns the Data Vendor s Name and Id for the given Investment s name Name The Investment s Name Formula result PowerLink Installation and User Manual 12 4 18 2013 E EVESTMENT S PERTRAC an eVestment company 3 PerTracGetPerformance Requires DataVendorName DataVendorid and TimeSeries Returns the performance data for the given Data Vendor s Name and ID and Time Series
14. ate the entire workbook when their underlying database has been updated For example let s say you create a 5 page monthly report The following month when your source database PerTrac Analytical Platform PerTrac Portfolio Manager or PerTrac CMS has been updated you can click Refresh All Sheets to update your report 7 Reconfigure Sheet A separate worksheet is added to your report each time you add an element table chart text box Once created use the Reconfigure Sheet option to go back through the wizard process to change the element options funds statistics etc Note This option works great when you copy worksheets and want to keep the element table chart or text box but change the inputs on the element 8 Update Database PerTrac PowerLink includes six User Defined Functions explained below in section VI to import data from your PerTrac Analytical Platform database and two User Defined Functions to write data back into your PerTrac Analytical Platform database The Update Database icon applies when writing data back to the database When you enter the Set functions the database will not automatically update with your new data You must first click the Update Database icon which will then prompt you to confirm that you want to add the information to your database PowerLink Installation and User Manual 5 4 18 2013 ott PERTRAC an eVestment company E EVESTMENT IV ADDING CONTENT TO YOUR EXCEL REPORT After
15. e Return 10 00 default 5 Risk Free Rate Risk Free Rate 5 0096 default Field Orientation Horizontal 6 Field Orientation Note If you change any of the settings listed above you must click Refresh Sheet on the plug in toolbar for the sheet to update As mentioned above if you would like to edit these fields and apply them to all worksheets in your report change the inputs on the PerTrac Options worksheet and click Refresh All Sheets on the menu bar PI k Table Configuration EJ VI D EF AU LT L N KS Calculation and Investments Me s a nvestmen ions alculation Options E L E M E N T 5 4 wa Monthly M ae Return 10 00 WORKSHEETS As mentioned in the previous section start Date Common Start Date b 1994 95 Risk Free Return 5 00 Yo ej d Date Common End Date Investments S manager Benchmark there are five default settings Time Series la SM il Start Date End Date Minimum Acceptable FOF uy LL el Name Vendor Start End E R eturn an d R S k F ree Ra te A It h ou g h t h ese Credit Suisse Tremont HFI Convertible Arbitrage PerTrac Indexes 01 31 1994 11 30 2009 Credit Suisse Tremont HFI Emerging Markets PerTrac Indexes 01 31 1994 11 30 2009 are s et W h en yo u f r st se e ct ane eme nt Credit Suisse Tremont HFI Equity Market Neutral PerTrac Indexes 01 31 1994 11 30 2009 7 Credit Suisse Tremont HFI Event Driven PerTracIndexes 01 31 1994
16. e given investments contained in the Universe file Hint This function is a multiple result function You MUST set an array for the output For example if your universe contains 25 funds your array would have to be 25 rows PowerLink Installation and User Manual 13 4 18 2013 E EVESTMENT tt PERTRAC an eVestment company or columns to display the results Function Areuments PerTracGetUniverseNames FileName C Program Files PerTrac Financia Returns the names of the investments contained in the Universe File FileName Universe s Full file name Formula result Help on this Function 6 PerTracGetUniverseVendorKeys Requires the universe file name path Returns the VendorNames and VendorIDs for the investments contained in the Universe file Hint This function is a multiple result function You MUST set an array for the output Function Areuments PerTracGetUniverseVendorkKeys FileName C Program Files PerTrac Financia A Returns Data Vendor s Names and Ids contained in the Universe File FileName Universe s Full File name Formula result Help on this Function 7 PerTracSetPerformance Requires DataVendorName DataVendorld TimeSeries and Performance range Sets the performance parameters for writing your performance data into the PerTrac Analytical Platform Investment Data sheets i gt NG runction Areuments FN PerTracSetPerformance DataVendorName PerTrac Indexes Fig
17. f C26 C56 cee l che C27 cs CB87 ci C28 C58 cee cng ca mM C59 ceg ceng ca C60 F cso C120 User Pss Dua icnets TEjReletedrunds Spt E Po pp Enable Eat Lejievs Exit X HELPFUL HINTS 1 If your report contains numerous elements charts tables text boxes you will have numerous sheets in your workbook Remember each element that you create appears on its own worksheet within the workbook Rather than scrolling through all of the sheets to find the one you want you can quickly access a specific sheet by right clicking on the four small scroll arrows located at the bottom left corner of the workbook When you right click a list box will open simply click on the sheet you wish to jump to When you add a new chart table or text box to your report a new worksheet is added for each Once the sheet has been created you can copy that sheet and then change PowerLink Installation and User Manual 18 4 18 2013 60606060600000 6466 6006060 eee o eeeeoes C eocccccccco 000 a a P d 3 9 ks ee C O G O O O 406606 46006 eec eo000000000000 O e 600606 gt 09 0 e0600000000000000000000000 o 9 O SSeeseeeseeseseeeeo 00000000006006 8086 e D eoe e 8 4606006 0800668666060 0000 680 O00 PowerLink Installation at UerManuaK0 000 CeeOBCOO 00000 OCO 120 eo 40640606 6 40601000101010 4 Oo I 06 00 e e
18. ion and User Manual 3 4 18 2013 3 PERTRAC TE an eVestment company E EVESTMENT tables or text boxes The plug in also includes User Defined Functions UDF to import time series data and single qualitative data from the PerTrac Analytical Platform to Excel and to export time series data and single qualitative data from Excel back to into the PerTrac Analytical Platform Ill PERTRAC POWERLINK TOOL BAR When PerTrac PowerLink has been installed a new PerTrac tab will be added to your Excel tool bar Py d Au Y 2041 e d L3 Loc Can Book2 Micro Home Insert Page Layout Formulas Data Review View Developer Adel Ins PerTrac BIW t Configure Table Chart Text Refresh Refresh Reconfigure Update Data Sources 7 Y Sheet All Sheets Sheet Database PerTrac API Add In 1 Configure Data Sources Prior to creating your report you must configure your application databases The configuration window lists three database options for three different applications in the PerTrac Suite PerTrac Analytic Platform Data Source PerTrac Portfolio Manager Data Source and PerTrac CMS Data Source At this time PowerLink is compatible with PerTrac Analytics only Future integration functionality is planned with our other applications 2 Table The table tab lists the available tables for PerTrac Analytical Platform PerTrac Portfolio Manager and PerTrac CMS Each section displays a table sub type Click the arrow next to each sub
19. iverse allows you to save the universe to overwrite the existing file or Save As to rename the universe When all inputs have been selected click Next e Select Fields The Fields tab step two of the wizard allows the user to select qualitative or quantitative fields for the selected table chart or text box If you add a table chart or text box built with pre defined data you can edit the existing data by adding or removing fields Note You can add or remove fields by clicking the green sign or the red x You can also drag and drop the fields between the two panes When all fields have been selected click Next PowerLink Installation and User Manual 6 ui Calendar Year Returns Configuration EJ GO Calculation and Investments d A Investments Fields Layout Investment Options Time Series Monthly Start Date Since Inception Y End Date End Of Data Investments Manager Benchmark dy Load Universe iE r Custom Universe Master Universe p aG Name YendorName Start End EN 3 p Raito Hei DIISHODOA OHSII2OUN Cochis Capital Distressed RMBS a panga peer 01 01 2002 01 31 2009 iL Capital Distressed RMBS PRS Manager 2 or 01 31 2002 01 31 2009 Colchis Capital Distressed RMBS p PRS Manager 3 User 01 31 2002 01 31 2009 Collingham Investment Fund Class PR5 Manager 4 User 01 31 2002 01 31 2009 Collingham Investment Fund Class PRS Manager 5 User 01 31 2002 01 31 200
20. o OO eoe 6660600000666 o0 ot 06 Q eoe 6 e o o0 0000 Q e 009
21. t that lists the names of all worksheets in the workbook When an element table chart or text box is added to the report a separate worksheet is added to the workbook The name of the worksheet displays the name of the element i e Calendar Year Returns The name of each sheet will be listed on the table of contents as well as the worksheet status c PerTrac Options This worksheet is a master sheet where you can edit the default options for all worksheets in the workbook Each sheet can be updated individually or you can update all sheets from the PerTrac Options worksheet PowerLink Installation and User Manual 7 4 18 2013 s PERTRAC an eVestment company E EVESTMENT The available fields to edit are located in cells B4 B9 and the values for those fields in C4 C9 d Element worksheets The PerTrac Options worksheet is the last default worksheet As you add tables charts or text boxes to your report a new worksheet will be added for each The individual worksheets also have options to edit the default settings located in cells B4 C9 The top section of the worksheet lists the element default settings that can be edited depending on whether you created a table chart or text box 1 Time Series Risk Table tart Date Options All options can be set in the Configuration Wizard 3 End Date Time Series Monthly default os Start Date SI default 4 Minimum Acceptable P End Date EOD default Return Minimum Acceptabl
22. tment company E EVESTMENT e Layout Options The last step in the wizard provides layout options When you select Table elements for DA opti MN AM u your report the Field Orientation radio buttons will 5 be available letting you display the table either M horizontally or vertically Mex 4 Note Once the table appears in Excel you have an option on that sheet to change the layout of your table The transpose options only apply to tables When you have completed the wizard process click Save on the bottom of the window A new Excel worksheet will be added to your workbook which displays the table chart or text box element you just selected Note The Previous button lets you move backwards through the wizard while the Cancel button lets you exit the wizard V VIEWING THE OUTPUT IN EXCEL 1 The Excel workbook Once you have selected your table chart or text box and completed the wizard process the selected element will appear on a separate worksheet within the Excel workbook The workbook will contain the following worksheets M gt M Sheet1 PerTrac Contents PerTrac Options PTAP Cal Year Returns Table1 PTAP Correlation Matrixi PT a Sheet1 blank worksheet This worksheet can be used for creating a report template linked to your individual element worksheets Additional sheets can always be added or deleted b Pertrac Contents This is a Table of Contents shee
23. ust that worksheet Note The PerTrac Options worksheet which appears in every PerTrac PowerLink workbook is somewhat of a Master worksheet that also allows for changing certain options The available fields for editing cells B4 B9 include Time Series Start Date End Date Minimum Acceptable Return MAR Risk Free Rate and Field Orientation transposed horizontal or vertical When you change these options and click Refresh All Sheets each individual worksheet in your workbook will update to the options set on the PerTrac Options worksheet Note If you change any of the options in cells B4 B9 on the individual element worksheet the status shown in cells D4 D9 will display overridden In that scenario if you then change the options on the PerTrac Options worksheet and click Refresh All Sheets only the fields not shown as overridden will update The overridden field can be linked back to the appropriate PerTrac Options field at any time using Excel linking and cell reference functions An example If you change the options on an individual element sheet for example Start Date the status in cell D5 will display overridden If you then go to the PerTrac Options worksheet and change the Start Date in cell C5 and click Refresh All Sheets the start date that had been overridden will not update Overridden fields are disconnected from the PerTrac Options worksheet 6 Refresh All Sheets This option allows the user to upd
24. w pertrac com and click on the Live Support link Next click on the PerTrac Analytics Client Login link c Next you will be prompted to enter the following required information Name Email and gt 0a h D License Number in order to gain access to the download page Use your PerTrac Analytics License number From the download page click the Download Software dropdown and select PowerLink Next click the link labeled Click here To Download PerTrac PowerLink Save the file to your selected destination Double click the file PerTrac PowerLink Setup exe to launch the installer By default the application will be installed at the following file path C Program Files PerTrac Financial Solutions You may change the installation location to a different file path if you wish A PerTrac PowerLink folder and files will be added to your selected path Launch Excel and click the new PerTrac tab on the menu bar Il POWERLINK OVERVIEW PerTrac PowerLink is a plug in for Excel Once installed PerTrac PowerLink adds a new PerTrac tab to your Excel toolbar The plug in will provide the user with the ability to create customized reports The user interface on the toolbar setup windows and configuration windows will be familiar to anyone who uses PerTrac Reporting Studio Intuitive menu options allow the user to easily select content from the PerTrac Analytical Platform for use in charts PowerLink Installat
Download Pdf Manuals
Related Search