Trying to find top gainers in 2015 via scan

[bigmit2011]

Hi, So I am looking for top gainers in 2015, but my script seems to be faulty,
as the scan list is returning stock that didn't gain over the percentage I am scaning for.

This below script seems to return over 300 stocks, but a lot of them don't seem to have gained 300%
as which is what my scan should filtering for.

I am using the Aggregation period as quarter.

I am not catching what I am possibly doing wrong.

Thank you.

def start = 20;
def end = 24;

def p0  = close()[start];
def p1 = close()[end];
def percent_change = (p1-p0) / p0;

plot scan = percent_change > 3.0;

 

[halcyonguy]

your % formula is missing
*100.
percent_change will never be > 1.

i am not sure how far back a scan can read data, so i am ignoring that possible issue.
i think it should be divided by the price from larger offset, farther back in time, the start of the period.
i would set the begining offset to be the larger number.
it is confusing, using 2 differently named sets of variables. ( start, p0 ?)

def start = 24;
def end = 20;
def start_p = close()[start];
def end_p = close()[end];
def percent_change = 100 * (start_p - end_p) / start_p;
plot scan = percent_change > 3.0;

 

[bigmit2011]

your % formula is missing
*100.
percent_change will never be > 1.

i am not sure how far back a scan can read data, so i am ignoring that possible issue.
i think it should be divided by the price from larger offset, farther back in time, the start of the period.
i would set the begining offset to be the larger number.
it is confusing, using 2 differently named sets of variables. ( start, p0 ?)

def start = 24;
def end = 20;
def start_p = close()[start];
def end_p = close()[end];
def percent_change = 100 * (start_p - end_p) / start_p;
plot scan = percent_change > 3.0;

Hi, so I was going for a 300% change since start of year, so that's why I was going with 3.0
It seems your updated formula would change it to 3% instead.
I wonder if that data doesn't go back that much.