No Code Stock Portfolio Construction Template

The No Code Stock Portfolio Construction Template includes the following:

1 macro-enabled Excel workbook

12 custom functions for building stock portfolios. Includes:

·        A no code Monte Carlo simulation to find the optimal asset allocation for a given portfolio of stocks

·        Functions for finding the Sharpe ratio, Sortino ratio, Sterling ratio, Treynor ratio, VaR, Burke ratio, Calmar ratio, Information ratio, Jensen's Alpha, Omega ratio, and Conditional Contribution to Total Risk (CCTR)