If you would be willing, I would very much like to receive your Excel
spreadsheet.
Thanks, Brett
Charles Mattson <[EMAIL PROTECTED]> wrote:
Bijan
I have an excel worksheet I use to calculate the Paul Desmond extreme index
which calculates the data you are interested in plus the sum of the price up
moves and the sum of the price down moves. Any list can be inserted. The
spreadsheet only gives list calculations for 1 day at a time, but the days
back feature is built in so you can rapidly calculate a series of historical
results and then paste them to a list for review. I tried to attach the
excel file to a reply to this board but yahoo rejected the 1MB file size.
If you are interested in trying the file let me know and I will try sending
the file to your email.
Charles Mattson
_____
From: [email protected] [mailto:[EMAIL PROTECTED] On
Behalf Of Bijan Khezri
Sent: Friday, August 25, 2006 7:14 AM
To: [email protected]
Subject: RE: [quotes-plus] Scan help
Howard,
Thank you very much. I am aware of the existing data which is published by
the exchanges. I am trying to put together a way to do the same for other
indices, such as the Russell 2000, for which the exchanges do not publish
breadth data. With kind regards,
Bijan
_____
From: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com
[mailto:quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com]
On
Behalf Of Howard Hansen
Sent: Friday, August 25, 2006 12:09 AM
To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com
Subject: RE: [quotes-plus] Scan help
Bejin
I will take a look at using Quotes Plus and Excel to calculate the
number of advancing and declining stocks in a list this week end. But
have you noticed that Quotes Plus already has historical data for
exactly the type of data you are looking for the American, NASDAQ and
New York Stock Exchanges.
Howard
-----Original Message-----
From: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com
[mailto:quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com]
On Behalf Of Bijan Khezri
Sent: Thursday, August 24, 2006 8:53 PM
To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com
Subject: RE: [quotes-plus] Scan help
Howard,
Thank you for responding. I have been scratching my head as to how to
write
even the scan for a single one of the items below, which, as you say I
could
then import into Excel.
Let's say that I have a list of ten stocks, and I want to find the daily
advancing issues for the past 500 periods. I thought that I could do a
close - close,-1 and determine if one of the stocks was advancing. How
can
I get a total for all the ten stocks for that day, and print it with the
date.
I thought of the function for .do.. but it seems to apply to only one
stock,
and there are no variables to hold and print a total for the true
condition
in the ten stocks for that day.
I would appreciate a little more detail on how you would see this
happening
in excel. Thanks and regards,
Bijan
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
---------------------------------
All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/quotes-plus/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
