Silicon Investor (SI) -- The First Internet Community

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Strategies & Market Trends : Technical Analysis - Beginners -- Ignore unavailable to you. Want to Upgrade?

To: Loren who wrote (7949)	1/23/1998 10:42:00 AM
From: ftth	Respond to of 12039

Hi Loren, I see what you mean for processing 1 stock at a time. When I looked into doing this a while back, I wanted to get the total processing time down under an hour, and minimize disk thrashing, so I had to get multiple securities per page, meaning data across rows rather than down rows. I was using the other worksheets within the workbook for composite indicators and indusrty groups, graphs, etc, so it would have been a mess to use multiple worksheets for the raw data. In any event, you may want to give a look at Wave$Wise. I'm not exactly clear on what you're trying to do, but WW acts like a gigantic subroutine for Excel. WW reads the data, performs indicators such as averages, rsi,regression etc and returns the answers back to Excel. Or, WW can send 16k cells per security back to Excel. You can write Excel macros or VBA to put the data anywhere you want in Excel. It may save you some work (especially validating and debugging) if it already provides some or most of what you're looking for. Pete at Wave$wise was very good at returning email and describing what his product can do. Might be worth a correspondence or 2 with him. Just a thought. dh