Hey Maverick,
For the weekly pivots, I use the last week (M-F). For the monthly pivots, I will use the last month. Besides the daily pivots, all I really need to do is change the numbers before the opening of every Monday and at the beginning of every month.
Excel makes my life alot easier. Simply use formulas and input the high, low, and close to get the pivots.
