|
PureBytes Links
Trading Reference Links
|
Excel and MS- what a dynamic duo they would make. Excel on calcs and MS
playing the graphics. Imagine if you will- the indicator builder having the
ability to reference an Excel workbook row or column for data to plot.
Excel's numerous functions especially in the arena of statistics (of which
MS has almost zip) just makes my mouth water. This thread has put me over
the edge- now I'm gonna have to learn to Excel.
-----Original Message-----
From: Guy Tann <grt@xxxxxxxxxxxx>
To: metastock@xxxxxxxxxxxxx <metastock@xxxxxxxxxxxxx>
Date: Thursday, February 25, 1999 10:34 PM
Subject: RE: Excel and MS, Guy Tann
>jr
>
>After replacing OLE, my next project will be to automate my the system as
>well. I currently mark each days results in another spreadsheet and
>maintain 4 different approaches. The first maintains a linkage between
>Bonds and the S&P (which appears to have broken last year but did work for
>the previous 12 years). The second ignores the Bonds. The third is our
>Intermediate signal and the 4th is a combination of #2 and #3, requiring
>both to trade. That's the one that's been long since 10/1/98.
>
>We normally trade #2 and will be trading #4, maybe in a separate account.
>
>Regards
>
>Guy
>
>
>-----Original Message-----
>From: owner-metastock@xxxxxxxxxxxxx
>[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of jr
>Sent: Thursday, February 25, 1999 5:55 PM
>To: metastock@xxxxxxxxxxxxx
>Subject: Re: Excel and MS, Guy Tann
>
>
>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
>>
>>
>>
>
>
|