Philip,
I need to ask you an RSI question; I hope I can explain it satisfactorily.
First, I’m using 4-hour Wealth Lab data to calculate Monthly RSI(14). So, I need to look back 1,680, 4-hour bars to calculate the Monthly RSI(14) at any juncture (6 bars per day X 20 days per period X 14 periods). If you like, I can change 20 to 21.
I’m using the formula to calculate it outlined here:
I need to obtain the last 15 “Monthly” Price Closes over these 1,680 bars, so that I can obtain the UP or DOWN delta between these Monthly Closing prices, which as you know, is part of the RSI formula. When looking at Monthly RSI, most (if not all) charting packages will use the Closing Price on the last day of the trading month, as the basis for further RSI Calculation.
Now here’s where it gets tricky - in WealthLab, at any given 4-hour bar juncture, it’s very easy for me to look back at 14 different periods of 20 trading days, to obtain the requisite Closing prices, BUT these Closing prices won’t necessarily fall on the last Trading day of the Month, and it’s very difficult programmatically to determine what the last day of the Month is. It is much easier to just go back 20 days at a time from a given point in time.
So, here’s my [B]QUESTION[/B]: do you think it is OK to grab Closing Prices moving backwards 20 days at a time for 14 periods from the current Bar? This would mean that I would be grabbing Closing prices that aren’t necessarily on the last trading-day-of-the-month boundaries (but I would still be getting 14 month’s of Closing price info), AND this would effectively result in having a different Monthly RSI(14) value at every 4-hour bar, which makes Monthly RSI(14) a bit more granular (this could be a positive thing), rather than just a single Monthly RSI(14) value that’s used for the entire trading Month.
If you say that it’s OK to do this, then super cool. If you answer NO to this, playing devil’s advocate, I would argue that a single Monthly RSI(14) value doesn’t necessarily represent the RSI properly within an entire month, since the underlying Closing prices used to calculate RSI are merely a single snapshot on the last trading day of the calendar month.
I hope my question is clear - kinda hard to explain it all in text, but I gave it my best. I can see why RSI values differ from package to package.