StockFetcher Forums · General Discussion · Sorting on %Change Column<< >>Post Follow-up
gvphubli
14 posts
msg #109231
Ignore gvphubli
12/10/2012 8:38:23 AM

I am using following statement..

Fetcher[
price dropped more than 10% in last 20 days
and index is S&P 500
]



I usually receive lot of symbols in the output, so I want to pick one or two stocks that have dropped the most (in the last 20 days) in my back testing in "Advanced Tab" for "Selection Criteria"

Thanks,
- GP

heypa
283 posts
msg #109248
Ignore heypa
12/10/2012 12:27:49 PM

Just click on the chg(%) column

gvphubli
14 posts
msg #109249
Ignore gvphubli
12/10/2012 12:54:30 PM

heypa - please read my question..want to %change over last 20 days not just today.

mahkoh
890 posts
msg #109250
Ignore mahkoh
modified
12/10/2012 1:10:01 PM

Fetcher[
price dropped more than 10% in last 20 days
and index is S&P 500
set{x,price/price 20 days ago}
add column x
sort column 5
]



gvphubli
14 posts
msg #109257
Ignore gvphubli
12/10/2012 3:21:03 PM

perfect this is what I needed...thanks !

mahkoh
890 posts
msg #109264
Ignore mahkoh
12/10/2012 4:58:13 PM

You're welcome. I forgot to "add column x" which represents % position compared to 20 days ago, edited it in the post.

duke56468
683 posts
msg #109265
Ignore duke56468
12/10/2012 5:32:29 PM

use "sort column 5 descending" if you want the largest drop on top

heypa
283 posts
msg #109286
Ignore heypa
12/11/2012 12:47:19 PM

Sorry.Getting too old for this crap.

StockFetcher Forums · General Discussion · Sorting on %Change Column<< >>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