| 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...
 
 
 
 
 | 
| 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!
 
 
 
 
 
 | 
| 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
 
 
 
 
 | 
| 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?
 
 
 |