Measure – Groupcount

Groupcount helps us to get the count of stocks/entries present for a given group with an optional filter. The “grouping” can be selected via the “group/sort” tabs in a widget, as seen below.

Selecting no group from the above-listed groups would run the widget scan assuming a single group for all the *group* functions.

Examples

  1. Get the count(after an optional filter) of items grouped by a given sector or industry; the below dashboard lists the total number of stocks, number of positive stocks & number of negative stocks, https://chartink.com/dashboard/122841.
  2. Using the count to calculate the % of stocks that have closed positive vs. negative. https://chartink.com/dashboard/122841

12 thoughts on “Measure – Groupcount”

  1. Could you please confirm if you are referring to the size of a candle or the range of band or Pivot levels (to be narrow/wide)?

  2. inadvertantly I tried to change RSI default setting from 14… since then In ‘ charts’ setting is always going to ‘2days’ and ‘5min’ …. How to to go back to defauit settings. Please guide.

  3. How to add the total number of stocks qualified based on the filter in atlas widget.
    If this is not possible, how to add column index so that we can scroll down to see the total number of stocks.

      1. Thank you for the response. I know this part, using group count. I use it to plot graphs as well.
        However, my question was about a widget that lists stocks. In the dashboard, I can use the sector or any other criteria as filter to filter stocks in other widgets. While doing so, I would like to know how many stocks qualified. Since there is no index column as well, I cant see the count.

        Ex.
        # Sym chg
        1. AWL 5%
        2. ITC 4%
        3. BEL 7%

        It would be best if we can display the count, 3, in the header

  4. How to add moving average, high, low etc to line graph widget.
    For ex, I have a widget to show how many stocks are above 20DMA, I would like to add lines that show –
    1. moving average of this
    2. high of the values (Resistance)
    3. low of values (Support)
    4. other reference support\resistance levels.

    1. Thank you for the response.
      My question was different. I understand that we can plot SMA of a standard attribute.
      In your example dashboard, can you had 20SMA for the pivot value R1 and S1? Not the close or high or low of the price.

      In my dashboard, I have a line graph drawn using groupcount of stocks above 20SMA to plot market breadth. I want to plot SMA for this groupcount value. I tried creating a custom indicator for the group count and tried to use it in the SMA function; the widget stops working.

      Cust_ind = groupcount( {cash} 1 where close > sma( close , 20 ) )

      I want to plot SMA (Cust_Ind, 20)
      or
      SMA (groupcount( {cash} 1 where close > sma( close , 20 ) ), 20)

  5. Hello Sir,
    Please refer to the second table/block in the dashboard : https://chartink.com/dashboard/116455
    I want to create a line chart of the ‘count of stocks that are up more than 3% AND they were down (% change negative) for a period of prior 4 days’ . I tried using CountStreak but I am not sure if it works and I have no way to find out if it is working. Can you correct and help?

    1. Hello,

      Do you mean today’s close is greater than the previous close by 3% and from the last 4 days close less than its previous close?

      If so, you need to add the below filter in your scan for the last four days down.
      1 day ago count( 4, 1 where latest close < 1 day ago close ) = 4

Leave a Reply

Your email address will not be published. Required fields are marked *