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