Changing the Spreadsheet Appearance

The appearance of the Spreadsheet View can be changed in several ways to allow you to customize the way in which you view the data.

Changing the Fields in the Spreadsheet View

The fields displayed in the Spreadsheet View are selected by using the Display Spreadsheet Dialog. This dialog is displayed when you request to view a data series in a spreadsheet. This dialog can be displayed for an existing spreadsheet by selecting Change Spreadsheet… from the context menu of a field heading in the Spreadsheet View. From there, fields can be added or removed from the spreadsheet and current fields can be moved into any order.

Changing the Values Being Displayed in the Spreadsheet View

Typically, values displayed in the Spreadsheet View are the actual values of the fields being displayed. However, it is sometimes desirable to modify these values to view these values in different ways.

The shifting and smoothing of the values being displayed for individual fields can be modified by selecting Change Field Properties… from the context menu for that field. This will display the Change Display Properties Dialog. From there, you can select to display such values as the absolute value of the field, the moving average of the field, or the change in value of a field.

Ä    Note: The raw values of signals do not include the effects of Entry/Exit Strategy settings in the Trading Styles used to analyze them. To see the effect of a trading style on a signal, create the Current Trading Signal Signal Analysis field for the signal and trading style you would like to view.

&  For help changing the actual values of a field, see Changing Values in the Spreadsheet.

Changing the Order of the Fields in the Spreadsheet View

The order of the fields being displayed in the Spreadsheet View is specified using the Display Spreadsheet Dialog. This dialog is displayed when you request to view a data series in a spreadsheet. This dialog can be displayed for an existing spreadsheet by selecting Change Spreadsheet… from the context menu of a field heading in the Spreadsheet View. From there, fields can be added or removed from the spreadsheet and current fields can be moved into any order.

Changing the Format of Numbers

TradingSolutions automatically selects a default format for all fields in the Spreadsheet View. This format specifies how many decimal places to display, along with how to display negative values and whether to display special symbols. Different formats can be selected for individual non-signal fields by selecting Modify Field… from the context menu for the field name and selecting a different format on the Modify Field Dialog: Name page. In addition, new field formats can be created using the Define Field Formats Dialog.

Sorting Data in the Spreadsheet View

The data in the Spreadsheet View can be sorted based on the values in any field. By default, the data is sorted based on the date field. To sort the data based on another field, select Sort Ascending or Sort Descending from the context menu for the field you would like sorted. You can also sort the data based on a field by double-clicking on the heading of that field.

Resizing Columns to Different Widths

By default, TradingSolutions sizes the field columns so that the values in the columns are completely visible. To make a field column a different width, you can use the mouse to resize the column. Simply position the mouse over the right edge of the heading for that column, then press and hold the left mouse button. Moving the mouse left or right will change the width of that column until the mouse button is released.

Ä    Note: It is possible to resize a column until it is no longer displayed. If this occurs and you are not able to restore the column, simply close the Spreadsheet View window and open a new Spreadsheet View for that data series.

You can also restore a field column to its default width by double-clicking on the right edge of the heading for that column.

Using a Larger or Smaller Font

Sometimes, it may be desirable to make the font used in the Spreadsheet View larger or smaller, whether it is to fit more information in the window or to make the values easier to read. To do this, select the zooming options from the context menu for the Date in the header row.

Ä    Note: If you have a mouse with a wheel control, such as a Microsoft Intellimouse, you may also be able to zoom in and out by holding down the Ctrl key and moving the mouse wheel. However, this feature may not be available for all systems.

&  For more help with the Spreadsheet View, see Displaying Data in a Spreadsheet.