|
PureBytes Links
Trading Reference Links
|
Dan-
To copy the data from the
Yahoo page to a spreadsheet, I do the following:
1. Type CTL+A. This selects the entire Yahoo
page.
2. Type CTL+C. This copies the page into the
clipboard.
3. Go to the spreadsheet.
4. Type CTL+V. This pastes the data from the clipboard
to the spreadsheet.
5. The NYSE advancing issues number is in C8.
The Amex is in E8, etc.
That ought to work for you
except for one thing. I use the StarOffice spreadsheet, not
Excel. StarOffice is the Sun Microsystems answer to one of the Microsoft
office products. It was preloaded into this beast of a computer when I
bought it, so that is what I use. I am not recommending it. I have
always believed that StarOffice and Excel are compatible, but if you are
still having problems after following these five steps, you probably ought to
search out an Excel expert.
Good luck.
-Scott
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
DanC
To: <A
href="mailto:s1f1winsor@xxxxxxxxxxx"; title=s1f1winsor@xxxxxxxxxxx>Scott
Winsor
Sent: Monday, July 08, 2002 7:26 PM
Subject: Re: [RT] advance/decline
data
Hey Scott,
Please help me out. I tried to do a clipboard copy from yahoo to a
spreadsheet, and it won't, at least I can't get it to copy. I do not see
a way of importing...
Please step my thick brain through copying the page into a spreadsheet, if
you don't mind.
Dan
Scott Winsor wrote:
Someone was asking about how
to get adv, decl, up/down volume, etc data, without manually entering it
from Barron's. I use:<FONT
face="MS Sans Serif">
<A
href="http://finance.yahoo.com/m0?u/";>http://finance.yahoo.com/m0?u/ <FONT
face="MS Sans Serif"> You can copy the page into a
spreadsheet and go from there. The only problem is that the site is
updated daily. If I miss a day, I have to use the printed
page. In a later
message, somebody mentioned Reuters. I am going to check them.
Maybe you can also.
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
----- Original Message -----
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From:
<A href="mailto:slevy1220@xxxxxxxxxxxxx";
title=slevy1220@xxxxxxxxxxxxx>slevyaa
To: <A
href="mailto:realtraders@xxxxxxxxxxxxxxx";
title=realtraders@xxxxxxxxxxxxxxx>realtraders@xxxxxxxxxxxxxxx
Sent: Sunday, July 07, 2002 7:16
AM
Subject: Re: [RT] A (weak) case for a
bounce in NDX/QQQ The last message in this thread mentions
Barrons. Are there sources for adv, decl, up/down vol,
new highs/lows other than manual entry from financial
press? Thanks
--- In realtraders@xxxx,
profitok <profitok@xxxx>
wrote: > did not get Barron's this week end??
> Dow Jones on strike? > anyone can e mail me
privately the data from it for the last 4 days > adv
issues,, dec issues,, up vol,, down vol,, new high and new
lows,, and > total volume > thanks
in advance > Ben > ----- Original Message
----- > From: "Kent Rollins" <kentr@xxxx>
> To: <realtraders@xxxx> > Sent:
Saturday, July 06, 2002 10:47 PM > Subject: Re: [RT] A
(weak) case for a bounce in NDX/QQQ >
> > > Gary > >
> > Do you have New Highs/New Lows? That can sometimes
resolve ambiguities. > > >
> Kent > > > > >
> ----- Original Message ----- > > From: "Gary
Funck" <gary@xxxx> > > To:
"Realtraders@xxxxxxxxxxxx Com" <realtraders@xxxx> >
> Sent: Saturday, July 06, 2002 3:56 PM > > Subject:
[RT] A (weak) case for a bounce in NDX/QQQ > >
> > > > > > Attached
are a few charts. > > > > 1. The
MACD of VIXN shows that implied volatility has peaked and
is > rolling > > over.
Bullish. > > > > 2. The weekly chart
of NDX shows a head and shoulders formation. The
> bottom > > neck line is broken. If we do
rally, a rally back to the shoulder line, >
and > > the > > down trend line of
about 1300 (32.50 on the QQQ's), or +22%, over the
> course > > of > >
month/so seems possible. > > > > 3.
The new high/new low and adv/decline study is a little more
ambiguous. > > Although both levels are low,
and low enough to spark a rally, they're not
> > at > > the 20% and 40% levels,
respectively, that would be typical of a >
significant > > bottom. > >
> > On a larger timing scale, a bounce into mid-August,
followed by a dive > into >
> Sept/Oct., making a much lower low than the recent low would be
a likely > > seasonal pattern.
> > > > > > To
unsubscribe from this group, send an email to: > >
realtraders-unsubscribe@xxxx > > >
> > > > > Your use of Yahoo!
Groups is subject to <A
href="http://docs.yahoo.com/info/terms/";>http://docs.yahoo.com/info/terms/
> > > > > >
> > > > > > To
unsubscribe from this group, send an email to: > >
realtraders-unsubscribe@xxxx > > >
> > > > > Your use of Yahoo!
Groups is subject to <A
href="http://docs.yahoo.com/info/terms/";>http://docs.yahoo.com/info/terms/
> > > >
To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the <A
href="http://docs.yahoo.com/info/terms/";>Yahoo! Terms of
Service.
To
unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the <A
href="http://docs.yahoo.com/info/terms/";>Yahoo! Terms of
Service.
To unsubscribe from this group, send an email to:
realtraders-unsubscribe@xxxxxxxxxxxxxxx
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Attachment:
Description: ""
|