billyspradling 13 posts msg #63616 - Ignore billyspradling | 
6/12/2008 9:36:18 PM
  show the % gain or loss of all stocks 1 month ago and add colum {1 month ago}
 show the % gain or loss of all stocks 2 month ago and add colum {2 month ago} 
 show the % gain or loss of all stocks  3 month ago and add colum {3 month ago}
 show the % gain or loss of all stocks 4 month ago and add colum {4 month ago}
 show the % gain or loss of all stocks 5 month ago and add colum {5 month ago}
 show the % gain or loss of all stocks 6 month ago and add colum {6 month ago}
 show the % gain or loss of all stocks 7 month ago and add colum {7 month ago}
 show the % gain or loss of all stocks 8 month ago and add colum {8 month ago}
 show the % gain or loss of all stocks 9 month ago and add colum {9 month ago}
 show the % gain or loss of all stocks 10 month ago and add colum {10 month ago}
 show the % gain or loss of all stocks 11 month ago and add colum {11 month ago}
 show the % gain or loss of all stocks 12 month ago and add colum {12 month ago}
 
 
 
 in other words i would like to see the gain or loss of all stocks and post them in columns jan feb mar  etc etc etc   
 
                                                                               THANK A MILLION 
                                                                                       BILL
 
  | 
nikoschopen 2,824 posts msg #63619 - Ignore nikoschopen | 
6/13/2008 1:42:31 AM
 
  	    
 Note the number used for the "date offset". I used 9 because the month of May ended nine trading days ago. You will need to manually count the days since the end of the previous month and change this number accordingly.
 
  | 
guru_trader 485 posts msg #64165 - Ignore guru_trader | 
6/22/2008 12:35:45 AM
 
  	    
 
  |