For the technical analyst, Excel is the #1 tool in the toolbox.
A particular model I want to highlight is the EPS_Estimates_MultiSource_v5 that you can download from the files section.
Following trends in analysts’ EPS estimates can be a valuable tool. Research suggests that companies experiencing downward revisions will likely receive more in the future. This spreadsheet shows the trends in EPS revisions. In addition, the model tracks historical EPS announcements. This can be valuable information too, especially if the company has been surprising on the upside and estimates have just started to be revised upward. This may depict a situation where The Street hasn’t fully grasped the potential earnings growth. This may lead to an undervalued situation if there is evidence that growth is underestimated and not priced into the stock.
Financial Alchemist: Importing Financial Web Data into Excel, part 2
No comments:
Post a Comment