
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.
Daily,Weekly,Monthly all below 30
Total : 0
| symbol | price | change | percent | rsi7m | rsi7w | rsi7d |
|---|
Daily,Weekly,Monthly all below 35
Total : 1
| symbol | price | change | percent | rsi7m | rsi7w | rsi7d |
|---|---|---|---|---|---|---|
| HOV | 23.96 | -0.57 | -2.3% | 31.57 | 25.70 | 17.24 |
Daily,Weekly,Monthly all above 70
Total : 8
| symbol | price | change | percent | rsi7m | rsi7w | rsi7d |
|---|---|---|---|---|---|---|
| KSS | 77.98 | -0.02 | -0.0% | 75.89 | 73.02 | 83.07 |
| ATVI | 19.30 | +0.17 | +0.9% | 72.75 | 74.01 | 79.11 |
| BHP | 49.88 | +0.16 | +0.3% | 72.84 | 78.89 | 79.06 |
| MICC | 81.37 | +0.84 | +1.0% | 89.83 | 73.22 | 78.11 |
| EXC | 71.04 | -0.28 | -0.4% | 81.98 | 83.28 | 73.96 |
| MBT | 59.77 | +1.44 | +2.5% | 74.39 | 72.01 | 71.48 |
| WBK | 107.65 | +0.57 | +0.5% | 78.36 | 75.10 | 70.99 |
| VIP | 98.57 | +0.56 | +0.6% | 87.55 | 79.60 | 70.46 |
Number of RSI7 > 70
Total: 29
ABB, ATVI, BHP, CCJ, CEO, CHA, CVX, DB, DEO, ECA, ERJ, EXC, GFI, GGB, KSS, MBT, MICC, ORCL, PBR, RIO, SLW, SNDK, SU, SWK, TOT, VCP, VIP, WBK, XOM,
Number of RSI7 < 30
Total: 2
HOV, PAYX,
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| « Mar | May » | |||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| 8 | 9 | 10 | 11 | 12 | 13 | 14 |
| 15 | 16 | 17 | 18 | 19 | 20 | 21 |
| 22 | 23 | 24 | 25 | 26 | 27 | 28 |
| 29 | 30 | |||||