Dynamic Portfolio Risk Correlation Matrix with Conditional Formatting

Create an advanced Excel workbook that dynamically calculates portfolio asset correlation using historical price data. Develop a matrix visualization that automatically color-codes correlation strength between different financial instruments, with conditional formatting ranging from deep red (negative correlation) to deep green (positive correlation). The solution should include VBA macros to auto-update data, calculate Pearson correlation coefficients, and generate an interactive heat map that financial analysts can use for real-time risk assessment.