Directory of Open Source for Quantitative Finance and Trading
Username: Password: Not registered?
 
Quick Search:    (AJAX based: No need to press button)

Main : Excel : 


Category: Excel View Full Details
Download Now!Matrix division in VBA
Submitter: azhang Date: 2008/4/30
Description:
I kinda like to do everything in VBA, and came up with this function .
It is equivalent to the Matlab code

Z=X\Y


Given matrizes X,Y this function returns matrix Z:

eg. usage:
xMat = ReadMatrix("sheet2", 4, 8, 2, 5)
yMat = ReadMatrix("sheet2", 4, 8, 8, 9)
z = MYMATRIXDIVIDE(xMat, yMat)
ShowMatrix "sheet2", 20, 2, z



Most of the code has been taken from Quantcode. The function MYMATRIXDIVIDE is available in MatrixModule in the excel file


Got a question or problem with this link? Just enter your message and click on submit. No registration is required.

Note: A copy of this message will also be emailed to the submitter of this link
Downloaded 587 times  587  File Size 0 bytes  Supported Platforms Excel VBA  Home Page http://www.quantcode.com/
Rating: 0.00 (0 votes)
Rate this File | Modify | Delete | Report Broken File | Tell a Friend | Comments (5)

Poster Thread
Anonymous
Posted: 2011/7/18 9:31  Updated: 2011/7/19 19:55
 Matrix division in VBA
Thnx! I'm new in VBA and I was looking for this operation! U just save me! :D

Poster Thread
Anonymous
Posted: 2012/12/18 2:37  Updated: 2013/2/10 12:52
 Matrix division in VBA
hi azhang, can u please explain me how to use divide sub programme, I have a large programme where I need to calculate the division of two matrices, please help me.

Discuss this file. Just enter your message and click on submit. No registration is required.
Similar Links:
Matrix division in matlab (Forum)
Matrix multiplication in VBA (Software)
Matrix Sorting in VBA (Software)
Assigning matrix in gsl (Forum)
Matrix display utility functions (Software)

Subscribe to RSS or daily email updates of latest quantitative finance code listings
Email address :
Copyright © 2011 QuantCode Inc. All rights reserved.