• If this is your first visit, you will have to register before you can post. To view messages, please scroll below and select the forum that you would like to visits. Questions? Be sure to check out the Forum FAQ.

Announcement

Collapse
No announcement yet.

Partner 728x90

Collapse

Profit per Month

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

    Profit per Month

    I'm trying to understand the profit per month metric in the backtest results as can bee seen in the attached png. I'm confused by the fact the the profit per month value is many times negative even though total net profit and cumulative profit are both positive values.
    Is someone able to explain this?
    Thanks in advance
    Attached Files

    #2
    Hello jwitt98,

    Please see the link below under 'Understanding Profit Per Month' for the formula that is used.
    http://www.ninjatrader.com/support/h...efinitions.htm

    Do you experience the negative value for the combined result row only?
    JasonNinjaTrader Customer Service

    Comment


      #3
      I thought that the issue had occurred on other results besides the combined results, but I haven't been able to reproduce it, so it may just be on the combined results.

      Are you suggesting that the combined results are calculated differently from the individual results? If so, what calculation is used for the combined results?

      Comment


        #4
        It seems to calculate differently. I assume it would take the average of all instruments. So add all values and divide it by the amount of instruments. However this does not seem to be the case. I tried different basket tests and manually calculated the average, but it does not add up. I tried currency, points and percent.

        I will check with development how Profit per month is calculated for combined results.
        JasonNinjaTrader Customer Service

        Comment


          #5
          My assumption of taking the average is incorrect. It is weighted by the number of trades per month. It uses the formula below.

          (Profit * Trades) + (Profit * Trades) + (Profit * Trades) + (Profit * Trades) / Total Trades

          If you like to calculate in Excel to verify, please see the link below.
          http://support.microsoft.com/kb/214049
          JasonNinjaTrader Customer Service

          Comment


            #6
            Thanks, it now makes sense...

            Comment

            Latest Posts

            Collapse

            Topics Statistics Last Post
            Started by user1986, Today, 07:28 PM
            2 responses
            9 views
            0 likes
            Last Post NinjaTrader_EricB  
            Started by ericson, Today, 08:14 PM
            0 responses
            5 views
            0 likes
            Last Post ericson
            by ericson
             
            Started by jertrade, Today, 06:57 PM
            0 responses
            5 views
            0 likes
            Last Post jertrade  
            Started by Emma1, Today, 02:42 PM
            1 response
            17 views
            0 likes
            Last Post NinjaTrader_DrewO  
            Started by fx.practic, Today, 03:10 PM
            1 response
            6 views
            0 likes
            Last Post NinjaTrader_Jesse  
            Working...
            X