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


Can I delete a trade from account performance?
Updated: Views / Replies:803 / 9
Created: by DoctorDirty 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: 45 since Sep 2013
Thanks: 43 given, 17 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,319 since Jun 2009
Thanks: 3,529 given, 3,931 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...

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, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 1,970 since Sep 2013
Thanks: 1,388 given, 2,951 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: 45 since Sep 2013
Thanks: 43 given, 17 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, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 1,970 since Sep 2013
Thanks: 1,388 given, 2,951 received
Forum Reputation: Legendary


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,311 since Aug 2009
Thanks: 4,545 given, 10,216 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, AEX, CL, NG, ZB, ZN, ZC, ZS, GC
 
rleplae's Avatar
 
Posts: 1,970 since Sep 2013
Thanks: 1,388 given, 2,951 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: 45 since Sep 2013
Thanks: 43 given, 17 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: Intermediate
Platform: NinjaTrader
Broker/Data: NT
Favorite Futures: Indices, Energy
 
Posts: 13 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: 45 since Sep 2013
Thanks: 43 given, 17 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)

FIO Journal Challenge featuring NinjaTrader ($2,000+ of prizes)

May
 

Prototyping Python Strategies (part 2: Backtesting) w/Ran Aroussi [special time: 1PM ET]

Elite only
 

Portfolio Diversification w/Brendon Delate @ Diversify Portfolio

Elite only

An overview of volumetric analytical tools w/Sergey Sokolov @ PTMC

Elite only

John Hoagland (TBA)

Elite only

FuturesTrader71 Extended Ask Me Anything (AMA)

Elite only

Pete @ Jigsaw Trading (TBA)

Elite only

John @ No BS Day Trading (TBA)

Elite only

An Afternoon with FIO member Softsoap (being rescheduled)

Elite only
     

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


All times are GMT -4. The time now is 05:55 PM.

Copyright © 2017 by futures io, s.a., Av Ricardo J. Alfaro, Century Tower, Panama, +507 833-9432, info@futures.io
All information is for educational use only and is not investment advice.
There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
no new posts
Page generated 2017-05-24 in 0.14 seconds with 19 queries on phoenix via your IP 54.224.153.234