I have inserted an extra column named ‘adjclose’ to keep track of the normalized closed prices. So if a 1 to 2 split occurs , all the past prices will be divided by 2 and stored into adjclose column. And the rsi7 is calculated based on this adjusted close price to get the correct values.

I will need to run few scripts manually when the split occurs, so it is somewhat inconvenient for me.

RSI daily report generated for 04/03/2007 have 3 stocks listed for ALL(Monthly,Weekly,Daily) RSI7 under 30. And NIKE (NKE) is the one of them. And has RSI7 value of just 4. If this was the correct value, I would have loaded up with NIKE right away.

Daily,Weekly,Monthly all below 30
Total : 3

But sadly , the value was incorrect caused by the stock split. Both NKE and BBD’s stock have split today. I did not think of the stock splits when I implemented RSI formula originally.

I have checked other websites to see how their calculations are done.

For www.stockcharts.com, the RSI7 daily value is 47.96 which looks more like a correct value. They normalized the past prices dividing by 2 ( since the stock has been split from 1 to 2 ratio) and calculated the RSI value.

But www.easystock.com doesn’t account the split just like I didn’t. Their daily RSI7 value is just 4 , same as mine.

It feels like that the stockchart.com method is correct, but I don’t like that the normalized historical are showing in the chart.(All past prices are divided by 2)

I will need some time to think how to implement it.