|
PureBytes Links
Trading Reference Links
|
Jim,
In addition to me earlier reply:
You need to visit http://home.earthlink.net/~jfritch/ and see what Jim
Fritch has accomplished using Excel in combination with an end of day
supplier (Quotes Plus). He has done quite a job but IMHO it is very
tailored to his particular whims which was his intent. The amount of
work has to be very large. But, he has shared the source with all that
care to download it and a lot can be gleaned and used in projects by
everyone. It takes a bit of time to "crack" what he's doing but his
code is done very nicely for, as he describes himself, "an amatuer".
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
>
|