InvestorQ : How do we actually calculate the RSI values and plot on the chart?
Arti Chavan made post

How do we actually calculate the RSI values and plot on the chart?

Answer
user profile image
1 year ago


The calculation of the RSI is based on a fairly simple formula. It is slightly difficult to explain without an illustration so we will also give you a complete tabular RSI measurement for your better understanding. Let us first start off with the formula for calculation of RSI.

RSI = 100 – [100 / (1 + (Average of Upward Price Change / Average of Downward Price Change ) ) ]

Date

High

Low

Close

px Change

Volatility

Chg

Gain

Loss

Av Gain

Av Loss

RS

RSI

23-Oct

1,153.00

1,125.10

1,149.90

1.01%

29.07%

11.50

11.50

-

6.45

8.72

0.739

42.501

24-Oct

1,158.50

1,143.15

1,152.15

0.20%

27.41%

2.25

2.25

-

6.15

8.10

0.759

43.149

25-Oct

1,155.00

1,144.10

1,149.40

-0.24%

26.12%

-2.75

-

2.75

5.71

7.72

0.740

42.518

26-Oct

1,158.00

1,139.00

1,153.20

0.33%

26.12%

3.80

3.80

-

5.57

7.17

0.778

43.743

27-Oct

1,155.90

1,136.05

1,145.05

-0.71%

22.57%

-8.15

-

8.15

5.17

7.24

0.715

41.691

28-Oct

1,145.00

1,130.00

1,135.45

-0.84%

15.28%

-9.60

-

9.60

4.80

7.40

0.649

39.349

29-Oct

1,135.80

1,114.10

1,131.20

-0.38%

11.84%

-4.25

-

4.25

4.46

7.18

0.621

38.323

30-Oct

1,150.45

1,133.40

1,145.50

1.26%

12.50%

14.30

14.30

-

5.16

6.67

0.775

43.648

31-Oct

1,157.60

1,132.30

1,136.80

-0.76%

13.24%

-8.70

-

8.70

4.79

6.81

0.704

41.311

01-Nov

1,145.00

1,119.40

1,122.90

-1.23%

14.57%

-13.90

-

13.90

4.45

7.32

0.608

37.827

02-Nov

1,143.90

1,122.90

1,138.30

1.36%

14.25%

15.40

15.40

-

5.23

6.80

0.770

43.512

03-Nov

1,140.00

1,115.20

1,134.60

-0.33%

13.48%

-3.70

-

3.70

4.86

6.57

0.739

42.506

04-Nov

1,127.50

1,100.10

1,103.85

-2.75%

17.09%

-30.75

-

30.75

4.51

8.30

0.544

35.220

05-Nov

1,103.85

1,103.85

1,103.85

0.00%

17.09%

-

-

-

4.19

7.71

0.544

35.220

06-Nov

1,103.85

1,103.85

1,103.85

0.00%

16.21%

-

-

-

3.89

7.16

0.544

35.220

07-Nov

1,106.00

1,090.00

1,100.80

-0.28%

16.05%

-3.05

-

3.05

3.61

6.86

0.526

34.488

08-Nov

1,094.00

1,067.20

1,080.20

-1.89%

17.35%

-20.60

-

20.60

3.36

7.85

0.428

29.957

09-Nov

1,082.90

1,052.00

1,061.50

-1.75%

17.79%

-18.70

-

18.70

3.12

8.62

0.361

26.548

10-Nov

1,045.15

1,011.25

1,020.00

-3.99%

22.91%

-41.50

-

41.50

2.89

10.97

0.264

20.871

11-Nov

1,052.00

1,023.80

1,047.80

2.69%

27.33%

27.80

27.80

-

4.67

10.19

0.459

31.446

12-Nov

1,063.20

1,042.05

1,052.40

0.44%

27.66%

4.60

4.60

-

4.67

9.46

0.493

33.041

13-Nov

1,062.40

1,038.00

1,053.70

0.12%

26.66%

1.30

1.30

-

4.43

8.78

0.504

33.512

14-Nov

1,050.80

1,037.00

1,041.15

-1.20%

26.77%

-12.55

-

12.55

4.11

9.05

0.454

31.229

15-Nov

1,041.15

1,041.15

1,041.15

0.00%

26.75%

-

-

-

3.82

8.41

0.454

31.229

16-Nov

1,059.50

1,040.05

1,052.40

1.07%

26.37%

11.25

11.25

-

4.35

7.80

0.557

35.777

17-Nov

1,070.00

1,045.00

1,066.35

1.32%

27.55%

13.95

13.95

-

5.03

7.25

0.695

40.988

18-Nov

1,098.30

1,056.20

1,087.90

2.00%

27.22%

21.55

21.55

-

6.21

6.73

0.923

48.006

19-Nov

1,095.00

1,072.95

1,079.00

-0.82%

27.38%

-8.90

-

8.90

5.77

6.88

0.838

45.594

20-Nov

1,079.95

1,059.00

1,060.70

-1.71%

28.13%

-18.30

-

18.30

5.36

7.70

0.696

41.030

21-Nov

1,064.80

1,049.05

1,057.75

-0.28%

28.13%

-2.95

-

2.95

4.97

7.36

0.676

40.329

22-Nov

1,064.90

1,040.10

1,049.05

-0.83%

27.31%

-8.70

-

8.70

4.62

7.46

0.620

38.254

23-Nov

1,059.00

1,040.00

1,046.25

-0.27%

26.40%

-2.80

-

2.80

4.29

7.12

0.602

37.583

24-Nov

1,062.75

1,039.30

1,044.40

-0.18%

19.61%

-1.85

-

1.85

3.98

6.75

0.590

37.120

25-Nov

1,046.95

1,022.55

1,028.20

-1.56%

17.16%

-16.20

-

16.20

3.70

7.42

0.498

33.258

26-Nov

1,051.60

1,030.30

1,047.35

1.85%

19.01%

19.15

19.15

-

4.80

6.89

0.697

41.065

27-Nov

1,061.90

1,045.90

1,052.80

0.52%

19.15%

5.45

5.45

-

4.85

6.40

0.758

43.104

28-Nov

1,073.15

1,048.05

1,069.50

1.57%

19.41%

16.70

16.70

-

5.70

5.94

0.958

48.936

29-Nov

1,079.10

1,058.80

1,077.55

0.75%

19.53%

8.05

8.05

-

5.86

5.52

1.063

51.516

30-Nov

1,098.00

1,083.40

1,095.85

1.68%

20.19%

18.30

18.30

-

6.75

5.12

1.318

56.852

01-Dec

1,109.80

1,088.00

1,107.10

1.02%

19.93%

11.25

11.25

-

7.07

4.76

1.487

59.783

02-Dec

1,103.40

1,079.45

1,083.15

-2.19%

20.78%

-23.95

-

23.95

6.57

6.13

1.072

51.728

03-Dec

1,107.40

1,065.95

1,103.45

1.86%

21.88%

20.30

20.30

-

7.55

5.69

1.326

57.015

04-Dec

1,097.45

1,080.10

1,083.75

-1.80%

22.03%

-19.70

-

19.70

7.01

6.69

1.047

51.159

05-Dec

1,102.50

1,087.05

1,100.85

1.57%

22.71%

17.10

17.10

-

7.73

6.21

1.244

55.437

06-Dec

1,104.45

1,090.10

1,096.35

-0.41%

22.38%

-4.50

-

4.50

7.18

6.09

1.178

54.095

07-Dec

1,096.35

1,096.35

1,096.35

0.00%

22.28%

-

-

-

6.67

5.66

1.178

54.095

08-Dec

1,110.00

1,090.00

1,104.75

0.76%

22.22%

8.40

8.40

-

6.79

5.25

1.293

56.382

09-Dec

1,110.00

1,097.30

1,104.70

0.00%

20.46%

-0.05

-

0.05

6.30

4.88

1.292

56.364

10-Dec

1,106.60

1,083.00

1,086.30

-1.68%

21.45%

-18.40

-

18.40

5.85

5.85

1.001

50.033

11-Dec

1,109.95

1,087.00

1,105.40

1.74%

22.34%

19.10

19.10

-

6.80

5.43

1.253

55.607

12-Dec

1,108.95

1,093.20

1,105.25

-0.01%

21.66%

-0.15

-

0.15

6.31

5.05

1.250

55.555

13-Dec

1,102.45

1,076.05

1,078.90

-2.41%

24.21%

-26.35

-

26.35

5.86

6.57

0.892

47.147

14-Dec

1,085.50

1,062.25

1,074.05

-0.45%

23.01%

-4.85

-

4.85

5.44

6.45

0.844

45.774

15-Dec

1,074.65

1,058.90

1,069.35

-0.44%

22.40%

-4.70

-

4.70

5.06

6.32

0.799

44.423

16-Dec

1,067.90

1,047.90

1,050.80

-1.75%

21.74%

-18.55

-

18.55

4.69

7.20

0.652

39.474

17-Dec

1,067.40

1,055.50

1,063.30

1.18%

20.65%

12.50

12.50

-

5.25

6.68

0.786

44.002

18-Dec

1,069.95

1,052.10

1,055.70

-0.72%

19.57%

-7.60

-

7.60

4.88

6.75

0.723

41.947

19-Dec

1,062.95

1,030.85

1,049.95

-0.55%

17.88%

-5.75

-

5.75

4.53

6.68

0.678

40.410

20-Dec

1,091.00

1,048.10

1,083.40

3.14%

23.16%

33.45

33.45

-

6.59

6.20

1.063

51.537

21-Dec

1,155.00

1,054.35

1,133.00

4.48%

30.20%

49.60

49.60

-

9.67

5.76

1.679

62.669

22-Dec

1,164.00

1,137.55

1,139.90

0.61%

30.15%

6.90

6.90

-

9.47

5.35

1.771

63.911

23-Dec

1,162.10

1,128.35

1,131.90

-0.70%

30.40%

-8.00

-

8.00

8.79

5.54

1.588

61.362

24-Dec

1,158.95

1,128.55

1,139.65

0.68%

29.24%

7.75

7.75

-

8.72

5.14

1.696

62.905

25-Dec

1,160.00

1,117.00

1,121.25

-1.63%

29.60%

-18.40

-

18.40

8.10

6.09

1.330

57.076

26-Dec

1,142.50

1,122.00

1,137.05

1.40%

30.10%

15.80

15.80

-

8.65

5.65

1.529

60.464

27-Dec

1,152.50

1,131.00

1,136.25

-0.07%

27.70%

-0.80

-

0.80

8.03

5.31

1.513

60.205