Database

[djkiwi]

Hi Guys, I was having a few nasty issues with charts slow to load and corrupt instruments that I was continually having to reload.

I looked at the forum and saw a post on renaming the old database and then logging into ninja which created a new one. I renamed the NinjaTrader.sdf

Overall the speed improved considerably. This resulted in a couple of other issues though :

1. Firstly my atmstrategies seem to be deleted. Is there a way of getting this back from the old database? Like loading in the old database on another pc etc?
2. Second I had to load in manually all instruments not contained in the default master list. Is there an easier way of doing this and setting the miscellaneous tab under interactive brokers to the instrument being imported?
3. All the sim data has been deleted. Is there a way of getting the old sim data with all my trade history into the new database?
4. The default futures instruments it loaded were the 09-11 period and not the 12-11. The charts populated correctly with the 12-11 instruments even though they were not in the default instrument list and I loaded them in later. Any idea why the 9-11 loaded and not the 12-11? Maybe I have a setting incorrect.

I really need point 3 so if I cannot get the history back is there a way of reloading the old database and reconditioning it so it's fast like now? Now I am thinking that NinjaTrader.sdf was the wrong file but there is no other file in the db directory.

Thanks
DJ

[NinjaTrader_RyanM1]

Hi DJ,

For performance reasons support may recommend you rename a database. Glad to hear you were able to get increased performance when doing this. Yes, you can certainly restore your database by naming the old one back to NinjaTrader.sdf but this may negate any of your performance gains you have with a new database. Unfortunately you won't be able to take pieces from one database and put into another.

[djkiwi]

Trade Sim data

Thanks Ryan. If I backup the historical trade data from the old database and then restore this to the new database I assume this gives me all my sim history?

Thanks
DJ

[NinjaTrader_RyanM1]

The concern is that there is no way to selectively backup just the trade history. You can either restore the whole old database or start with a new one.

What you may consider doing is restoring your old database, and then use the account performance reporting feature to generate a history of your trades. You can send this data outside of NinjaTrader using the Right Click > Grid menu. Once you have this data available outside of NinjaTrader, could then go back to a new database.

[djkiwi]

Historical Trade Data

Thanks Ryan, that won't help much I'm afraid as I like to do extensive analysis using the ninja features and analytical tools. I am confused about what is actually stored in the database. The database I replaced was tiny with only 300mb and has over 1 year of trade records. So I'm not sure how recreating a new database helped much given it was tiny.

Is there something else I can try instead so I can keep this trade history? I intend to use ninja long term so would like to understand how I can avoid losing my trade history if I rebuild the database.

How is resetting the database different from creating a new one?

Thanks
DJ

[NinjaTrader_RyanM1]

Database stores your ATM Strategy templates, Session templates, Instrument Lists / Custom Instruments and historical trade execution data.

Resetting the database only removes your trade execution data, but keeps all of the other items above.

300 MB may not be big compared to your hard drive, but is big compared to the default size (around 5 MB).

I'm not aware of another approach that will allow you to keep your trade history and keep the improved performance from a clean DB.