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 [email protected], "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 > 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/
