StockFetcher Forums · General Discussion · Syntax, 1 day out of 30?<< >>Post Follow-up
Bricktop13
6 posts
msg #95531
Ignore Bricktop13
8/9/2010 12:33:07 PM

Anyone know the correct syntax to search for stocks that had a 1 day gain of a certain percentage, (say 20%) w/in the last 30 days?

This is what i have but it returns either the cumulative gain or today's gain, rather than the percentage gain on 1 day within the last 30 days:

"price gain more than 20 percent in the last 30 days"
"price gain more than 20 percent on 1 day within last 30 days"

thanks a lot

Kevin_in_GA
4,538 posts
msg #95532
Ignore Kevin_in_GA
8/9/2010 12:46:21 PM

Fetcher[

set{gain, count(close 30% above close 1 day ago,30)}

add column gain

gain above 0.5

]



Bricktop13
6 posts
msg #95535
Ignore Bricktop13
8/9/2010 2:37:21 PM

Thanks Kevin!

What is the "gain above 0.5"? 50 cents?



Kevin_in_GA
4,538 posts
msg #95536
Ignore Kevin_in_GA
8/9/2010 3:52:44 PM

GAIN IS THE USER DEFINED VARIABLE I CREATED TO GET THE NUMBER OF TIMES A GIVEN STOCK ROSE 30% IN A SINGLE DAY.

THE "COUNT" FUNCTION WITHIN THAT VARIABLE RETURNS THE NUMBER OF TIMES THE STOCK MET THAT CRITERIA.

SO BY SAYING "GAIN ABOVE 0.5" ALL I AM ASKING IS THAT THE FILTER RETURN ANY STOCK WHERE THAT CONDITION WAS MET IN THE PAST 30 DAYS.



Bricktop13
6 posts
msg #95537
Ignore Bricktop13
8/9/2010 4:49:25 PM

GOTCHA, APPRECIATE IT.

Kevin_in_GA
4,538 posts
msg #95538
Ignore Kevin_in_GA
8/9/2010 5:22:06 PM

Sorry about the ALL CAPS in my last message - not yelling.

Bricktop13
6 posts
msg #95542
Ignore Bricktop13
8/9/2010 8:20:33 PM

no worries, thanks again

Eman93
4,659 posts
msg #95545
Ignore Eman93
8/9/2010 9:31:07 PM

trading volatility

http://forums.stockfetcher.com/sfforums/?q=view&fid=1002&tid=56077&qrid=&isiframe=

StockFetcher Forums · General Discussion · Syntax, 1 day out of 30?<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus