IndianStocksR - An R package to download Indian Stock EOD data

Gurudev Ilangovan

July 29, 2018


Introduction

The IndianStocksR package is used to download the end of day data of all stocks in the two primary Indian stock markets, NSE and BSE. The end of data data is provided free by the two stock exchanges from their websites and consists of information like the open, high, low, close among others for each script that’s traded in them.

The data can be accessed from their websites based on the date formatted in a certain way. The R-Bloggers article was the source of inspiration for the package. However, the package modularizes the code, tweaks a lot of things and creates a much more accessible API that’s more powerful in the sense that it abstracts away the complexity from the user. You can find the github repo of the project here.

It is advised to create a folder and set the working directory to that folder before we start work. Even better, if you’re working from R studio is to create an R project for downloading the data and working on your analysis.

The package is currently getting submitted to CRAN after which a simple install.packages("IndianStocksR") will get it installed. But for now, it is available on github.

install.packages("devtools")
devtools::install_github("ilangurudev/IndianStocksR")

After installation, we load the package. The package basically creates data frames and hence plays along well with the concepts of tidy data and the tidyverse. So it is highly encouraged to load that package as well

library(IndianStocksR)
library(tidyverse)


Main Functions

download_stocks

The workhorse of the package is the function download_stocks. However, you will rarely have to use it. It still pays to understand the parameters as it is the basis of the other functions that you will probably use.

download_stocks(date = "2018-07-20", exchange = c("nse", "bse"), dest_path = "./data", quiet = FALSE)
## Downloading from 'nse' as exchange not clearly specified.
## Dowloaded stocks data from NSE on 20 JUL 2018
  • The date parameter can be a date object (and defaults to today). It can also be a string (yyyy-mm-dd) or a number that can be parsed as a date by lubridate::as_date(). For instance, "2018-05-21" is a valid date.
  • The exchange can either be “nse” or “bse”.
  • The dest_path specifies where you want the data files to get downloaded. It defaults to the data folder in the current working directory (which it will create if not found). This is why it is advisable to work in a project. This keeps all the data files of a project organized. If the path you specify is not found, an error is thrown.
  • The quiet parameter controls whether you want the download status messages or not.

The main purpose of this function is to download data from the specified exchange on the mentioned date. If data is not available for the date you specified, you will get an error.


download_stocks_period

The function you’ll probably have to use first is the download_stocks_period

df_period <- 
  download_stocks_period(start = "2018-07-21",
                         end = "2018-07-26",
                         exchange = c("both", "nse", "bse"),
                         dest_path = "./data",
                         compile = TRUE,
                         delete_component_files = TRUE,
                         quiet = FALSE)
  • start and end: The download stocks period downloads data for all the dates in the date range specified by start and end. start defaults to today - 8 days and end defaults to today. If today is 2018-07-30, then end takes that value and start takes the value 2018-07-22. However, it makes sense to make start today - 365 or specify the actual date from when you want the data. You could change the end value too if you want data for a specific date range. The start and end values follow the same rules as the date parameter in download_stocks
  • The exchangefunction’s behavior is pretty straightforward. Downloads data for the date range from NSE if “nse” or BSE from “bse” or both NSE and BSE if “both”. Defaults to “both”
  • The dest_path does the same job as it does in download_stocks
  • The compile parameter compiles all the downloaded files into one file (if exchange is “both”, one compiled file for “nse”, one for “bse” and one combined). This option is by default on as compiled files are much more tractable for analysis.
  • The delete_component_files deletes everything apart from the compiled files. This keeps the work space clean and more efficient for updating.
  • The quiet does the same job as it does in download_stocks

Let’s take a look at df_period.

df_period %>% slice(1:200)
exchange date symbol isin open high low close volume series last prevclose tottrdval timestamp totaltrades sc_group no_trades net_turnov tdcloindi
nse 2018-07-20 20MICRONS INE144J01027 34.90 35.20 33.90 34.40 42383 EQ 34.75 34.60 1.456395e+06 20-JUL-2018 607 NA NA NA NA
nse 2018-07-20 21STCENMGM INE253B01015 34.90 34.90 34.90 34.90 1202 EQ 34.90 34.25 4.194980e+04 20-JUL-2018 4 NA NA NA NA
nse 2018-07-20 3IINFOTECH INE748C01020 3.55 3.70 3.50 3.50 2998992 EQ 3.50 3.60 1.071709e+07 20-JUL-2018 1137 NA NA NA NA
nse 2018-07-20 3MINDIA INE470A01017 21541.00 23490.00 21318.55 23338.75 9813 EQ 23100.00 21722.15 2.222181e+08 20-JUL-2018 4330 NA NA NA NA
nse 2018-07-20 3PLAND INE105C01023 15.00 15.00 12.65 13.15 2517 EQ 13.10 13.45 3.373560e+04 20-JUL-2018 28 NA NA NA NA
nse 2018-07-20 5PAISA INE618L01018 294.75 304.95 294.75 300.85 2925 EQ 302.00 304.05 8.753848e+05 20-JUL-2018 241 NA NA NA NA
nse 2018-07-20 63MOONS INE111B01023 65.25 66.80 63.10 65.55 216988 EQ 65.20 65.20 1.410211e+07 20-JUL-2018 2403 NA NA NA NA
nse 2018-07-20 8KMILES INE650K01021 335.00 339.00 307.50 307.50 1422247 EQ 307.50 341.65 4.447500e+08 20-JUL-2018 21142 NA NA NA NA
nse 2018-07-20 A2ZINFRA INE619I01012 19.65 20.10 19.30 19.80 168417 EQ 19.70 19.80 3.304623e+06 20-JUL-2018 740 NA NA NA NA
nse 2018-07-20 AARTIDRUGS INE767A01016 520.70 527.00 520.00 521.75 5263 EQ 520.00 520.95 2.757494e+06 20-JUL-2018 538 NA NA NA NA
nse 2018-07-20 AARTIIND INE769A01020 1197.15 1229.80 1197.15 1215.45 7544 EQ 1211.00 1204.40 9.197825e+06 20-JUL-2018 1295 NA NA NA NA
nse 2018-07-20 AARVEEDEN INE273D01019 29.60 30.40 28.80 29.10 8583 EQ 29.10 29.55 2.509224e+05 20-JUL-2018 63 NA NA NA NA
nse 2018-07-20 ABAN INE421A01028 101.80 103.95 100.15 101.90 462821 EQ 102.30 102.20 4.702502e+07 20-JUL-2018 5859 NA NA NA NA
nse 2018-07-20 ABB INE117A01022 1164.90 1179.95 1129.00 1134.95 186787 EQ 1132.00 1157.60 2.151432e+08 20-JUL-2018 14947 NA NA NA NA
nse 2018-07-20 ABBOTINDIA INE358A01014 7286.00 7348.75 7193.60 7311.95 3185 EQ 7325.00 7266.20 2.321175e+07 20-JUL-2018 813 NA NA NA NA
nse 2018-07-20 ABCAPITAL INE674K01013 126.00 127.80 125.10 126.45 1206816 EQ 126.90 125.55 1.521385e+08 20-JUL-2018 11165 NA NA NA NA
nse 2018-07-20 ABFRL INE647O01011 136.05 136.80 134.25 135.05 883312 EQ 135.00 136.05 1.188593e+08 20-JUL-2018 1440 NA NA NA NA
nse 2018-07-20 ABGSHIP INE067H01016 5.70 5.70 5.30 5.65 12835 BZ 5.70 5.55 7.047700e+04 20-JUL-2018 52 NA NA NA NA
nse 2018-07-20 ACC INE012A01025 1297.00 1297.00 1267.65 1293.00 272055 EQ 1292.30 1274.50 3.497398e+08 20-JUL-2018 9555 NA NA NA NA
nse 2018-07-20 ACCELYA INE793A01012 1069.00 1101.85 1058.45 1096.90 4517 EQ 1095.00 1069.80 4.904186e+06 20-JUL-2018 343 NA NA NA NA
nse 2018-07-20 ACE INE731H01025 120.30 129.75 120.00 129.05 258631 EQ 128.50 123.60 3.247183e+07 20-JUL-2018 2521 NA NA NA NA
nse 2018-07-20 ADANIENT INE423A01024 152.10 164.70 149.70 162.95 27020824 EQ 161.95 151.05 4.276061e+09 20-JUL-2018 130410 NA NA NA NA
nse 2018-07-20 ADANIGREEN INE364U01010 29.95 35.60 29.50 35.40 5891772 EQ 35.60 29.70 2.049862e+08 20-JUL-2018 19693 NA NA NA NA
nse 2018-07-20 ADANIPORTS INE742F01042 369.60 376.90 366.90 370.05 1886770 EQ 369.95 369.60 7.018623e+08 20-JUL-2018 33098 NA NA NA NA
nse 2018-07-20 ADANIPOWER INE814H01011 22.30 25.00 21.65 24.65 82844118 EQ 24.50 22.30 1.991683e+09 20-JUL-2018 81277 NA NA NA NA
nse 2018-07-20 ADANITRANS INE931S01010 149.20 157.45 147.80 150.40 464642 EQ 149.90 149.20 7.077580e+07 20-JUL-2018 7670 NA NA NA NA
nse 2018-07-20 ADFFOODS INE982B01019 236.95 244.00 235.00 236.45 89169 EQ 236.15 236.50 2.120041e+07 20-JUL-2018 1360 NA NA NA NA
nse 2018-07-20 ADHUNIK INE400H01019 4.25 4.25 3.95 3.95 91468 EQ 3.95 4.10 3.762009e+05 20-JUL-2018 137 NA NA NA NA
nse 2018-07-20 ADHUNIKIND INE452L01012 76.50 76.50 71.00 74.00 69953 EQ 74.15 74.25 5.144542e+06 20-JUL-2018 228 NA NA NA NA
nse 2018-07-20 ADLABS INE172N01012 32.20 33.90 32.20 32.95 37660 EQ 32.95 32.90 1.249496e+06 20-JUL-2018 522 NA NA NA NA
nse 2018-07-20 ADORWELD INE045A01017 269.10 277.05 266.10 269.85 5028 EQ 268.20 270.50 1.359517e+06 20-JUL-2018 247 NA NA NA NA
nse 2018-07-20 ADROITINFO INE737B01033 35.10 35.45 29.50 30.40 46729 EQ 30.00 35.15 1.547914e+06 20-JUL-2018 537 NA NA NA NA
nse 2018-07-20 ADSL INE102I01027 14.30 14.85 13.55 14.25 28985 EQ 14.35 14.10 4.111782e+05 20-JUL-2018 127 NA NA NA NA
nse 2018-07-20 ADVANIHOTR INE199C01026 46.05 47.50 43.80 45.90 10838 EQ 45.45 46.70 4.916558e+05 20-JUL-2018 249 NA NA NA NA
nse 2018-07-20 ADVENZYMES INE837H01020 201.00 204.75 197.20 202.10 71979 EQ 202.50 202.00 1.450842e+07 20-JUL-2018 2690 NA NA NA NA
nse 2018-07-20 AEGISCHEM INE208C01025 236.20 241.00 233.75 236.30 83965 EQ 237.00 236.20 2.002959e+07 20-JUL-2018 1690 NA NA NA NA
nse 2018-07-20 AFL INE020G01017 45.50 47.80 45.05 47.25 586 EQ 46.25 47.05 2.762300e+04 20-JUL-2018 20 NA NA NA NA
nse 2018-07-20 AGARIND INE204E01012 271.95 283.50 265.25 272.75 703 EQ 271.90 266.00 1.905340e+05 20-JUL-2018 65 NA NA NA NA
nse 2018-07-20 AGCNET INE676A01019 104.90 106.90 102.10 105.05 2047 EQ 105.00 105.00 2.162518e+05 20-JUL-2018 36 NA NA NA NA
nse 2018-07-20 AGLSL INE517U01013 84.80 84.80 82.05 83.70 179 EQ 83.05 81.75 1.495000e+04 20-JUL-2018 11 NA NA NA NA
nse 2018-07-20 AGRITECH INE449G01018 97.50 99.60 96.00 97.40 13640 EQ 97.00 98.25 1.337862e+06 20-JUL-2018 365 NA NA NA NA
nse 2018-07-20 AGROPHOS INE740V01019 35.85 36.90 35.85 36.90 30000 SM 36.90 34.90 1.083600e+06 20-JUL-2018 5 NA NA NA NA
nse 2018-07-20 AHLEAST INE926K01017 251.90 256.05 251.90 255.05 754 EQ 255.00 259.20 1.924468e+05 20-JUL-2018 22 NA NA NA NA
nse 2018-07-20 AHLUCONT INE758C01029 321.65 330.00 321.65 326.25 55438 EQ 325.20 325.05 1.802926e+07 20-JUL-2018 57 NA NA NA NA
nse 2018-07-20 AHLWEST INE915K01010 283.75 293.00 283.75 293.00 1369 BE 293.00 298.65 3.992598e+05 20-JUL-2018 10 NA NA NA NA
nse 2018-07-20 AIAENG INE212H01026 1606.70 1614.50 1555.10 1599.95 26243 EQ 1600.00 1597.70 4.182032e+07 20-JUL-2018 2018 NA NA NA NA
nse 2018-07-20 AICHAMP INE768E01024 24.35 24.35 24.35 24.35 10 BE 24.35 23.95 2.435000e+02 20-JUL-2018 1 NA NA NA NA
nse 2018-07-20 AIFL INE428O01016 447.00 449.00 444.50 446.00 190067 EQ 445.95 445.40 8.488145e+07 20-JUL-2018 1812 NA NA NA NA
nse 2018-07-20 AIRAN INE645W01018 345.00 350.00 345.00 350.00 1500 SM 350.00 345.70 5.205000e+05 20-JUL-2018 3 NA NA NA NA
nse 2018-07-20 AISL INE635Y01015 76.00 78.00 76.00 77.25 3600 SM 78.00 79.05 2.766000e+05 20-JUL-2018 3 NA NA NA NA
nse 2018-07-20 AJANTPHARM INE031B01049 965.00 1027.50 950.60 1019.25 615992 EQ 1024.00 973.95 6.182580e+08 20-JUL-2018 17936 NA NA NA NA
nse 2018-07-20 AJMERA INE298G01027 199.10 206.00 199.10 201.40 39019 EQ 203.90 200.45 7.912329e+06 20-JUL-2018 1156 NA NA NA NA
nse 2018-07-20 AJOONI INE820Y01013 18.40 19.00 16.00 17.45 52000 SM 17.45 19.00 8.944000e+05 20-JUL-2018 13 NA NA NA NA
nse 2018-07-20 AKSHARCHEM INE542B01011 498.05 499.05 480.00 482.40 1156 EQ 481.00 497.25 5.647472e+05 20-JUL-2018 188 NA NA NA NA
nse 2018-07-20 AKSHOPTFBR INE523B01011 26.00 27.20 25.80 26.50 887681 EQ 26.40 25.90 2.354385e+07 20-JUL-2018 2624 NA NA NA NA
nse 2018-07-20 AKZOINDIA INE133A01011 1809.05 1855.00 1807.00 1812.30 3095 EQ 1810.00 1835.95 5.646884e+06 20-JUL-2018 465 NA NA NA NA
nse 2018-07-20 ALANKIT INE914E01040 23.60 24.90 23.25 23.60 719846 EQ 23.65 23.95 1.706218e+07 20-JUL-2018 3226 NA NA NA NA
nse 2018-07-20 ALBERTDAVD INE155C01010 379.10 401.95 378.00 389.00 918 EQ 389.00 383.20 3.557307e+05 20-JUL-2018 46 NA NA NA NA
nse 2018-07-20 ALBK INE428A01015 41.10 41.20 40.25 40.90 4450750 EQ 40.90 41.15 1.814825e+08 20-JUL-2018 7267 NA NA NA NA
nse 2018-07-20 ALCHEM INE964B01033 5.65 5.80 5.45 5.65 3894 BE 5.70 5.70 2.142835e+04 20-JUL-2018 26 NA NA NA NA
nse 2018-07-20 ALEMBICLTD INE426A01027 36.85 37.45 36.20 36.90 260102 EQ 36.85 36.35 9.579784e+06 20-JUL-2018 1392 NA NA NA NA
nse 2018-07-20 ALICON INE062D01024 582.15 589.50 575.00 579.60 925 EQ 577.00 582.15 5.382078e+05 20-JUL-2018 65 NA NA NA NA
nse 2018-07-20 ALKALI INE773I01017 59.00 62.35 59.00 60.05 3110 EQ 60.60 60.00 1.884364e+05 20-JUL-2018 108 NA NA NA NA
nse 2018-07-20 ALKEM INE540L01014 1851.40 1876.00 1816.10 1841.80 23756 EQ 1876.00 1843.30 4.356758e+07 20-JUL-2018 4911 NA NA NA NA
nse 2018-07-20 ALKYLAMINE INE150B01021 631.00 650.75 613.05 616.65 2081 EQ 623.30 649.90 1.297098e+06 20-JUL-2018 188 NA NA NA NA
nse 2018-07-20 ALLCARGO INE418H01029 105.00 109.25 105.00 108.05 228670 EQ 108.20 108.90 2.461992e+07 20-JUL-2018 2952 NA NA NA NA
nse 2018-07-20 ALLSEC INE835G01018 245.35 252.95 243.75 249.20 8263 EQ 249.00 250.75 2.063331e+06 20-JUL-2018 354 NA NA NA NA
nse 2018-07-20 ALMONDZ INE326B01027 29.10 30.50 29.10 30.05 2251 BE 29.15 29.90 6.751965e+04 20-JUL-2018 8 NA NA NA NA
nse 2018-07-20 ALOKTEXT INE270A01011 3.25 3.25 3.25 3.25 1264309 BE 3.25 3.40 4.109004e+06 20-JUL-2018 497 NA NA NA NA
nse 2018-07-20 ALPA INE385I01010 24.30 25.00 23.35 24.65 5409 EQ 24.50 25.05 1.324782e+05 20-JUL-2018 49 NA NA NA NA
nse 2018-07-20 ALPHAGEO INE137C01018 647.45 651.15 635.05 641.95 4949 EQ 641.50 647.50 3.187353e+06 20-JUL-2018 599 NA NA NA NA
nse 2018-07-20 ALPSINDUS INE093B01015 2.10 2.10 2.10 2.10 23980 BE 2.10 2.00 5.035800e+04 20-JUL-2018 24 NA NA NA NA
nse 2018-07-20 AMARAJABAT INE885A01032 767.00 769.10 752.90 762.75 179971 EQ 768.00 762.40 1.369977e+08 20-JUL-2018 8420 NA NA NA NA
nse 2018-07-20 AMBANIORG INE00C501018 66.25 67.00 66.25 67.00 64000 ST 0.00 66.65 4.271500e+06 20-JUL-2018 16 NA NA NA NA
nse 2018-07-20 AMBER INE371P01015 910.05 918.00 889.00 900.40 9359 EQ 899.00 921.55 8.445119e+06 20-JUL-2018 1046 NA NA NA NA
nse 2018-07-20 AMBIKCO INE540G01014 1255.70 1273.45 1255.00 1264.45 1331 EQ 1255.00 1268.60 1.680451e+06 20-JUL-2018 180 NA NA NA NA
nse 2018-07-20 AMBUJACEM INE079A01024 193.40 195.45 191.70 194.30 1105960 EQ 194.45 193.35 2.148690e+08 20-JUL-2018 19897 NA NA NA NA
nse 2018-07-20 AMDIND INE005I01014 19.70 19.70 18.90 19.50 6324 EQ 19.50 19.85 1.214089e+05 20-JUL-2018 49 NA NA NA NA
nse 2018-07-20 AMJLAND INE606A01024 25.00 25.00 24.50 24.65 11316 EQ 24.70 24.70 2.788935e+05 20-JUL-2018 75 NA NA NA NA
nse 2018-07-20 AMRUTANJAN INE098F01031 273.00 275.85 273.00 275.60 8967 EQ 275.00 274.30 2.456614e+06 20-JUL-2018 116 NA NA NA NA
nse 2018-07-20 AMTEKAUTO INE130C01021 7.35 7.70 7.15 7.15 183713 BZ 7.15 7.50 1.330123e+06 20-JUL-2018 408 NA NA NA NA
nse 2018-07-20 ANANTRAJ INE242C01024 36.80 36.90 35.95 36.45 305304 EQ 36.35 36.75 1.106380e+07 20-JUL-2018 1232 NA NA NA NA
nse 2018-07-20 ANDHRABANK INE434A01013 30.15 31.00 29.80 30.80 6163514 EQ 30.60 30.15 1.880378e+08 20-JUL-2018 10268 NA NA NA NA
nse 2018-07-20 ANDHRACEMT INE666E01012 8.30 8.40 8.20 8.25 36280 EQ 8.25 8.30 3.004700e+05 20-JUL-2018 83 NA NA NA NA
nse 2018-07-20 ANDHRSUGAR INE715B01013 316.00 319.15 311.00 314.55 6973 EQ 311.00 316.50 2.205729e+06 20-JUL-2018 432 NA NA NA NA
nse 2018-07-20 ANGIND INE017D01010 2.80 2.90 2.70 2.90 13552 BE 2.90 2.80 3.832710e+04 20-JUL-2018 38 NA NA NA NA
nse 2018-07-20 ANIKINDS INE087B01017 26.50 28.15 26.00 26.70 4592 BE 27.35 27.20 1.224984e+05 20-JUL-2018 39 NA NA NA NA
nse 2018-07-20 ANKITMETAL INE106I01010 0.70 0.70 0.70 0.70 23 BE 0.70 0.70 1.610000e+01 20-JUL-2018 3 NA NA NA NA
nse 2018-07-20 ANSALAPI INE436A01026 14.50 15.00 14.50 14.80 15458 EQ 14.80 15.00 2.298963e+05 20-JUL-2018 81 NA NA NA NA
nse 2018-07-20 ANSALHSG INE880B01015 13.85 14.20 13.70 13.95 11473 EQ 13.95 13.95 1.598658e+05 20-JUL-2018 83 NA NA NA NA
nse 2018-07-20 ANTGRAPHIC INE414B01021 0.50 0.55 0.50 0.50 33276 BE 0.50 0.55 1.664805e+04 20-JUL-2018 15 NA NA NA NA
nse 2018-07-20 APARINDS INE372A01015 607.60 629.00 605.05 619.80 18420 EQ 613.10 607.60 1.140117e+07 20-JUL-2018 886 NA NA NA NA
nse 2018-07-20 APCL INE071F01012 144.45 147.00 138.75 144.70 1350 EQ 144.00 144.45 1.930195e+05 20-JUL-2018 182 NA NA NA NA
nse 2018-07-20 APCOTEXIND INE116A01024 532.40 534.25 529.15 530.90 3574 EQ 534.25 530.30 1.897500e+06 20-JUL-2018 256 NA NA NA NA
nse 2018-07-20 APEX INE346W01013 337.00 354.70 333.00 354.55 122039 EQ 354.70 337.85 4.223532e+07 20-JUL-2018 2342 NA NA NA NA
nse 2018-07-20 APLAPOLLO INE702C01019 1625.65 1642.90 1580.00 1605.50 24101 EQ 1610.00 1641.80 3.869073e+07 20-JUL-2018 1617 NA NA NA NA
nse 2018-07-20 APLLTD INE901L01018 520.95 533.90 518.00 531.55 91094 EQ 532.65 514.60 4.790290e+07 20-JUL-2018 3615 NA NA NA NA
nse 2018-07-20 APOLLO INE713T01010 136.00 139.05 128.00 128.60 44765 EQ 128.60 135.55 5.901192e+06 20-JUL-2018 6431 NA NA NA NA
nse 2018-07-20 APOLLOHOSP INE437A01024 948.00 959.65 925.15 929.55 774467 EQ 934.80 953.95 7.234384e+08 20-JUL-2018 18448 NA NA NA NA
nse 2018-07-20 APOLLOTYRE INE438A01022 277.15 289.80 274.35 280.30 5049006 EQ 279.45 279.75 1.419793e+09 20-JUL-2018 42515 NA NA NA NA
nse 2018-07-20 APOLSINHOT INE451F01016 1252.75 1255.00 1244.00 1255.00 20 EQ 1255.00 1252.75 2.504050e+04 20-JUL-2018 10 NA NA NA NA
nse 2018-07-20 APTECHT INE266F01018 239.00 244.00 234.50 242.60 246207 EQ 243.75 240.30 5.890232e+07 20-JUL-2018 5361 NA NA NA NA
nse 2018-07-20 ARCHIDPLY INE877I01016 48.50 51.90 48.25 48.90 13688 EQ 48.75 50.10 6.675337e+05 20-JUL-2018 162 NA NA NA NA
nse 2018-07-20 ARCHIES INE731A01020 26.95 27.00 25.90 26.90 25652 BE 27.00 26.55 6.828816e+05 20-JUL-2018 181 NA NA NA NA
nse 2018-07-20 ARCOTECH INE574I01035 13.80 13.80 13.05 13.20 180164 EQ 13.35 13.20 2.365742e+06 20-JUL-2018 414 NA NA NA NA
nse 2018-07-20 ARENTERP INE610C01014 9.55 9.55 9.55 9.55 200 EQ 9.55 9.95 1.910000e+03 20-JUL-2018 1 NA NA NA NA
nse 2018-07-20 ARIES INE298I01015 98.05 99.30 93.15 93.90 36517 EQ 94.40 98.85 3.508712e+06 20-JUL-2018 900 NA NA NA NA
nse 2018-07-20 ARIHANT INE413D01011 32.20 35.25 32.20 35.00 455 EQ 35.00 33.80 1.566250e+04 20-JUL-2018 11 NA NA NA NA
nse 2018-07-20 ARIHANTSUP INE643K01018 71.50 71.80 63.90 66.05 52874 EQ 64.50 70.95 3.579608e+06 20-JUL-2018 1064 NA NA NA NA
nse 2018-07-20 ARMANFIN INE109C01017 340.00 350.00 340.00 342.00 2662 BE 340.00 336.20 9.192912e+05 20-JUL-2018 34 NA NA NA NA
nse 2018-07-20 AROGRANITE INE210C01013 52.20 52.20 50.00 50.55 12144 EQ 50.00 52.20 6.198152e+05 20-JUL-2018 160 NA NA NA NA
nse 2018-07-20 ARROWGREEN INE570D01018 137.30 137.40 134.00 137.40 20117 EQ 137.40 130.90 2.754955e+06 20-JUL-2018 267 NA NA NA NA
nse 2018-07-20 ARROWTEX INE933J01015 28.00 28.55 25.30 26.15 6713 EQ 26.75 27.50 1.792640e+05 20-JUL-2018 90 NA NA NA NA
nse 2018-07-20 ARSHIYA INE968D01022 52.00 55.50 50.55 54.05 15254 EQ 54.05 52.45 8.148059e+05 20-JUL-2018 176 NA NA NA NA
nse 2018-07-20 ARSSINFRA INE267I01010 17.30 19.10 17.30 18.50 34164 BE 19.10 18.20 6.195703e+05 20-JUL-2018 151 NA NA NA NA
nse 2018-07-20 ARTNIRMAN INE738V01013 23.00 23.00 23.00 23.00 12000 SM 23.00 23.50 2.760000e+05 20-JUL-2018 1 NA NA NA NA
nse 2018-07-20 ARVIND INE034A01011 397.80 404.35 394.50 400.05 1453675 EQ 398.20 397.00 5.821291e+08 20-JUL-2018 31801 NA NA NA NA
nse 2018-07-20 ARVSMART INE034S01021 162.00 162.00 158.00 160.45 4698 EQ 158.10 160.25 7.511726e+05 20-JUL-2018 129 NA NA NA NA
nse 2018-07-20 ASAHIINDIA INE439A01020 325.10 327.45 325.00 325.85 7246 EQ 325.00 326.80 2.362429e+06 20-JUL-2018 440 NA NA NA NA
nse 2018-07-20 ASAHISONG INE228I01012 256.95 257.00 251.80 257.00 1268 EQ 257.00 254.55 3.244327e+05 20-JUL-2018 28 NA NA NA NA
nse 2018-07-20 ASAL INE900C01027 51.15 52.50 50.70 51.40 4169 EQ 51.20 52.20 2.138067e+05 20-JUL-2018 75 NA NA NA NA
nse 2018-07-20 ASHAPURMIN INE348A01023 41.80 42.50 41.40 42.05 30730 EQ 42.00 41.70 1.291512e+06 20-JUL-2018 212 NA NA NA NA
nse 2018-07-20 ASHIANA INE365D01021 123.60 129.00 118.05 127.65 43154 EQ 128.00 121.00 5.350818e+06 20-JUL-2018 813 NA NA NA NA
nse 2018-07-20 ASHIMASYN INE440A01010 23.10 23.95 22.10 23.20 57586 EQ 23.05 23.15 1.333936e+06 20-JUL-2018 326 NA NA NA NA
nse 2018-07-20 ASHOKA INE442H01029 150.00 150.00 141.80 144.00 108583 EQ 143.70 148.80 1.575561e+07 20-JUL-2018 2519 NA NA NA NA
nse 2018-07-20 ASHOKLEY INE208A01029 106.50 110.00 105.80 107.45 60955186 EQ 107.35 105.70 6.605025e+09 20-JUL-2018 235641 NA NA NA NA
nse 2018-07-20 ASIANHOTNR INE363A01022 247.00 248.60 225.00 228.45 781 EQ 227.20 234.70 1.838418e+05 20-JUL-2018 42 NA NA NA NA
nse 2018-07-20 ASIANPAINT INE021A01026 1403.00 1404.75 1381.50 1396.45 575194 EQ 1395.00 1403.00 8.017291e+08 20-JUL-2018 29434 NA NA NA NA
nse 2018-07-20 ASIANTILES INE022I01019 286.00 290.45 280.65 282.55 38078 EQ 282.00 290.15 1.082485e+07 20-JUL-2018 1558 NA NA NA NA
nse 2018-07-20 ASPINWALL INE991I01015 236.00 250.95 231.50 236.35 456 EQ 235.00 240.00 1.079865e+05 20-JUL-2018 31 NA NA NA NA
nse 2018-07-20 ASSAMCO INE442A01024 3.55 3.60 3.35 3.35 780617 EQ 3.35 3.50 2.666369e+06 20-JUL-2018 277 NA NA NA NA
nse 2018-07-20 ASTEC INE563J01010 645.00 645.00 631.00 634.15 13273 EQ 631.70 638.15 8.444145e+06 20-JUL-2018 825 NA NA NA NA
nse 2018-07-20 ASTERDM INE914M01019 163.00 163.90 160.85 162.15 36259 EQ 163.30 163.85 5.894001e+06 20-JUL-2018 3778 NA NA NA NA
nse 2018-07-20 ASTRAL INE006I01046 1056.95 1097.00 1036.00 1045.15 76935 EQ 1045.00 1049.10 8.215336e+07 20-JUL-2018 3701 NA NA NA NA
nse 2018-07-20 ASTRAMICRO INE386C01029 95.45 98.25 95.05 97.20 188886 EQ 97.40 95.65 1.821106e+07 20-JUL-2018 1521 NA NA NA NA
nse 2018-07-20 ASTRAZEN INE203A01020 1440.00 1464.90 1415.00 1424.00 9749 EQ 1420.00 1435.55 1.401456e+07 20-JUL-2018 992 NA NA NA NA
nse 2018-07-20 ASTRON INE646X01014 104.50 106.40 103.80 104.45 148626 EQ 104.65 104.55 1.554764e+07 20-JUL-2018 857 NA NA NA NA
nse 2018-07-20 ATFL INE209A01019 621.00 647.00 621.00 640.75 7909 EQ 647.00 621.80 5.024156e+06 20-JUL-2018 386 NA NA NA NA
nse 2018-07-20 ATLANTA INE285H01022 34.80 37.70 34.05 37.20 171404 EQ 37.70 34.30 6.295060e+06 20-JUL-2018 926 NA NA NA NA
nse 2018-07-20 ATLASCYCLE INE446A01025 117.10 124.00 117.10 122.90 7661 BE 124.00 119.00 9.269844e+05 20-JUL-2018 114 NA NA NA NA
nse 2018-07-20 ATUL INE100A01010 2831.50 2900.00 2801.95 2870.75 59416 EQ 2870.00 2806.60 1.698249e+08 20-JUL-2018 4420 NA NA NA NA
nse 2018-07-20 ATULAUTO INE951D01028 397.95 413.45 380.65 402.10 109549 EQ 400.00 392.30 4.438628e+07 20-JUL-2018 5351 NA NA NA NA
nse 2018-07-20 AUBANK INE949L01017 629.00 634.60 625.90 632.00 317342 EQ 632.00 629.50 2.001849e+08 20-JUL-2018 12225 NA NA NA NA
nse 2018-07-20 AURIONPRO INE132H01018 185.20 199.35 185.20 197.50 21787 EQ 197.00 190.70 4.237777e+06 20-JUL-2018 327 NA NA NA NA
nse 2018-07-20 AUROPHARMA INE406A01037 568.00 589.45 566.75 583.80 1676065 EQ 580.95 567.85 9.732787e+08 20-JUL-2018 43760 NA NA NA NA
nse 2018-07-20 AUSOMENT INE218C01016 70.55 74.35 69.30 70.70 2470 EQ 70.15 71.35 1.748151e+05 20-JUL-2018 63 NA NA NA NA
nse 2018-07-20 AUTOAXLES INE449A01011 1170.50 1172.00 1114.10 1126.05 13912 EQ 1115.00 1171.45 1.581216e+07 20-JUL-2018 1312 NA NA NA NA
nse 2018-07-20 AUTOIND INE718H01014 63.15 64.55 60.00 61.60 24120 EQ 61.95 62.40 1.507018e+06 20-JUL-2018 423 NA NA NA NA
nse 2018-07-20 AUTOLITIND INE448A01013 55.50 56.90 54.00 54.80 15335 EQ 54.50 56.15 8.399942e+05 20-JUL-2018 208 NA NA NA NA
nse 2018-07-20 AVADHSUGAR INE349W01017 285.80 286.00 275.05 278.40 8378 EQ 278.00 286.45 2.348846e+06 20-JUL-2018 468 NA NA NA NA
nse 2018-07-20 AVANTIFEED INE871C01038 422.30 434.45 417.00 430.60 694076 EQ 427.90 421.15 2.958522e+08 20-JUL-2018 21804 NA NA NA NA
nse 2018-07-20 AVG INE680Z01018 90.00 90.00 90.00 90.00 1200 SM 90.00 90.00 1.080000e+05 20-JUL-2018 1 NA NA NA NA
nse 2018-07-20 AVTNPL INE488D01021 29.80 30.40 29.50 29.90 40727 EQ 30.00 30.00 1.221302e+06 20-JUL-2018 304 NA NA NA NA
nse 2018-07-20 AXISBANK INE238A01034 526.80 536.45 525.00 533.70 2532288 EQ 533.70 526.80 1.347726e+09 20-JUL-2018 27820 NA NA NA NA
nse 2018-07-20 AXISCADES INE555B01013 110.70 115.20 107.85 109.55 64335 EQ 108.90 112.15 7.108589e+06 20-JUL-2018 1599 NA NA NA NA
nse 2018-07-20 AXISGOLD INF846K01347 2651.00 2699.00 2635.00 2648.25 62 EQ 2649.00 2637.00 1.645839e+05 20-JUL-2018 16 NA NA NA NA
nse 2018-07-20 AXISNIFTY INF846K01ZL0 1176.00 1176.00 1058.90 1110.09 161 EQ 1110.09 1104.58 1.785725e+05 20-JUL-2018 9 NA NA NA NA
nse 2018-07-20 AYMSYNTEX INE193B01039 45.10 47.05 45.05 45.90 1312 EQ 45.60 45.30 5.977945e+04 20-JUL-2018 15 NA NA NA NA
nse 2018-07-20 BAFNAPHARM INE878I01014 22.00 22.40 20.30 20.70 27357 EQ 20.45 21.60 5.753301e+05 20-JUL-2018 171 NA NA NA NA
nse 2018-07-20 BAGFILMS INE116D01028 4.10 4.20 4.10 4.20 39088 EQ 4.15 4.15 1.615970e+05 20-JUL-2018 61 NA NA NA NA
nse 2018-07-20 BAJAJ-AUTO INE917I01010 3130.00 3153.80 2816.45 2839.60 4976986 EQ 2821.60 3115.00 1.465667e+10 20-JUL-2018 209645 NA NA NA NA
nse 2018-07-20 BAJAJCORP INE933K01021 401.65 409.00 391.35 395.10 26425 EQ 396.00 403.10 1.058065e+07 20-JUL-2018 1847 NA NA NA NA
nse 2018-07-20 BAJAJELEC INE193E01025 524.00 560.00 521.20 544.05 843061 EQ 541.55 524.45 4.593322e+08 20-JUL-2018 23559 NA NA NA NA
nse 2018-07-20 BAJAJFINSV INE918I01018 6319.00 6782.00 6200.00 6663.95 968973 EQ 6660.10 6296.90 6.382904e+09 20-JUL-2018 100265 NA NA NA NA
nse 2018-07-20 BAJAJHIND INE306A01021 5.95 5.95 5.60 5.65 1583930 EQ 5.65 5.95 9.114550e+06 20-JUL-2018 9352 NA NA NA NA
nse 2018-07-20 BAJAJHLDNG INE118A01012 2968.90 3126.85 2915.10 3020.00 95199 EQ 3015.00 2950.75 2.893267e+08 20-JUL-2018 12633 NA NA NA NA
nse 2018-07-20 BAJFINANCE INE296A01024 2521.00 2745.00 2486.85 2721.35 7361274 EQ 2721.95 2520.20 1.955666e+10 20-JUL-2018 267359 NA NA NA NA
nse 2018-07-20 BALAJITELE INE794B01026 111.60 112.20 109.80 111.50 20041 EQ 111.50 112.30 2.224482e+06 20-JUL-2018 332 NA NA NA NA
nse 2018-07-20 BALAMINES INE050E01027 499.85 510.00 485.00 497.85 18343 EQ 496.20 500.30 9.165088e+06 20-JUL-2018 1094 NA NA NA NA
nse 2018-07-20 BALKRISHNA INE875R01011 63.10 66.80 63.10 65.40 2758 EQ 65.00 64.40 1.792486e+05 20-JUL-2018 58 NA NA NA NA
nse 2018-07-20 BALKRISIND INE787D01026 1150.00 1219.20 1145.00 1199.75 460603 EQ 1199.00 1152.95 5.466905e+08 20-JUL-2018 15889 NA NA NA NA
nse 2018-07-20 BALLARPUR INE294A01037 8.45 8.65 8.25 8.30 377489 EQ 8.25 8.45 3.182662e+06 20-JUL-2018 755 NA NA NA NA
nse 2018-07-20 BALMLAWRIE INE164A01016 206.00 209.45 206.00 207.80 36363 EQ 209.40 207.00 7.546786e+06 20-JUL-2018 1063 NA NA NA NA
nse 2018-07-20 BALPHARMA INE083D01012 70.50 72.60 70.10 70.80 7216 EQ 70.55 71.05 5.127107e+05 20-JUL-2018 150 NA NA NA NA
nse 2018-07-20 BALRAMCHIN INE119A01028 62.65 64.00 61.65 63.45 2181423 EQ 64.00 62.90 1.371723e+08 20-JUL-2018 7704 NA NA NA NA
nse 2018-07-20 BANARBEADS INE655B01011 51.45 51.80 49.50 50.45 15437 EQ 50.45 49.35 7.840697e+05 20-JUL-2018 263 NA NA NA NA
nse 2018-07-20 BANARISUG INE459A01010 1450.00 1485.00 1416.35 1451.00 51 EQ 1450.00 1456.30 7.390845e+04 20-JUL-2018 29 NA NA NA NA
nse 2018-07-20 BANCOINDIA INE213C01025 196.25 201.80 195.10 198.65 16498 EQ 200.00 196.25 3.275543e+06 20-JUL-2018 640 NA NA NA NA
nse 2018-07-20 BANDHANBNK INE545U01014 618.00 706.80 616.00 687.40 5425223 EQ 681.80 617.50 3.592467e+09 20-JUL-2018 161618 NA NA NA NA
nse 2018-07-20 BANG INE863I01016 53.10 55.55 52.70 54.80 30299 EQ 53.90 53.90 1.634222e+06 20-JUL-2018 167 NA NA NA NA
nse 2018-07-20 BANKBARODA INE028A01039 118.60 121.65 117.70 120.25 10768295 EQ 120.30 120.05 1.288709e+09 20-JUL-2018 47659 NA NA NA NA
nse 2018-07-20 BANKBEES INF732E01078 2730.00 2741.65 2730.00 2739.94 722 EQ 2739.00 2729.58 1.975308e+06 20-JUL-2018 98 NA NA NA NA
nse 2018-07-20 BANKINDIA INE084A01016 82.25 83.90 81.55 83.25 7259483 EQ 83.20 82.75 6.014234e+08 20-JUL-2018 23208 NA NA NA NA
nse 2018-07-20 BANSAL INE668X01018 127.90 128.90 126.10 127.60 36000 SM 126.50 126.35 4.598250e+06 20-JUL-2018 32 NA NA NA NA
nse 2018-07-20 BANSWRAS INE629D01012 85.80 85.80 82.60 83.05 898 EQ 83.00 84.35 7.496145e+04 20-JUL-2018 88 NA NA NA NA
nse 2018-07-20 BARTRONICS INE855F01034 9.00 9.00 8.65 8.80 16909 BE 8.70 8.95 1.491010e+05 20-JUL-2018 68 NA NA NA NA
nse 2018-07-20 BASF INE373A01013 1801.05 1844.60 1745.00 1762.05 8176 EQ 1762.00 1827.45 1.454447e+07 20-JUL-2018 1198 NA NA NA NA
nse 2018-07-20 BASML INE186H01014 223.00 223.00 211.55 213.00 330 EQ 213.00 218.05 7.031440e+04 20-JUL-2018 14 NA NA NA NA
nse 2018-07-20 BATAINDIA INE176A01028 834.50 845.90 829.45 842.40 1769736 EQ 840.00 828.60 1.482310e+09 20-JUL-2018 41818 NA NA NA NA
nse 2018-07-20 BAYERCROP INE462A01022 4342.35 4379.60 4320.50 4349.85 5912 EQ 4321.00 4383.90 2.569323e+07 20-JUL-2018 1430 NA NA NA NA
nse 2018-07-20 BBL INE464A01028 1035.00 1065.00 1010.05 1050.30 10334 EQ 1051.00 1020.45 1.075007e+07 20-JUL-2018 738 NA NA NA NA
nse 2018-07-20 BBTC INE050A01025 1452.50 1478.90 1439.95 1463.75 125388 EQ 1460.00 1459.75 1.844065e+08 20-JUL-2018 3142 NA NA NA NA
nse 2018-07-20 BDL INE171Z01018 354.90 354.90 341.50 342.90 22351 EQ 345.00 352.00 7.705268e+06 20-JUL-2018 1435 NA NA NA NA
nse 2018-07-20 BEARDSELL INE520H01022 37.00 37.00 35.75 36.00 933 EQ 35.75 36.60 3.384485e+04 20-JUL-2018 24 NA NA NA NA
nse 2018-07-20 BEDMUTHA INE844K01012 18.95 18.95 17.65 18.05 5403 BE 18.50 18.40 9.803310e+04 20-JUL-2018 24 NA NA NA NA
nse 2018-07-20 BEL INE263A01024 98.40 104.20 97.75 103.65 9193680 EQ 103.10 97.90 9.292114e+08 20-JUL-2018 39612 NA NA NA NA
nse 2018-07-20 BEML INE258A01016 761.10 773.00 750.35 756.00 581386 EQ 753.95 767.00 4.415557e+08 20-JUL-2018 15002 NA NA NA NA
nse 2018-07-20 BEPL INE922A01025 125.80 129.00 122.20 127.90 396383 EQ 128.30 124.30 4.971038e+07 20-JUL-2018 3934 NA NA NA NA
nse 2018-07-20 BERGEPAINT INE463A01038 307.00 314.35 302.35 309.95 1618311 EQ 310.00 308.30 5.035996e+08 20-JUL-2018 17110 NA NA NA NA
nse 2018-07-20 BETA INE351Y01019 93.00 93.00 92.00 92.00 2400 SM 92.00 94.90 2.224000e+05 20-JUL-2018 3 NA NA NA NA

The function returns the compiled files apart from writing them out as a csv.


update_stocks

Once you have the download_stocks_period run, you can update the database later by running the update_stocks

df_updated <- 
  update_stocks(data_path = "./data",
                till = lubridate::today(),
                exchange = c("both", "nse", "bse"),
                compile = TRUE,
                delete_component_files = TRUE)

Most of this parameters have been discussed before. This function scans all the files in the directory and finds out the date till which there is data and downloads data from the day after till the date mentioned by till. If there are no files inside the specified folder, it downloads data from today - 8 till the date mentioned by till. You rarely have to tweak the till function. It’s primarily used to update till the current day.

Let’s take a look at df_updated.

df_updated %>% slice(1:200)
exchange date symbol isin open high low close volume series last prevclose tottrdval timestamp totaltrades sc_group no_trades net_turnov tdcloindi
nse 2018-07-30 20MICRONS INE144J01027 40.80 40.80 39.00 39.35 8062 EQ 39.05 39.90 3.185818e+05 30-JUL-2018 213 NA NA NA NA
nse 2018-07-30 21STCENMGM INE253B01015 37.80 37.80 37.80 37.80 1597 EQ 37.80 37.10 6.036660e+04 30-JUL-2018 8 NA NA NA NA
nse 2018-07-30 3IINFOTECH INE748C01020 3.50 3.60 3.45 3.55 3290306 EQ 3.55 3.55 1.161822e+07 30-JUL-2018 1432 NA NA NA NA
nse 2018-07-30 3MINDIA INE470A01017 23523.00 23789.95 22752.10 23293.15 1384 EQ 23299.95 23609.80 3.200037e+07 30-JUL-2018 652 NA NA NA NA
nse 2018-07-30 3PLAND INE105C01023 12.40 14.05 12.10 13.95 4805 EQ 13.95 12.15 6.588530e+04 30-JUL-2018 71 NA NA NA NA
nse 2018-07-30 5PAISA INE618L01018 344.55 353.00 337.00 339.15 3389 EQ 338.00 344.55 1.153079e+06 30-JUL-2018 318 NA NA NA NA
nse 2018-07-30 63MOONS INE111B01023 70.00 71.20 69.20 69.80 124508 EQ 69.70 69.80 8.726575e+06 30-JUL-2018 1335 NA NA NA NA
nse 2018-07-30 8KMILES INE650K01021 273.85 273.85 273.85 273.85 91291 EQ 273.85 260.85 2.500004e+07 30-JUL-2018 1018 NA NA NA NA
nse 2018-07-30 A2ZINFRA INE619I01012 23.95 23.95 22.45 22.90 958702 EQ 22.75 24.65 2.207395e+07 30-JUL-2018 3238 NA NA NA NA
nse 2018-07-30 AAKASH INE087Z01016 34.90 34.90 33.40 33.40 4000 SM 33.40 34.50 1.366000e+05 30-JUL-2018 2 NA NA NA NA
nse 2018-07-30 AARTIDRUGS INE767A01016 553.20 567.65 553.20 560.45 5722 EQ 561.00 552.70 3.215511e+06 30-JUL-2018 450 NA NA NA NA
nse 2018-07-30 AARTIIND INE769A01020 1260.00 1265.00 1232.00 1243.80 7707 EQ 1237.20 1252.40 9.672186e+06 30-JUL-2018 920 NA NA NA NA
nse 2018-07-30 AARVEEDEN INE273D01019 31.40 34.50 30.65 33.00 14681 EQ 33.05 32.40 4.884423e+05 30-JUL-2018 138 NA NA NA NA
nse 2018-07-30 AARVI INE754X01016 58.00 58.00 55.10 55.10 10000 SM 55.10 58.00 5.568000e+05 30-JUL-2018 5 NA NA NA NA
nse 2018-07-30 ABAN INE421A01028 108.10 112.95 106.30 109.95 2074990 EQ 109.95 108.35 2.270816e+08 30-JUL-2018 19396 NA NA NA NA
nse 2018-07-30 ABB INE117A01022 1196.00 1219.45 1179.00 1209.55 45747 EQ 1212.00 1188.40 5.518855e+07 30-JUL-2018 4516 NA NA NA NA
nse 2018-07-30 ABBOTINDIA INE358A01014 7551.00 7723.95 7450.00 7686.25 5342 EQ 7700.00 7612.55 4.041722e+07 30-JUL-2018 1518 NA NA NA NA
nse 2018-07-30 ABCAPITAL INE674K01013 143.00 148.40 142.70 147.35 2918116 EQ 147.35 142.80 4.278963e+08 30-JUL-2018 19384 NA NA NA NA
nse 2018-07-30 ABFRL INE647O01011 140.05 143.75 140.05 142.50 174682 EQ 143.00 140.00 2.483385e+07 30-JUL-2018 3082 NA NA NA NA
nse 2018-07-30 ABGSHIP INE067H01016 5.65 5.80 5.40 5.65 31477 BZ 5.40 5.65 1.788917e+05 30-JUL-2018 67 NA NA NA NA
nse 2018-07-30 ABMINTLTD INE251C01017 18.45 18.45 18.45 18.45 65 BE 18.45 19.40 1.199250e+03 30-JUL-2018 1 NA NA NA NA
nse 2018-07-30 ACC INE012A01025 1537.70 1537.70 1501.05 1503.80 995382 EQ 1509.10 1535.00 1.505804e+09 30-JUL-2018 34914 NA NA NA NA
nse 2018-07-30 ACCELYA INE793A01012 1089.65 1089.65 1047.30 1078.65 3329 EQ 1080.00 1073.60 3.593639e+06 30-JUL-2018 499 NA NA NA NA
nse 2018-07-30 ACCORD INE113X01015 46.50 46.80 46.50 46.80 4000 SM 46.80 39.00 1.866000e+05 30-JUL-2018 2 NA NA NA NA
nse 2018-07-30 ACE INE731H01025 135.20 142.90 135.20 140.95 386528 EQ 140.70 136.65 5.386162e+07 30-JUL-2018 2399 NA NA NA NA
nse 2018-07-30 ACEINTEG INE543V01017 33.00 33.00 32.00 32.00 21000 SM 32.00 32.05 6.870000e+05 30-JUL-2018 3 NA NA NA NA
nse 2018-07-30 ADANIENT INE423A01024 197.20 200.40 192.35 193.55 13913862 EQ 193.45 195.90 2.724292e+09 30-JUL-2018 70951 NA NA NA NA
nse 2018-07-30 ADANIGREEN INE364U01010 52.80 57.55 52.80 57.55 2011508 EQ 57.55 52.35 1.132475e+08 30-JUL-2018 9661 NA NA NA NA
nse 2018-07-30 ADANIPORTS INE742F01042 395.00 397.50 387.65 390.80 1649794 EQ 389.15 394.65 6.448505e+08 30-JUL-2018 31710 NA NA NA NA
nse 2018-07-30 ADANIPOWER INE814H01011 26.30 29.80 25.80 29.05 72767742 EQ 28.95 26.20 2.016749e+09 30-JUL-2018 61502 NA NA NA NA
nse 2018-07-30 ADANITRANS INE931S01010 169.00 174.70 165.40 172.65 531333 EQ 172.00 168.20 9.040906e+07 30-JUL-2018 5616 NA NA NA NA
nse 2018-07-30 ADFFOODS INE982B01019 242.25 246.00 241.80 243.10 42659 EQ 242.20 242.20 1.035065e+07 30-JUL-2018 591 NA NA NA NA
nse 2018-07-30 ADHUNIK INE400H01019 3.05 3.35 3.05 3.35 414467 BE 3.35 3.20 1.301671e+06 30-JUL-2018 267 NA NA NA NA
nse 2018-07-30 ADHUNIKIND INE452L01012 77.30 78.30 75.50 76.65 9269 EQ 76.75 77.30 7.106798e+05 30-JUL-2018 123 NA NA NA NA
nse 2018-07-30 ADLABS INE172N01012 34.90 36.55 34.00 34.90 143161 EQ 35.00 34.40 5.059793e+06 30-JUL-2018 1335 NA NA NA NA
nse 2018-07-30 ADORWELD INE045A01017 308.90 315.00 308.00 309.75 8872 EQ 309.30 306.05 2.754987e+06 30-JUL-2018 315 NA NA NA NA
nse 2018-07-30 ADROITINFO INE737B01033 30.45 30.45 28.30 28.80 1303 BE 28.30 29.00 3.767275e+04 30-JUL-2018 13 NA NA NA NA
nse 2018-07-30 ADSL INE102I01027 15.20 16.00 14.65 15.65 31657 EQ 15.80 15.00 4.884413e+05 30-JUL-2018 203 NA NA NA NA
nse 2018-07-30 ADVANIHOTR INE199C01026 51.40 55.00 49.50 53.75 49121 EQ 54.40 50.65 2.576844e+06 30-JUL-2018 334 NA NA NA NA
nse 2018-07-30 ADVENZYMES INE837H01020 208.15 211.80 207.05 210.00 69717 EQ 211.00 208.15 1.461681e+07 30-JUL-2018 1892 NA NA NA NA
nse 2018-07-30 AEGISCHEM INE208C01025 233.50 238.25 233.50 235.00 235303 EQ 235.00 235.80 5.549723e+07 30-JUL-2018 9294 NA NA NA NA
nse 2018-07-30 AFL INE020G01017 49.80 50.00 48.40 49.30 1685 EQ 49.30 48.95 8.390625e+04 30-JUL-2018 13 NA NA NA NA
nse 2018-07-30 AGARIND INE204E01012 283.00 290.00 275.00 277.00 367 EQ 275.00 283.00 1.023492e+05 30-JUL-2018 76 NA NA NA NA
nse 2018-07-30 AGCNET INE676A01019 114.00 116.85 111.20 112.35 7649 EQ 112.30 115.85 8.701152e+05 30-JUL-2018 135 NA NA NA NA
nse 2018-07-30 AGLSL INE517U01013 86.00 89.00 80.20 88.40 10626 EQ 89.00 83.00 9.215058e+05 30-JUL-2018 89 NA NA NA NA
nse 2018-07-30 AGRITECH INE449G01018 97.00 98.40 95.55 96.70 17274 EQ 97.10 96.95 1.672141e+06 30-JUL-2018 370 NA NA NA NA
nse 2018-07-30 AGROPHOS INE740V01019 37.25 37.50 35.05 35.05 30000 SM 35.05 38.50 1.107000e+06 30-JUL-2018 5 NA NA NA NA
nse 2018-07-30 AHLEAST INE926K01017 258.05 261.00 250.95 256.90 7131 EQ 257.50 254.10 1.830213e+06 30-JUL-2018 132 NA NA NA NA
nse 2018-07-30 AHLUCONT INE758C01029 336.65 345.00 332.65 334.75 2527 EQ 332.65 336.65 8.544583e+05 30-JUL-2018 153 NA NA NA NA
nse 2018-07-30 AHLWEST INE915K01010 288.15 297.95 288.05 289.80 117 EQ 288.05 302.80 3.396240e+04 30-JUL-2018 16 NA NA NA NA
nse 2018-07-30 AIAENG INE212H01026 1649.25 1660.00 1627.70 1651.75 22895 EQ 1650.00 1649.25 3.777456e+07 30-JUL-2018 2978 NA NA NA NA
nse 2018-07-30 AIFL INE428O01016 451.55 462.00 450.20 459.85 163775 EQ 459.00 450.10 7.459176e+07 30-JUL-2018 2408 NA NA NA NA
nse 2018-07-30 AIRAN INE645W01018 357.25 366.90 357.25 362.45 21500 SM 361.75 361.75 7.765500e+06 30-JUL-2018 17 NA NA NA NA
nse 2018-07-30 AJANTPHARM INE031B01049 1100.10 1136.90 1100.00 1130.40 656439 EQ 1135.15 1095.30 7.373466e+08 30-JUL-2018 19827 NA NA NA NA
nse 2018-07-30 AJMERA INE298G01027 208.00 211.85 206.00 207.75 450184 EQ 207.60 208.45 9.352753e+07 30-JUL-2018 1165 NA NA NA NA
nse 2018-07-30 AKASH INE737W01013 68.00 84.00 68.00 83.90 4000 SM 83.95 75.00 3.197500e+05 30-JUL-2018 4 NA NA NA NA
nse 2018-07-30 AKSHARCHEM INE542B01011 527.65 547.00 524.05 528.15 2577 EQ 526.00 527.65 1.375833e+06 30-JUL-2018 229 NA NA NA NA
nse 2018-07-30 AKSHOPTFBR INE523B01011 28.45 28.85 28.00 28.40 419002 EQ 28.35 28.25 1.191406e+07 30-JUL-2018 1348 NA NA NA NA
nse 2018-07-30 AKZOINDIA INE133A01011 1880.00 1880.00 1844.75 1855.70 6883 EQ 1855.00 1849.05 1.277140e+07 30-JUL-2018 580 NA NA NA NA
nse 2018-07-30 ALANKIT INE914E01040 24.15 26.30 24.05 25.95 1278350 EQ 26.00 23.95 3.228510e+07 30-JUL-2018 2447 NA NA NA NA
nse 2018-07-30 ALBERTDAVD INE155C01010 403.95 409.95 395.00 395.70 3795 EQ 395.00 399.25 1.522677e+06 30-JUL-2018 56 NA NA NA NA
nse 2018-07-30 ALBK INE428A01015 45.15 46.80 45.15 46.30 7498757 EQ 46.30 45.15 3.463866e+08 30-JUL-2018 14847 NA NA NA NA
nse 2018-07-30 ALCHEM INE964B01033 5.95 5.95 5.60 5.60 6874 BE 5.60 5.70 4.061680e+04 30-JUL-2018 22 NA NA NA NA
nse 2018-07-30 ALEMBICLTD INE426A01027 40.00 41.80 39.75 40.95 493225 EQ 40.85 39.80 2.014399e+07 30-JUL-2018 2415 NA NA NA NA
nse 2018-07-30 ALICON INE062D01024 639.95 645.00 607.00 617.95 2078 EQ 617.95 624.50 1.284914e+06 30-JUL-2018 153 NA NA NA NA
nse 2018-07-30 ALKALI INE773I01017 65.50 67.85 64.60 66.55 3038 EQ 66.55 66.45 2.029271e+05 30-JUL-2018 82 NA NA NA NA
nse 2018-07-30 ALKEM INE540L01014 2122.00 2139.00 2098.05 2116.40 261985 EQ 2129.00 2116.60 5.540774e+08 30-JUL-2018 7778 NA NA NA NA
nse 2018-07-30 ALKYLAMINE INE150B01021 693.15 697.00 682.50 692.20 1201 EQ 692.00 693.15 8.337238e+05 30-JUL-2018 55 NA NA NA NA
nse 2018-07-30 ALLCARGO INE418H01029 118.75 121.90 118.05 118.95 372904 EQ 119.20 117.75 4.483879e+07 30-JUL-2018 3970 NA NA NA NA
nse 2018-07-30 ALLSEC INE835G01018 265.05 276.00 260.15 272.40 7182 EQ 270.10 269.45 1.926616e+06 30-JUL-2018 223 NA NA NA NA
nse 2018-07-30 ALMONDZ INE326B01027 28.20 29.50 28.15 28.60 1516 EQ 28.55 29.50 4.298780e+04 30-JUL-2018 13 NA NA NA NA
nse 2018-07-30 ALOKTEXT INE270A01011 4.20 4.20 4.20 4.20 1601372 BE 4.20 4.00 6.725762e+06 30-JUL-2018 722 NA NA NA NA
nse 2018-07-30 ALPA INE385I01010 26.40 26.40 25.70 26.05 6598 EQ 26.00 25.80 1.718095e+05 30-JUL-2018 46 NA NA NA NA
nse 2018-07-30 ALPHAGEO INE137C01018 682.00 696.00 682.00 686.40 3762 EQ 688.60 685.90 2.580360e+06 30-JUL-2018 305 NA NA NA NA
nse 2018-07-30 ALPSINDUS INE093B01015 2.55 2.60 2.45 2.50 7666 BE 2.50 2.55 1.951010e+04 30-JUL-2018 18 NA NA NA NA
nse 2018-07-30 AMARAJABAT INE885A01032 800.00 812.45 794.30 805.50 622226 EQ 810.00 792.35 5.017608e+08 30-JUL-2018 15702 NA NA NA NA
nse 2018-07-30 AMBANIORG INE00C501018 66.25 66.50 66.25 66.25 22000 ST 0.00 66.25 1.458500e+06 30-JUL-2018 11 NA NA NA NA
nse 2018-07-30 AMBER INE371P01015 950.00 960.05 945.00 950.70 3521 EQ 945.00 949.85 3.361551e+06 30-JUL-2018 422 NA NA NA NA
nse 2018-07-30 AMBIKCO INE540G01014 1276.00 1297.45 1265.05 1274.10 1553 EQ 1275.00 1275.55 1.977628e+06 30-JUL-2018 166 NA NA NA NA
nse 2018-07-30 AMBUJACEM INE079A01024 225.50 228.45 222.95 227.00 2775674 EQ 226.85 225.10 6.274888e+08 30-JUL-2018 32391 NA NA NA NA
nse 2018-07-30 AMDIND INE005I01014 20.30 21.80 20.15 21.80 11892 EQ 21.80 20.80 2.511911e+05 30-JUL-2018 43 NA NA NA NA
nse 2018-07-30 AMJLAND INE606A01024 28.50 28.50 27.50 27.60 88114 EQ 27.65 27.95 2.462731e+06 30-JUL-2018 480 NA NA NA NA
nse 2018-07-30 AMRUTANJAN INE098F01031 276.85 276.85 270.00 270.90 3876 EQ 270.30 272.85 1.052170e+06 30-JUL-2018 150 NA NA NA NA
nse 2018-07-30 AMTEKAUTO INE130C01021 8.60 8.60 8.60 8.60 61691 BZ 8.60 8.20 5.305426e+05 30-JUL-2018 161 NA NA NA NA
nse 2018-07-30 ANANTRAJ INE242C01024 41.10 41.95 40.60 41.70 317293 EQ 41.55 41.25 1.309536e+07 30-JUL-2018 1425 NA NA NA NA
nse 2018-07-30 ANDHRABANK INE434A01013 33.30 36.05 33.30 35.65 10899650 EQ 35.65 33.30 3.797003e+08 30-JUL-2018 20845 NA NA NA NA
nse 2018-07-30 ANDHRACEMT INE666E01012 9.00 9.30 8.80 8.90 94050 EQ 9.10 9.10 8.504762e+05 30-JUL-2018 226 NA NA NA NA
nse 2018-07-30 ANDHRSUGAR INE715B01013 376.00 397.00 376.00 383.15 108821 EQ 381.95 357.85 4.191143e+07 30-JUL-2018 2503 NA NA NA NA
nse 2018-07-30 ANGIND INE017D01010 2.70 2.90 2.70 2.90 5532 BE 2.90 2.80 1.509440e+04 30-JUL-2018 17 NA NA NA NA
nse 2018-07-30 ANIKINDS INE087B01017 32.20 32.20 32.20 32.20 2470 EQ 32.20 30.70 7.953400e+04 30-JUL-2018 16 NA NA NA NA
nse 2018-07-30 ANKITMETAL INE106I01010 0.60 0.65 0.55 0.60 77497 BE 0.60 0.55 4.348340e+04 30-JUL-2018 59 NA NA NA NA
nse 2018-07-30 ANSALAPI INE436A01026 15.60 16.80 15.60 16.40 62666 EQ 16.50 15.90 1.021849e+06 30-JUL-2018 204 NA NA NA NA
nse 2018-07-30 ANSALHSG INE880B01015 15.20 15.45 14.75 15.35 19626 EQ 15.30 15.10 2.990710e+05 30-JUL-2018 107 NA NA NA NA
nse 2018-07-30 ANTGRAPHIC INE414B01021 0.50 0.60 0.50 0.60 63902 BE 0.60 0.55 3.610610e+04 30-JUL-2018 35 NA NA NA NA
nse 2018-07-30 APARINDS INE372A01015 618.30 620.00 612.90 615.25 22657 EQ 615.00 620.70 1.395019e+07 30-JUL-2018 1900 NA NA NA NA
nse 2018-07-30 APCL INE071F01012 152.15 161.95 152.10 158.05 2410 EQ 158.05 153.45 3.821832e+05 30-JUL-2018 107 NA NA NA NA
nse 2018-07-30 APCOTEXIND INE116A01024 570.00 578.00 561.95 564.50 19053 EQ 562.10 555.95 1.081416e+07 30-JUL-2018 964 NA NA NA NA
nse 2018-07-30 APEX INE346W01013 413.90 414.00 396.05 401.35 94913 EQ 401.80 412.80 3.832211e+07 30-JUL-2018 2555 NA NA NA NA
nse 2018-07-30 APLAPOLLO INE702C01019 1643.60 1645.75 1603.00 1606.40 6847 EQ 1603.00 1634.30 1.111856e+07 30-JUL-2018 864 NA NA NA NA
nse 2018-07-30 APLLTD INE901L01018 573.05 575.00 553.00 557.00 101185 EQ 555.35 570.50 5.639731e+07 30-JUL-2018 4657 NA NA NA NA
nse 2018-07-30 APOLLO INE713T01010 147.25 158.65 147.00 155.30 38304 EQ 154.60 149.10 5.917534e+06 30-JUL-2018 1024 NA NA NA NA
nse 2018-07-30 APOLLOHOSP INE437A01024 940.00 941.00 910.10 931.45 1201433 EQ 935.90 933.85 1.109562e+09 30-JUL-2018 40246 NA NA NA NA
nse 2018-07-30 APOLLOTYRE INE438A01022 289.90 293.00 286.05 289.45 2175750 EQ 289.65 290.40 6.302107e+08 30-JUL-2018 21552 NA NA NA NA
nse 2018-07-30 APOLSINHOT INE451F01016 1292.00 1380.00 1292.00 1335.20 521 EQ 1340.00 1300.00 7.077198e+05 30-JUL-2018 117 NA NA NA NA
nse 2018-07-30 APTECHT INE266F01018 250.35 255.25 243.65 251.30 294144 EQ 252.20 250.35 7.311603e+07 30-JUL-2018 4313 NA NA NA NA
nse 2018-07-30 ARCHIDPLY INE877I01016 59.00 60.00 56.70 58.80 5291 EQ 59.00 58.30 3.107941e+05 30-JUL-2018 168 NA NA NA NA
nse 2018-07-30 ARCHIES INE731A01020 28.70 29.40 28.25 29.40 55266 EQ 29.40 28.00 1.611793e+06 30-JUL-2018 340 NA NA NA NA
nse 2018-07-30 ARCOTECH INE574I01035 12.80 13.50 12.80 13.40 165043 EQ 13.45 12.95 2.196752e+06 30-JUL-2018 577 NA NA NA NA
nse 2018-07-30 ARIES INE298I01015 108.00 118.65 107.05 117.05 43669 EQ 117.60 109.40 5.020718e+06 30-JUL-2018 1170 NA NA NA NA
nse 2018-07-30 ARIHANT INE413D01011 35.05 36.95 34.20 35.05 4210 EQ 35.10 36.00 1.481625e+05 30-JUL-2018 43 NA NA NA NA
nse 2018-07-30 ARIHANTSUP INE643K01018 66.70 68.10 64.35 66.40 93356 EQ 64.55 66.30 6.227252e+06 30-JUL-2018 3588 NA NA NA NA
nse 2018-07-30 ARMANFIN INE109C01017 365.05 376.00 365.05 374.85 1382 EQ 375.45 370.00 5.133201e+05 30-JUL-2018 39 NA NA NA NA
nse 2018-07-30 AROGRANITE INE210C01013 55.65 61.35 55.65 58.15 76218 EQ 58.60 56.20 4.526733e+06 30-JUL-2018 502 NA NA NA NA
nse 2018-07-30 ARROWGREEN INE570D01018 184.00 184.00 168.05 184.00 199041 EQ 184.00 175.25 3.585888e+07 30-JUL-2018 3142 NA NA NA NA
nse 2018-07-30 ARROWTEX INE933J01015 28.00 29.10 28.00 28.95 9698 EQ 29.10 28.10 2.777823e+05 30-JUL-2018 68 NA NA NA NA
nse 2018-07-30 ARSHIYA INE968D01022 60.95 60.95 58.35 58.90 15217 EQ 59.00 58.15 9.029771e+05 30-JUL-2018 161 NA NA NA NA
nse 2018-07-30 ARSSINFRA INE267I01010 24.45 24.65 24.45 24.65 3404 BE 24.65 23.50 8.388860e+04 30-JUL-2018 15 NA NA NA NA
nse 2018-07-30 ARVEE INE006Z01016 56.55 56.55 56.55 56.55 2000 SM 56.55 51.00 1.131000e+05 30-JUL-2018 1 NA NA NA NA
nse 2018-07-30 ARVIND INE034A01011 430.00 430.00 415.40 419.65 2005209 EQ 421.00 426.15 8.415841e+08 30-JUL-2018 47135 NA NA NA NA
nse 2018-07-30 ARVSMART INE034S01021 177.10 178.45 171.60 174.10 9494 EQ 173.45 178.80 1.666557e+06 30-JUL-2018 260 NA NA NA NA
nse 2018-07-30 ASAHIINDIA INE439A01020 330.95 335.95 329.15 331.95 33767 EQ 331.00 329.00 1.121817e+07 30-JUL-2018 678 NA NA NA NA
nse 2018-07-30 ASAHISONG INE228I01012 264.60 283.45 262.00 266.65 30352 EQ 266.90 249.95 8.140344e+06 30-JUL-2018 995 NA NA NA NA
nse 2018-07-30 ASAL INE900C01027 59.00 62.60 58.10 58.70 95500 EQ 58.10 58.45 5.801355e+06 30-JUL-2018 1396 NA NA NA NA
nse 2018-07-30 ASHAPURMIN INE348A01023 44.05 44.70 43.40 43.60 61122 EQ 43.50 43.75 2.680395e+06 30-JUL-2018 531 NA NA NA NA
nse 2018-07-30 ASHIANA INE365D01021 132.00 133.45 130.05 130.75 29700 EQ 130.75 131.80 3.904705e+06 30-JUL-2018 703 NA NA NA NA
nse 2018-07-30 ASHIMASYN INE440A01010 23.00 23.40 22.65 22.75 36940 EQ 22.65 22.80 8.440248e+05 30-JUL-2018 194 NA NA NA NA
nse 2018-07-30 ASHOKA INE442H01029 150.00 152.55 149.50 151.00 563940 EQ 150.10 148.95 8.515299e+07 30-JUL-2018 1399 NA NA NA NA
nse 2018-07-30 ASHOKLEY INE208A01029 112.95 114.70 111.70 113.00 22155360 EQ 112.90 112.85 2.509408e+09 30-JUL-2018 93022 NA NA NA NA
nse 2018-07-30 ASIANHOTNR INE363A01022 225.00 239.95 213.05 230.30 1122 EQ 237.95 231.45 2.573745e+05 30-JUL-2018 59 NA NA NA NA
nse 2018-07-30 ASIANPAINT INE021A01026 1434.25 1451.85 1427.00 1430.20 750392 EQ 1430.00 1434.85 1.080853e+09 30-JUL-2018 34298 NA NA NA NA
nse 2018-07-30 ASIANTILES INE022I01019 302.80 304.75 299.00 303.05 24878 EQ 303.50 301.95 7.508989e+06 30-JUL-2018 722 NA NA NA NA
nse 2018-07-30 ASPINWALL INE991I01015 254.00 269.85 254.00 264.00 3248 EQ 264.00 253.20 8.463372e+05 30-JUL-2018 86 NA NA NA NA
nse 2018-07-30 ASSAMCO INE442A01024 3.55 3.65 3.50 3.65 267820 EQ 3.65 3.50 9.718268e+05 30-JUL-2018 136 NA NA NA NA
nse 2018-07-30 ASTEC INE563J01010 663.00 675.00 636.25 644.90 25013 EQ 644.50 657.65 1.634821e+07 30-JUL-2018 1018 NA NA NA NA
nse 2018-07-30 ASTERDM INE914M01019 170.00 174.15 169.35 170.45 33496 EQ 170.25 169.50 5.716531e+06 30-JUL-2018 1139 NA NA NA NA
nse 2018-07-30 ASTRAL INE006I01046 1118.50 1169.00 1100.00 1111.55 88424 EQ 1104.00 1118.50 1.014776e+08 30-JUL-2018 10736 NA NA NA NA
nse 2018-07-30 ASTRAMICRO INE386C01029 103.70 106.30 101.70 105.05 594468 EQ 105.00 102.35 6.207435e+07 30-JUL-2018 5293 NA NA NA NA
nse 2018-07-30 ASTRAZEN INE203A01020 1501.15 1545.00 1500.00 1523.65 15085 EQ 1524.00 1509.00 2.297640e+07 30-JUL-2018 1595 NA NA NA NA
nse 2018-07-30 ASTRON INE646X01014 106.95 109.50 106.10 109.10 122261 EQ 109.05 105.35 1.326350e+07 30-JUL-2018 1205 NA NA NA NA
nse 2018-07-30 ATFL INE209A01019 636.40 648.00 625.00 633.90 21961 EQ 633.95 642.85 1.392010e+07 30-JUL-2018 882 NA NA NA NA
nse 2018-07-30 ATLANTA INE285H01022 41.90 41.90 41.90 41.90 13633 EQ 41.90 44.10 5.712227e+05 30-JUL-2018 122 NA NA NA NA
nse 2018-07-30 ATLASCYCLE INE446A01025 138.00 139.90 132.50 137.75 4845 BE 137.80 135.80 6.675023e+05 30-JUL-2018 75 NA NA NA NA
nse 2018-07-30 ATUL INE100A01010 2751.00 2769.95 2716.00 2740.05 5760 EQ 2738.00 2740.70 1.579626e+07 30-JUL-2018 844 NA NA NA NA
nse 2018-07-30 ATULAUTO INE951D01028 400.00 406.75 393.00 399.15 9636 EQ 399.00 407.25 3.851461e+06 30-JUL-2018 724 NA NA NA NA
nse 2018-07-30 AUBANK INE949L01017 636.40 644.80 636.40 640.25 1824310 EQ 641.50 636.40 1.167622e+09 30-JUL-2018 3859 NA NA NA NA
nse 2018-07-30 AURIONPRO INE132H01018 195.00 201.00 195.00 199.35 6817 EQ 200.95 196.80 1.356110e+06 30-JUL-2018 215 NA NA NA NA
nse 2018-07-30 AUROPHARMA INE406A01037 591.00 607.80 587.00 603.90 1739240 EQ 604.50 591.05 1.045954e+09 30-JUL-2018 32620 NA NA NA NA
nse 2018-07-30 AUSOMENT INE218C01016 74.35 74.40 71.15 71.50 2697 EQ 71.30 72.45 1.945751e+05 30-JUL-2018 80 NA NA NA NA
nse 2018-07-30 AUTOAXLES INE449A01011 1203.00 1234.80 1203.00 1224.05 8596 EQ 1225.00 1210.95 1.052346e+07 30-JUL-2018 654 NA NA NA NA
nse 2018-07-30 AUTOIND INE718H01014 69.00 71.00 66.50 68.95 20283 EQ 69.50 66.70 1.393194e+06 30-JUL-2018 475 NA NA NA NA
nse 2018-07-30 AUTOLITIND INE448A01013 57.20 57.90 55.30 56.55 5517 EQ 56.50 56.90 3.147478e+05 30-JUL-2018 103 NA NA NA NA
nse 2018-07-30 AVADHSUGAR INE349W01017 297.80 315.05 297.80 310.80 23787 EQ 312.75 297.75 7.326575e+06 30-JUL-2018 925 NA NA NA NA
nse 2018-07-30 AVANTIFEED INE871C01038 443.00 459.00 441.00 456.10 585262 EQ 457.00 443.55 2.653451e+08 30-JUL-2018 20308 NA NA NA NA
nse 2018-07-30 AVONMPL INE652Z01017 51.40 52.50 51.40 51.95 4000 ST 0.00 54.00 2.078000e+05 30-JUL-2018 2 NA NA NA NA
nse 2018-07-30 AVTNPL INE488D01021 31.85 32.45 31.80 31.95 53755 EQ 31.90 31.85 1.726522e+06 30-JUL-2018 509 NA NA NA NA
nse 2018-07-30 AXISBANK INE238A01034 556.05 571.20 550.80 569.65 12949737 EQ 569.00 553.25 7.295951e+09 30-JUL-2018 143343 NA NA NA NA
nse 2018-07-30 AXISCADES INE555B01013 114.95 118.40 114.15 116.25 54805 EQ 116.60 114.50 6.387459e+06 30-JUL-2018 899 NA NA NA NA
nse 2018-07-30 AXISGOLD INF846K01347 2649.00 2649.00 2635.00 2640.00 51 EQ 2640.00 2636.00 1.346982e+05 30-JUL-2018 13 NA NA NA NA
nse 2018-07-30 AXISNIFTY INF846K01ZL0 1137.54 1142.27 1137.22 1142.27 534 EQ 1142.27 1137.54 6.079047e+05 30-JUL-2018 13 NA NA NA NA
nse 2018-07-30 AYMSYNTEX INE193B01039 45.15 46.40 45.10 45.85 31695 EQ 45.70 45.60 1.443706e+06 30-JUL-2018 54 NA NA NA NA
nse 2018-07-30 BAFNAPHARM INE878I01014 22.00 22.30 20.60 21.20 13540 EQ 21.20 21.70 2.913957e+05 30-JUL-2018 124 NA NA NA NA
nse 2018-07-30 BAGFILMS INE116D01028 4.60 4.60 4.35 4.40 88812 EQ 4.40 4.50 3.903090e+05 30-JUL-2018 80 NA NA NA NA
nse 2018-07-30 BAJAJ-AUTO INE917I01010 2686.95 2699.00 2655.50 2673.15 546935 EQ 2668.95 2686.75 1.463922e+09 30-JUL-2018 35726 NA NA NA NA
nse 2018-07-30 BAJAJCORP INE933K01021 410.00 416.35 407.05 408.60 24896 EQ 408.40 404.95 1.020222e+07 30-JUL-2018 2372 NA NA NA NA
nse 2018-07-30 BAJAJELEC INE193E01025 608.80 618.70 595.30 608.55 623883 EQ 607.65 609.30 3.788243e+08 30-JUL-2018 17948 NA NA NA NA
nse 2018-07-30 BAJAJFINSV INE918I01018 6964.00 6978.65 6861.05 6895.85 121952 EQ 6908.00 6927.20 8.426350e+08 30-JUL-2018 13165 NA NA NA NA
nse 2018-07-30 BAJAJHIND INE306A01021 6.65 6.70 6.60 6.65 681548 EQ 6.65 6.60 4.542085e+06 30-JUL-2018 1592 NA NA NA NA
nse 2018-07-30 BAJAJHLDNG INE118A01012 2990.95 2990.95 2936.15 2945.85 10130 EQ 2938.00 2991.40 2.992309e+07 30-JUL-2018 1543 NA NA NA NA
nse 2018-07-30 BAJFINANCE INE296A01024 2715.55 2722.60 2666.00 2678.00 822162 EQ 2674.10 2713.70 2.208425e+09 30-JUL-2018 38160 NA NA NA NA
nse 2018-07-30 BALAJITELE INE794B01026 117.30 118.60 115.50 117.45 41469 EQ 118.50 116.55 4.873826e+06 30-JUL-2018 541 NA NA NA NA
nse 2018-07-30 BALAMINES INE050E01027 567.55 588.00 559.95 580.75 81515 EQ 577.35 556.90 4.691877e+07 30-JUL-2018 3903 NA NA NA NA
nse 2018-07-30 BALAXI INE618N01014 15.45 15.45 15.45 15.45 100 BE 15.45 14.75 1.545000e+03 30-JUL-2018 1 NA NA NA NA
nse 2018-07-30 BALKRISHNA INE875R01011 69.00 70.00 67.10 69.10 15623 EQ 69.90 67.75 1.072012e+06 30-JUL-2018 97 NA NA NA NA
nse 2018-07-30 BALKRISIND INE787D01026 1190.20 1211.00 1170.20 1201.95 386601 EQ 1197.00 1187.30 4.606456e+08 30-JUL-2018 16910 NA NA NA NA
nse 2018-07-30 BALLARPUR INE294A01037 9.30 9.70 9.25 9.60 590394 EQ 9.65 9.25 5.608242e+06 30-JUL-2018 793 NA NA NA NA
nse 2018-07-30 BALMLAWRIE INE164A01016 222.10 225.00 220.30 221.85 88143 EQ 221.50 220.70 1.956028e+07 30-JUL-2018 2144 NA NA NA NA
nse 2018-07-30 BALPHARMA INE083D01012 74.00 77.55 71.75 76.90 70722 EQ 76.95 72.85 5.348753e+06 30-JUL-2018 548 NA NA NA NA
nse 2018-07-30 BALRAMCHIN INE119A01028 71.00 73.75 69.65 72.65 3796960 EQ 73.30 70.75 2.708468e+08 30-JUL-2018 14669 NA NA NA NA
nse 2018-07-30 BANARBEADS INE655B01011 49.70 50.00 49.00 49.50 1421 EQ 49.55 49.70 7.017760e+04 30-JUL-2018 31 NA NA NA NA
nse 2018-07-30 BANARISUG INE459A01010 1450.00 1450.00 1427.00 1440.00 423 EQ 1440.00 1434.00 6.088199e+05 30-JUL-2018 40 NA NA NA NA
nse 2018-07-30 BANCOINDIA INE213C01025 206.75 208.20 205.55 206.95 24037 EQ 207.00 204.90 4.973453e+06 30-JUL-2018 475 NA NA NA NA
nse 2018-07-30 BANDHANBNK INE545U01014 690.40 707.95 685.95 690.00 769600 EQ 688.15 687.05 5.336840e+08 30-JUL-2018 26616 NA NA NA NA
nse 2018-07-30 BANG INE863I01016 53.00 54.50 52.75 53.40 22080 EQ 53.15 52.90 1.181667e+06 30-JUL-2018 202 NA NA NA NA
nse 2018-07-30 BANKBARODA INE028A01039 149.00 153.30 144.65 152.05 69716569 EQ 152.15 137.85 1.044252e+10 30-JUL-2018 290113 NA NA NA NA
nse 2018-07-30 BANKBEES INF732E01078 2818.50 2841.40 2807.49 2839.96 37030 EQ 2839.70 2808.01 1.048319e+08 30-JUL-2018 198 NA NA NA NA
nse 2018-07-30 BANKINDIA INE084A01016 99.00 104.15 98.85 103.25 15015297 EQ 103.15 97.80 1.531894e+09 30-JUL-2018 49413 NA NA NA NA
nse 2018-07-30 BANSAL INE668X01018 119.80 119.80 113.00 115.65 55000 SM 115.90 113.45 6.361250e+06 30-JUL-2018 28 NA NA NA NA
nse 2018-07-30 BANSWRAS INE629D01012 86.00 87.35 84.10 85.30 1206 EQ 85.55 86.05 1.031751e+05 30-JUL-2018 48 NA NA NA NA
nse 2018-07-30 BARTRONICS INE855F01034 9.10 9.50 8.95 9.40 19786 EQ 9.50 9.05 1.833786e+05 30-JUL-2018 72 NA NA NA NA
nse 2018-07-30 BASF INE373A01013 1809.00 1840.00 1746.15 1757.35 9397 EQ 1755.00 1798.10 1.684381e+07 30-JUL-2018 1385 NA NA NA NA
nse 2018-07-30 BASML INE186H01014 218.70 222.00 217.00 221.95 2361 EQ 221.95 218.95 5.164130e+05 30-JUL-2018 10 NA NA NA NA
nse 2018-07-30 BATAINDIA INE176A01028 915.00 925.00 906.00 918.25 550530 EQ 916.45 916.30 5.046857e+08 30-JUL-2018 13869 NA NA NA NA
nse 2018-07-30 BAYERCROP INE462A01022 4498.95 4525.00 4470.00 4488.25 8218 EQ 4500.00 4498.75 3.683831e+07 30-JUL-2018 2120 NA NA NA NA
nse 2018-07-30 BBL INE464A01028 1210.10 1236.40 1188.90 1194.40 17001 EQ 1219.90 1198.35 2.044659e+07 30-JUL-2018 716 NA NA NA NA
nse 2018-07-30 BBTC INE050A01025 1537.85 1578.00 1514.45 1555.30 191521 EQ 1555.00 1528.20 2.976369e+08 30-JUL-2018 7386 NA NA NA NA
nse 2018-07-30 BDL INE171Z01018 342.10 384.55 342.10 375.70 95982 EQ 373.90 342.35 3.495214e+07 30-JUL-2018 3577 NA NA NA NA
nse 2018-07-30 BEARDSELL INE520H01022 40.95 41.00 38.60 40.45 1289 EQ 40.45 40.40 4.993115e+04 30-JUL-2018 16 NA NA NA NA
nse 2018-07-30 BEDMUTHA INE844K01012 19.00 20.10 18.75 20.00 12463 EQ 19.60 19.15 2.447100e+05 30-JUL-2018 59 NA NA NA NA
nse 2018-07-30 BEL INE263A01024 103.00 108.80 102.65 107.80 14056081 EQ 108.00 102.50 1.502094e+09 30-JUL-2018 71497 NA NA NA NA
nse 2018-07-30 BEML INE258A01016 826.95 905.40 826.00 897.10 4816769 EQ 900.65 820.60 4.238993e+09 30-JUL-2018 118257 NA NA NA NA


A note on defaults

Except the date parameters, one rarely has to tweak the defaults. The defaults are designed to work optimally.

Let’s look at the data

Let’s see how well Larsen and Toubro has performed in NSE in the last few days.

df_updated %>% 
  filter(symbol == "LT",
         exchange == "nse") %>% 
  ggplot(aes(date, close)) +
  geom_line() +
  theme_light()

Bugs, comments, suggestions and feature requests

This is just an initial version of the package and I expect to see a few bugs. I’d be very happy if you create github issues if you run into anything. Suggestions and feature requests welcome. Feel free to comment what you think of the package.

Thanks for reading! Cheers!

comments powered by Disqus