MASTER INDEX
  SEARCH
  CHARTS
  MAIN TOOLBAR
  SETTING PREFERENCES
  TECHNICAL INDICATORS
  WHAT'S NEW
  ALARMS
  BACKTESTING
  CONFIRMING TRADES
  CUSTOM COLUMNS
  CUSTOM INDICATORS
  CUSTOM INSTRUMENTS
  CUSTOM PRICES
  DATA FEEDS
  DATABASE
  DOWNLOADING DATA
  FEED STATUS
  HEARTBEAT
  HELP
  MULTI-LINKING
  MULTI-PERIODICITY
  INSTRUMENT SETUP
  NASDAQ LEVEL II
  NEWS TICKER
  NEWS BROWSER
  OPTIMIZATION
  OPTIONS ANALYTICS
  PLACING TRADES
  PORTFOLIOS
  PRESETS
  PRINTING
  QUICK QUOTES
  QUOTE PAGES
  REALIZATION
  RTL LANGUAGE
  SCANS
  SCHEDULES
  SCOPE
  SYSTEM STATUS
  TICKER TAPE
  TIME AND SALES
  TRADING NOTES
  USER VARIABLES
  VERTICAL SCALE
MASTER INDEX
DICTIONARY
FEEDBACK

View/Edit Historical Data
Time & Sales Window

In Investor/RT, View/Edit windows are identical to, and have the same properties as Time and Sales windows, except the Time and Sales windows have a periodicity of "tick" and update live.

You can access the Time and Sales window by clicking on the T/S button on the quotepage toolbar. You can access the View/Edit window by either clicking on the V/E button on the chart or quotepage toolbar, or by choosing "Control: Data Management: View/Edit" from the menu.

You may navigate through the fields by clicking them with the mouse, clicking on the horizontal or vertical scroll bars, or using keyboard keys. The up and down arrow keys move up and down a row at a time. Tab moves one field to the right. Shift + Tab moves one field to the left.

Data for Daily, Weekly, Monthly, and Tick charts can be edited. Intra-day bars can be viewed but may not be revised since they are derived from tick data. To revise a data element, click the mouse in the cell, revise the number, and press tab, enter or return. Prices may be entered as fractions or as decimals. Volume and open interest numbers may be entered with the suffix k or m for thousand and million, respectively, e.g. 1100k, 1.1m, and 1,100,000 are equivalent. Note: If you edit a cell but close the history window before pressing return, enter, or tab, or clicking in a different cell, the change will not be stored.

The active chart window is automatically refreshed to reflect the edited data when you close the view/edit spreadsheet. Other charts that are open at the time the edits are made may not reflect the changes.

Certain cell categories, such as "QuoteTime" do not allow editing. You may delete any row of data in the spreadsheet by selecting the row (click in any cell) and pressing the Del (Delete) key on the keyboard. Confirmation will be requested.

If you wish to make major edits to your data, another method would be to export the data, make changes using a text editor of your choice, and then import the edited data.