|
PureBytes Links
Trading Reference Links
|
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
> >
>
|