Show summary rows for all dates between a date range in explore

AFL Programming
1

I am trying to get an output similar to this, couple of questions

  1. How to get the explore window to show only dates without all the stocks that pass the criteria
  2. How to show results based on two different filter criteria, from same afl in same run

image
image402×129 2.14 KB

// Define conditions
PriceCon = ROC(Close, 1) > 4 AND Volume > MA(Volume, 30);
denom = High - Low;
DCR = (Close - Low) / IIf(denom != 0, denom, 0.001);
DCRCon = DCR > 0.35;

// Filter to see only stocks meeting either condition
Filter = PriceCon AND DCRCon;

// Basic exploration settings
//SetOption("NoDefaultColumns", True);
AddColumn(Close, "Close");
AddSummaryRows(16,1.2);
2

I still didn't fully understand your question
Is the explore still on stocks and you want output only for those stocks or a summary?

SetOption("NoDefaultColumns", True);
AddColumn( DateTime(), "Date / Time", formatDateTime );
then, 
AddColumn()... for other columns

or see this
if you want your custom output

AFL Function Reference - ADDROW

3

Here is what my explore looks with code (made small changes).

image
image532×259 9.45 KB

Objective - Find number of stocks where stock moved more than 4% and also count of stocks where DCR is > 0.35, and grouped by dates when i choose two dates as date range

// Define conditions
PriceCon = ROC(Close, 1) > 4 AND Volume > MA(Volume, 30);
denom = High - Low;
DCR = (Close - Low) / IIf(denom != 0, denom, 0.001);
DCRCon = DCR > 0.35;

// Filter to see only stocks meeting either condition
Filter = PriceCon;

// Basic exploration settings
//SetOption("NoDefaultColumns", True);
AddColumn(PriceCon, "PriceCon",1);
AddSummaryRows(16,1.2);
SetSortColumns(2);