StockFetcher Forums · Filter Exchange · Filter for top performance over a range of dates<< >>Post Follow-up
jimmyjazz
102 posts
msg #113769
Ignore jimmyjazz
modified
5/29/2013 12:55:36 PM

How would I search a set of stocks (S&P, NYSE, etc.) for the top performers over a specific date range? By "performance" I would start with the ratio of closing prices between the 2 dates (start & end). To complicate, how would I also account for dividend yield?

duke56468
683 posts
msg #113775
Ignore duke56468
5/29/2013 4:14:48 PM

I'm sure there are better ways but this may get you started...
Fetcher[s&p 500
set{start,open 200 days ago}
set{finish,close-start}
set{gain,finish/open 200 days ago}
set{percentgain,gain*100}
add column percentgain
add column start
sort column 5 descending
]



jimmyjazz
102 posts
msg #113776
Ignore jimmyjazz
5/29/2013 5:01:31 PM

Thanks! What if I didn't want the last 200 days, but some previous block of dates?

duke56468
683 posts
msg #113777
Ignore duke56468
5/29/2013 5:29:42 PM

I think you could use "open 150 days ago" "close 20 days ago"

jimmyjazz
102 posts
msg #113779
Ignore jimmyjazz
modified
5/29/2013 7:31:03 PM

Well, I'm obviously doing something wrong. It's always a learning curve!

Fetcher[s&p 500
set{start,close 3 days ago}
set{finish,close 2 days ago}
set{gain,finish/start}
set{percentgain,gain*100}
add column percentgain
add column start
sort column 5 descending
]



fortyfour
189 posts
msg #113780
Ignore fortyfour
5/29/2013 8:57:01 PM

this may help.

http://www.stockfetcher.com/forums/General-Discussion/Technique-Calc-your-own-returns-for-any-period/33296&isiframe=

duke56468
683 posts
msg #113786
Ignore duke56468
5/30/2013 11:39:51 AM

try this
Fetcher[s&p 500
set{start,close 3 days ago}
set{finish,close 2 days ago}
set{diff,finish-start}
set{gain,diff/start}
set{percentgain,gain*100}
add column percentgain
add column start
sort column 5 descending
]



jimmyjazz
102 posts
msg #113798
Ignore jimmyjazz
5/30/2013 1:57:45 PM

I think that's exactly what I'm looking for. Thanks! Do you happen to know if "days" are trading days?

StockFetcher Forums · Filter Exchange · Filter for top performance over a range of dates<< >>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.