Changing Values in the Spreadsheet
Values in fields that have been imported or are manual entry fields can be modified directly in the Spreadsheet View. Cells of fields that can be modified have a white background to clearly distinguish them from fields that cannot be modified.
Modifying Values in the Spreadsheet
To modify a single value, simply click on the cell containing the value and type in a new value. You can also use copy, cut, and paste to edit these values. If this is the first change to the values in this Spreadsheet View, TradingSolutions will confirm that you want to modify the values in the spreadsheet. After pressing enter or moving to a new cell, any calculated values affected by the new entry will be recalculated automatically.
Ä Note: Values can be entered as decimal numbers or fractional numbers, regardless of the current display format.
Using copy, cut, and paste, it is also possible to copy the values from entire dates, fields, or sections. The only requirement when doing this is that the region being pasted to must be the same size as the region that was copied.
Adding New Dates
To add new dates to the spreadsheet, select Insert New Dates… from the context menu for the date field. This will display the Insert Date Range Dialog, which allows you insert new dates at the beginning, middle, or end of the data series. Once the dates are added, you can enter the values for them directly into the spreadsheet.
Ä Note: If you will be importing the values for these new dates from a file, you do not need to perform this step. Data that is being imported automatically creates any needed new date records in the data series.
Removing Dates
One or more rows of data can be removed from the data series by selecting them in the Spreadsheet View and selecting Remove Data from the context menu for a date in the selected region. This will display the Remove Date Range Dialog, which allows you to remove a range of dates.
& For more help with the Spreadsheet View, see Displaying Data in a Spreadsheet.