These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, December 10, 2015

Benjamin Graham's Intrinsic Value Stock Screener


Executive Summary:
This project implements Benjamin Graham’s Value 10 investing principles and unlike the previous versions that were submitted in prior semesters. This version includes the intrinsic value calculation using Benjamin Graham’s formula and compares it to the stock’s current price to determine whether the stock is Over/Undervalued.

This tool is useful for non-technical inexperienced investors to get a feel into the world of portfolio management. This is a simplified stock screener that hopefully will pique the interest of the user to learn about more advanced stock analysis. This tool is a mere introduction to stock selection.

http://files.gove.net/shares/files/15f/jxl4527/Jimmy_Lee_Graham_Intrinsic_Value.xlsm
http://files.gove.net/shares/files/15f/jxl4527/VBA_Writeupup_Graham_Jimmy_Lee.pdf

No comments:

Post a Comment

Blog Archive