SI
SI
discoversearch

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 : The 56 Point TA; Charts With an Attitude

 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext  
To: wittder who wrote (29255)5/7/1999 7:49:00 PM
From: Alski  Read Replies (1) of 79241
 
wittder,
I've not done much with Access but it seems to me a more flexible data structure would be to turn the data around. How tough would it be to create a record for each symbol with fields for the last N hit dates, most recent first. I bet 5 or 10 dates would be plenty.
Then search for today's date in the first date field and a non-null date in the second date field.
An interesting extension might be to have several ranges of date fields, each for different scans.
Seems like the trick would be to create the tool to populate the date fields and create the new records for new hits.
FWIW...Alski
Report TOU ViolationShare This Post
 Public ReplyPrvt ReplyMark as Last ReadFilePrevious 10Next 10PreviousNext