Saving and Restoring Spreadsheets

Charts and spreadsheets can be saved in TradingSolutions to be viewed later using a concept called "Data Views". A data view allows you to take the current settings of a chart or spreadsheet and save it with a name so that you can open it later. In addition, the most recent chart and spreadsheet for each data series are automatically saved so that you can return to viewing them.

Restoring the Most Recent Spreadsheet

Each time you close a spreadsheet, it is automatically saved as the most recent view for that data series. When you select to view another spreadsheet for that data series, the Display Spreadsheet Dialog is displayed with the most recent view automatically selected. To open this view, press the OK button without making any additional changed. To open a different saved view, select it from the list of previous views. Or, to create a new view, choose Select new fields to display and select the desired fields.

You can also set TradingSolutions to automatically restore all of the previously open charts and spreadsheets from when you last closed TradingSolutions. This option is available on the Modify Options Dialog: General page. It is left off by default to allow TradingSolutions to open and close faster.

Saving and Restoring Spreadsheets

Individual spreadsheets can be saved with a name to be restored later. To do this, select Save this Spreadsheet… from the context menu for the chart. This will display the Save View Dialog, which will allow you to specify a name for your chart.

Ä    Note: You can update previously saved views by saving them with the same name.

To open the saved view, select it from the Display Spreadsheet Dialog and press OK. Saved views can be renamed or deleted by pressing the Manage Views button on this dialog. This will display the Modify Data Series Dialog: Data Views page.

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