| 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?
 
 
 |