The Spreadsheet View Window

The Spreadsheet View window has the following features:

·      Spreadsheet View Title Bar

The title bar displays the name of the data series in the Spreadsheet View window. It also includes buttons for minimizing, maximizing, and closing the window.

Ä    Note: If the Spreadsheet View is maximized, the information in the title bar will appear as part of the main title bar for TradingSolutions and the buttons will appear on the far right of the menu bar.

·      Date Column

The Date column always appears on the left side of the Spreadsheet View window. It displays the date associated with data and has its own context menu with options for inserting and removing dates.

·      Field Columns

The field columns display the data associated with the dates in the Date column. The context menu for the heading row includes options that let you manipulate the fields. The data in each column has different background colors depending on the source of the data:

Background Meaning

White Raw data that can be modified.

Gray Calculated data or data from another data series.

Pink Predicted data in the training set.

Green Predicted data in the cross validation set.

Blue Predicted data in the testing set.

·      Scroll Bars

The Spreadsheet View window has scroll bars that allow you to move quickly forward and backward through the dates, as well as left and right through the fields.

·      Splitter Bars

At the top of the vertical scroll bar and at the right of the horizontal scroll bar are splitter bars that allow you to divide the Spreadsheet View window into multiple sections so that you can view non-contiguous data or fields at the same time.

·      Record Controls

The bottom of the Spreadsheet View window includes record controls that display the record number of the current entry relative to the beginning of the data. These controls allow you to move quickly through the data or jump directly to a specific record number.

Loading All Available Data

By default, the Spreadsheet Window loads only a subset of the data for display. This allows TradingSolutions to display the data more quickly. To load all of the available data into a spreadsheet, right-click on the date column and select Load Remaining Data from the context menu. Alternatively, the amount of data to be loaded can be selected when the spreadsheet is first created.

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