|
PureBytes Links
Trading Reference Links
|
Excel for real-time information? Where can you get more information on
that? Will excel automatically update the information?
Thanks in advance,
Peter Gialames
-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx [mailto:owner-metastock@xxxxxxxxxxxxx]
On Behalf Of Marvin Lin
Sent: Thursday, February 25, 1999 1:18 PM
To: metastock@xxxxxxxxxxxxx
Subject: Re: Excel and MS
Just an idea ...
Using Excel as the data collecting interface via DDE to Reuters IDNDDE,
BridgeStation, Open Bloomberg (which provides free Excel Link), FS,
and almost all of the Internet feeds, for both real-time and EOD. Excel
itself is the basic development platform. By Excel Link for Mathematica
(or Matlab, Statistica, etc.) you could achieve almost anything regarding
computation, modeling, and simulation. Both Excel and Mathematica are
quite open, robust, and fully tested and supported (not only within the
financial world) and will not easily get obsolete or discontinued. This
kind of schemes or much more complex ones are actually applied by
some institutions for derivatives markets modeling and evaluation.
So, why not take this scheme as trader's operating system/environment?
Feed vendors just have to care about their data quality, delivery
efficiency,
contents, and devise a reliable, efficient data managers linked to Excel.
Developers concentrated on implementing/designing their indicators, trading
systems, special purpose fuctions or add-ons on this general platform, and
end users just spend their efforts evaluating what solutions are to their
purpose and utilizing them to the best.
Really tired of real-time datafeed availability and compatibility. And
another
2.5 years wait for a software to go from 16-bit to 32-bit (this time 32-bit
to
64-bit, maybe. You know what product I mean).
Feasible?
>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
>
>
|