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