In this blog we will learn how to extract & analyze the Stock Market data using R!
Using quantmod package first we will extract the Stock data after that we will create some charts for analysis.
Quantmod – “Quantitative Financial Modeling and Trading Framework for R”!
R Package designed to assist the quantitative trader in the development, testing, and deployment of statistically based trading models. It has many features so check out its link.
Check out this blog for Quantmod getSymol R Shiny App – Link
R Packages Required:-
Extracting Stock Market Data–
Functions getSymbols: It load and manage data from Multiple Sources.
getSymbols(“SYMBOL”, src=”SOURCE” , from =”YYYY-MM-DD”, to = “YYYY-MM-DD”)
Some src methods are: yahoo, google, oanda etc.
In this blog we will first extract Bombay Stock Exchange Data using yahoo finance source. Bombay Stock Exchange Index/Symbol – BSESN
1) Analyze One Month Data of Bombay Stock Exchange-
library(quantmod) getSymbols("^BSESN",src="yahoo" , from ="2016-10-23", to = Sys.Date()) View(BSESN)
Here is the BSESN (xts Object) Output Data. Here you can see different columns having data for Open, High, Low, Close, Volume & Adjusted Stock Price.
High refers to the highest price of the stock touched the same day, Low refer to the lowest price the stock was traded on the same day, Close refers to the closing price of that particular stock and the Volume refer to the number of share traded that day.
As you can see in below chart there was huge dip after 8 Nov 2016, may be this is due to demonetization in India.
2) Analyze One Year Data of Bombay Stock Exchange-
getSymbols("^BSESN",src="yahoo" , from ="2015-10-23", to = Sys.Date()) chart_Series(BSESN,type = "candlesticks")
2) Complete Data of Bombay Stock Exchange–
It will provide you all data after 2007.
Quantmod has some other features. For more details, please visit this Link.
Happy Learning! Your feedback would be appreciated!Follow @shobhitsinghIN