I
Improper Californian
Hello all who kindly choose to read this...
I'm trying to use Excel Link to pull out functions from MATLAB for use in
Excel. I'm currently using the matlabsub function provided by Excel Link. I
am working directly in the worksheet, and not using VBA code. (My boss, the
person who uses this spreadsheet, doesn't like to use VBA. He prefers to
work directly in the worksheet cells.) Anyway, I'm running into a snag with
this. If I try to pull a function that yields more than one result, e.g.
cfamounts(coupon, start date, end date) = [CFlowAmounts, CFlowDates], only
the first vector (CFlowAmounts) is showing up in Excel's cells. I won't see
the CFlowDates results at all. Does anybody know how to get multiple vectors
to populate Excel's cells?? The way I currently have this spreadsheet set up
is as follows...
=matlabsub(B10,C10, D10,E10,F10)
B10 = cfamounts (function name)
C10 = P10 (the cell I want the output to begin)
D10 = 8.25 (coupon amount)
E10 = 31-Jan-2002 (start date)
F10 = 31-Jan-2009 (end date)
I've tried fiddling with input signifying the output start cell with no
luck. The reason I have it set up like this is because I want to be able to
pull many different MATLAB functions, mostly user built. I want to be able
to specify them as I go. If anybody could help shed some light on this I
would be very grateful. Please let me know if I have been unclear about
anything, and I will try to correct this. Thanks in advance!
Cheers,
The Improper Californian
I'm trying to use Excel Link to pull out functions from MATLAB for use in
Excel. I'm currently using the matlabsub function provided by Excel Link. I
am working directly in the worksheet, and not using VBA code. (My boss, the
person who uses this spreadsheet, doesn't like to use VBA. He prefers to
work directly in the worksheet cells.) Anyway, I'm running into a snag with
this. If I try to pull a function that yields more than one result, e.g.
cfamounts(coupon, start date, end date) = [CFlowAmounts, CFlowDates], only
the first vector (CFlowAmounts) is showing up in Excel's cells. I won't see
the CFlowDates results at all. Does anybody know how to get multiple vectors
to populate Excel's cells?? The way I currently have this spreadsheet set up
is as follows...
=matlabsub(B10,C10, D10,E10,F10)
B10 = cfamounts (function name)
C10 = P10 (the cell I want the output to begin)
D10 = 8.25 (coupon amount)
E10 = 31-Jan-2002 (start date)
F10 = 31-Jan-2009 (end date)
I've tried fiddling with input signifying the output start cell with no
luck. The reason I have it set up like this is because I want to be able to
pull many different MATLAB functions, mostly user built. I want to be able
to specify them as I go. If anybody could help shed some light on this I
would be very grateful. Please let me know if I have been unclear about
anything, and I will try to correct this. Thanks in advance!
Cheers,
The Improper Californian