Using Python (Pandas, NumPy, Matplotlib) and Excel VBA, I developed models to calculate efficient frontiers, balancing risk and return. Macro-level data such as GDP growth, inflation rates, interest rate changes, and commodity price trends were incorporated to inform allocation decisions. Monte Carlo simulations and correlation analysis were applied to evaluate portfolio resilience across different market conditions, while stress tests assessed performance under extreme scenarios.