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