NexusFi: Find Your Edge


Home Menu

 





really annoying performance reporting


Discussion in NinjaTrader

Updated
      Top Posters
    1. looks_one dmau with 9 posts (2 thanks)
    2. looks_two NinjaTrader with 7 posts (3 thanks)
    3. looks_3 ThatManFromTexas with 6 posts (2 thanks)
    4. looks_4 Big Mike with 2 posts (0 thanks)
      Best Posters
    1. looks_one dakine with 1 thanks per post
    2. looks_two NinjaTrader with 0.4 thanks per post
    3. looks_3 ThatManFromTexas with 0.3 thanks per post
    4. looks_4 dmau with 0.2 thanks per post
    1. trending_up 8,532 views
    2. thumb_up 8 thanks given
    3. group 4 followers
    1. forum 27 posts
    2. attach_file 7 attachments




 
Search this Thread

really annoying performance reporting

  #21 (permalink)
 
NinjaTrader's Avatar
 NinjaTrader  NinjaTrader is an official Site Sponsor
Site Sponsor

Web: NinjaTrader
AMA: Ask Me Anything
Webinars: NinjaTrader Webinars
Elite offer: Click here
 
Posts: 1,714 since May 2010
Thanks Given: 203
Thanks Received: 2,686


ThatManFromTexas View Post

If you start the DAILY reports on a day where you started the day flat and run the last daily report on a day where you ended flat, and then ran a report for the entire period INCLUSIVE of the first entry and the last exit, would the totals of the daily reports then equal the total for the period report?

Mathematically there are scenarios where it would equal but not probable. The reason is that the trade pairings would be different if one had positions carried over from one session to the next and thus the performance calculations would likely generate different results.

Follow me on Twitter Reply With Quote

Can you help answer these questions
from other members on NexusFi?
About a successful futures trader who didnt know anythin …
Psychology and Money Management
Trade idea based off three indicators.
Traders Hideout
NT7 Indicator Script Troubleshooting - Camarilla Pivots
NinjaTrader
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
What broker to use for trading palladium futures
Commodities
 
  #22 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,464 since Jun 2009
Thanks Given: 33,242
Thanks Received: 101,662

Sounds like you need to bust out your brokerage statements, and go trade by trade, day by day, until you understand the discrepancies.

What @NinjaTrader is saying makes sense. I think the next step is for you to consult your brokerage statements and identify the exact trades that are different, to better understand why it is happening.

Mike



Join the free Markets Chat beta: one platform, all the trade rooms!

We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on Twitter Visit my NexusFi Trade Journal Reply With Quote
  #23 (permalink)
 
NinjaTrader's Avatar
 NinjaTrader  NinjaTrader is an official Site Sponsor
Site Sponsor

Web: NinjaTrader
AMA: Ask Me Anything
Webinars: NinjaTrader Webinars
Elite offer: Click here
 
Posts: 1,714 since May 2010
Thanks Given: 203
Thanks Received: 2,686



dmau View Post
yes. those 2 numbers are equal but they are both incorrect. - not even remotely close-



Also I have even got into the discrepancy under the accounts tab. cash value 107k (approx) - yet realized number is -$150 and the cash started at 100k
.....

I have provided (I hope) a clear understanding of the logic behind the trade performance engine and how the input impacts the results. I have also provided logic as to why one range period results would be different than another. If you are comparing results to your brokerage statements, and they do not match then...

- If you carry positions overnight they likely will not since brokerage statements are marked to market, something a client side application is not capable of matching
- If you don't carry positions overnight then you must look at the input used (executions) to make sure the are correct and you have all historical fills in NinjaTrader
- Make sure commissions match by setting the correct values

Follow me on Twitter Reply With Quote
  #24 (permalink)
 
dakine's Avatar
 dakine 
Volcano, HI
 
Experience: None
Platform: Ninja
Broker: AMP/CQG
Trading: Futura2000
Posts: 200 since Dec 2009
Thanks Given: 389
Thanks Received: 166

FWIW, I don't hold positions overnight and I never have any discrepancies with reporting whether I run daily, weekly or monthly reports... NT is always spot on.

Reply With Quote
Thanked by:
  #25 (permalink)
 
ThatManFromTexas's Avatar
 ThatManFromTexas 
Houston,Tx
 
Experience: Advanced
Platform: NinjaTrader
Broker: Mirus Futures/Zen-Fire
Trading: TF
Posts: 2,265 since Feb 2010
Thanks Given: 1,206
Thanks Received: 4,355


NinjaTrader View Post
If you are comparing results to your brokerage statements, and they do not match then...

- If you carry positions overnight they likely will not since brokerage statements are marked to market, something a client side application is not capable of matching


dakine View Post
FWIW, I don't hold positions overnight and I never have any discrepancies with reporting whether I run daily, weekly or monthly reports... NT is always spot on.

@dmau

Looks like the short answer is, if you hold positions overnight ....

Use your brokerage statement for accounting.

I'm just a simple man trading a simple plan.

My daddy always said, "Every day above ground is a good day!"
Reply With Quote
  #26 (permalink)
 ddnut 
San Marcos, CA
 
Experience: Intermediate
Platform: NinjaTrader
Trading: 6E, ES
Posts: 54 since Nov 2010
Thanks Given: 125
Thanks Received: 33


NinjaTrader View Post
I have not followed up with my support team on this case nor have I read in detail your post but I did want to offer up one point of understanding.

NinjaTrader performance reporting is simply a set of calculations of fills that have a time stamp within the date range specified. The first step in the process is to filter the fills and then pair them to form trades. If positions are carried over night then surely you can have different results since the trade pairs will be different if you change dates.

Example:
Enter 1 June 4th
Exit 1 June 5
Enter 1 June 5
Exit 1 June 5

In the fill flow above, if you generated a report from June 4 through 6, you would see two trades reported (Entry June 4th and Exit June 5th) and (Entry June 5th and Exit June 5).

If you generated a reported June 5th through June 6th, you would only see one trade reported where the exit on June 5th is the trade entry and the entry on June 5th is the exit.

As you can see, the result would yield different results. NinjaTrader has no way of knowing if a fill is truly an entry or exit thus it has to build trade pairs starting with the first fill as entry in the date filtered dataset.

I am not sure if this is an explanation for your situation but might help to understand what is happening under the hood.


ThatManFromTexas View Post
@NinjaTrader

I understand what you are saying, but if he ran a report each day and totaled all the daily reports, and then ran a report for the entire period (inclusive of all entries and exits) , the two totals should be equal, right?

@ThatManFromTexas,
Assume that both trades are long and winners of $250 each. The daily performance report for 4 June would show 0 trades since the long entry has no match. The daily report for 5 June would show 1 trade, a sell followed by a buy. This is a FALSE trade. The third trade is seen as an open short and is again not counted in the performance report.

Thus the individual reports could look something like this: Profit for 4 June is 0, profit for 5 June is -1000, profit for 4-5 June is +500.

But there is another anomaly that I cannot figure out. Comparing the screenshots 22/05-01/06 to 22/05-05/06 there is a net difference of 5 trades (42-37). But the reports for the individual days show 12, 3, 1, and 1 trades respectively. It seems that NT would be counting fewer trades on the individual daily reports, not more.

Reply With Quote
  #27 (permalink)
 
ThatManFromTexas's Avatar
 ThatManFromTexas 
Houston,Tx
 
Experience: Advanced
Platform: NinjaTrader
Broker: Mirus Futures/Zen-Fire
Trading: TF
Posts: 2,265 since Feb 2010
Thanks Given: 1,206
Thanks Received: 4,355


ddnut View Post
@ThatManFromTexas,
Assume that both trades are long and winners of $250 each. The daily performance report for 4 June would show 0 trades since the long entry has no match. The daily report for 5 June would show 1 trade, a sell followed by a buy. This is a FALSE trade. The third trade is seen as an open short and is again not counted in the performance report.

Thus the individual reports could look something like this: Profit for 4 June is 0, profit for 5 June is -1000, profit for 4-5 June is +500.

But there is another anomaly that I cannot figure out. Comparing the screenshots 22/05-01/06 to 22/05-05/06 there is a net difference of 5 trades (42-37). But the reports for the individual days show 12, 3, 1, and 1 trades respectively. It seems that NT would be counting fewer trades on the individual daily reports, not more.

@ddnut

NT reports are designed for day trading. Don't try forcing a square peg in a round hole.

I'm just a simple man trading a simple plan.

My daddy always said, "Every day above ground is a good day!"
Reply With Quote
  #28 (permalink)
 lblanks 
South Carolina
 
Experience: Intermediate
Platform: Ninjatrader
Broker: Zen Fire
Trading: 6E, ES
Posts: 51 since Jun 2011
Thanks Given: 126
Thanks Received: 15


ThatManFromTexas View Post
@dmau

I depend on NT for charts and handle order management.

I depend on the clearing house for accounting.

My daddy always said... "Use the right tool for the right job" .. but then again , he would say, "Hand me a crescent wrench.." and I'd say..."What size?" ... and he'd say ... "It don't matter...I'm gonna use it for a hammer"

Great quote!

Reply With Quote




Last Updated on June 7, 2012


© 2024 NexusFi™, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
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.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Privacy Policy - Downloads - Top
no new posts