|
PureBytes Links
Trading Reference Links
|
That must be fun having it with excel,
just imagine what the optimizer alone
could do... godness ... :)
.........
>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
>
>
>
|