15minoffame 131 posts msg #112796 - Ignore 15minoffame | 
4/16/2013 7:53:24 PM
  Hi SF master level technicians,
 I know SF doesn't offer monthly numbers but is it possible nonetheless to do a work around?  I like how stockcharts.com has it that the pivot levels remain the same for the entire month.  This month's pivot levels are based on March's high, low, & close.
 
 Much appreciated in advance!
 
 Tuan
 
  | 
Cheese 1,374 posts msg #112807 - Ignore Cheese | 
4/17/2013 1:56:14 AM
  I would use the new sF date-based features at
 http://www.stockfetcher.com/sfforums/?q=view&fid=1004&tid=112556&qrid=
 
  	    
 
  | 
mahkoh 1,065 posts msg #112808 - Ignore mahkoh modified | 
4/17/2013 7:16:44 AM
  I think that shows the daily pivots on the last day of the prior month. 
 For monthly lines try this:
 
  	    
 
 You will need to adjust the number of trading days of the prior month each new month.
 
  | 
15minoffame 131 posts msg #112811 - Ignore 15minoffame | 
4/17/2013 10:22:05 AM
  Thank you very much Cheese & Mahkoh!  I'm so glad there's people here on SF that can write codes with ease because even though I've been with SF for 5 years now, I've barely graduated beyond the filter builder...lol.  You two keep this up & soon you'll be in the SF pantheon of great code contributors!
 
 Mahkoh, your code is exactly what I'm looking for!  The pivots are only off by a penny to Stockchart's when I use 22 days.
 
 Thanks again for your help!  
 
 Now, my next request is can either of you two able to write codes that can predict correct lotto numbers...ha! :-)
 
  | 
mahkoh 1,065 posts msg #112814 - Ignore mahkoh | 
4/17/2013 1:29:01 PM
  The pivots being slightly off may have to do with calculation of monthly high and low. I never thought of this before but it could be that you have to use the monthly high close rather that the intraday high.
 
   	    
 
 Could you check these values?
 
  | 
15minoffame 131 posts msg #112822 - Ignore 15minoffame | 
4/17/2013 3:55:13 PM
  Hi Mahkoh,
 Now it's way off even after I entered 22 days.  Stockchart's April Spy pivot levels: S2 147.32, S1 151.99, P 154.42, R1 159.10, R2 161.53.
 
 Thanks!
 
 Tuan
 
  | 
mahkoh 1,065 posts msg #112823 - Ignore mahkoh modified | 
4/17/2013 4:38:32 PM
  It must have to do with SPY going ex-dividend March 15. If you replace SPY with a non dividend paying stock like DTV the values match (when using high 20 day high version))
 Stockcharts is known to adjust for dividends.
 
  | 
15minoffame 131 posts msg #112829 - Ignore 15minoffame | 
4/17/2013 10:32:03 PM
  Mahkoh,
 I tried to say close crossed above ms1, mpp, etc., but it's not working.  Would you by chance know how I can go about doing this?
 
 Thanks again!
 
 Tuan
 
  | 
mahkoh 1,065 posts msg #112835 - Ignore mahkoh | 
4/18/2013 1:16:04 PM
  You can use to give you stocks that are up to 1 % above ms1
 
 set{x,price/ms1}
 x between 1 and 1.01 
 
 or
 
 Count(price above ms1,6) above 4
 price below ms1
 
 to show stocks that crossed below ms 1 after having been above for at least the last 5 days
 
 
 
  | 
15minoffame 131 posts msg #112836 - Ignore 15minoffame | 
4/18/2013 3:56:53 PM
  Mahkoh,
 So I can't say close crossed above ms1 within last 1 day?
 
  |