RE: [CANSLIM] Spreadsheet Question

From: "Tangen, Eric" <tangene@tycoelectronics.com>
Subject: RE: [CANSLIM] Spreadsheet Question
Date: Fri, 14 Dec 2001 17:37:00 -0500

Next Article (by Author): [CANSLIM] WARNING "Tim Fisher"
Previous Article (by Author): [CANSLIM] Spreadsheet Question "Perry Stanfield"
Top of Thread: [CANSLIM] Spreadsheet Question "Perry Stanfield"
Articles sorted by: [Date] [Author] [Subject]

You have several options:

1. Write a VBA routine...well worth learning and this is about as good a
starter project as it gets.
2. Use Access - (the database program you get with the Professional version
of Office)...again, easy if you know database programming.
3. Look into Pivot Tables in Excel...there might be something there. All I
know about pivot tables is how to spell it, so this may be a dead end.

ERIC TANGEN




- -----Original Message-----
From: Perry Stanfield [mailto:mpstan@attbi.com]
Sent: Friday, December 14, 2001 3:04 PM
To: canslim@lists.xmission.com
Subject: [CANSLIM] Spreadsheet Question


Is there a way to compare two columns of stock symbols  in a spreadsheet and
determine which symbols are "new" in the second column?  This comes up with
scans.........It would be nice to automate the process of identifying stocks
that are just making a screen for the first time.  There must be a way with
Excel...........

Thanks

Perry



- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim".  Do not use quotes in your email.

- -
- -To subscribe/unsubscribe, email "majordomo@xmission.com"
- -In the email body, write "subscribe canslim" or
- -"unsubscribe canslim".  Do not use quotes in your email.

Go to Jeff Salisbury LWGate Home Page.