<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="http://www.r-bloggers.com/candlestick-charts-using-quandl-and-plotly/"></div></div><div><a data-url="http://www.r-bloggers.com/candlestick-charts-using-quandl-and-plotly/" data-counturl="http://www.r-bloggers.com/candlestick-charts-using-quandl-and-plotly/" data-count="horizontal" data-text="Candlestick charts using Quandl and Plotly" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://moderndata.plot.ly/candlestick-charts-using-quandl-and-plotly/"> R – Modern Data</a></strong>, and kindly contributed to <a rel="nofollow" href="http://www.r-bloggers.com/">R-bloggers)</a> </div>
<p>In this post we’ll show how to create candle stick charts using the new <strong>plotly 4.0</strong> syntax. You can refer to <a target="_blank" href="http://moderndata.plot.ly/candlestick-charts-using-plotly-and-quantmod/">this older post</a> as well.</p>
<p>This time we’ll use the <strong>Quandl</strong> package to retrieve stock data. See <a target="_blank" href="https://www.quandl.com/tools/r">here</a> for more details.</p>
<div>
<pre>install.packages(&quot;Quandl&quot;)
library(Quandl)
df &lt;- Quandl(&quot;WIKI/AAPL&quot;)
df &lt;- df[,c(1, 9:12)]

names(df) &lt;- c(&quot;Date&quot;, &quot;Open&quot;, &quot;High&quot;, &quot;Low&quot;, &quot;Close&quot;)
df$Date &lt;- as.Date(df$Date)

df &lt;- df[1:1000,]

hovertxt &lt;- Map(function(x, y)paste0(x, &quot;:&quot;, y), names(df), df)
hovertxt &lt;- Reduce(function(x, y)paste0(x, &quot;&lt;br&amp;gt;&quot;, y), hovertxt)

plot_ly(df, x = ~Date, xend = ~Date, hoverinfo = &quot;none&quot;,
        color = ~Close > Open, colors = c(&quot;#00b386&quot;,&quot;#ff6666&quot;)) %>%
  
  add_segments(y = ~Low, yend = ~High, line = list(width = 1, color = &quot;black&quot;)) %>%
  
  add_segments(y = ~Open, yend = ~Close, line = list(width = 3)) %>%
  
  add_markers(y = ~(Low + High)/2, hoverinfo = &quot;text&quot;,
              text = hovertxt, marker = list(color = &quot;transparent&quot;)) %>% 
  
  layout(showlegend = FALSE, 
         color = &quot;white&quot;,
         yaxis = list(title = &quot;Price&quot;, domain = c(0, 0.9)),
         annotations = list(
           list(xref = &quot;paper&quot;, yref = &quot;paper&quot;, 
                x = 0, y = 1, showarrow = F, 
                xanchor = &quot;left&quot;, yanchor = &quot;top&quot;,
                align = &quot;left&quot;,
                text = paste0(&quot;&lt;b>AAPL&lt;/b>&quot;)),
           
           list(xref = &quot;paper&quot;, yref = &quot;paper&quot;, 
                x = 0.75, y = 1, showarrow = F, 
                xanchor = &quot;left&quot;, yanchor = &quot;top&quot;,
                align = &quot;left&quot;,
                text = paste(range(df$Date), collapse = &quot; : &quot;),
                font = list(size = 8))),
         plot_bgcolor = &quot;#f2f2f2&quot;)</pre>

<p><iframe height="600" width="1024" src="https://plot.ly/~riddhiman/373.embed"></iframe></p>
<p><div><div><div><div data-width="55" data-show-faces="false" data-send="true" data-layout="box_count" data-height="62" data-href="http://www.r-bloggers.com/candlestick-charts-using-quandl-and-plotly/"></div></div><div><a data-url="http://www.r-bloggers.com/candlestick-charts-using-quandl-and-plotly/" data-counturl="http://www.r-bloggers.com/candlestick-charts-using-quandl-and-plotly/" data-count="vertical" data-text="Candlestick charts using Quandl and Plotly" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://moderndata.plot.ly/candlestick-charts-using-quandl-and-plotly/"> R – Modern Data</a></strong>.</div>
<hr>
<a rel="nofollow" href="http://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="http://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a title="The R Project for Statistical Computing" rel="nofollow" href="http://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="http://www.r-bloggers.com/?s=tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="http://www.r-bloggers.com/?s=data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="http://www.r-bloggers.com/?s=Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="http://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="http://www.r-bloggers.com/?s=ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="http://www.r-bloggers.com/?s=boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="http://www.r-bloggers.com/?s=map">maps</a>, <a title="Animation in R" rel="nofollow" href="http://www.r-bloggers.com/?s=animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="http://www.r-bloggers.com/?s=RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="http://www.r-bloggers.com/?s=sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="http://www.r-bloggers.com/?s=LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="http://www.r-bloggers.com/?s=SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="http://www.r-bloggers.com/?s=eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="http://www.r-bloggers.com/?s=git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="http://www.r-bloggers.com/?s=hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="http://www.r-bloggers.com/?s=Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="http://www.r-bloggers.com/?s=regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="http://www.r-bloggers.com/?s=PCA">PCA</a>, <a title="Time series" rel="nofollow" href="http://www.r-bloggers.com/?s=time+series">time series</a>, <a title="finance trading" rel="nofollow" href="http://www.r-bloggers.com/?s=trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/5l8RNJJPb1s"></a></div></div>