Example: Indian Oil Corporation SHARE 50MA, 100MA & 200MA Analysis

Note: MA200 tells about broad trend (either Up-trend or down-trend) then, MA100 further MA50 or MA14 ! Cross-over tells about reversal.

import pandas as pd
pd.set_option(‘display.max_rows’, 500)
pd.set_option(‘display.max_columns’, 500)
pd.set_option(‘display.width’, 1000)
from pandas.plotting import register_matplotlib_converters
import datetime as dt
import matplotlib.pyplot as plt
from matplotlib import style

from matplotlib.finance import candlestick_ohlc

import matplotlib.dates as mdates
pd.core.common.is_list_like = pd.api.types.is_list_like

import pandas_datareader.data as web

style.use(‘ggplot’)
df = pd.read_csv(‘IOC.csv’, parse_dates=True, index_col=0)
df[’10ma’]= df[‘Close’].rolling(window=10).mean()
df[’25ma’]= df[‘Close’].rolling(window=25).mean()
df[’50ma’]= df[‘Close’].rolling(window=50).mean()
df[‘100ma’]=df[‘Close’].rolling(window=100).mean()

df_ohlc = df[‘Close’].resample(’10D’).ohlc()

df_Volume = df[‘Volume’].resample(’10D’).sum()

print(df_Volume.tail())

print(df_ohlc.head())

df.dropna(inplace=True)

print(df.tail(20))
ax1 = plt.subplot2grid((6,1),(0,0),rowspan=5,colspan=1)
ax2 = plt.subplot2grid((6,1),(5,0),rowspan=1,colspan=1,sharex=ax1)
ax1.plot(df.index,df[‘Close’])

ax1.plot(df.index,df[’10ma’])

ax1.plot(df.index,df[’25ma’])

ax1.plot(df.index,df[‘100ma’])

Volume Graph

ax2.bar(df.index,df[‘Volume’])

df.plot()
plt.show()
df[‘Open’].plot(label=’IOC’,figsize=(12,8),title = ‘Opening Prices’)
plt.legend();

df[‘MA14’] = df[‘Open’].rolling(14).mean()
df[‘MA50’] = df[‘Open’].rolling(50).mean()
df[‘MA100’] = df[‘Open’].rolling(100).mean()
df[‘MA200’] = df[‘Open’].rolling(200).mean()
df[‘Open’].plot(figsize = (15,7))
df[‘MA14’].plot(color=”purple”, linewidth=1.0, linestyle=”-“, label=”MA14”)
df[‘MA50’].plot(color=”red”, linewidth=1.0, linestyle=”-“, label=”MA50”)
df[‘MA100’].plot(color=”blue”, linewidth=1.0, linestyle=”-“, label=”MA100”)
df[‘MA200’].plot(color=”green”, linewidth=1.0, linestyle=”-“, label=”MA200”)
plt.legend(loc=’upper left’)

SAMPLE IOC.csv file (Can be copied to notepad):

Date,Open,High,Low,Close,Volume
2020-07-20,86.95,88.5,86.15,88.3,20607847
2020-07-21,88.3,94.7,87.7,93.45,93905218
2020-07-22,93.55,94.2,91.5,92,30482054
2020-07-23,91.75,95.45,91.2,94.3,44920975
2020-07-24,93.9,94.6,91.8,92.8,22611546
2020-07-27,93.6,95.65,91.4,93.75,39139215
2020-07-28,93.75,95.25,92.65,93.4,24585687
2020-07-29,92.3,93.7,92.05,92.6,14883656
2020-07-30,92,92.5,87.6,88.55,43622365
2020-07-31,89.3,89.95,87.25,88.45,41414494
2020-08-03,88.35,88.35,85.4,86.2,31446437
2020-08-04,86.3,87.45,85.8,86.95,25498635
2020-08-05,87,88.05,86.3,86.6,21667810
2020-08-06,86.8,88.2,86.3,87.2,19663459
2020-08-07,87.7,88.4,85.65,86.4,22270182
2020-08-10,86.6,87.7,86.2,87.1,16255605
2020-08-11,87.2,88.2,86.9,87.05,16717030
2020-08-12,87.05,87.25,85.7,85.85,21486470
2020-08-13,86.4,87.05,85.95,86.85,11778434
2020-08-14,87.5,87.5,84.55,84.8,19898132
2020-08-17,85.25,87.75,85.15,87.55,19481634
2020-08-18,87.1,87.9,86.65,87,13545170
2020-08-19,87.1,89,87.1,88,24451316
2020-08-20,87.9,89.7,87.1,89.05,32146698
2020-08-21,89.95,90.45,88.6,88.85,19035208
2020-08-24,88.95,89.4,88.1,88.35,9740352
2020-08-25,88.35,89.05,87.6,88.3,19552892
2020-08-26,88.8,88.85,87.6,87.9,16122996
2020-08-27,88.15,88.4,87.05,87.2,15445049
2020-08-28,87.8,89,87.4,87.8,17611779
2020-08-31,88.5,91.75,85.35,85.8,70850231
2020-09-01,85.8,86.6,83.5,84.65,27777356
2020-09-02,85.4,85.65,84.55,85.3,12523696
2020-09-03,85.7,86.55,84.45,85.1,14027426
2020-09-04,84,84.85,82.75,83.9,12703543
2020-09-07,84.5,84.95,81.8,83.8,14902298
2020-09-08,83.95,84.4,82.55,82.75,16168962
2020-09-09,82.7,82.85,79.3,80.55,24388612
2020-09-10,80.7,83.95,80.7,83.55,29432278
2020-09-11,83.3,84,82.05,83.1,17860255
2020-09-14,83.2,83.8,82.35,82.7,11874116
2020-09-15,82.7,83.4,81.8,82.25,11709315
2020-09-16,82.25,83.05,81.45,82.7,12791146
2020-09-17,82.4,82.8,81.4,81.8,12883226
2020-09-18,82.6,82.85,80.25,80.7,21035497
2020-09-21,80.8,81,77,77.7,22523202
2020-09-22,78.1,78.4,75.4,76.15,20539323
2020-09-23,76.5,77.2,75.35,75.95,19123948
2020-09-24,75,75.2,71.65,72,24558526
2020-09-25,72.35,74.4,71.85,74.1,24753598
2020-09-28,75,76.6,74.3,75.65,16096156
2020-09-29,76,76.25,74.05,74.85,14878350
2020-09-30,74.85,75.45,73,73.9,18970112
2020-10-01,73.95,75,73.45,74.1,14256817
2020-10-05,74.5,76.15,73.8,75.55,16171232
2020-10-06,76.15,76.25,74.7,75.35,16092167
2020-10-07,75.15,75.55,74.3,75.2,15157502
2020-10-08,75.1,75.8,74.3,75.5,13210777
2020-10-09,74.6,77.5,74.6,76.5,18028904
2020-10-12,76.5,77.45,75.1,75.7,11846163
2020-10-13,75.55,76.35,74.55,76.1,12907922
2020-10-14,75.2,75.9,73.75,74.65,19604295
2020-10-15,74.65,75.8,74,74.55,17815860
2020-10-16,74.6,75.2,73.85,74.2,23227741
2020-10-19,74.6,77.4,74.6,76.8,23207536
2020-10-20,76.6,76.7,74.9,75.05,18691246
2020-10-21,75.75,76.75,75.4,76,28080425
2020-10-22,75.85,78.25,75.5,77.7,21947260
2020-10-23,77.7,79.25,77.7,78.25,13735592
2020-10-26,78.25,79.2,78,78.1,12517768
2020-10-27,77.55,78.5,76.1,78.1,15157667
2020-10-28,78.1,78.35,77.1,78.05,11414392
2020-10-29,76.7,78.9,76.2,78.4,18997747
2020-10-30,80,81.9,79,79.55,54768803
2020-11-02,80.05,80.5,77.55,78.2,19197735
2020-11-03,78.05,79.1,77.4,78,15275353
2020-11-04,78,78.5,76.85,77.95,10731410
2020-11-05,78.7,80.2,78.25,79.8,19673077
2020-11-06,80,80.9,79.7,80.25,15044571
2020-11-09,80.45,81.45,80.1,81.2,15987537
2020-11-10,81.1,84.45,81.1,84.25,21976849
2020-11-11,84.25,85.2,83.15,85,18399868
2020-11-12,85,85.5,83.95,85.3,13700138
2020-11-13,84,85.15,83.7,84.75,11108758
2020-11-14,85.25,87,84.9,86.65,6756382
2020-11-17,87,87,84.5,84.95,25035014
2020-11-18,84.5,85.45,84.2,85.25,12869418
2020-11-19,85.25,86.6,84.5,84.7,15420472
2020-11-20,84.75,85.75,83.4,84.85,15609165
2020-11-23,85.5,86.65,84.05,86.45,21750853
2020-11-24,87,87.35,85.75,86.15,17836449
2020-11-25,86.5,87.1,85.5,85.75,17102078
2020-11-26,85.9,86.25,84.55,85.6,15122856
2020-11-27,85.6,86.2,84,84.6,31877290
2020-12-01,85,86,84.1,85.85,14386967
2020-12-02,85.85,89.35,85.6,88.4,44728000
2020-12-03,89.45,90.1,87.6,89.9,39317570
2020-12-04,90.3,91.45,89,90.4,24856327
2020-12-07,90.5,92.2,90.4,91.7,21338652
2020-12-08,92,92.3,90.05,91.05,17122770
2020-12-09,91.4,94.25,91.1,93.95,34467763
2020-12-10,93.9,93.9,91.15,92.45,22243189
2020-12-11,93.55,96.1,93.05,93.85,55197152
2020-12-14,95,96.8,94.6,96.2,34961172
2020-12-15,96.25,96.25,94.35,95.45,20959935
2020-12-16,96.5,97.5,95.8,96.35,22630689
2020-12-17,96.5,97,95,95.4,16645932
2020-12-18,95.4,95.75,93.3,93.95,24364590
2020-12-21,93.4,93.4,84.6,87.1,49215350
2020-12-22,86,88.5,84.2,87.95,34029323
2020-12-23,88.2,88.6,86.75,88.15,21048766
2020-12-24,88.25,91.25,88.25,90.25,21997837
2020-12-28,91,92,90.9,91.7,13213126
2020-12-29,92,92.5,90.4,91.2,14705538
2020-12-30,91.35,91.7,90,90.9,13421049
2020-12-31,90.5,91.65,90.2,90.95,15177511
2021-01-01,91.3,91.75,91.1,91.5,7144142
2021-01-04,92,94.05,92,93.85,20940906
2021-01-05,93,93.25,91.8,93,18715045
2021-01-06,93.35,95.6,93.2,94.1,24710986
2021-01-07,95,95.45,93.8,94.5,18143241
2021-01-08,95.1,96.4,94.65,96.15,22542041
2021-01-11,96.2,96.95,94.6,96,16225411
2021-01-12,95.6,99.35,95.2,97.95,31941540
2021-01-13,98.45,102.75,98.2,100.95,55937686
2021-01-14,101.75,103.6,100.3,103.2,30720438
2021-01-15,103.35,103.9,100.5,101.3,27838004
2021-01-18,101.55,101.85,97.5,98.3,28599856
2021-01-19,99,100.3,98,98.55,24415735
2021-01-20,98.9,99.8,97.75,98.3,18930532
2021-01-21,98.2,99.6,96.2,96.7,25634853
2021-01-22,96.5,97.35,95.25,95.7,22504208
2021-01-25,97,97.5,93.15,93.45,22533235
2021-01-27,93,93.8,90.25,91.4,27493562
2021-01-28,90.45,92.95,90.25,92.6,24137903
2021-01-29,93.8,96.3,92.8,93.25,74195476
2021-02-01,95.8,96.4,93.4,95.8,53177517
2021-02-02,97.55,99.2,96.75,98.8,38641408
2021-02-03,100.6,102.4,99.9,101.85,58158800
2021-02-04,102.8,104.35,102.5,103.6,51171418
2021-02-05,104.5,104.6,102.05,102.4,31422905
2021-02-08,104,104.4,102.45,104.1,37924977
2021-02-09,99.8,99.8,97,97.7,47911877
2021-02-10,98.1,98.75,96.1,96.75,22672022
2021-02-11,96.1,97.5,95.9,96.5,19512564
2021-02-12,96.55,97.1,94.6,95.1,19038734
2021-02-15,95.55,96.1,94,94.15,14796024
2021-02-16,94.15,96.5,94,95.6,24869144
2021-02-17,95.55,95.7,94.65,95,16459093
2021-02-18,95.3,99.85,95.3,99,54055390
2021-02-19,99.2,100.5,96.1,97.55,42193351
2021-02-22,97.5,98.5,95.1,95.65,19487082
2021-02-23,96.4,99.1,96,97.65,35512683
2021-02-24,98.4,99.9,97,97.95,19784111
2021-02-25,99.4,101.95,98.85,100.9,62750445
2021-02-26,99.5,101.95,97.2,98.05,45723160
2021-03-01,101,101.5,99.8,100.7,30046249
2021-03-02,102.25,104.1,101.75,102.2,45720247
2021-03-03,103,104,101.4,102.6,30023276
2021-03-04,101.5,103.1,101.15,101.45,16870409
2021-03-05,101.7,102.85,100.85,101.45,40145177
2021-03-08,102.25,105,102.1,103.6,49732782
2021-03-09,102.45,102.9,99.2,100.55,29925269
2021-03-10,101.9,101.9,98.7,98.85,21160710
2021-03-12,100.25,102.3,100.2,101.3,34987666
2021-03-15,101.65,102.7,100,101.05,21098400
2021-03-16,102.1,102.6,99.95,100.4,27527510
2021-03-17,101.25,101.25,98,98.2,20922333
2021-03-18,98.9,99.5,96.5,97.25,21413768
2021-03-19,96.95,99.6,95.4,98.75,34445364
2021-03-22,99.65,99.8,98.25,99.15,21252461
2021-03-23,97.2,97.5,96.4,96.75,22153320
2021-03-24,96,96.75,94.25,94.55,19041669
2021-03-25,94.35,94.7,90.45,90.9,27910375
2021-03-26,91.8,92.2,90.6,90.9,18974850
2021-03-30,91,91.95,90.1,91.55,20591828
2021-03-31,91.55,92.3,90.95,91.85,13495181
2021-04-01,92,93.35,91.2,93.15,14843941
2021-04-05,93,93,90.05,90.75,17182715
2021-04-06,90.9,91.85,90.45,91.15,11040294
2021-04-07,91.15,92.9,91.15,92.7,13742822
2021-04-08,93,93.7,92.5,92.95,12783404
2021-04-09,92.8,92.95,91.3,91.7,10297316
2021-04-12,90.1,90.45,86.75,87,19962491
2021-04-13,87.2,89.25,87.1,88.8,15976037
2021-04-15,88.2,90.35,88.1,90.1,15727499
2021-04-16,89.15,91.15,89.15,90.15,10290317
2021-04-19,87.95,88.8,86.85,88.1,15268241
2021-04-20,88.35,90,87.35,87.8,10866044
2021-04-22,88,88.3,87.35,87.85,9490190
2021-04-23,87.65,88.55,87.4,88.05,8003678
2021-04-26,88.7,88.8,87.75,88.2,7066681
2021-04-27,88.2,89.1,88.2,88.85,8752415
2021-04-28,89.2,89.55,89,89.4,6336704
2021-04-29,90.25,90.5,88.7,88.9,8957163
2021-04-30,88.6,93.1,88,90.85,29815698
2021-05-03,89.85,91.9,89.55,91.45,13655785
2021-05-04,92.5,93.5,91.1,91.4,14855641
2021-05-05,92.8,93.45,91.8,92.2,22976074
2021-05-06,92.85,93.15,92,92.6,14722752
2021-05-07,92.9,95.25,92.2,94.7,18508502
2021-05-10,95.3,99.55,95.2,99.15,36970751
2021-05-11,98.6,104.4,97.8,103.7,76907792
2021-05-12,103.9,106.6,102.3,102.8,39084460
2021-05-14,102.8,103.65,100,101.05,21825753
2021-05-17,101.65,102.25,100.1,102,19693910
2021-05-18,103.1,105.9,102.45,105.55,35764247
2021-05-19,104.5,108.95,104.1,107.2,74174684
2021-05-20,109.7,109.7,104.5,104.7,56482450
2021-05-21,105.8,106.9,103.55,104.3,38579179
2021-05-24,105,109.9,105,109.45,83199043
2021-05-25,110.4,111.9,109.6,110.3,40720179
2021-05-26,110.1,112.8,109.25,112,36991909
2021-05-27,112.7,113.7,109.95,110.25,34323489
2021-05-28,111.5,112,108.45,109.85,30246118
2021-05-31,110,110.5,108.35,109.25,18219003
2021-06-01,109.5,110.95,109.05,109.9,17108041
2021-06-02,109.8,111.4,109.55,110.85,17386308
2021-06-03,110.15,112.95,110.15,112.45,20956249
2021-06-04,112.5,114.95,112.4,114.6,28329820
2021-06-07,114.85,115.75,114.3,114.7,19210364
2021-06-08,115.15,117.5,113.35,116.7,22786086
2021-06-09,117.1,117.85,114.5,114.95,21013561
2021-06-10,115.5,116.5,115.2,115.95,12975319
2021-06-11,116.4,117.35,114.4,115.1,15096011
2021-06-14,115.25,115.7,112.5,114.75,10651393
2021-06-15,114.55,116.4,114.55,115.75,12477524
2021-06-16,115.75,117.15,115.5,115.9,11893517
2021-06-17,114.95,116.3,114.05,114.6,9555157
2021-06-18,115.2,115.6,111,112.3,16211302
2021-06-21,111.5,113.5,110.65,112.65,15093435
2021-06-22,113.6,114.85,113,113.85,12121307
2021-06-23,114.5,114.5,112.7,112.9,5465048
2021-06-24,113,113.6,111.05,111.45,7991737
2021-06-25,111.5,112.4,111.2,111.4,5213142
2021-06-28,111.9,111.95,110.7,110.85,6517463
2021-06-29,110.85,111.9,107.8,108.15,15190047
2021-06-30,108.25,109.9,107.6,107.9,11404351
2021-07-01,107.9,108.95,107.35,107.55,8810812
2021-07-02,107.75,109.75,107.75,108.45,11938563
2021-07-05,109.45,109.45,108.45,108.8,6203719
2021-07-06,108.7,109.4,108.2,108.4,6200880
2021-07-07,107.65,108.4,107.15,107.95,7451336
2021-07-08,107.95,109.1,107.35,107.55,9531909
2021-07-09,107.55,107.6,106.55,107.3,7282932
2021-07-12,107.35,108.3,106.85,107.2,6292486
2021-07-13,107.35,108.1,106.85,107.8,7484958
2021-07-14,107.55,108.15,106.65,107.1,6079860
2021-07-15,107,107.25,106.15,106.3,7634493
2021-07-16,106.05,107.4,105.45,106.1,7862388
2021-07-19,105.75,107.9,105.1,105.95,11688575
2021-07-20,106.1,106.8,104.55,105.6,12829211
2021-07-22,106.5,107,105.2,106.7,10839232
2021-07-23,106.7,107.2,105.45,106,7331144
2021-07-26,106,106.25,104.5,104.65,7291715
2021-07-27,104.75,105.35,103.25,103.95,7727582
2021-07-28,104,104.75,103.1,104,9155891
2021-07-29,104.25,104.5,103.2,103.9,10093200
2021-07-30,104.25,106.3,102.9,103.15,26245260
2021-08-02,104.5,105.85,103.65,105.5,13312605
2021-08-03,106,106.5,105.3,106.15,10106484
2021-08-04,106.5,107.5,104.9,105.3,11584493
2021-08-05,104.5,104.8,102.55,103.95,13497599
2021-08-06,103.95,106.25,103.8,105.9,9202543
2021-08-09,106.2,106.45,103.95,104.4,8306815
2021-08-10,104.9,104.9,101.9,102.25,8212403
2021-08-11,102.8,104.95,102.3,104.65,10858036
2021-08-12,104.65,105.5,103.75,104.1,8961763
2021-08-13,104,105,103.75,104.65,6700217
2021-08-16,104.75,107.45,104.3,107.2,21879419
2021-08-17,107.3,108.25,104.7,105.7,17129194
2021-08-18,106.4,106.5,104.7,106.2,12592530
2021-08-20,105.45,105.5,103,103.5,10490839
2021-08-23,104.9,104.9,102.2,103,6954749
2021-08-24,103.9,106.2,103.65,105.9,11898392
2021-08-25,106.5,106.95,105.4,106.1,7541658
2021-08-26,105.9,106.05,104.7,105.6,7953133
2021-08-27,105.75,106.45,105.3,105.95,5570805
2021-08-30,106.4,108.2,106.1,107.35,12826846
2021-08-31,108,111.3,107.4,110.85,22323605
2021-09-01,111,111.7,109.6,110.75,11800119
2021-09-02,109.8,110.35,109,110.15,11510399
2021-09-03,110.7,113.5,110.1,113.1,15271194
2021-09-06,113.75,113.8,111.25,111.6,7535291
2021-09-07,111.6,112.45,110.7,111.85,7583149
2021-09-08,111.1,112.9,111.1,112.6,8331481
2021-09-09,112.65,114.65,112.4,112.8,13322585
2021-09-13,112.8,114.25,112.5,114,8755616
2021-09-14,114,115.9,114,115.25,9235074
2021-09-15,115.45,116.85,115.2,116.4,12683906
2021-09-16,116.7,119,116.15,118.35,14086068
2021-09-17,118.7,119.45,116.1,118.25,34694650
2021-09-20,116.5,117.7,114.4,114.6,9170924
2021-09-21,114.55,115.65,113.35,115,9380594
2021-09-22,115.05,116.8,115.05,116.45,7834585
2021-09-23,117,118.65,116.8,118,8928265
2021-09-24,118,118.95,116,117.25,7922579
2021-09-27,118.15,118.85,117.5,118.65,9939220
2021-09-28,118.7,123.9,118.7,122.95,20386843
2021-09-29,122.25,128,122,127.45,19848536
2021-09-30,127.45,128.5,124.35,125.3,11997043
2021-10-01,125.65,128.85,125,127.4,13390167
2021-10-04,127.4,127.4,127.4,127.4,1710225
2021-10-04,127.8,128.35,125.5,126.25,7563511
2021-10-05,126.25,130.6,126.25,129.9,20207254
2021-10-06,130.9,134.9,129.35,130.1,25424490
2021-10-07,130.5,132.9,129.85,132.25,12699622
2021-10-08,133.55,134.45,130.85,131.8,9093264
2021-10-11,132.15,133.95,131.2,131.55,6307813
2021-10-12,131.85,132.55,129.3,131.25,9992741
2021-10-13,131.95,132.35,130.3,131.25,9164815
2021-10-14,132,135.5,131,134.4,14040736
2021-10-18,140,140,135.7,136.35,14763816
2021-10-19,136.65,137.25,133.35,133.8,10316614
2021-10-20,133.2,134.3,129.65,130.55,10755221
2021-10-21,132.05,135.5,130.7,131.65,18346637
2021-10-22,132.55,133.65,130,130.7,10917937
2021-10-25,131.6,132.4,128.45,130.45,10037225
2021-10-26,131,132.4,130.05,131.5,10132403
2021-10-27,131.75,133,130.25,130.8,8941463
2021-10-28,130.8,131.4,127.75,128.65,9267487
2021-10-29,128,130,126.45,127.95,8408925
2021-11-01,132.1,132.85,126.6,131.65,17879133
2021-11-02,132.55,133,130.55,130.8,9688784
2021-11-03,130.8,135,130.4,132.55,20760692
2021-11-04,134.95,135,133.55,134.65,3324144
2021-11-08,135,140.9,134.25,140.45,24833133
2021-11-09,141.45,141.5,138.95,139.7,12921755
2021-11-10,139.4,141.3,138.7,139.45,10244603
2021-11-11,134.15,135.6,132.6,133.3,12699644
2021-11-12,134,134.8,132.05,132.95,9503361
2021-11-15,133.25,134.15,132,132.85,5872665
2021-11-16,133.4,133.5,130.65,131,6492595
2021-11-17,130.9,131.4,128.15,128.45,6220901
2021-11-18,128.45,130.25,127.6,129.35,7260896
2021-11-22,129.55,129.9,124.05,124.5,7749576
2021-11-23,124,126.85,123.75,126.15,12297812
2021-11-24,126.7,129.3,126.4,127.6,8101605
2021-11-25,127.6,128,124.5,125.65,6387962
2021-11-26,125.6,125.6,120.5,120.95,7725288
2021-11-29,119.55,120.95,117.85,118.8,10535707
2021-11-30,119,120.9,117.85,118.95,18375929
2021-12-01,119.65,119.95,116.5,117.7,13247777
2021-12-02,118,121.1,117.9,120.65,13790719
2021-12-03,121,122.85,120.75,122.2,9910726
2021-12-06,122.45,123.1,120.5,120.95,6252846
2021-12-07,121.8,123.35,120.25,120.6,9643120
2021-12-08,121.65,122.55,120,120.4,9800225
2021-12-09,121,121.5,119.45,119.7,12864956
2021-12-10,120,121.3,119.6,120.05,13554843
2021-12-13,121,121.3,117.85,118.3,13574697
2021-12-14,119,119.2,117.15,117.9,11614836
2021-12-15,117.7,118.4,115.5,115.7,11957959
2021-12-16,116.7,117.15,115.45,115.75,10633707
2021-12-17,115.95,116,112.35,112.85,11765814
2021-12-20,112,112.5,108.15,108.75,11809254
2021-12-21,109.5,110.3,108.65,109.5,8388306
2021-12-22,110.05,110.05,108.25,109.05,10895989
2021-12-23,109.9,112.45,109.7,112.15,10285091
2021-12-24,113.45,113.5,109.8,110.25,11602146
2021-12-27,110.2,111,109.05,110.75,4459963
2021-12-28,111.25,112.5,111.2,112.3,5650460
2021-12-29,112.4,112.5,111,111.5,4221956
2021-12-30,111.5,111.75,109.9,110.55,5512955
2021-12-31,110.6,112.6,110.6,111.5,5811981
2022-01-03,111.5,113.3,111.35,112.95,6684375
2022-01-04,113.7,114.9,113.25,114.05,5548059
2022-01-05,114.05,117.45,113.8,117.25,14249336
2022-01-06,117.3,117.65,113.05,117.25,7197038
2022-01-07,117.65,119.2,116.95,118.5,7535679
2022-01-10,119,120.15,118.3,119.7,6615734
2022-01-11,120.45,120.45,118.2,118.6,5946036
2022-01-12,119.2,120,118.35,119.15,7165590
2022-01-13,119.65,121.5,118.85,121.15,8373086
2022-01-14,121.5,124.4,121.35,123.3,14954005
2022-01-17,125,125,123.2,123.75,9699015
2022-01-18,124.2,125.55,123.35,123.95,14263853
2022-01-19,123.6,125.6,123,125.1,9913407
2022-01-20,125.1,125.95,124.35,125.5,6671672
2022-01-21,124,125.5,120.75,121.7,9818888
2022-01-24,121,122.45,119.9,120.35,13110559
2022-01-25,120.2,121.7,119.3,121.45,6434320
2022-01-27,120.9,123.75,119.8,122.7,8593559
2022-01-28,123.3,127.05,123.3,124.1,9996713
2022-01-31,126.7,128,124.2,125.2,13191388
2022-02-01,126,126,119.5,121.75,23085078
2022-02-02,122.5,124.95,122.2,124.45,9832796
2022-02-03,125.4,125.85,124.15,124.65,8744759
2022-02-04,124.9,125.35,123.7,124.15,7149068
2022-02-07,124.5,124.6,122.5,122.9,8968249
2022-02-08,123.1,123.55,120,121.35,15697108
2022-02-09,118.5,121.7,117.75,121.05,11720982
2022-02-10,121.1,121.45,119.65,119.95,12080112
2022-02-11,119.5,122.65,119.05,122.05,17657900
2022-02-14,121,121,116.15,116.55,10975847
2022-02-15,117,119,114.5,118.75,8652149
2022-02-16,119.25,122.2,119.25,121.5,11782127
2022-02-17,122.85,123.95,120.5,121.4,11183068
2022-02-18,121.4,122.3,120.6,121.15,5319044
2022-02-21,120,121.15,118.6,119.2,5730295
2022-02-22,117,118.65,116.5,117.1,7606407
2022-02-23,117.8,118.3,116.5,117.15,5683477
2022-02-24,114.95,116.2,109.3,110,13232094
2022-02-25,113,118.5,111,112.35,18699142
2022-02-28,112.8,116.2,110.6,115,16521199
2022-03-02,113.75,116.4,111.45,112.25,14926831
2022-03-03,115,116.5,113,114.65,18861056
2022-03-04,114.95,115.4,112.8,113.25,16670574
2022-03-07,113.95,113.95,111.2,112.25,16928369
2022-03-08,112,117.75,111.6,117.05,22322573
2022-03-09,118.9,118.9,115.8,116.95,15650703
2022-03-10,119.05,121.4,117.7,120.95,18394923
2022-03-11,120.8,124.4,120.4,123.7,12398829
2022-03-14,124.85,124.85,120.05,120.8,14878543
2022-03-15,120.8,121.05,118.2,119,11001228
2022-03-16,120.3,122.6,119.45,121.95,10117835
2022-03-17,122.4,122.9,120.1,121.35,27800074
2022-03-21,121.8,121.8,117.8,118,12111014
2022-03-22,119,121.85,118.5,120.65,20619526
2022-03-23,121.85,123,120.65,121.7,16847442
2022-03-24,121.8,122.15,120.35,120.6,8251754
2022-03-25,120.05,120.85,118.6,118.8,8158981
2022-03-28,119.4,120.7,117.7,119.95,10228584
2022-03-29,120.3,121.3,118,118.3,9751383
2022-03-30,119.7,119.7,116.1,117.2,106426898
2022-03-31,118,120.95,118,118.95,21134412
2022-04-01,119.1,122.45,119,122.1,10701784
2022-04-04,122.1,123,121.7,122.3,9396800
2022-04-05,122.8,123.5,122.35,122.65,8714130
2022-04-06,122.45,126.4,121.5,126.05,15720227
2022-04-07,124.3,126.75,123.25,123.55,20159190
2022-04-08,124.9,127.5,124.05,126.95,14466488
2022-04-11,126.9,129.45,126.6,128.85,12758301
2022-04-12,128.45,128.8,125.2,126.05,9722449
2022-04-13,126.05,129,125.65,127.9,11783874
2022-04-18,127.7,128.5,126.5,128.1,11647900
2022-04-19,129.3,133,128.5,130.3,20122110
2022-04-20,131,134.3,130.65,133.4,19126711
2022-04-21,134.45,135.4,133.4,135.05,14769541
2022-04-22,134.9,136.05,133.85,134.35,9118742
2022-04-25,132.8,132.95,127.4,127.75,11069540
2022-04-26,129.4,130,127.75,129.05,9422276
2022-04-27,127.6,129,125.1,127.35,9978492
2022-04-28,129.5,130.25,127.6,129.95,10515726
2022-04-29,131.4,131.4,125.6,126,8675536
2022-05-02,125.95,127.3,124,126.65,5749158
2022-05-04,126.85,128.7,125.1,125.85,5412290
2022-05-05,127,128.15,125.2,125.7,5343427
2022-05-06,125,127.75,122.6,126.25,9120449
2022-05-09,125.65,125.65,121.35,124,8241164
2022-05-10,124.4,126.3,121.25,122,10375582
2022-05-11,123.4,124.4,118.85,120.45,9743582
2022-05-12,120.45,124,119.55,122.1,20411762
2022-05-13,125,125.25,120.7,121.3,15067646
2022-05-16,124,124,120.65,122.1,8377926
2022-05-17,126,126,121.6,124.4,18261022
2022-05-18,124,124.4,117.75,118.05,43268313
2022-05-19,117,118.4,115.5,117.25,14576700
2022-05-20,119,119.2,116.15,116.95,16158630
2022-05-23,117.6,118.6,116.7,117.7,11658604
2022-05-24,117.7,119.6,117.2,118.7,12302782
2022-05-25,119.3,119.45,114.2,114.8,11544857
2022-05-26,115,115.8,111.85,114.2,15855279
2022-05-27,115.4,115.55,113.15,114.15,7744647
2022-05-30,115.25,116.25,114.05,116.1,8148419
2022-05-31,115.7,117.5,115.5,116,13283897
2022-06-01,117,119.05,116.75,118.2,11124014
2022-06-02,118.85,119.25,116,117.65,10849768
2022-06-03,118.05,119,117.85,118.3,9043106
2022-06-06,118.3,118.6,116.45,117.55,8108561
2022-06-07,117.35,119.5,116.65,118.2,9867341
2022-06-08,118.65,119.15,117.65,118,8635359
2022-06-09,118,120.7,116.9,118.3,21408262
2022-06-10,117.9,118,116.5,117.25,10782311
2022-06-13,116.3,116.3,113.05,113.6,10082086
2022-06-14,113.55,114,110.05,110.25,15682933
2022-06-15,111,111,108.3,109.2,9591153
2022-06-16,110.55,110.7,107.5,108.15,9931675
2022-06-17,108,108,103.55,104.2,15767609
2022-06-20,105.1,105.45,101.55,103.05,12775588
2022-06-21,104.05,106.25,103.55,105.75,9446372
2022-06-22,105.95,106.6,103.6,105.55,12427782
2022-06-23,106,107.6,105.15,107.3,11052835
2022-06-24,107.6,108.65,107.3,108.5,7871986
2022-06-27,110,110.85,108.8,109.55,11887157
2022-06-28,109.5,110.65,107.55,108.3,15087448
2022-06-29,108.6,110.05,108,109.8,12602600
2022-06-30,73.95,76,73.7,74.25,34424950
2022-07-01,75,75.15,72.85,74.55,22029311
2022-07-04,74.7,74.7,73.3,74.35,12798384
2022-07-05,74.5,74.5,73.4,73.6,17464685
2022-07-06,74,74.6,72.25,72.6,21856830
2022-07-07,73.3,73.3,72.15,72.7,17846046
2022-07-08,73,73.25,72.2,72.7,11692575
2022-07-11,72.7,72.85,72.05,72.55,11548617
2022-07-12,72.45,72.5,70.4,70.65,16729806
2022-07-13,70.65,70.95,70.25,70.4,13704386
2022-07-14,70.4,71,70.2,70.75,8917897
2022-07-15,70.7,71.1,70,70.35,7310057
2022-07-18,70.7,71.25,70.35,71.15,6697658
2022-07-19,71.25,72.15,71.00,72.00,7585011
2022-07-20,73.00,73.10,72.20,72.35,10590222
2022-07-21,72.35,72.75,71.35,72.55,9537111
2022-07-22,72.90,72.95,72.00,72.15,8740051

OUTPUT GRAPH (Image):

Conclusion:

The above analysis can be used to understand a stock’s short-term and long-term behavior. A decision support system can be created to pick stock from industry and understand trend.