• 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 GussJ, Today, 01:30 PM
      1 response
      5 views
      0 likes
      Last Post NinjaTrader_PaulH  
      Started by GARZONJ, Today, 12:25 PM
      3 responses
      13 views
      0 likes
      Last Post NinjaTrader_PaulH  
      Started by RandanAL, Today, 11:53 AM
      1 response
      13 views
      0 likes
      Last Post NinjaTrader_ChelseaB  
      Started by yeshujbp, 07-21-2019, 02:40 PM
      2 responses
      35 views
      0 likes
      Last Post omololu
      by omololu
       
      Started by seagraph, Yesterday, 03:27 PM
      2 responses
      30 views
      0 likes
      Last Post seagraph  
      Working...
      X