Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
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.
Can you help answer these questions from other members on NexusFi?
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.
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.
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.
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!