Results 1 to 4 of 4

Inverting non-square matrix for bootstrapping

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    02-06-2013
    Location
    UK
    MS-Off Ver
    365
    Posts
    693

    Inverting non-square matrix for bootstrapping

    Hi, attached is an example of a topic I am currently looking into, some basic application of linear algebra in something called yield curve construction.
    Any mathematicians may excuse my inexact language here.
    I acknowledge this may chiefly be more of a math question than a (pure) Excel one.

    My example is simplified for the purpose of illustrating how this works and what my problem is.

    I am given 4 bonds with a certain cash flow profile, i.e. mathematically speaking basically 4 polynoms of degrees one to four which are not dependant upon each other in any way.
    In rows 27 to 43, instead of iteratively as shown in the previous rows in the spreadsheet, I solved the equations with inverting the coefficient matrix and multiplying it with the constants matrix.

    So far, so good.
    The numbers and the technique employed makes sense to me (first block coloured in gray and which reconciles to the previous manual solutions).

    To my problem:
    Now I was trying to construct the same result vector but with a slightly reduced set of equations to work with.
    I was taking equations 1, 2 and 4 of the previous example, so left out Bonds #3 which gives me a non-square matrix.
    Whether or not there's still a solution to this matrix, I guess depends among others on its determinant.
    In order to be able to invert the matrix, I multiplied both sides with the transposed matrix of A and solved in the same way as before.

    I am now a bit puzzled at the results of this, the second gray vector.
    Especially, given that the first two equations are the same as before these two equations alone should be sufficient to solve x1 and x2 of the variable matrix X,
    how can the solutions be different than before?


    Maybe someone can shed some light on whether my matrix transformations are incorrect technically or mathematically or what I am missing about the interpretation of the results.

    Thank and Regards
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to get a value in a square matrix with two conditions
    By alexlutz in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-09-2019, 08:11 PM
  2. square matrix determinant
    By handa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-05-2018, 09:02 PM
  3. Create a r-square matrix on simple strings of values
    By guillm in forum Excel General
    Replies: 5
    Last Post: 11-15-2016, 05:25 AM
  4. Bootstrapping with Excel and VBA
    By stpyrg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-28-2014, 08:50 PM
  5. Bootstrapping of stock price (Data based simulation)
    By Ajohs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2013, 11:25 AM
  6. Replies: 3
    Last Post: 08-19-2009, 08:53 AM
  7. maximum range inverting matrix
    By _Anna_ in forum Excel General
    Replies: 3
    Last Post: 03-23-2009, 11:47 AM

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