So I'm paper trading with NinjaTrader and it disconnected while in a short trade in GC during Brexit so instead of hitting my stop I was -$6000 in the hole.

Basically I want to know if there's a way to delete this trade from the Account Performance data without wiping all of my data.

DoctorDirty 

So I'm paper trading with NinjaTrader and it disconnected while in a short trade in GC during Brexit so instead of hitting my stop I was -$6000 in the hole. Basically I want to know if there's a way to delete this trade from the Account Performance data without wiping all of my data.

It's easy to reset all trades from Ninja interface, but for single one you'll have to open Ninja SQLce database (Documents\NinjaTrader 7\db\NinjaTrader.sdf), and find the trade in the table nt_execution and in nt_order.
Not very simple...

DoctorDirty 

So I'm paper trading with NinjaTrader and it disconnected while in a short trade in GC during Brexit so instead of hitting my stop I was -$6000 in the hole. Basically I want to know if there's a way to delete this trade from the Account Performance data without wiping all of my data.

Probably safer to update the table for the execution price so that the result = 0
and not delete it, as you might break the relation in the DB

sam028 

It's easy to reset all trades from Ninja interface, but for single one you'll have to open Ninja SQLce database (Documents\NinjaTrader 7\db\NinjaTrader.sdf), and find the trade in the table nt_execution and in nt_order. Not very simple...

Thank you for the info. So my next question is what program do I use to open the .sdf file?

I installed a program called CompactView and it returns an error when I try to open it. Also I tried opening it through SQL Server Management Studio and that didn't work either.

DoctorDirty 

Thank you for the info. So my next question is what program do I use to open the .sdf file? I installed a program called CompactView and it returns an error when I try to open it. Also I tried opening it through SQL Server Management Studio and that didn't work either.

CompactViewer is fine, on top of compact viewer, you need to install SQLCE drivers, be careful to download
the correct version 3.5 build 8085, the same as the DLL in your ninjatrader folder

or you can go to control center and click on executions. then highlight the trade you want to remove. right click and you'll see the option to delete that trade. it should also adjust the account performance.

interesting feature, but ...

Silvester17 

or you can go to control center and click on executions. then highlight the trade you want to remove. right click and you'll see the option to delete that trade. it should also adjust the account performance. interesting feature, but ...

That's a good one...
I learned something

Silvester17 

or you can go to control center and click on executions. then highlight the trade you want to remove. right click and you'll see the option to delete that trade. it should also adjust the account performance. interesting feature, but ...

That's good to know! It's strange to me that you can right click > remove under Executions but not under Account Performance.

Is there a way to make 'historical' trades show up under Executions so I can delete them?

Ninja Trader allows "resetting" simulation accounts only, not removing them.

WHY would anyone want to remove a trade result from simulation?

I believe...that trader, may be considering false representing results...
So be honest with yourself and others...it helps become a clear minded trader.

Kowabunga 

Ninja Trader allows "resetting" simulation accounts only, not removing them. WHY would anyone want to remove a trade result from simulation? I believe...that trader, may be considering false representing results... So be honest with yourself and others...it helps become a clear minded trader.

Because of the reason I said in the original post. The reason for the disconnect was the trial account expiring, which would not happen in a live trading environment.

----------------------------------------------------

Anyways, for those looking at this in the future:

I was able to 'zero out' the trade with the instructions rleplae and sam028 suggested.

However, for SQLCE v3.5 I was only able to find build 8080, not 8085, but it worked fine.
Also, I only 'zeroed out' the values in nt_execution and not nt_order.

Be sure to back up your NinjaTrader.sdf before you do anything!