Trough&Peak Analysis

Trough & Peak Analysis is designed for detailed analysis of minimum, maximum, average, total, first and last value, rate to max, min and average values of a security or group of securities data such as close, volume, MCAP, etc.

You can view this form by selecting New> Trough & Peak Analysis from SG icon on the top left corner of the application on your Workspace.

Trough & Peak Analysis Designer:

You can use this window from left to right as a wizard. Once you completed your selections in the Designer, you can view detailed list on the form.

Security/Group Selection: There are two options on the top left of designer. By selecting “Security” option on the top left of the designer, you can pick one security or more to analyze. If you choose “Group” option, you can analyze any group of securities such as an index, sector or MyList.

Show Names: You can check this box in order to display names of the securities.

Date Selection: You can pick dates you are interested in. Default date range is the previous year from today. You can arrange first and last days using the date picker.

Data Field: This section consists of 3 lists, the data field, types and a combination of selections below. The intersection of the data fields of the selected securities is listed on the left. You can select any set of data fields and types (minimum, maximum, average, total, first, last ,rate to maximum, rate to minimum and rate to average values) and send them to the list below using arrow buttons. You can select multiple fields and types by using “Ctrl” key and left- click mouse button at the same time or simply holding down left mouse button on the items you want to select. You can delete the items on the list by clicking up arrow button.

For example, when you select XU100 index and Value (Max), Value (Min), MCAP (Max), MCAP (Min),

Minimum and Maximum values of value will be found by looking at the closing values of the index
When it comes to the MCAP values, MCAP values of all the securities within the index will be summed for each day and then the maximum and minimum MCAP value of the index will be found.

Show dates: You can check this box in order to display the dates of the occurrences in an additional column.

Currency: You can view the list in any currency. Default currency is the one you selected in the options. You can change the default currency on the SG icon>Options>Currency window.

Once you have made your selections and click the “OK” button, your final table will be created. Here, you can change the date range and currency on the caption. You can also edit your selections by clicking “Designer” on the right click menu or pressing “F3” button.

Inherited from MyGrid, Trough & Peak Analysis form has all the features of MyGrid.