• 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

How do I filter a row with a blank cell

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

    How do I filter a row with a blank cell

    Just to get this question out into its own thread:

    How do I filter rows that have a blank cell in the column I am filtering on?

    Thanks,
    EV

    #2
    There is not a filter mechanism for blank rows at this time, however I will pass this thread to our development team as an idea to enhance this feature.

    If you're working with an indicator, and the value is null, it is replaced by the current price. What you can do instead in that case, is explicitly set the value to 0 for example in the logic of the indicator and filter based on that value.
    MatthewNinjaTrader Product Management

    Comment


      #3
      Originally posted by NinjaTrader_Matthew View Post
      There is not a filter mechanism for blank rows at this time, however I will pass this thread to our development team as an idea to enhance this feature.

      If you're working with an indicator, and the value is null, it is replaced by the current price. What you can do instead in that case, is explicitly set the value to 0 for example in the logic of the indicator and filter based on that value.
      If there is an issue with an indicator that does get called then your idea works -- i.e. you can set zero (or some absurdly large value) and filter for that.

      Your idea fails for blank cells, though, because they happen when the indicator is not called at all -- when there are no bars in the specified range.

      The only idea I have is to write a custom indicator, assign it an infinite range, and then see what dates it gets called with. It could return zero or one, and then the MA could filter for that. Seems as if there should be a better way ....

      --EV

      Comment

      Latest Posts

      Collapse

      Topics Statistics Last Post
      Started by b16_aln, Today, 08:53 AM
      0 responses
      4 views
      0 likes
      Last Post b16_aln
      by b16_aln
       
      Started by learningnt, Yesterday, 10:52 PM
      1 response
      10 views
      0 likes
      Last Post NinjaTrader_ChrisL  
      Started by U0000999, Today, 07:31 AM
      1 response
      8 views
      0 likes
      Last Post NinjaTrader_PaulH  
      Started by TheGameOfProbabilities, Today, 06:56 AM
      5 responses
      22 views
      0 likes
      Last Post NinjaTrader_Tyler  
      Started by emuns, Today, 06:40 AM
      2 responses
      11 views
      0 likes
      Last Post emuns
      by emuns
       
      Working...
      X