Database Operations

<< Click to Display Table of Contents >>

Navigation:  Operations > Database >

Database Operations

Previous page Return to chapter overview Next page

Show/Hide Hidden Text

Various database operations can be performed from the Database window.

 

Database_Window

 

tog_minus        Rollover futures instruments

Rollover Futures Instruments

This will rollover your futures instrument to the most recent expiries across all open workspaces. If there are instruments open in the workspace that are eligible to be rolled forward they will be shown in the grid. For more information on this process please see the rolling over a futures contract section of the help guide.

tog_minus        Update instruments

Update Instruments

This will replace and update all instruments to current server definitions.

 

The NinjaTrader data server maintains definitions for Instruments, NinjaTrader will update your local instrument general properties and symbol mappings should there be any changes on the server automatically. However if you make any changes to the either the general properties or the symbol mappings for an instrument then the instrument would no longer be automatically updated. Using this utility will remove any custom changes you have made locally and update the instrument definition to the servers version.

 

General properties

Sets if the General properties of each instrument will be replaced with the server definition

Symbol mappings

Sets if the Symbol mappings of each instrument will be replaced with the server definition

Remove user added instruments

Sets if instruments created by the user will also be removed

 

Note: If you would like to report an incorrect or missing server definition please send an email to platformsupport@ninjatrader.com and we will promptly correct the issue.

tog_minus        Update instrument lists

Update Instruments Lists

This will replace and update all instrument lists to current server definitions.

 

The NinjaTrader data server maintains definitions for the following instrument lists:

 

Dow 30
FOREX
Futures
Indexes
NASDAQ 100
SP 500

 

Any time there is an instrument added or removed to the above instrument lists they will be automatically updated by NinjaTrader. However if you add or remove instruments from the list manually using the Instrument Lists window then the instrument list will no longer continue to be updated automatically by NinjaTrader. Should you wish to update and reset your instrument lists manually then you would use the following update utility.

 

Predefined instrument lists

Sets if the General properties of each instrument will be replaced with the server definition

Remove user added instrument lists

Sets if instruments created by the user will also be removed

 

Note: If you would like to report an incorrect or missing server definition please send an email to platformsupport@ninjatrader.com and we will promptly correct the issue.

tog_minus        Reset DB

Reset the Database

This will remove historical trade data from the database. It will not remove chart data or reset any Simulation accounts.

 

Historical orders

Sets if the historical orders stored in the database will be removed

Historical executions

Sets if the historical executions in the database will be removed

tog_minus        Repair DB

Repair the Database

This should only be used when directed by NinjaTrader support and performs a repair on the NinjaTrader database. Depending on the size of the database this can take a few moments to complete.