|
PureBytes Links
Trading Reference Links
|
Dale
I'm not looking to use any of his indicators, etc. My primary purpose is to
'see' a working Excel spreadsheet with VBA code, and then, lift the data
access code and put it in my own spreadsheets. With that, I can then move
on to checking out his various indicators, etc.
At this point in time, I'll attempt to code the VBA program to run
simulations on our data base, in order to automate out testing and daily
processing. Currently, we have to run 3 different systems to develop our
daily signals. With Excel, all 3 are done at the same time thereby
eliminating a lot of manual work.
Anyway, we'll see what happens.
Regards
Guy
Regards
Guy
-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Dale Wingo
Sent: Tuesday, March 16, 1999 4:54 PM
To: metastock@xxxxxxxxxxxxx
Subject: RE: Use of EXCEL
It's fairly "robust" code .. good luck!
If I can help (which at this point is problematical since I haven't
totally dissected his code) let me know..
Dale
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Guy Tann
> Sent: Tuesday, March 16, 1999 6:47 PM
> To: metastock@xxxxxxxxxxxxx
> Cc: Walter Lake
> Subject: RE: Use of EXCEL
>
>
> Dale
>
> My thought for my own system would be to use the MetaStock
> data initially
> and then move it over to Access or some similar module.
> That's why I bought
> the MS File Library DLLs.
>
> I also have the same data duplicated in an xBase format
> (Clipper) which I
> maintain manually for our Clipper based System. I guess I
> can access it
> either way.
>
> I'm going to start with Fritch's spreadsheets tonight and
> see if I can move
> the appropriate code over to my own spreadsheets to
> eliminate the OLE link
> and replace it with MS DLL links.
>
> I'll post any successes (or failures or set backs).
>
> Guy
>
>
>
>
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Dale Wingo
> Sent: Tuesday, March 16, 1999 11:49 AM
> To: metastock@xxxxxxxxxxxxx
> Cc: Walter Lake
> Subject: RE: Use of EXCEL
>
>
> Jim,
>
> I quite agree that Excel would be inappropriate for your use. The
> volume of stocks that you follow dictates an approach similar to the
> one that Metastock and its competitors are using and would require a
> development team or one guy with no life and nothing else to do.
>
> Just for arguments sake, if one were to use Excel then
> storage in the
> spreadsheet would be at best impractical. However one could use a
> relational database such as Access which is available thru
> the use of
> VBA which is part of Excel. Once the database direction is
> taken the
> spreadsheet could then be used to view the data and for
> charting, etc.
>
> At this point we have been discussing the approach to take
> in building
> a system using Excel. Till now there has been no mention of storing
> the data in a database.
>
> Dale
>
> > -----Original Message-----
> > From: owner-metastock@xxxxxxxxxxxxx
> > [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of
> Wooglinx@xxxxxxx
> > Sent: Tuesday, March 16, 1999 1:02 PM
> > To: metastock@xxxxxxxxxxxxx
> > Cc: Walter Lake
> > Subject: Use of EXCEL
> >
> >
> > Walt, et al.
> >
> > I have been following this subject and one question I have
> > is how do you plan
> > to handle a large number of stocks in one's data base. I
> > currently have about
> > 1400 stocks and indices for which I download data every
> > night. I also use
> > several different templates, each with at least two
> > indicators up to as many
> > as 6 on the same chart.
> >
> > In EXCEL, would you have to maintain a separate sheet for
> > each stock with the
> > indicators resident on the same sheet to perform the
> > computations against the
> > stock data? If so, that would not only mean a lot of sheets
> > for a large data
> > base of stocks, but also a huge amount of redundancy of indicator
> > calculations. Or, is there some plan to have separate
> sheets of just
> > indicators that can be "called" at will and applied against
> > the sheet of stock
> > data? And, if so, will you be able to "call" more than one
> > indicator at the
> > same time?
> >
> > While I have used EXCEL extensively for business plan and
> > budget modeling (and
> > Lotus and MultiPlan in the past), I have not as yet
> > considered / studied its
> > application to stock data analysis. Hopefully, there are
> > positive answers to
> > the questions posed.
> >
> > Jim Barone
> >
>
|