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 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Hansen Sent: Thursday, August 24, 2006 4:44 PM To: [email protected] Subject: RE: [quotes-plus] Scan help Bijan You can not do what you ask with a Quotes Plus Scan. Quotes Plus does not have the capability to calculate simple statistics like counting the number of rising or declining stocks or calculating averages. This is because Quotes Plus does not have static variables. Instead variables are reset to their initial conditions when a Quotes Plus Scan moves on to the next stock in a list. One way around this short coming is to import the output of your scan into Excel and use Excel to calculate your statistics. 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 11:13 AM To: Quote Plus List Subject: [quotes-plus] Scan help Hi, I need to write a scan to output the following historical data for a list of stocks: - Advancing number of issues - Declining number of issues - Advancing volume - Declining Volume Basically, the scan would, starting back at the number of bars prescribed, go through the list and 1) tag the advancing and declining stocks from close to prior close 2) add the total number of advancing, print that number 3) add the total number of declining, print that number 4) add the volume of the advancing, print that number 5) add the volume of the declining, print that number 6) go to the next day, and do the same. I would be grateful with some assistance in writing this scan. Thanks, Bijan [Non-text portions of this message have been removed] [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/
