Questions about the Spreadsheet View
General Questions
How can I display more data in a spreadsheet?
This question can have several different meanings, each of which is answered below.
If you would like to reduce the size of the text in the spreadsheet, select Zoom Out from the context menu for the Date column heading. You can also use the mouse wheel of Microsoft Intellimouse to adjust the scaling by holding down the Ctrl key while moving the mouse wheel.
If you would like to make the Spreadsheet View window larger to display more data, you can maximize that window by pressing the maximize gadget in the title bar of the chart window. The maximize gadget is the button with a square in it, next to the button with an X in it.
You can also make more room for the Chart View and Spreadsheet View windows by temporarily hiding the Portfolio View. To do this, press the Toggle Portfolio View button in the toolbar, or select Toggle Portfolio View from the View menu. Select this option again to restore the Portfolio View.
If you would like to add additional fields to a Spreadsheet View, select Change Spreadsheet… from the context menu for any column heading. This will display the Display Fields in Spreadsheet Dialog.
Questions about Calculated Fields
Why are there empty cells at the start of some of my calculated and predicted fields?
Empty cells represent null values. Null values are typically produced when there is not sufficient data to calculate a value. This can be due to one of the inputs to a calculation or prediction being null, or a calculation or prediction requiring a previous value that is not yet available. For example, a moving average is an average of the current value with the specified number of previous values. A moving average of ten requires nine previous values to be calculated. Therefore, the first nine records for a moving average will be null.
Null values are propagated. For example, a moving average of a moving average will be null until the first moving average has enough values to calculate the second moving average. In this case, a moving average of ten of a moving average of ten will begin with eighteen null values – nine for the first moving average and nine for the second.
Predictions require all of their inputs to be non-null to produce a value. If you are using the change in a value as an input, it is important to note that this requires the current value and the previous value to be calculated.
Ä Note: This restriction only applies to the inputs to the neural network. The memory included in some neural network topologies will produce values as long as all of the current inputs are available. However, it is important to be aware that random values may be used in the memory at the beginning of the data.
Why are there empty cells at the end of my optimal signal field?
Empty cells represent null values. Null values are typically produced when there is not sufficient data to calculate a value. This can be due to one of the inputs to a calculation or prediction being null, or a calculation or prediction requiring a previous value that is not yet available. In this case, an optimal signal field uses a specified number of future samples to generate an appropriate signal. If the required future samples are not available, the optimal signal will not be able to be generated.