Dynamic Portfolio Risk Heat Map with Conditional Formatting

Create an advanced Excel workbook that dynamically generates a portfolio risk heat map using conditional formatting and nested IF statements. The dashboard should automatically color-code investment assets based on volatility, beta, and standard deviation calculations. Include automated VBA macros that pull real-time financial data, calculate risk metrics, and update the visualization in real-time. Ensure the heat map can handle at least 100 different securities and provides instant visual risk assessment.