+ Reply to Thread
Results 1 to 4 of 4

Mmult function with non matching arrays

  1. #1
    Registered User
    Join Date
    10-01-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Mmult function with non matching arrays

    I need to use mmult for the matrix of stock returns and certain factors. The issue i'm running into is that not all the firms have stock data up to the same point. Some data goes back 15 years, but some only 5.
    Since im using stock returns, i cant fill the empty cells with 0, as that would indicate a 0% return for that period, so im looking for a workaround. The formula im currently using is:
    =MMULT(MMULT(MINVERSE(MMULT(TRANSPOSE('Factor Data'!D8:E106),'Factor Data'!D8:E106)),TRANSPOSE('Factor Data'!D8:E106)),C8:I106)
    Which only works if i match both matrixes.

  2. #2
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: Mmult function with non matching arrays

    Hi,

    Perhaps a small sample dataset with expected results would be useful here.

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  3. #3
    Registered User
    Join Date
    10-01-2018
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Re: Mmult function with non matching arrays

    For some reason the upload button doesn't work for me (shows a blank box), and im not yet allowed to post other links.

    Knipsel.PNG

    Is this enough?

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,725

    Re: Mmult function with non matching arrays

    Hi Sampieee. Welcome to the forum.

    I am afraid not.

    Try this method of upload.

    To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
    • be sure to desensitize the data
    • click “Go Advanced” (next to Post Quick Reply – bottom right),
    • scroll down until you see “Manage Attachments”, click that,
    • click “Browse”.
    • select your file(s)
    • click “Upload”
    • click “Close window”
    • click “Submit Reply”

    The file name will appear at the bottom of your reply.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How MMULT Function works?? How it can be used??
    By chullan88 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-22-2017, 05:40 AM
  2. Using mmult function
    By nim73n in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 12-08-2014, 08:13 AM
  3. vba compare arrays and remove exact matching arrays
    By jacojvv in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-25-2013, 07:30 AM
  4. Replies: 4
    Last Post: 09-24-2013, 06:57 AM
  5. Matching value in two arrays
    By wondering2 in forum Excel General
    Replies: 2
    Last Post: 12-26-2010, 09:58 PM
  6. Matching two arrays - Part 1
    By PradeepRed in forum Excel General
    Replies: 2
    Last Post: 09-17-2010, 04:16 AM
  7. MMULt Worksheet Function
    By TC8 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2006, 09:00 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1