For my first post, I want to share a project I have been working on and am continually working to improve. It is a basic calculator for valuing stock/option positions. Currently, the program is able to calculate Cost Basis, Total Equity, Total Return ($/%), and Targeted Numbers. On the options side of things, it can calculate Contract Cost, Intrinsic Value, Break Even, P/L, and the Contract’s Status (In, At, or Out of the Money). The functionality support both buying and selling calls/puts, just change the selected option type in the drop down menu next to “Type”. Although it was initially built only using excel logic, I have begun incorporating VBA functions in order to make the calculator flow much more efficiently. Try it out for yourself and feel free to comment on it until I come up with an improved, more advanced iteration of this project. Enjoy!
-S.F.


Love thisss
LikeLike