Jonny --
The NASDAQ reached its highest point so far on March 10, 2000 at 5132.50:
Useless Facts
"NASDAQ Index All-Time High" (March 19, 2003)
http://www.distant.ca/UselessFacts/fact.asp?ID=205
Interestingly, the New York Times notes that the day's close was
5,048.62 -- so that was an intra-day high.
The New York Times for the following day indicates that there were the
following changes for NASDAQ stocks:
Advances: 1,858
Declines: 2,382
Unchanged: 737
The NASDAQ exchange tracks the composite index over a 7-year period:
NASDAQ
"NASDAQ Composite Index"
http://dynamic.nasdaq.com/reference/Comp_Eligibility_Criteria.stm
The low point actually came on Oct. 9, 2002, when the NASDAQ composite
fell to 1114.11 at closing, according to BigCharts.com. That would be
lowest the NASDAQ had been since 1996 and it would start rising from
then until now:
BigCharts
Historical Quote Database
http://bigcharts.marketwatch.com/historical/
According to the Wall Street Journal market summary numbers, this is
what happened on the NASDAQ that day:
Advances: 881
Declines: 2,528
Unchanged: 258
Google search strategy:
NASDAQ + "all time high"
Use the New York Times index and Wall Street Journal microfilms to get stock tables
Best regards,
Omnivorous-GA |
Request for Answer Clarification by
jonnysalkow-ga
on
17 Jan 2004 07:01 PST
Hello Omnivorous,
Thanks for your effort.
As I read it, you misinterpreted the last part of my question. I
wanted the dates and levels of the top and the bottom and that you did
perfectly.
But the winner/loser/unchanged numbers I need must compare the period
begining at the close on March 10, 2000 when the high was reached and
October 9, 2002 when the low was reached. Please just use the closing
numbers. The interday high, while interesting, would add unneeded
complexity.
Hope you can do this for me.
Thank you very much.
alan
|
Clarification of Answer by
omnivorous-ga
on
17 Jan 2004 08:09 PST
Jonny --
The "intra day" high was just a way of finding the two critical dates.
I confirmed that March 10 indeed was the highest close:
March 10, 2000 close: 5,048.62
Oct. 9, 2002 close: 1,114.11
And the up/down/unchanged were listed for both days:
March 10, 2000:
Advances: 1,858
Declines: 2,382
Unchanged: 737
October 9, 2002:
Advances: 881
Declines: 2,528
Unchanged: 258
Or did I somehow misinterpret the question?
Best regards,
Omnivorous-GA
|
Clarification of Answer by
omnivorous-ga
on
17 Jan 2004 08:26 PST
Jonny --
If you're seeking a comparison of up/down/unchanged between 3/10/2000
and 10/9/2002, there are several problems:
* you'll start with 3,667 stocks to check
* there were 1300+ more stocks traded on 3/10/2000 but you don't know
if a company was merged with another; if it's stock simply didn't
trade on Oct. 9; if it's gone to the NYSE or AMEX; if it's bankrupt
(and worthless); or if it simply changed name and ticker symbol.
* you'd have to adjust the number for stock splits. For example,
Starbucks (NASDAQ: SBUX) may have had a lower per-share price -- but
it split 2-for-1 in March, 2001.
* the last (and most minor of the problems) is that some stocks
traded in 2002 might not have had any shares change hands on 3/9/2000.
If this is the way that you need the data, I'll be glad to ask the
editors to withdraw my answer so that you're not charged. However,
you may want to save some of this data for the next researcher.
Best regards,
Omnivorous-GA
|
Request for Answer Clarification by
jonnysalkow-ga
on
18 Jan 2004 16:28 PST
Omnivorous,
Thanks for your effort.
That is what I want but I understand the issues.
Let's call it even on this one. And please let me pay you for your work.
Hope we get a chance to work together again.
|
Clarification of Answer by
omnivorous-ga
on
18 Jan 2004 16:51 PST
Jonny --
Thank you for your kind consideration -- even if we didn't hit the
mark on this one. Alternate ways to get a rough approximation of what
you need (and reduce the amount of work) might be to take the top 10
NASDAQ companies by value in 2000 -- then see what happened.
I considered proposing doing the NASDAQ 100 but even that would be
probably a week's work due to the factors mentioned above. Any
mergers would probably take a couple of hours to work out the actual
share valuations upon closing.
Hope to see you again at Google Answers!
Best regards,
Omnivorous-GA
|