Results 1 to 2 of 2
  1. #1
    tdham is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    2

    Storing asset class Correlations help!

    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!

  2. #2
    tdham is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    2
    I have attached the sample correlation file .

Please reply to this thread with any new information or opinions.

Similar Threads

  1. object or class does not support the set of events
    By couch potato in forum Programming
    Replies: 2
    Last Post: 03-20-2010, 08:55 AM
  2. In over my head with a database class
    By fixittech in forum Database Design
    Replies: 3
    Last Post: 01-22-2010, 07:45 AM
  3. storing and printing on a pdf
    By jlm722 in forum Reports
    Replies: 4
    Last Post: 10-27-2009, 02:48 AM
  4. Replies: 0
    Last Post: 08-31-2009, 10:50 AM
  5. Storing an Equation in Table
    By tmedler in forum Programming
    Replies: 0
    Last Post: 03-09-2009, 09:25 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums