|
PureBytes Links
Trading Reference Links
|
Hi Lionel
MathCAD and Excel are highly integrated both for data transfer and for drag
and drop of objects. They work extremely well together. MS, Excel and
MathCAD form an excellent analysis combination.
Mathematica needs a special add-on to access Excel data. It is a high
powered program for pure math and statistics.
Excel has the capability to do arrays which is not the same as matrix math,
i.e., linear algebra. Workbooks exist that are designed to solve matrices.
Various functions can be purchased in xla form to do linear algebra, but the
plain Excel 2000 out of the book will not do matrix math. Why bother when
MathCAD is so powerful.
Re graphics ... 2D histograms for example look a little flat in comparison
to 3D histograms. Check around for an expensive copy ... it's worth the
digging effort.
Best regards
Walter
----- Original Message -----
From: Lionel Issen <lissen@xxxxxxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Thursday, August 30, 2001 12:32 PM
Subject: Re: Matrix Forecasting
> Walter:
> Thanks for bringing this article to my attention.
> Are you saying that MathCAD interfaces better with Excel than Mathmatica
or
> that it is cheaper and adequate?
> I was surprised to hear that Excel doesn't have built in matrix utilities.
> You are correct on this.
> Excel graphing features are very good and easy to use. I'm using Excel
2000
> and I am impressed with its capabilities.
>
> Thanks again.
> Lionel Issen
> lissen@xxxxxxxxxxxxxx
> ----- Original Message -----
> From: "W Lake" <wlake@xxxxxxxxx>
> To: <metastock@xxxxxxxxxxxxx>
> Sent: Thursday, August 30, 2001 10:32 AM
> Subject: Matrix Forecasting
>
>
> > The recent article in the Aug 2001 Futures Mag on Matrix Forecasting
uses
> > matrix math.
> >
> > The linear algebra can be solved quickly in Mathcad. Although it's easy
to
> > do the Linear algebra in Mathematica, the Excel to Mathematica links
cost
> > extra whereas the importing of single files or a "live" link between
Excel
> > and Mathcad is very quick and easy. The graphing capability in Mathcad
is
> > more 'exciting' and is what you usually see in trader's mags.
> >
> > Most of the available mcd files on the web are Mathcad 6 or 7 and are
> easily
> > readable by later versions. My version 2000 pro reads them fine so you
> > should have no trouble with 2001. Student versions are available quite
> > inexpensively ... mcd "readers" also appear to be available.
> >
> > Matrix work looks like a more natural extension to the MS - XL cluster
of
> > programs than neural nets.
> >
> > Best regards
> >
> > Walter
> >
> >
> >
> >
> >
> >
> >
> >
>
>
|