Technical Analysis - Beginners Message Board

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

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: Loren who wrote (7943)	1/22/1998 10:48:00 PM
From: ftth	Read Replies (1) of 12039

Hi Loren, the links were just to show the kinds of things others have done with Excel, to give ideas. If you want to do automated scans of a large universe of stocks, you may run into problems with Excel's row and column limits (different depending on version ). For excel 7 you're limited to 256 day's data, or only 1 trading year. Each issue uses at least 5 rows (o-h-l-c-v), plus rows for indicator calculations, so you have to pre-filter the database down to about 1500 stocks or so. If each stock is on a worksheet, you're limited to 256. Multiple stocks per page AND multiple worksheets is possible, but a real mess. If you flip the rows and columns around, it gets around one problem but creates a new one later. Don't know if you've thought about the mechanics of it yet, so I just thought I'd bring this up to possibly save you from doing a lot of work, then running in to a dead end. dh

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next