|
PureBytes Links
Trading Reference Links
|
Hi Daniel and Chuck
I'm pretty sure that Fritch was adding or already had real-time capability
in his Excel program.
Since I trade spreads, my time frames are a little slower and "older". Lots
of historic data processing. Spreads only occur once a year for 3 to 8 weeks
and need a balance of historical / statistical analysis, technical analysis
and fundamental analysis. So Metastocks' charting ability fits well with
Excel's number crunching capability.
Right now my current XL VBA project is developing a ListBox to find and open
folders of 200+ CSV text files into their own worksheet in a workbook. For
example, the files might be 30 years of bean contracts price data with 7
contracts per year.
Using the "recording macros" procedure I have all of the components
(objects, methods and properties) figured out except the "looping" part so
that the procedure will keep opening files one at a time until finished ...
Given my bumbling style I'll probably end up with a "Sorcerers Apprentice"
running out of control <G>.
For Lionel et al ... Ruggiero continues his series of articles on using
Excel for trading in Futures Magazine. He's getting quite sophisticated
now.
Staying with eod data and spreads allows me to use current processing power
comfortably. Of course, lots more horsepower is on the horizon. My
organizing questioning is always: "what am I going to have ... what do I
want to have on my desk in five years?" in terms of processing and software.
If this product that you mentioned Daniel http://www.FMLabs.com is on the
market now ... what will be there in 5 years? Look at all the "freebies"
that are being handed out.
Thanks Chuck ... I can see why
http://24.0.100.173:5080/twtest1/twcharts.htm has the Omega people "wetting
their pants".
Got to run and put more "nerd" tape on my glasses. <G>
Best regards
Walter
Best regards
Walter
----- Original Message -----
From: Daniel Martinez <DanM@xxxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Monday, September 27, 1999 8:38 AM
Subject: Re: Excel 2000 VBa book
| Walter,
| Excel VBa does have possibilities and I do plan to read "Microsoft Excel
2000
| Power Programming with VBa" and "'Special'
| Edition Using Excel 2000." What I like about Excel, while tracking a few
| symbols, is its ability to create custom TA which Metastock cannot. For
| example, if you wanted to combine more than 2-4 symbols for a custom
indicator.
|
| If you aren't already familiar with true visual programming in VB or VC++,
it's
| probably best you stick with Metastock or Excel VBa. Getting results in
| programming can be tedious, especially if you're not experienced.
However, if
| you truly want to program, EBAY has MS Visual Studio 6 Enterprise for only
about
| $250. This has EVERYTHING. It is huge requiring 8 CD's and includes VB6,
VC++
| 6, J++, and more. If I ever get back into programming, and with the
| http://www.FMLabs.com product I just might, this is the package I would
get.
|
| For now I will stick with VBa. However, there are 2 drawbacks to Excel
VBa.
| First, in order to get 8,785 symbols continually updated realtime in
Excel, you
| need the VBa code. The only way to obtain this is to get BMI/eSignal/DBC
to
| cough it up. Without their support, you can pretty much forget it.
Because
| Excel is the standard, I'm pretty sure DBC has the code. If I bothered
them
| long enough, I think they may actually send it to me. <G>
|
|