LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,101
Default Stock Symbol Column comparison

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup stock symbol on worksheet and return summary data Greg Purnell[_2_] Excel Worksheet Functions 7 April 4th 07 01:42 PM
Cell Column Comparison ace21 Excel Worksheet Functions 3 January 16th 07 04:29 PM
Excel Chart - 2 column stack /w 1 comparison column wclairmont Charts and Charting in Excel 1 December 1st 06 01:54 AM
How do I add a stock symbol smart tag in Excel? Teacher in Need Excel Discussion (Misc queries) 0 August 29th 06 10:59 PM
Excel; Stock Quotes; Smart Tags: doesn't always recognize symbol. Sled Excel Discussion (Misc queries) 13 March 10th 06 12:21 AM


All times are GMT +1. The time now is 08:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"