|
PureBytes Links
Trading Reference Links
|
Walter
As an 'old' programmer (and probably personally responsible for the Y2K
crisis <G>), I loved your post about Excel. It is an extremely powerful
tool and if used properly can contribute to anybody's TA.
In converting our system to Metastock, years ago, it took forever and a day,
because the older MS didn't handle variables and it took me forever to
develop a methodology to even approximate an alternative momentum indicator.
When moving it into Excel, it took a couple of days and I had the original
indicators running as well as their modified replacement from MS.
I guess I should thank Equis, because it was MS' lack of computational
abilities that forced me to come up with this modified momentum indicator.
We have integrated it into our system and it helps make it a little more
sensitive and at times gives us a early signal that we used to miss (or lag
actually).
The weakness when connecting Excel with Equis data is OLE. I plan on using
VB or Access or whatever to replace that OLE connection. I have already
purchase MS File Library to access MS data. Now I need to update it, because
of the 6.52 changes.
What surprised me is the speed of computation in Excel. I'm really
impressed with the fact that I can calculate 3 years of data within Excel in
less time than MS can process 1 year. Guess this is just how it's
programmed.
Regards
Guy
-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Walter Lake
Sent: Thursday, February 25, 1999 6:26 AM
To: metastock bulletin board
Subject: Excel and MS
As a novice user of Excel, my first discovery was that Excel is not user
friendly.
Excel 97, 5.0 etc. are really excellent programs with many user friendly
features but the "environment" is not user friendly. It is not a "get in
your car and turn turn the key" environment like Metastock.
When you open a "page" or worksheet or spreadsheet, you only see a small
part of what's available. In 97, the sheet is (I've been told) 12,000+
square feet. 6 times bigger than most houses. Lots of emptiness. Pages of
emptiness in fact.
Excel is basically a programming "space" and I soon learned to think
"programming" about everything that I did. Especially linking "things" and
"actions" together.
Excel is organized into workbooks with sheets (i.e., tabs). Sort of like a
ring-binder with a couple of pages in it. There's room for lots more. A lot
more.
Room for lots of "linked" sections. Lots of "linked" pages within each
section. Lots of "linked" rows and columns within each page.
So you need a plan, you definitely need an organizing plan.
This is where nobody helps you, in using Excel for trading.
Best regards
Walter
|