This comes with 18 days of delay, as I had not been monitoring this room for a while and I am catching up, but certainly does not lack appreciation and a little embarrassment at the delayed thanks. I would like to thank Dale for the little jewel that he wrote. Quick and easy. Thank you very much.
Bijan _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of dalewarehime Sent: Thursday, August 31, 2006 1:43 PM To: [email protected] Subject: [quotes-plus] Re: Scan help Bijan: I just uploaded a file to the files section for your review. This requires the use of Excel VBA. In order to update the file you simply press Control-a and the file will update for all dates from today to the last date that you have previously update. To use your basket of stocks delete all of the stocks in the Symbols worksheet and insert your list. If you change the stocks, just delete all the lines that are include in the second sheet and type in a market date one day before the date you wish to start. I have tested the program using 1/2/90. In the interest of space I havn't included these with the file. This will run in Excel 2000. I have written this using Excel 2007. --- In quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com, "Bijan Khezri" <[EMAIL PROTECTED]> wrote: > > 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] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/quotes-plus/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/quotes-plus/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
