The QuanDL Package

What is QuanDl about?

While looking for financial historical data for our projects, we might be interested to gather historical fundamental data for some companies.

QuanDl is a package available in R that will help is with this task.

You can find the source code at:

How to use the QuanDl package

How to install QuanDl in RStudio

You can install QuantMod in R with the following command:

# CRAN (stable)
install.packages("quantmod")

Using QuanDl in R

Query Historical Stock Information:

You can use QuanDl to query historical stocks information in R the following way:

First log your API key:

# Get your API key from quandl.com and include it on a 'config.yaml' file
vars = yaml.load_file("config.yml")
quandl_api = vars$config$quandl_api
 
# Add the key to the Quandl keychain
Quandl.api_key(quandl_api)

Your_Ticker <- 'KO'


df_quandl <- Quandl.datatable('SHARADAR/SF1',
                               ticker = Your_Ticker,
                               calendardate.gte='2000-12-31',
                               )

Now enhance the dataframe with a plotly graph:

plot_ly(df1_quandl, type = 'scatter', mode = 'lines') %>%
      add_trace(x = ~calendardate, y = ~ros*100, name='ROS') %>%
                    layout(title = '<b>Return on Sales<b>', xaxis = list(title = 'Date'), 
                 yaxis = list(title = 'ROS (%)'), legend = list(title=list(text='<b> Date </b>')))

Project example using QuanDl

I found PriceR really useful and have used it during the creation of this Shiny project:

https://github.com/JAlcocerT/R_Stocks/

Financial data in R - Dividend and Splits - QuantMod Getting started with PySpark