Can I delete a trade from account performance? - NinjaTrader | futures.io
futures.io futures trading


Can I delete a trade from account performance?
Started: by DoctorDirty Views / Replies:650 / 9
Last Reply: Attachments:0

Welcome to futures.io.

Welcome, Guest!

This forum was established to help traders (especially futures traders) by openly sharing indicators, strategies, methods, trading journals and discussing the psychology of trading.

We are fundamentally different than most other trading forums:
  • We work extremely hard to keep things positive on our forums.
  • We do not tolerate rude behavior, trolling, or vendor advertising in posts.
  • We firmly believe in openness and encourage sharing. The holy grail is within you, it is not something tangible you can download.
  • We expect our members to participate and become a part of the community. Help yourself by helping others.


You'll need to register in order to view the content of the threads and start contributing to our community. It's free and simple, and we will never resell your private information.

-- Big Mike

Reply
 
Thread Tools Search this Thread
 

Can I delete a trade from account performance?

  #1 (permalink)
Elite Member
Fukuoka-shi, Fukuoka-ken, Japan
 
Futures Experience: None
Platform: NinjaTrader
Favorite Futures: Futures
 
Posts: 30 since Sep 2013
Thanks: 37 given, 12 received

Can I delete a trade from account performance?

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.

Reply With Quote
 
  #2 (permalink)
Administrator: Retired Backtester
 Vendor: speedytradingservers.com 
Rennes France
 
Futures Experience: Advanced
Platform: NinjaTrader
Broker/Data: IB/Kinetick
Favorite Futures: Futures
 
sam028's Avatar
 
Posts: 3,257 since Jun 2009
Thanks: 3,480 given, 3,847 received


DoctorDirty View Post
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...

Usually in trading, those who know don't talk, and those who talk don't know. (Al Brooks)
success requires no deodorant! (Sun Tzu)
Reply With Quote
The following 2 users say Thank You to sam028 for this post:
 
  #3 (permalink)
Elite Member
Omer עומר / Israel י
 
Futures Experience: Master
Platform: NinjaTrader, Proprietary,
Broker/Data: Ninjabrokerage/IQfeed + Synthetic datafeed
Favorite Futures: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, CL, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 1,658 since Sep 2013
Thanks: 1,220 given, 2,502 received
Forum Reputation: Legendary



DoctorDirty View Post
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

Reply With Quote
The following user says Thank You to rleplae for this post:
 
  #4 (permalink)
Elite Member
Fukuoka-shi, Fukuoka-ken, Japan
 
Futures Experience: None
Platform: NinjaTrader
Favorite Futures: Futures
 
Posts: 30 since Sep 2013
Thanks: 37 given, 12 received


sam028 View Post
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.

Reply With Quote
 
  #5 (permalink)
Elite Member
Omer עומר / Israel י
 
Futures Experience: Master
Platform: NinjaTrader, Proprietary,
Broker/Data: Ninjabrokerage/IQfeed + Synthetic datafeed
Favorite Futures: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, CL, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 1,658 since Sep 2013
Thanks: 1,220 given, 2,502 received
Forum Reputation: Legendary

Futures Edge on FIO

DoctorDirty View Post
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

Reply With Quote
The following user says Thank You to rleplae for this post:
 
  #6 (permalink)
Market Wizard
Columbus, OH
 
Futures Experience: None
Platform: NT 8, TOS
Favorite Futures: ES
 
Silvester17's Avatar
 
Posts: 3,245 since Aug 2009
Thanks: 4,472 given, 9,963 received
Forum Reputation: Legendary

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 ...

Reply With Quote
The following 3 users say Thank You to Silvester17 for this post:
 
  #7 (permalink)
Elite Member
Omer עומר / Israel י
 
Futures Experience: Master
Platform: NinjaTrader, Proprietary,
Broker/Data: Ninjabrokerage/IQfeed + Synthetic datafeed
Favorite Futures: 6A, 6B, 6C, 6E, 6J, 6S, ES, NQ, YM, CL, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 1,658 since Sep 2013
Thanks: 1,220 given, 2,502 received
Forum Reputation: Legendary


Silvester17 View Post
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

Reply With Quote
The following user says Thank You to rleplae for this post:
 
  #8 (permalink)
Elite Member
Fukuoka-shi, Fukuoka-ken, Japan
 
Futures Experience: None
Platform: NinjaTrader
Favorite Futures: Futures
 
Posts: 30 since Sep 2013
Thanks: 37 given, 12 received


Silvester17 View Post
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?

Reply With Quote
 
  #9 (permalink)
Trading Apprentice
NYC, NY, USA
 
Futures Experience: Beginner
Platform: NinjaTrader
Favorite Futures: Indices, Energy
 
Posts: 12 since Jul 2015
Thanks: 0 given, 4 received

Not positive, but NO

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.

Reply With Quote
 
  #10 (permalink)
Elite Member
Fukuoka-shi, Fukuoka-ken, Japan
 
Futures Experience: None
Platform: NinjaTrader
Favorite Futures: Futures
 
Posts: 30 since Sep 2013
Thanks: 37 given, 12 received



Kowabunga View Post
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!

Reply With Quote

Reply



futures.io > > > > Can I delete a trade from account performance?

Thread Tools Search this Thread
Search this Thread:

Advanced Search



Upcoming Webinars and Events (4:30PM ET unless noted)

2016 True Edge Awards: Voting is open until Jan 21!

Now
 

An Afternoon with FIO member Massive l

Elite only
 

Anthony Drager: Pulling the trigger with confidence

Elite only
 

Leo Murphy: The Art and Science of Technical Analysis

Elite only
 

FuturesTrader71: Ask Me Anything

Elite only
     

Similar Threads
Thread Thread Starter Forum Replies Last Post
Reading the Account Performance/Trading alpine4133 NinjaTrader 8 June 17th, 2014 05:58 AM
Account performance and statistics ktrader MultiCharts 4 November 8th, 2011 07:53 AM
Incorrect account performance on N7 fxprobie Traders Hideout 4 August 24th, 2010 09:21 AM
NinjaTrader Account Performance Tabissues Gabe2004 NinjaTrader 1 December 2nd, 2009 08:27 AM
Account Performance alpine4133 NinjaTrader 2 September 12th, 2009 01:59 PM


All times are GMT -4. The time now is 06:03 AM.

no new posts
Page generated 2017-01-20 in 0.13 seconds with 20 queries on phoenix via your IP 54.92.229.162