View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Stock Symbol Column comparison



"Mike" wrote:

Please help. I download stock symbol EOD (End of Day) data into Excel 2000.
Columns are titled Symbol, Date, Close, Volume. I am trying to compare the
closing price and volume columns for 2, 3, and 5 consecutive days. However,
for example Nasdaq, on one day contains 3, 340 symbols, the next day 3, 352
symbols. I would like to compare columns and retain in another column those
symbols that are common. Would appreciate any help possible. Thanks in
advance.


Thank you very much to all of you for your inputs. It helped very much. I
am a novice with Excel, but I used Harlan's after figuring out where to put
it and it worked, and it also selected those symbols that were common for two
days of Nasdaq EOD download and did it very fast. I can now go on and look
for "runners". Those stocks which go up in price and volume for 2, 3, and 4
days consecutive.

Again, appreciate all inputs........ Mike Davis in Panama