StockFetcher Forums · General Discussion · Top 50 Stocks per exchange per year<< >>Post Follow-up
jimw909
5 posts
msg #57060
Ignore jimw909
11/27/2007 4:18:05 PM

A stock picker on the web boast he is able to pick the TOP 50 STOCKS each year going back 5 years. On a price performance basis starting January 1, 2006 and ending December 31, 2006 can someone write how to fetch the TOP 50 STOCKS in the Nasdaq in 2006? Thanks

rtucker
318 posts
msg #57063
Ignore rtucker
modified
11/27/2007 5:25:58 PM

****************** TOP 2006 PERFORMERS ****************

Fetcher[set{price_begin_2006,close 250 days ago}
set{price_end_2006,close}

set{diff, close - close 250 days ago}
set{a, diff/close 250 days ago}
set{2006_anual_return%,a*100}

add column price_begin_2006
add column price_end_2006
add column 2006_anual_return%
anual_return is above 50
sort column 7 descending

close > 25
avg vol(90) > 500000

offset 1/1/2007
]



1/1/2007 becomes the reference date. Approx 250 trading days in a year. Calculations are done looking back from 1/1/2007.
PREFORMANCE column is how they have fared since then.
Adjust price/volumn etc.. to suit yourself.


TheRumpledOne
6,411 posts
msg #57113
Ignore TheRumpledOne
11/28/2007 4:14:00 PM

See SF, if we had AS OF DATE this would be simple to code.

Once again, we need to be able to code:

close as of 1/1/2006

high as of 12/31/2006

etc....

If necessary:

AsOf( ind, date)

we could code this way as follows:

AsOf( close, 12/31,2006) above AsOf( close, 1/1/2006)

I don't care which way you implement it, just, please, GET 'ER DONE!!



guru_trader
485 posts
msg #57133
Ignore guru_trader
11/28/2007 8:40:39 PM

I agree ... please add this!

StockFetcher Forums · General Discussion · Top 50 Stocks per exchange per year<< >>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 2022 - 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


This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.