Add column to return only nominated score

AFL Programming
1

Hello,
In the last line of the code below, I return a column with a score of 1 or 0. Is there a way to only return the score of 1 and omit all 0 events? Thanks in advance...

AddColumn(mavten,"mavten");
AddColumn(volum,"Volume");
AddColumn(mavvol,"Mavvolume");
AddColumn(c,"close");
AddColumn(C>MA(C,10)AND C*V>250000 AND MA(v,50)>100000 AND C > .25 AND C <1.25  ,"trade",1);
2

Have you read the docs... such as How to create your own exploration?
Apparently you haven't because Filter is missing in your code.

Filter = C>MA(C,10)AND C*V>250000 AND MA(v,50)>100000 AND C > 0.25 AND C <1.25;

AddColumn(mavten,"mavten");
AddColumn(volum,"Volume");
AddColumn(mavvol,"Mavvolume");
AddColumn(c,"close");
1 Like
3

Okay I get it...I did have filter...just did not copy it to the post...soz...still learning...

Filter = 1;
AddColumn(mavten,"mavten");
AddColumn(volum,"Volume");
AddColumn(mavvol,"Mavvolume");
AddColumn(c,"close");
AddColumn(C>MA(C,10)AND C*V>250000 AND MA(v,50)>100000 AND C > .25 AND C <1.25  ,"trade",1);
4

All working now...thanks heaps..