Anyone know a good program that can backtest a strategy based on earnings estimates? I'm looking for something that: 1. Isn't outrageously expensive 2. Has earnings estimates, earnings revisions, and stock price data for each day of the year on a historical basis (at least 3-5 years worth)
Zacks not sure there is anything there though (e estimates) but you can try lots of screening criteria
Thanks but I'm not sure if Portfolio123 will let you backtest what happens to stocks that have just had an earnings estimate revision on a particular day. I emailed them for an answer last week but haven't got a response yet.
either way they have system that have great returns and high sharpe ratios. I stick to price related info, but their free systems look promising.
you can do it in excel. grab earnings data from here- http://www.fulldisclosure.com/company.asp?client=cb&ticker=msft (i think, i have it somewhere on my computer) and run on free data from yahoo. not sure,how exactly you want to play it,but earnings surprise alone will be not enough.
Appreciate the idea Bob. There are two problems: 1. Earnings.com doesn't post earnings estimate revisions by date of the revision. 2. I need to do this for hundreds of symbols so I'm looking for something automated. I think high-end programs like www.lim.com can do it but they charge more than my car payment each month (x 5).
i done it very long time ago in VB. for all US stocks it takes about 20-30 min with good internet speed. let me check, if function i have still works(if i could find it)))))), and if it is-i can share this data with you if you need it