Hi,
I want to store correlation assumtions between different asset classes in an access table. I am not sure of how to design this table as the number of asset classes could vary from month to month. A sample correlation table is as shown below ( please ignore the actual correlation values)
US EquityInternational EquityEM EquityHQ-PhysicalsARSHigh YieldUS Equity10.60.60.60.60.6International Equity0.610.60.60.60.6EM Equity0.60.610.60.60.6HQ-Physicals0.60.60.610.60.6ARS0.60.60.60.610.6High Yield0.60.60.60.60.61
How can I design a table to store sucha correlation table if the asset classes are dynamic ? Thanks in advance for the help!