Bijan
Actually J6 adds -J4 to J5 The minus sign before J4 gets hidden somewhat by the = sign The logic is explained on the instructions page. All of the if then statements clean up data errors. Without them a symbol removed through merger etc would disrupt the calculation. The if then statements cause an invalid symbol or bad data to be ignored. I have also used only raw data functions to try to reduce the impact of stock splits on days back results. Hopefully it is obvious how to change the days back to get historical results. If you have not set up your excel to use the QP add ins the spreadsheet will not work for you. Doing this is covered in the help section of QP3. Once this is done the spreadsheet should update every time you open it to the most current quotes plus data. Good luck Charles Mattson _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bijan Khezri Sent: Monday, August 28, 2006 10:03 AM To: [email protected] Subject: RE: [quotes-plus] Scan help Charles, Thank you for the spreadsheet. I have been looking through it and it needs of course an output from QP for the data that it needs to analyze. I will try to recreate the output. I have found a strange cell which I cannot explain: cell J6 adds cells J4 and J5. The latter two are positive numbers, yet J6 is a negative number. Cheers, Bijan _____ From: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com [mailto:quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com] On Behalf Of Charles Mattson Sent: Friday, August 25, 2006 4:14 PM To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com Subject: RE: [quotes-plus] Scan help I have uploaded the worksheet under Desmond NYSE Index Mod,xls I would be interested in any feedback from users of the spreadsheet. Charles _____ 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:07 PM To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com Subject: RE: [quotes-plus] Scan help Charles I suggest you upload your Excel worksheet to this list's files folder. 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 Charles Mattson Sent: Friday, August 25, 2006 8:30 AM To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com Subject: RE: [quotes-plus] Scan help 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: 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: Friday, August 25, 2006 7:14 AM To: quotes-plus@ <mailto:quotes-plus%40yahoogroups.com> yahoogroups.com 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] [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] 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/
