Hi, I find the time stamp of the candles wrong or should I say inconsistent with the rest of the data, for the hourly data on the following dates, given below. For the year 2015, Month Jan, the dates 22, 23, 27,28,29,30 show the timing of hourly candles as 10:00, 11:00, 12:00, instead of 9:15, 10:15, 11:15 same problem with almost all months of 2015, some days of data in July and Aug of 2016 has times beyond 15:30,
I hope you can correct this data, as this presents a problem in building candles of higher order, (2 and 4 hours) Thanks.
Thanks for the reply. The ones I got in my db for hourly candles , for nifty50 are these below which show times beyond 1530, though some of these are muhurat trading. But there are many which shouldn't be there. Because i stopped downloading as soon as i found these errors , i am not sure if these are the only ones. Below this list is another kind of error in 15 min candles, where the minutes are not multiples of 15.
Again, below are hourly candles, again with the problem of the minutes ending in between hours, "session" "time" "20150421" "1946" "20150629" "1154" "20150702" "1228" "20150720" "1117" "20150720" "1217" "20150720" "1317" "20150720" "1417" "20150720" "1517" "20150813" "923" "20151111" "1609" "20151111" "1631" "20151111" "1731" "20151111" "1831" "20170111" "956" "20170221" "1327" "20170222" "1138" "20170515" "931" "20170628" "1002"
I only downloaded 60 min candles to make 2 hour and 4 hour candles, but after seeing these errors, i am making higher order candles from 1 min , there may also be errors in other time frames like 5 mins, 10 mins.
hi @sujith, found some more errors, these are hourly candles with wrong time, and possibly wrong data. Could you please confirm if these indeed are errors in current data, and you are in the process of correcting them.
Please note, fetching the 1-min data just to build hourly candles is not very efficient, especially when the hourly candles are readily available.
Any updates @sujith ..? I downloaded nifty index hourly data to check , it still shows errors, Been waiting for this for two weeks now, can you give a probable date, some kind of status,
Hi @yousuf, We have reported this issue to data team and they are working on the feasible solution for this. In the meanwhile, you can add logic to your algorithm to ignore these candles.
Hi @sujith , I took the below given sample of equities (very liquid) , 197 in total and downloaded just the hourly candles from 2015 or latter from where ever they are available. The total number of wrong candles (wrong data), only in the hourly timeframe is 18,368. (eighteen thousand+) ! (+-20 for muhurat trading, didn't account for these.)
Hourly data of just 197 equities from 2015 to 2017 contains 18368 errors. (+-20) (The file with all errors is attached.) --------------
Errors on Nov 13th, 2017 (yesterday) , for this 197-equity sample, only in the hourly candles,
following are the errors on 10th of Nov, 2017 symbol,session,time,open,high,low,close,vol AJANTPHARM,20171110,1313,1211.45,1216.45,1201.00,1203.85,9542 BERGEPAINT,20171110,1213,252.00,252.10,250.00,251.45,39708 CONCOR,20171110,1313,1346.35,1350.00,1344.40,1346.00,42847 DALMIABHA,20171110,1008,2940.10,2970.70,2940.10,2970.30,5524 DALMIABHA,20171110,1100,2970.30,2983.15,2915.05,2932.00,11252 DALMIABHA,20171110,1200,2932.00,2932.70,2900.05,2927.60,8594 GODFRYPHLP,20171110,1401,1031.50,1051.25,1030.00,1045.00,106153 MRPL,20171110,1310,127.30,127.30,125.80,126.55,121314 OFSS,20171110,1003,3635.30,3728.00,3526.90,3720.10,40408 REPCOHOME,20171110,1001,571.00,591.90,569.00,588.30,68643 REPCOHOME,20171110,1410,587.05,588.70,582.65,586.40,16647 RNAVAL,20171110,1200,50.10,50.20,50.10,50.10,28875 RNAVAL,20171110,1302,50.10,50.30,50.00,50.00,77925 RNAVAL,20171110,1400,50.00,50.15,49.70,50.10,112234 TORNTPHARM,20171110,1310,1225.00,1228.90,1222.20,1225.40,9489
Every date as you go back has errors.
@sujith, I cannot code to ignore wrong candles as you suggest, apart from introducing errors myself, I would be making my testing effort meaningless. And the other point is, there are just 7 hourly candles per day, how can the program ignore 3 out of 7 candles for a day in technical analysis? (in the case of OFSS) ? and , this is just a sample of 197 equities , mostly very liquid instruments, extrapolate to 6000+ intruments and timeframes of 3, 5, 10, 15 minutes, and you can see the scale of the problem. Errors will total up to lakhs, present on almost every trading day. now, How can you draw the hourly trendline, and calculate moving averages?,
This is to show nothing has been resolved, and the data is corrupt and unusable.
Thank you for notifying. We will look into this.
Can you give the exact date for issue wherein in candles beyond 15:30 exists?
Thanks for the reply.
The ones I got in my db for hourly candles , for nifty50 are these below which show times beyond 1530, though some of these are muhurat trading. But there are many which shouldn't be there. Because i stopped downloading as soon as i found these errors , i am not sure if these are the only ones. Below this list is another kind of error in 15 min candles, where the minutes are not multiples of 15.
date(yyyymmdd) time
20150128 1600
20150130 1600
20150202 1600
20150204 1600
20150205 1600
20150206 1600
20150209 1600
20150210 1600
20150211 1600
20150212 1600
20150213 1600
20150216 1600
20150218 1600
20150219 1600
20150220 1600
20150223 1600
20150224 1600
20150225 1600
20150226 1600
20150227 1600
20150228 1600
20150302 1600
20150303 1600
20150304 1600
20150305 1600
20150309 1600
20150310 1600
20150311 1600
20150312 1600
20150313 1600
20150316 1600
20150317 1600
20150318 1600
20150319 1600
20150320 1600
20150323 1600
20150324 1600
20150325 1600
20150326 1600
20150327 1600
20150330 1600
20150331 1600
20150401 1600
20150421 1946
20150508 1740
20151111 1609
20151111 1631
20151111 1730
20151111 1731
20151111 1735
20151111 1831
20160713 1615
20160714 1615
20160715 1615
20160718 1615
20160718 1715
20160719 1615
20160720 1615
20160721 1615
20160722 1615
20160725 1615
20160726 1615
20160727 1615
20160728 1615
20160729 1615
20160801 1615
20160801 1715
20160802 1615
20160803 1615
20160804 1615
20160804 1715
20160805 1615
20160805 1715
20160805 1815
20160808 1615
20160809 1615
20160810 1615
20160811 1615
20160812 1615
20160816 1615
20160816 1715
20160817 1615
20160818 1615
20160819 1615
20160822 1615
20160822 1715
20160823 1615
20160824 1615
20160824 1715
20160825 1615
20160825 1715
20160825 1815
20160826 1615
20160826 1715
20160829 1615
20160830 1615
20160831 1615
20160901 1615
20160902 1615
20160906 1615
20160907 1615
20160908 1615
20160909 1615
20160909 1715
20160912 1615
20160912 1715
20160914 1615
20160914 1715
20160915 1615
20160916 1615
20160919 1615
20160920 1615
20160921 1615
20160922 1615
20160923 1615
20160926 1615
20160927 1615
20160928 1615
20160928 1715
20160929 1615
20160929 1715
20160930 1615
20161030 1830
20171019 1830
==============================
These are errors in the 15 mins candles, the timing is not a multiple of 15. (this is for nifty50)
"date" "time"
"20150119" "926"
"20150119" "941"
"20150119" "956"
"20150119" "1011"
"20150119" "1026"
"20150119" "1041"
"20150119" "1056"
"20150119" "1111"
"20150119" "1126"
"20150119" "1141"
"20150119" "1156"
"20150119" "1211"
"20150119" "1226"
"20150119" "1241"
"20150119" "1256"
"20150119" "1311"
"20150119" "1326"
"20150119" "1341"
"20150119" "1356"
"20150119" "1411"
"20150119" "1426"
"20150119" "1441"
"20150119" "1456"
"20150119" "1511"
"20150119" "1526"
"20150824" "949"
"20150824" "1004"
"20150824" "1019"
"20150824" "1034"
"20150824" "1049"
"20150824" "1104"
"20150824" "1119"
"20150824" "1134"
"20150824" "1149"
"20150824" "1204"
"20150824" "1219"
"20150824" "1234"
"20150824" "1249"
"20150824" "1304"
"20150824" "1319"
"20150824" "1334"
"20150824" "1349"
"20150824" "1404"
"20150824" "1419"
"20150824" "1434"
"20150824" "1449"
"20150824" "1504"
"20150824" "1519"
"20150902" "953"
"20150902" "1008"
"20150902" "1023"
"20150902" "1038"
"20150902" "1053"
"20150902" "1108"
"20150902" "1123"
"20150902" "1138"
"20150902" "1153"
"20150902" "1208"
"20150902" "1223"
"20150902" "1238"
"20150902" "1253"
"20150902" "1308"
"20150902" "1323"
"20150902" "1338"
"20150902" "1353"
"20150902" "1408"
"20150902" "1423"
"20150902" "1438"
"20150902" "1453"
"20150902" "1508"
"20150902" "1523"
"20150907" "1338"
"20150907" "1353"
"20150907" "1408"
"20150907" "1423"
"20150907" "1438"
"20150907" "1453"
"20150907" "1508"
"20150907" "1523"
"20150916" "1446"
"20150916" "1501"
"20150916" "1516"
"20150918" "1046"
"20150918" "1101"
"20150918" "1116"
"20150918" "1131"
"20150918" "1146"
"20150918" "1201"
"20150918" "1216"
"20150918" "1231"
"20150918" "1246"
"20150918" "1301"
"20150918" "1316"
"20150918" "1331"
"20150918" "1346"
"20150918" "1401"
"20150918" "1416"
"20150918" "1431"
"20150918" "1446"
"20150918" "1501"
"20150918" "1516"
"20150923" "1347"
"20150923" "1402"
"20150923" "1417"
"20150923" "1432"
"20150923" "1447"
"20150923" "1502"
"20150923" "1517"
"20151111" "1748"
"20151111" "1803"
"20151111" "1818"
"20151111" "1833"
"20151222" "1048"
"20151222" "1103"
"20151222" "1118"
"20151222" "1133"
"20151222" "1148"
"20151222" "1203"
"20151222" "1218"
"20151222" "1233"
"20151222" "1248"
"20151222" "1303"
"20151222" "1318"
"20151222" "1333"
"20151222" "1348"
"20151222" "1403"
"20151222" "1418"
"20151222" "1433"
"20151222" "1448"
"20151222" "1503"
"20151222" "1518"
Again, below are hourly candles, again with the problem of the minutes ending in between hours,
"session" "time"
"20150421" "1946"
"20150629" "1154"
"20150702" "1228"
"20150720" "1117"
"20150720" "1217"
"20150720" "1317"
"20150720" "1417"
"20150720" "1517"
"20150813" "923"
"20151111" "1609"
"20151111" "1631"
"20151111" "1731"
"20151111" "1831"
"20170111" "956"
"20170221" "1327"
"20170222" "1138"
"20170515" "931"
"20170628" "1002"
I only downloaded 60 min candles to make 2 hour and 4 hour candles, but after seeing these errors, i am making higher order candles from 1 min , there may also be errors in other time frames like 5 mins, 10 mins.
thanks again.
Please confirm when these errors are corrected.
Thanks.
found some more errors, these are hourly candles with wrong time, and possibly wrong data.
Could you please confirm if these indeed are errors in current data, and you are in the process of correcting them.
Please note, fetching the 1-min data just to build hourly candles is not very efficient, especially when the hourly candles are readily available.
symbol; date(yyyymmdd); time(HHmm); open; high; low; close; vol
banknifty; 20150604; 1000; 17634.35; 17688.45; 17627.45; 17688.45; 0
banknifty; 20150629; 1154; 17882.95; 17894.25; 17866.20; 17876.75; 0
banknifty; 20150702; 1228; 18564.15; 18639.45; 18559.00; 18598.25; 0
banknifty; 20150720; 1117; 18970.50; 18990.85; 18871.15; 18892.90; 0
banknifty; 20150720; 1217; 18892.90; 18904.10; 18852.70; 18884.55; 0
banknifty; 20150720; 1317; 18884.55; 18950.70; 18866.70; 18940.45; 0
banknifty; 20150720; 1417; 18940.45; 19083.60; 18937.60; 19024.00; 0
banknifty; 20150720; 1517; 19024.00; 19035.00; 19016.50; 19032.70; 0
banknifty; 20150813; 923; 18314.00; 18341.90; 18218.35; 18220.45; 0
banknifty; 20170111; 956; 18598.05; 18619.55; 18573.20; 18616.45; 0
banknifty; 20170221; 1326; 20670.75; 20736.55; 20661.90; 20729.45; 0
banknifty; 20170222; 1137; 20917.10; 20958.25; 20915.10; 20916.30; 0
banknifty; 20170628; 1002; 23173.85; 23287.80; 23165.65; 23262.35; 0
nifty50; 20150604; 1000; 8119.15; 8137.15; 8116.10; 8137.00; 0
nifty50; 20150629; 1154; 8217.55; 8220.15; 8209.20; 8214.70; 0
nifty50; 20150702; 1228; 8455.60; 8473.80; 8453.15; 8456.95; 0
nifty50; 20150720; 1117; 8578.60; 8584.00; 8559.10; 8566.35; 0
nifty50; 20150720; 1217; 8566.30; 8572.45; 8561.35; 8568.25; 0
nifty50; 20150720; 1317; 8568.15; 8588.65; 8561.45; 8586.05; 0
nifty50; 20150720; 1417; 8586.30; 8623.65; 8585.70; 8598.10; 0
nifty50; 20150720; 1517; 8598.40; 8603.45; 8596.45; 8603.45; 0
nifty50; 20150813; 923; 8414.40; 8423.85; 8388.35; 8390.45; 0
nifty50; 20170111; 956; 8345.05; 8345.20; 8336.00; 8338.10; 0
nifty50; 20170221; 1327; 8866.60; 8881.20; 8864.95; 8880.10; 0
nifty50; 20170222; 1138; 8940.35; 8954.35; 8937.95; 8948.45; 0
nifty50; 20170515; 931; 9431.65; 9439.05; 9423.80; 9437.45; 0
nifty50; 20170628; 1002; 9490.40; 9516.05; 9487.45; 9504.80; 0
niftyit; 20150604; 1000; 11403.30; 11421.05; 11400.10; 11412.35; 0
niftyit; 20150629; 1154; 11083.90; 11085.95; 11040.65; 11061.40; 0
niftyit; 20150702; 1228; 11209.80; 11235.55; 11203.45; 11203.45; 0
niftyit; 20150720; 1117; 11234.80; 11271.05; 11234.35; 11261.40; 0
niftyit; 20150720; 1217; 11262.55; 11281.25; 11253.05; 11272.05; 0
niftyit; 20150720; 1317; 11272.05; 11298.35; 11249.10; 11291.90; 0
niftyit; 20150720; 1417; 11291.90; 11307.90; 11256.45; 11256.60; 0
niftyit; 20150720; 1517; 11256.60; 11266.95; 11245.90; 11266.95; 0
niftyit; 20150813; 923; 11985.85; 12086.85; 11978.60; 12061.80; 0
niftyit; 20170111; 953; 10205.90; 10220.65; 10201.00; 10204.40; 0
niftyit; 20170221; 1326; 10671.20; 10680.10; 10644.70; 10670.75; 0
niftyit; 20170222; 1137; 10598.30; 10607.75; 10588.05; 10595.20; 0
niftyit; 20170515; 931; 10321.10; 10341.00; 10304.75; 10328.90; 0
niftyit; 20170628; 1002; 10072.30; 10115.35; 10071.05; 10086.20; 0
niftymidcap50; 20150604; 1000; 3172.30; 3196.10; 3172.05; 3196.10; 0
niftymidcap50; 20150629; 1154; 3155.60; 3155.90; 3144.70; 3145.95; 0
niftymidcap50; 20150702; 1228; 3294.60; 3305.30; 3294.20; 3298.45; 0
niftymidcap50; 20150720; 1117; 3441.45; 3444.90; 3437.10; 3441.75; 0
niftymidcap50; 20150720; 1217; 3442.20; 3443.80; 3434.90; 3439.20; 0
niftymidcap50; 20150720; 1317; 3439.20; 3446.90; 3436.65; 3445.90; 0
niftymidcap50; 20150720; 1417; 3445.90; 3453.60; 3445.65; 3445.85; 0
niftymidcap50; 20150720; 1517; 3445.85; 3450.80; 3445.80; 3448.90; 0
niftymidcap50; 20150813; 923; 3403.60; 3407.45; 3368.10; 3368.10; 0
niftymidcap50; 20170111; 956; 3830.10; 3830.30; 3818.70; 3820.10; 0
niftymidcap50; 20170221; 1327; 4169.15; 4177.85; 4168.45; 4175.50; 0
niftymidcap50; 20170222; 1138; 4185.80; 4191.85; 4182.35; 4182.35; 0
niftymidcap50; 20170628; 1002; 4434.35; 4474.80; 4433.15; 4465.40; 0
Been waiting for this for two weeks now, can you give a probable date, some kind of status,
symbol,date,time,open,high,low,close,vol (time doesn't align with the hour)
nifty50,20150629,1154,8217.55,8220.15,8209.20,8214.70,0
nifty50,20150702,1228,8455.60,8473.80,8453.15,8456.95,0
nifty50,20150720,1117,8578.60,8584.00,8559.10,8566.35,0
nifty50,20150720,1217,8566.30,8572.45,8561.35,8568.25,0
nifty50,20150720,1317,8568.15,8588.65,8561.45,8586.05,0
nifty50,20150720,1417,8586.30,8623.65,8585.70,8598.10,0
nifty50,20150720,1517,8598.40,8603.45,8596.45,8603.45,0
nifty50,20150813,923,8414.40,8423.85,8388.35,8390.45,0
nifty50,20151111,1609,7783.35,7783.35,7783.35,7783.35,0
nifty50,20151111,1631,7783.35,7833.35,7748.80,7831.90,0
nifty50,20151111,1731,7832.70,7846.30,7829.65,7845.80,0
nifty50,20151111,1831,7822.70,7830.20,7819.55,7825.00,0
nifty50,20170111,953,8342.70,8345.25,8336.00,8338.10,0
nifty50,20170221,1326,8866.55,8881.20,8864.95,8880.10,0
We have reported this issue to data team and they are working on the feasible solution for this.
In the meanwhile, you can add logic to your algorithm to ignore these candles.
This should be resolved now. Can you check and let us know if you are still facing issues?
Hi @sujith ,
I took the below given sample of equities (very liquid) , 197 in total and downloaded just the hourly candles from 2015 or latter from where ever they are available.
The total number of wrong candles (wrong data), only in the hourly timeframe is 18,368. (eighteen thousand+) ! (+-20 for muhurat trading, didn't account for these.)
Hourly data of just 197 equities from 2015 to 2017 contains 18368 errors. (+-20)
(The file with all errors is attached.)
--------------
Errors on Nov 13th, 2017 (yesterday) , for this 197-equity sample,
only in the hourly candles,
symbol,date,time,open,high,low,close,vol
DALMIABHA,20171113,1012,2926.95,2953.00,2924.00,2944.75,8650
GMRINFRA,20171113,1401,17.65,18.15,17.65,17.80,4834968
INFIBEAM,20171113,1201,180.05,181.50,178.50,180.10,841848
MARICO,20171113,1107,309.95,310.00,308.80,309.85,142176
MARICO,20171113,1201,309.85,310.05,309.45,309.45,40377
MINDTREE,20171113,1305,500.10,506.50,499.85,505.70,180915
NESTLEIND,20171113,1301,7773.00,7775.90,7725.00,7734.00,1441
NHPC,20171113,1103,28.00,28.00,27.85,27.90,635605
NIITTECH,20171113,1110,630.50,631.15,625.50,629.20,41364
OFSS,20171113,1104,3633.90,3670.55,3625.00,3648.65,1940
OFSS,20171113,1300,3644.00,3659.00,3632.20,3651.35,1353
OFSS,20171113,1403,3651.75,3658.45,3632.00,3640.05,1157
OIL,20171113,1301,358.70,358.70,354.30,356.25,72134
RAMCOCEM,20171113,1100,695.00,699.00,695.00,695.00,16436
RNAVAL,20171113,1205,48.35,48.65,48.35,48.65,100025
RNAVAL,20171113,1308,48.60,48.65,48.25,48.40,66462
SIEMENS,20171113,1301,1207.90,1209.95,1203.35,1207.60,3851
following are the errors on 10th of Nov, 2017
symbol,session,time,open,high,low,close,vol
AJANTPHARM,20171110,1313,1211.45,1216.45,1201.00,1203.85,9542
BERGEPAINT,20171110,1213,252.00,252.10,250.00,251.45,39708
CONCOR,20171110,1313,1346.35,1350.00,1344.40,1346.00,42847
DALMIABHA,20171110,1008,2940.10,2970.70,2940.10,2970.30,5524
DALMIABHA,20171110,1100,2970.30,2983.15,2915.05,2932.00,11252
DALMIABHA,20171110,1200,2932.00,2932.70,2900.05,2927.60,8594
GODFRYPHLP,20171110,1401,1031.50,1051.25,1030.00,1045.00,106153
MRPL,20171110,1310,127.30,127.30,125.80,126.55,121314
OFSS,20171110,1003,3635.30,3728.00,3526.90,3720.10,40408
REPCOHOME,20171110,1001,571.00,591.90,569.00,588.30,68643
REPCOHOME,20171110,1410,587.05,588.70,582.65,586.40,16647
RNAVAL,20171110,1200,50.10,50.20,50.10,50.10,28875
RNAVAL,20171110,1302,50.10,50.30,50.00,50.00,77925
RNAVAL,20171110,1400,50.00,50.15,49.70,50.10,112234
TORNTPHARM,20171110,1310,1225.00,1228.90,1222.20,1225.40,9489
Every date as you go back has errors.
@sujith, I cannot code to ignore wrong candles as you suggest, apart from introducing errors myself, I would be making my testing effort meaningless.
And the other point is, there are just 7 hourly candles per day, how can the program ignore 3 out of 7 candles for a day in technical analysis? (in the case of OFSS) ?
and , this is just a sample of 197 equities , mostly very liquid instruments, extrapolate to 6000+ intruments and timeframes of 3, 5, 10, 15 minutes,
and you can see the scale of the problem. Errors will total up to lakhs, present on almost every trading day.
now, How can you draw the hourly trendline, and calculate moving averages?,
This is to show nothing has been resolved, and the data is corrupt and unusable.
The sample of equities I used, symbol:token format
--------------------------------------------------------------------------------
{"ADANIPORTS;3861249", "ENGINERSIN;1256193", "ICICIPRULI;4774913", "IGL;2883073",
"JETAIRWAYS;2997505", "JSWENERGY;4574465", "GAIL;1207553", "RELIANCE;738561", "TATAELXSI;873217",
"RELINFRA;141569", "REPCOHOME;7577089", "SAIL;758529", "INDUSINDBK;1346049", "JSWSTEEL;3001089",
"RAMCOCEM;523009", "TATAPOWER;877057", "STAR;1887745", "DLF;3771393", "FEDERALBNK;261889",
"RBLBANK;4708097", "SOUTHBANK;1522689", "TATAGLOBAL;878593", "DABUR;197633", "BALRAMCHIN;87297",
"BIOCON;2911489", "HINDPETRO;359937", "PETRONET;2905857", "SIEMENS;806401", "RPOWER;3906305",
"GRASIM;315393", "CESC;160769", "TATAMTRDVR;4343041", "RECLTD;3930881", "TITAN;897537", "SHREECEM;794369",
"MGL;4488705", "ITC;424961", "PAGEIND;3689729", "SUZLON;3076609", "TATACHEM;871681", "SUNTV;3431425",
"SYNDIBANK;1837825", "PIDILITIND;681985", "PVR;3365633", "PNB;2730497", "POWERGRID;3834113",
"BAJAJ_AUTO;4267265", "BEML;101121", "DALMIABHA;5444865", "DHFL;215553", "TATACOMM;952577", "LUPIN;2672641",
"PTC;2906881", "RCOM;3375873", "EXIDEIND;173057", "IDFC;3060993", "SUNPHARMA;857857", "SRF;837889",
"OFSS;2748929", "GSFC;319233", "TATAMOTORS;884737", "TECHM;3465729", "BAJFINANCE;81153",
"BAJAJFINSV;4268801", "MANAPPURAM;4879617", "MCDOWELL_N;2674433", "MFSL;548353", "BHEL;112129",
"MOTHERSUMI;1076225", "COALINDIA;5215745", "DCBBANK;3513601", "MUTHOOTFIN;6054401", "HDIL;3789569",
"BOSCHLTD;558337", "DISHTV;3721473", "NESTLEIND;4598529", "NHPC;4454401", "NIITTECH;2955009",
"INDIGO;2865921", "NTPC;2977281", "OIL;4464129", "INDIACEM;387841", "ORIENTBANK;636673", "MCX;7982337",
"MRPL;584449", "NATIONALUM;1629185", "ANDHRABANK;2524673", "PCJEWELLER;7455745", "PEL;617473",
"PFC;3660545", "MRF;582913", "GODREJCP;2585345", "TORNTPHARM;900609", "ONGC;633601", "HCLTECH;1850625",
"NMDC;3924993", "RELCAPITAL;737793", "TCS;2953217", "INDIANB;3663105", "NBCC;8042241", "TATASTEEL;895745",
"BPCL;134657", "CEATLTD;3905025", "GMRINFRA;3463169", "MINDTREE;3675137", "AJANTPHARM;2079745",
"ALBK;2760193", "APOLLOTYRE;41729", "AMARAJABAT;25601", "AMBUJACEM;325121", "AUROPHARMA;70401",
"ARVIND;49409", "ASHOKLEY;54273", "ASIANPAINT;60417", "AXISBANK;1510401", "BATAINDIA;94977",
"BERGEPAINT;103425", "BHARTIARTL;2714625", "BANKINDIA;1214721", "BHARATFORG;108033", "CAPF;3903745",
"CASTROLIND;320001", "CANBK;2763265", "CADILAHC;2029825", "COLPAL;3876097", "CENTURYTEX;160001",
"CGPOWER;194561", "DIVISLAB;2800641", "EQUITAS;4314113", "HAVELLS;2513665", "HINDALCO;348929",
"GLENMARK;1895937", "IBREALEST;3699201", "IBULHSGFIN;7712001", "HCC;352001", "HDFCBANK;341249",
"HEROMOTOCO;345089", "HEXAWARE;2747905", "HINDZINC;364545", "ADANIPOWER;4451329", "SBIN;779521",
"RNAVAL;4465665", "ICICIBANK;1270529", "IDFCBANK;2863105", "IDBI;377857", "ICIL;3068673", "IDEA;3677697",
"IFCI;381697", "INFRATEL;7458561", "INFY;408065", "INFIBEAM;4159745", "IOC;415745", "IRB;3920129",
"JINDALSTEL;1723649", "JISLJALEQS;2661633", "JPASSOCIAT;2933761", "JUSTDIAL;7670273", "JUBLFOOD;4632577",
"KAJARIACER;462849", "KOTAKBANK;492033", "KPIT;1790465", "KSCL;3832833", "KTKBANK;2061825",
"LICHSGFIN;511233", "LT;2939649", "M_MFIN;3400961", "M_M;519937", "MARICO;1041153", "MARUTI;2815745",
"SRTRANSFIN;1102337", "ACC;5633", "APOLLOHOSP;40193", "BANKBARODA;1195009", "BRITANNIA;140033",
"CANFINHOME;149249", "BEL;98049", "BHARATFIN;4995329", "CIPLA;177665", "CUMMINSIND;486657",
"CHENNPETRO;524545", "CHOLAFIN;175361", "CONCOR;1215745", "DRREDDY;225537", "FORTIS;3735553",
"ESCORTS;245249", "GODREJIND;2796801", "GRANULES;3039233", "HINDUNILVR;356865", "HDFC;340481", "NCC;593665",
"RAYMOND;731905", "GODFRYPHLP;302337", "EICHERMOT;232961", "ADANIENT;6401", "SREINFRA;836353",
"BALKRISIND;85761", "L_TFH;6386689" };