New Members: Be sure to confirm your email address by clicking on the link that was sent to your email inbox. You will not be able to post messages until you click that link.
weekly scan using previous weeks
I want to compare PPO Line to previos week and the previous week PPO Line to two weeks ago PPO Line.
I tried the following:
and[ WEEKLY PPO LINE(12,26,1) > 1 WEEK AGO PPO LINE(12,26,1)]
AND[1 WEEK AGO PPO LINE(12,26,1)< 2 WEEK'S AGO WEEKLY PPO LINE(12,26,1)]
I only got results where PPO Line was greater than the previous week and the Previous week PPO Line was greater than 2 weeks ago.
Any suggestions are welcome