Home

ModHist

1. A Font XXXXX XXX ZZZZ 7272 172727272 ZZZZZZZZZZZZ ZZZZZZZZZZZ increase font size 12777 771 XXXX A Decrease font size KXXXX XXX C j _ 7 Configuration options i Restore configuration Templates k Column alignment options 1 December 2008 MEFF 2008 B 7 User Manual Advanced options Ap ndice B Customisation of the Data Matrices By means of the Configurations Options menu option one accesses the data matrix configuration screen In the Columns panel of the said screen it is possible to select a set of advanced options for the columns The following diagram describes the options that can be configured Window title titl tit2 tit4 tit5 2200 300000000 00000000000 0000000000 Y Zzzz ZZzz 222772722 227222222772 77717777777 Cm choose saz 0 _ Alignment ZZ 7 77 2777777777 ZZZZZZZZZZZZ 27777777777 3 Best fit 900000000000 200000000XX 7ZZZZZ c ZZ sx ZZZZZZZZZ 727277277777 22277777777 Best Fit columns 77777 ZZZ xOOOOOOOOOOC Font ZZZZZZZZZ 777777777777 ZZZZZZZZZZZ AX increase font size 777777 ZZZ JOOOOOOOOOOQXX XO0000000XX Decrease font size Doa LL Options General
2. si Sa eT aes 8 46 stiano NG ex DOING EE 9 Appendix A Available HeDOLL S risna aao cd dedu dd aeuo b A 1 nw MN eoi Pe Sa uuu DEUS 1 nx Wido ru Bie A 2 Appendix B Customisation of the Data Matrices J J B 1 s PARIS OR R mus 1 B2 6 a Pee eed B 3 Bo sGol mtumsiatadelriell suc dads siii d nexo a a etes seus sis B 4 B4 So igo MERE EP B 9 Bo LOLI Eoo Dom B 10 ROWS Sy alae a B 12 BZ AMOS EDI B 13 BS WEE STILE IN obolis certus iio e a Srl ate ad ech cad B 17 P fee Miia gt anne ee E ne LM soiree eam Mi n e are E a LM ERU ete ei en B 19 User Manual 1 Introduction 1 Introduction The historical files module ModHist is an application developed by MEFF with the purpose of making the available information accessible in the database of the MEFFServer application From ModHist one can view the selected information and also print and export it after having manipulated it to adapt it to the specific needs Data files generati
3. XXX XXX XXX XXXXXXXX XXX XXX XXX XXX XXXXXXXX XXX ZZZZ ZZZZZZZZZ ZZZZZZZZZZZZ Sorting columns Hide If one wishes to hide any of the displayed columns click the mouse button on its title heading and while keeping the mouse button pressed drag it outside the screen window until the mouse icon changes into a blade cross shape It is also possible to perform the same process by pressing the data matrix menu option Remove this column Window title Columns removal 1 December 2008 MEFF 2008 B 5 ModHist User Manual Ap ndice B Customisation of the Data Matrices Width The width of each column can be manually adjusted to do this place the cursor between the title headings of the columns to be amended until the cursor changes shape P and while pressing the main mouse button drag the division line until the desired width has been achieved Window title Seles 2222 Manual adjustment of the columns width Select the Adjust Column option from the data matrix menu in order to assign the optimal width for the selected column Select the Adjust all Columns option from the data matrix menu so that the application can allocate the width to all the columns assigning each one its most adequate width a Window title Seles titi tit2 tit3 tit
4. Grouping Cc SetiDate Z Tile Reference initialT radelD emer ee Market D eciamals IntTrdDats p Trading Fee Clearing Fee Visible Premium M Options hw Show titles Cell Autosize Iw Autosize Tie Autosize hv Allow filtenng Allow filtering when it is selected it is possible to filter the rows by the value of some columns Show titles when it is selected the application will show the columns headers Otherwise only the data rows will be shown without any header Configuration options V Restore configuration Templates Selection of column Title allows changes to the text that is shown in the header of the column Decimals in the columns that contain numeric values it allows the number of decimal places displayed to be specified Visible allows the columns that are to be displayed to be selected Cell Autosize when it is selected the application will adjust the height of the rows by the content The line break is only used when spaces are found Title Autosize when it is selected the application will display the full text of the titles In this case the width of the row of titles will be increased if necessary Autosize when it is selected the application adjusts the width of the columns so that they fit in the window Otherwise all the columns might not be visible simultaneously and it may be necessary to use the h
5. DER XXX XXX XXX XXXXXXXX XXX ZZZ Zu ZZZ ZZZZZZZZ LLZ XXX XXX XXX XXXXXXXX XXX ZZZ ZZZ ZZZ ZZZZZZZZ ZZZ XXX XXX XXX XXXXXXXX XXX ZZZ ZZZ ZZZ ZZZZZZZZ ZZZ XXX XXX XXX XXXXXXXX XXX ZZZ ZZZ ZZZ ZZZZZZZZ ZZZ XXX XXX XXX XXXXXXXX XXX Click with the auxiliary button of the mouse over the title bar Sort Ascending XXX z Sort Descending ZZ Clear Sorting XXX gt Group by this Field XXX Group by box ZZ C Footers XXX Group footers 221 Remove this column 2 Column chooser Alignment ka Best Fit Best Fit all columns A Font A Increase Font size A Decrease font size Ls Configuration options ul Restore configuration Templates OX XXX XXX XXXXXXXX XXX 7ZZ LLL ZZZ ZZZZZZZZ zu X XXX XXX XXXXXXXX XXX 7ZZ LLL ZZZ ZZZZZZZZ ZZZ _ X XXX XXX 7ZZ ZZZ ZZZ ZZZZZZZZ ZZZ OX XXX XXX XXXXXXXX XXX 7ZZ ZZZ ZZZ ZZZZZZZZ ZZZ OX XXX XXXXXXXX XXX The functionalities associated with the menu options are described in detail throughout this appendix 1 December 2008 MEFF 2008 B 3 ModHist User Manual Ap ndice B Customisation of the Data Matrices B 3 Columns management Add To add columns that are not presently being displayed press on the Select Columns option of the data matrix menu Then a floating window will appear with the list of columns that can be selected To add one of these columns click on the mouse and holding it pressed drag the elemen
6. Tit1 val2 Tit2 val2 1 20 000 23 15 000 93 219 210 08 Tit2 val2 2 25 000 246 23 000 665 010 298 00 2 MAX 25 000 MIN 123 38 000 AVG 379 114 754 04 MAX 25 000 MIN 123 56 000 AVG 192 065 862 77 Example screen with group totals lines The available functions are the same as those for footing totals Take into account that the functions assignment is done by column and that it will therefore be the same for all the groups The assigned groups function is independent of the function assigned in the footing totals 1 December 2008 MEFF 2008 B 15 ModHist User Manual Ap ndice B Customisation of the Data Matrices Configuration options By means of the Configurations Options menu option one accesses the configuration screen of the data matrix In the Grouping panel of the said screen one can also activate or deactivate the footing totals by means of the Page Totals checkboxes It is similarly possible to select the behaviour of the group total lines by means of the Group totals pull down menu The following diagram describes the options that can be configured Options General Grouping Columns Activation of footers 4 w Field grouping Page totals Group totals Hidden Group Hidden Visible if expanded totals option Always vi
7. 12 2 05 07 20 16 12 2005 0 200512 we MNFO6 0100 0 20 01 2 24 10 20 20 01 2006 0 200601 ESOBOO0050 MNGO6 0100 0 17 02 2 21 11 20 17 02 2006 0 200602 ESOBOO0051 MNHO6 0100 0 17 03 2 21 02 20 17 03 2006 0 200603 ESOBO000047 MNHO 0100 0 16 03 2 21 02 20 16 03 2007 0 200703 MNHO8 0100 0 20 03 2 19 09 20 20 03 2008 0 200803 MNMO6 0100 0 16 06 2 05 07 20 16 06 2006 0 200606 ES08000048 MNMU 0100 0 15 05 2 20 12 20 15 06 2007 0 200706 MNMO8 0100 0 20 06 2 21 02 20 20 06 2008 0 200806 MNMOS 0100 0 19 0672 21 02 20 19 06 2008 0 200906 MNM10 0100 018 06 2 20 06 20 18 06 2010 0 201006 MNUO6 0100 0 15 09 2 21 02 20 15 09 2006 0 200609 ESOB000048 MNUO 0100 0 21 0972 21 03 20 21 09 2007 0 200703 Report Screen 4 3 Data matrix The data matrix is the part of the screen where the data is displayed with the selected presentation by means of a viewing bar or with the specific customisation that is made to it Among the available customisations there are columns selection the sorting and grouping of records the calculation of partial or overall group totals the column width the source and colour of the records etc Given the versatility of the configuration of the data matrix it has been preferred to leave the details of its customisation in an appendix on it refer to Ap n
8. 3 MEF E ModHist USER MANUAL MEFF S MART v9 0 1 December 2008 ModHist User Manual The information contained in this document is subject to changes without prior notice Unless otherwise stated the companies the names and the data used in the examples are fictitious No part of this document may be copied or transmitted in any manner or by any means either electronic or mechanical for any purpose without prior written authorisation 2006 MEFF All rights reserved 2007 MEFF All rights reserved 2008 MEFF All rights reserved ModHist User Manual Table of Contents 15 MINTO CUI eee aaa saa 1 The Data Engironien tuuu u uuu ri y uu eee Dav EUH 2 Main Screen or the ApBIlIiCaliohuuu Lu tesa loved eects avec Ga recusa oaa iau u 3 cO u 3 3 2 Selecting the report to be generated D M u nmay huuu M nnn nnn A 4 CAVA cess nei 5 A REDO SGI COM ette 6 ME 1 OM cog u u oom 6 gt General Overview Tm 6 43 Data Tall ae E A bed tuer a oed tud 6 Ad T rers 7 IDISplay Vile WS x utis ont Dade
9. 4 tit5 tit6 tit7 XXXX XXXX XXXXXXXXX XXXXXXXXXXXXX Remove this column ZZZZZZZZZ ZZZZZZZZZZZZ f choose 39000009XX X000000000009X 880 ZZZZZZZZZ ZZZZZZZZZZZZ _ Moment 300000000009 F Best f 22727272 ZZZZZZZZZZZZ beste el core 2 222 227 zzzzzzzz zz 39000009XX ENS 272772727 ZZZZZZZZZZZZ A Fo 000000000000 Ak Increase font size LLL LLL d A Decrease font size S configuration options T Restore configuration Templates k Automatic column width adjustments 1 December 2008 MEFF 2008 6 ModHist User Manual Ap ndice B Customisation of the Data Matrices Alignment Select the Alignment option from the data matrix menu in order to select the desired type of alignment for the selected column Window title BE tit1 tit2 tit3 tit4 titS was Remove this column xxxx xxxx xxxxxxxxxxx ace XXXXX 7777 7777 277777777 722777777777 77777777777 ZZZzzz ZZz xxx xxx XXXXXXXXXXXXX xxxxxxxxxxx saan 7777 7777 777777777 777777777777 77777777777 A est fe Align Right XXXX Align Center zzzz zzzz zzzzzzzzz zzzzzzzzzzzz zzzzzzzzzzz Ot teme 777720201 XXXX XXXX
10. 777777 20 000 0 95 10 000 1 024 12 Assigning functions to the footing totals 1 December 2008 MEFF 2008 B 13 User Manual Available functions The following table describes each of the available functions E unctior xplanation Sum of all the values in the column Minimum value in the column Ap ndice B Customisation of the Data Matrices Maximum value in the column Number of elements present Mean of the values in the column An example screen is shown below in which different functions of the footing totals functions have been selected Window title EEk XXXX XXXX 2222 2222 XXXX XXXX 2222 2222 XXXX XXXX 2222 2222 XXXX XXXX Account 1 December 2008 XXXXXXXXX 2222222272 ZZZZZZZZZ XXXXXXXXX ZZZZZZZZZ 5 000 10 000 10 000 20 000 25 000 20 000 10 000 25 000 Example of the different footing totals functions MEFF 2008 Sum 1 2 3 4 5 6 Z AVG 331 14 Average B 14 ModHist User Manual Ap ndice B Customisation of the Data Matrices Totals by group By means of the Group Totals option of the data matrix menu one can activate or deactivate the group total lines Window title w tit2 Tit1 val1 Tit2 val1 1 Tit2 val1 2 2 15 000 678 6 000 2 021 970 00 2 MAX 15 000 MIN 345 18 000 a AVG 5 016 971 50
11. Data filter Go to report management window Selection process of the dataset to be displayed 1 December 2008 MEFF 2008 4 ModHist User Manual 3 Main Screen of the Application 3 3 Prior filtering of data When one presses the Display List button on the main screen one has access to the data within an application that allows for it to be manipulated in many ways among these is the filtering of the data On the other hand the prior filtering of data is that which can be done directly from the main screen and which is restricted to only a few fields normally from one date to another and for a Member The object of this filtering is to soeed up the data extraction process from the database decreasing the query time and the data volume that must subsequently be handled This filtration process may be pertinent for historical files which can contain large amounts of data such as that of transactions or orders Cash movements Stat Date U2 Ub 2005 EndDate 02 06 2006 E Environment RV LL Member 899 gt R On filtering the data the query is executed quicker and the later manipulation is much more agile Prior filtering of data 1 December 2008 MEFF 2008 5 ModHist User Manual 4 Report Screen 4 Report Screen 4 1 Introduction When data has been selected from the main screen of ModHist and the Display List button 15 pressed a new application will open displayi
12. I Oy BS QQ N FA ZZZZZZZZZZZ ZZZZZZZZZZZ ZZZZZZZZZZZ ZZZZZZZZZZZ Selection of grouping criteria Window title XXX XXX ZZZ ZZZ ZZZ ZZZZZZZZ ZZZ XXX XXX ZZZ ZZZ ZZZ ZZZZZZZZ ZZZ XXX XXX ZZZ ZZZ ZZZ ZZZZZZZZ ZZZ XXX XXX ZZZ ZZZ ZZZ ZZZZZZZZ zz XXX XXX XXXXXXXX XXX EEr H es 1 Tod ww CCCC Personalizado adda eeee aaaa El tit xxxx EZ XXX XXX XXX XXXXXXXX XXX XXX XXXXXXXX XXX XXX XXX XXXXXXXX XXX XXX XXX XXX XXX XXX XXX XXXXXXXX XXX Result of first selection and selection of second grouping criteria Window title XXXXXXXXXXX XXX XXX XXXXXXXXXXX XXX XXX XXX XXX XXXXXXXX XXX XXXXXXXXXXXXX XXX XXX XXX XXXXXXXX XXX XXXX XXXX XXXX x E 1 xxxx tit2 aaaa The lower part of the data matrix displays a line showing the defined filter and allows for it to be Result of both filters Example of columns filtering activated or deactivated by means of a checkbox 1 December 2008 MEFF 2008 B 12 M
13. dice B Customisation of the Data Matrices 1 December 2008 MEFF 2008 6 ModHist User Manual 4 Report Screen 4 4 The filter toolbar Depending on the data that is displayed on the report screen a filter bar will be made available showing the most usual selection criteria for the displayed data 2 2 2 2 2 pd pr Poo x Todd md pesar 1 AX pora Bem Dp pote gt 7 pol ehad Timp Tamehmea Peleg cw w p di T z 1 z 21 08 2008 20058 2 TRAN z Ae sali We T 1820472006 a 7 1 m a 2 2 2 2 2 2 2 2 Grupo lt Tadas gt Todos z z 22 4 0 ZEE MUG 2 Nw OS TEE 0 Ene 1 ANI 2 8 2002007 b 200088 Filter bar of the report screen 1 December 2008 MEFF 2008 7 ModHist User Manual 4 Report Screen 4 5 Display Views For each of the reports it is possible to define one or several display views A display view groups a set of customisations made on the data matrix together so that they can subsequently be used To access one of the saved display views it should be selected by the name it was saved as in the combo Display Views screen View Default Restore if Save FORMAT Heads Format Visible columns changes Columns arrangement Registers arrangement Registers grouping Registers Filter Totals totals for
14. ents of a data matrix Similarly when the matrix allows for it one can add totals lines for the entire matrix or for groups of records The instructions on how to carry out the abovementioned tasks are explained in detail below in this appendix 1 December 2008 MEFF 2008 B 2 User Manual B 2 Options menu Ap ndice B Customisation of the Data Matrices To access the options menu of the data matrix click on the right hand mouse button on the title bar If the action to be taken is on a specific column this process must be carried out from its title heading Window title XXXX XXXX XXXXXXXXX X00000000000XX X00000000OXX XXX 2277 ZZZZZZZZZ XXXX XXXXXXXXX ZZZZ ZZZZZZZZZ ZZZZZZZZZ XXXXXXXXX ZZZZZZZZZ Window title 0000 OX XXXX 10000009X X90000000000XX 9000000XX XX0000000000XX XXXX 20000000X X000000000000X 3600 XXXXXXXXXXXXX XXXX XXXX XX900000000XXX ZZZZZZZZZZZZ ZZZZZZZZZZZZ XXXXXXXXXXXXX ZZZZZZZZZZZZ ZZZZZZZZZZZZ Access to the data matrix options menu ZZZZZZZZZZZ ZZZZZZZZZZZ ZZZZZZZZZZZ XXX XXXXXXXX ZZZZZZZZZZZ
15. f the desired ook and feel Options General Grouping Column Rows Look and Feel W Show indicato Native Separator Type m Grid Standard U traflat Lines Harizontal and Vertic gt Cancel Look and Feel Configuration Options Grid By means of the Rows pull down list one can select the grid lines one wishes to have visible The dialogue box located to the right of this control allows one to select the colour of these lines By means of the Font button one accesses a screen that allows for the font to be chosen that will be used in the entire data matrix Options General Grouping Column Rows Look and Feel W Show indicato Native Separator Type Flat IE Lines Harizontal and Vertic gt Font Horizontal and Vertical Mone Vertical Horizontal Grid configuration options 1 December 2008 MEFF 2008 B 18 ModHist User Manual Ap ndice B Customisation of the Data Matrices B 9 Templates Save Once a data matrix has been configured the customisation made can be saved for subsequent use by means of the Save Templates option of the data matrix menu Once this option has been selected a name must be assigned to the new template If an existing name is used for the subject screen the latter will prevail The saved templates are associated with the screen to which the data matrix belongs The saved templates are associated
16. group Fonts Columns width I r wann wet d rd LT SR T d D sss sI Y D s Restore View Default gt AX Delete Display views management 1 December 2008 MEFF 2008 8 ModHist User Manual 4 Report Screen 4 6 Printing and exporting By using the Export and Print options from the report screen one can respectively export or print out data Both the printing and exporting processes take account of the selected sorting columns grouping of records and other customisations made The export process allows for files of the following types to be generated e xml e html e xls e ixl Macc cS Y Export m DUE xML a amp a o gt mim n HTML 39 TT 34 xs ei 2 E oe uj IxT 28 2 XE 71 Nm rmE p BL EEN 3 121 1 PUTA ID B LPS ZT Reports n Pean d EN Print settings gt See Lael Ir r peus L1 omm LET id Page properties litade Nrgorincban H rpr 2006 160228 Change of Type printing Margins settings Size Orientation Proportions Title i Header Ventana de previsualizaci n Numeration Date and
17. list of the data that can be accessed from ModHist classified by environment negotiation clearing and grouped at a functional level exactly as it is displayed on the main screen of the application As a general rule the datasets that are available in ModHist coincide with the data files that can be generated from MEFFServer For a detailed description of the files refer to the MEFFServer User Manual 1 December 2008 MEFF 2008 2 ModHist User Manual 3 Main Screen of the Application 3 Main Screen of the Application 3 1 General overview From the main screen one selects the data to be queried and accesses the screen of the requested report Environment H Historical Reports 1 01 00 7 06 00 Beta 2 selection Trading Contracts daily information Clearing _ Contracts daily information Ru General trades Stat Date 02 06 2006 EndDate 02 06 2006 Environment RV TR Data filter fields Selection panel for lt data set J Selection panel for 4 J Private Confiquration Data E data group i Tradina Control Buttons ModHist Main Screen 1 December 2008 MEFF 2008 3 ModHist User Manual 3 Main Screen of the Application 3 2 Selecting the report to be generated The following diagram shows the steps to be followed to determine the information to be processed Environment Selection Clearing Trading Data group selection Data set selection
18. ng the selected data and allowing for it to be manipulated exported or printed 4 2 General overview The following diagram shows the main components of the report screen Window name View Print and environment data manage export date time ment bar buttons Listado Negociaci n Contratos 16 ene 2006 16 02 58 DER Filter bar E i Todos Todos v Vistas lt Defecto gt v W Guardar 2 Borrar imprimir By Exportar optiona Merc Contr GrupoCon v TipoCont Precio FechaVto Fechalni FechaFin TimeSpreadT TimeSprea BaseCeroTSp Id CodigolSIN M3 MNFOS 0100 0 21 01 2 18 10 20 21 01 2005 200501 M3 MNGOS 0100 0 18 02 2 22 11 20 18 02 2005 200502 _ M3 MNHO5 0100 0 18 03 2 22 03 20 18 03 2005 200503 M3 MNJOS 0100 0 15 04 2 24 01 20 15 04 2005 200504 M3 MNK05 0100 0 20 05 2 21 02 20 20 05 2005 200505 MNM05 0100 0 17 06 2 21 06 20 17 06 2005 200505 M3 MNNOS 0100 0 15 07 2 18 04 20 15 07 2005 200507 M3 MNQ05 0100 0 19 08 2 23 05 20 19 08 2005 200508 M3 MNUOS 0100 0 16 09 2 20 09 20 16 09 2005 200509 M3 0100 0 21 03 2 19 09 20 21 03 2008 200803 3 MNVO5 0100 0 21 10 2 18 07 20 21 10 2005 0 200510 Data matrix M3 MNXO5 0100 0 18 11 2 22 08 20 18 11 2005 0 200511 M3 MNZ05 0100 0 16
19. odHist User Manual Ap ndice B Customisation of the Data Matrices 7 Totals lines Footing totals By means of the Footing Totals of the data matrix menu one can activate or deactivate the footing totals of the data matrix Window title XXXXXXXXXXXXX 3000 sort Descending X XXX XXX XXX 222777777 ZZZZZZZZZZZZ ZZZ Zz ELE ZZZ ZZZZZZZZ ZZZ XXXXXXXXX XXXXXXXXXXXXX 3000 Group by this field K XXX XXX XXXXXXXX XXX 777777777 777777777777 zzz ME Group by box ZZ ZZZ ZZZ 77777777 ZZZ XXXXXXXXX XXXXXXXXXXXXX XXX LT a xXx XXXXXXXX XXX 777777777 777777777777 ZZZ EE Group footers EZ ZZZ ZZZ 77777777 ZZZ XXXXXXXXX XXXXXXXXXXXXX XXX X XXX XXX XXXXXXXX XXX Remowve this calumn a Column chooser Alignment bea Best fit Best Fit all columns Fort JA Increase font size A Decrease Font size Configuration options Restore configuration Templates k Activation deactivation of the footing totals Once the footing totals have been activated one can assign a different function for each column To assign a function to a column click on the secondary mouse button on the related footing totals area of the subject column in order to access the functions selection menu Window title 5 000 123 1 125 12 777777777 10 000 234 1023 90 XXXXXXXXX 10 000 345 10 90 777777777 20 000 456 9 34 XXXXXXXXX 25 000 123 65 777
20. on T Data print Report generation ModHist Functionalities The ModHist application has a main screen on which one selects the required data and which allows one to access an independent application allowing one to manipulate the data perform queries and export and print the information Main window ModHist Screens 1 December 2008 MEFF 2008 1 ModHist User Manual 2 The Data Environment 2 he Data Environment The dataset that can be accessed by ModHist depends on the MEFFServer application which caters for keeping the Database updated Data visibility can vary and depends on the rights that a Member has been conferred within MEFF Among other aspects the user may solely be limited to the operating aspects or may access clearing operations may or may not have online upgrading or be restricted to the public market information In any event the ModHist application will provide access to all the information available in the configured database this being what may contain some manner of restriction with regards to the available information A single instance of ModHist may have access to multiple environments and these can be for negotiation or clearing indifferently Regardless of the environments to which ModHist may have access each data query is performed on a specific environment In other words ModHist does not generate reports by mixing the data from different environments Ap ndice A shows a
21. orizontal cursor Advanced Column Configuration Options 1 December 2008 2008 Options for the selected columns gt Options for all the columns ModHist User Manual Ap ndice B Customisation of the Data Matrices Identification of the columns On placing the mouse cursor in the title heading of a column up to two floating text boxes may appear The upper text box will only appear when the column width is insufficient to contain the column name and will be used to display its full name The lower text box may contain two texts one of these between square brackets The text that is not within square brackets contains the column description This text only appears if the description is other than the present title heading of the column The text between square brackets is the original title heading of the column This text only appears if the description is other than the present title heading of the column mE l Pending x m ee i Wen Peridvol aif Pending valume E L example Description Only present when different from the column title L 2 Column header original name Only present if differnt form the current header 1 Column name Only present when the size of the column doesn t fit the whole text Identification of the Columns B 4 Sorting rows The matrices allow for the sorting of
22. r the type of information being displayed the data matrix will allow for groupings of rows to be made in accordance with the values of one or more columns To group on any of the columns select the option Group on this Field from the data matrix menu The same process can be done by dragging the title heading of the column onto the grouping panel If the grouping panel is not available select the option Group By Panel from the data matrix menu Window title 30000000XX X00000000000X E HN HE Zzzz 7272 772720707 ZZZZZZZZZZZZ XXXX XXX 10000000X 300000000000XX Sort Ascending Fal Sort Descending Group by this Field 2227772 Group by box zzzzzz Fonkers XXX Group footers 2222272 Remove this column a Column chooser Alignment d ma Best Fit Best Fit all columns AA Font A Increase Font size A Decrease font size Configuration options A Restore configuration Templates k Grouping Options The following diagram displays the appearance of a data matrix on which grouping has been done on two of its columns By using the expand or contract buttons one can select the data to be displayed First level column grouping Second level column Window title d 2 grouping gt Grouping panel First level groups Tit1 val1 Second Titi val2 level E Buttons to expand or reduce the group
23. rix offsetting o Theoretical prices o Deltas e Transactions o Transactions e Transaction management o Live transactions o Assignments and transfers made o Give Outs o Give Ins for a Destination member o Give Ins for the Clearer of a Destination Member e Open Position 1 December 2008 MEFF 2008 A 2 ModHist User Manual Ap ndice A Available Reports o Open Position balance o Position adjustments e Exercise Due Date o Exercise requests o Members cash transactions o Breakdown of cash transactions by titleholder e Fees o Detail of fees o Fees e Guarantees Deposited o Detail of Guarantees deposited e Gain Loss at a Titleholder level o Detailed calculation of the daily guarantee o Option premiums o Margin Variations o Clearing settlements and guarantees by titleholder o Clearing settlements as at due date e Gain Loss for Clearing Members o Guarantees required from the Clearing Member o Cash movements for the Clearing Member o Invoicing e Gain Loss for Agents o Guarantees required form the Custodian Member o Cash movements for the Domiciliary Entity 1 December 2008 MEFF 2008 A 3 ModHist User Manual Ap ndice B Customisation of the Data Matrices Ap ndice B Customisation of the Data Matrices A description is given below of the functionalities that are available for configuring the data matrix Grid This appendix deals with the data matrix in a generic manner and it may be possible that no
24. rows on the values of one or more columns The sorting on fields that are numeric will be done by the direct comparison of values the sorting of text type columns will be done in accordance with the ASCII table sorting criteria To sort on the values of a column click the mouse button in its title heading Beside the title heading a symbol will appear which shows the type of sort exactly as shown in the following table To change the sort type click the mouse in the title heading of the same column It is also possible to carry out this process by means of the Sort Ascending and the Sort Descending option of the data matrix menu Sorting Sorting type Indicator From less to greater From greater to less Sorting Indicators If one wishes to sort on more than one column at a time click the mouse button on the title headings of the columns while keeping the SHIFT key pressed The sequence selected for the columns will be used to decide on which columns are to be sorted on first New sorting columns can be added at any time by clicking the mouse in the title header of the column while keeping the SH FT key pressed 1 December 2008 MEFF 2008 B 9 ModHist User Manual Ap ndice B Customisation of the Data Matrices To eliminate columns sorting criteria click the mouse on its title heading while keeping the CTRL key pressed or use the Suppress Sort option from the data matrix menu B 5 Grouping rows When it is appropriate fo
25. s Grouping by columns 1 December 2008 MEFF 2008 B 10 ModHist User Manual Ap ndice B Customisation of the Data Matrices Take into account that the grouping implies sorting by the grouping fields By means of the Configuration Options option one accesses the configuration screen for the data matrix In the Grouping panel of the said screen one can also activate or deactivate the grouping panel by means of the checkbox Grouping of fields The following diagram shows the options that can be configured Options General Grouping Columns w Field grouping Page totals Group totals Hidden Cancel Activation deactivation of the grouping panel from the options screen 1 December 2008 MEFF 2008 B 11 User Manual B 6 Filtering rows The data matrix allows for the filtering of a set of files to be displayed in accordance with the values of some of the fields The columns which may be used to set filtering conditions are displayed with a arrow button beside their title When this button is pressed a pull down list will appear from which one can select the filtering value for the said column Window title Ap ndice B Customisation of the Data Matrices Todo Personalizado ZZZZZZZZZZZZ ZZZZZZZZZZZZ ZZZZZZZZZZZZ ZZZZZZZZZZZZ OO N
26. sible Cancel Configuration of totals lines from the options screen 1 December 2008 MEFF 2008 B 16 ModHist User Manual Ap ndice B Customisation of the Data Matrices B 8 Presentation options By means of the Configuration Options option one accesses the data matrix configuration screen This section describes the options that can be accessed from within the General panel of the said Screen Rows By means of the See indicator checkbox one can activate or deactivate the display of the control column located at the left of the data matrix which contains a pointer that points to the selected column s The Separator field indicates the separation between rows by the number of pixels of separation between the rows The dialogue box located to the right of this field allows one to select the colour used as a filler in this separator Options General Grouping Columns u Look and Feel iw Native Separator Type o SB Standard Grid Lines Harizontal and Vertic gt Font Rows configuration options 1 December 2008 MEFF 2008 B 17 ModHist User Manual Ap ndice B Customisation of the Data Matrices Look and Feel By means of the Native checkbox one can select whether one wishes to use the presentation elements that are configured with the equipment or whether one wishes to specify a specific type If the checkbox was not checked the pull down list Type allows for the selection o
27. t all the options described are available in ModHist B 1 Parts of a matrix The matrices hold a record in each row Each record is comprised of several fields Each one of the fields is associated with a column The title area is displayed at the top of the matrix where the column names are displayed As will be explained further on from this area one can access the matrix options menu select the sorting criteria move or remove columns and also access other functionalities On the left side of the screen a column of indicators is displayed where the selected record is always highlighted Indicator Columns ti2 tts tt4 tte tiv 4 Titles EE Rows gt Basic components of a data matrix 1 December 2008 MEFF 2008 B 1 ModHist User Manual Ap ndice B Customisation of the Data Matrices In addition to the elements described above depending on the data content a matrix may contain a grouping panel When any kind of grouping has been made buttons will be displayed on the left of the matrix allowing for the expanding or contracting of the different groups Window title Bis Tit vall Tit1 val 1 Grouping panel lt Group headers XXX XXX XXXXXXXX XXX Buttons to expand or reduce groups nnnnn DES nnnnnnnnn nnnn nnnnnn 2 Totals line A Filas de datos Optional elem
28. t to the desired position Window title f Jm Hite tit7 XXXXXXXX XXX 7777 7777 0280 MZ ZZZZZZZZ ZZZ XXXX Alignment XXX XXXXXXXX XXX 7777 Fi Best fit Z ZZZ ZZZ 77777777 ZZZ XXXX XXXXXXXXX XXX XXX XXXXXXXX XXX 7777 NH Z ZZZ ZZZ 77777777 ZZZ XXXX XXXX XXXXXXXXX A Font XXX XXX 7777 7777 777777777 ZZZZZZZZZZZZ 7777 Increase Fort size Z ZZZ ZZZ 77777777 ZZZ XXXX XXXX XXXXXXXXX XXXXXXXXXXXXX Decrease font size XXX XXX XXXXXXXX XXX Li L Configuration options wi Restore configuration Templates Window title m Tis L L L E C Tit16 Columnas Tit47 Tit18 Columns selection 1 December 2008 MEFF 2008 B 4 ModHist User Manual Ap ndice B Customisation of the Data Matrices Position To change the position in which the columns are selected click in the title heading of the column to be moved and keeping the button pressed drag it to the desired position Window title tit1 tit2 tit3 tit4 titS tit6 tit7 XXXX XXX XXX XXX XXX 277277 7777 777777777 727277777727 17272727277 ZZZ ZZZ ZZZ 77777777 ZZZ XXX XXX XXX XXXXXXXX XXX XXXX XXXXXXXXX XXXXXXXXXXXXX
29. time format Color of fund Design 4 Ej Z Data printing and exporting As can be seen from the diagram the printing process has a previewing screen that allows for many aspects of the print out to be configured 1 December 2008 MEFF 2008 9 ModHist User Manual Ap ndice A Available Reports Apendice A Available Reports A list is given below of the reports that are available in ModHist organised in accordance with the same criteria used in the application A 1 Negotiation e General Data o Market o Status o Holidays o Participating entities o Contract groups o Contract types o Contracts o Transaction types e Public Daily Information o Daily contract information o General transactions e Private Configuration Data o Accounts e Operations o Orders o Applications o Operations 1 December 2008 MEFF 2008 A 1 ModHist User Manual Ap ndice A Available Reports A 2 Clearing e General Data o Clearing House o Status o Holidays o Participating entities o Contract groups o Contract types o Contracts o Transaction types e Daily Public Information o Daily contract information e Private Configuration Data o Accounts o Give Out references o Give In references o Give In acceptance filters for the Destination Member o Give In acceptance filters for the Clearer of the Destination Member e Data for Calculating Guarantees o Guarantees matrix parameters o Intra matrix offsetting o lInter mat
30. with the workstation terminal and are saved for future use By means of the Save as default template Template option when one saves a customisation configuration it is also set as the default template If a default template has been selected when a new screen of the same type is opened the said template will be used for the related data matrix Apply To apply a template that was previously saved one must use the option Apply Templates from the data matrix menu Once this option has been selected the name of the template it is desired to open must be chosen Management The Management Templates option of the data matrix menu opens a screen which displays the different templates saved for the subject data matrix By pressing the secondary mouse button on one of the grids one accesses a menu which allows for both the said template to be deleted as well as to assign or unassign it as the default template If a default template has been selected when a new screen of the same type is opened the said template will be used for the related data matrix Restore confiquration The Restore Configuration data matrix menu option allows for one to recover the original appearance of the data matrix This option does not restore the default template as it loads the standard configuration that the workstation terminal came with 1 December 2008 MEFF 2008 B 19

ModHist

Contents

Download Pdf Manuals

Related Search

Related Contents