Wednesday, April 2, 2014

Blank NinjaTrader Instrument Database

If I remember correctly, NinjaTrader is pre-loaded with the definitions for about 17k instruments which are mainly stocks, futures and currency pairs for the US markets. I am running NinjaTrader in a VM environment. Sometimes the Instrument Manager will freeze momentarily when I add or remove an instrument. Since my focus has always been on Malaysian instruments, I embarked on a mission to get rid of all the pre-loaded instruments irrelevant to me.

If you have all the time in the world, you can delete each and every instrument one at a time in the Instrument Manager. It is a shame we cannot select multiple instruments for deletion. If you have some basic knowledge of SQL, a faster way to remove unwanted instruments is to update the NinjaTrader database directly.

NinjaTrader 7 Database Path:
C:\Users\{username}\Documents\NinjaTrader 7\db\NinjaTrader.sdf 

I will not go into details how I purged the database. If you would like to build your own instruments database from scratch, you may download the blank [1] NinjaTrader database file here [2]. Simply replace the file in the above-mentioned path and you are good to go.


---
  1. The database is not really blank. It still contains the instrument definitions for the major currency pairs.
  2. Download blank NinjaTrader Instrument Database.

No comments:

Post a Comment