<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/reading-a-table-from-yahoo-finance/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://www.copula.de/2016/12/reading-table-from-yahoo-finance.html"> Copula</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<p>As you know, the composition of an Index changes over time and this scipt takes the Yahoo Finance page and retrieves all individual stock symbols for you and stores it in the tickers object.</p>
<p>I had to update my R-Version to use the RCurl package – this is required as it is a https:// connection we would like to use.</p>
<p>I was surprised how easy it is to parse the xml page and retrieve all the tables on the page.</p>
<p><a name="more"></a></p>
<p>In this little example we are interested in retrieving all symbols of the DAX (30 largest listed companies in Germany) from this link https://de.finance.yahoo.com/q/cp?s=^GDAXI</p>
<p>It is the table 5 which holds the relevant data for us  – it is completely transparent to the user and I enjoyed using the XML – Package. </p>
<p><span>library(XML)</span><br><span>library(RCurl)</span><br><span><br></span><span>universum &lt;-function()</span><br><span>{</span><br><span>  world=c(“^GDAXI”,”^MDAXI”,”^SDAXI”,”^TECDAX”)</span><br><span>  my=NA</span><br><span>  for(i in 1:NROW(world)) {</span><br><span>    url=paste(“https://de.finance.yahoo.com/q/cp?s=”,world[[i]],sep = “”)</span><br><span>    s &lt;- getURL(url)  #rcurl package</span><br><span>    t=readHTMLTable(s)</span><br><span>    t=t[[5]]</span><br><span>    t = t[-(1:5), ]</span><br><span>    newtickers=t[,1]</span><br><span>    a=NROW(my)</span><br><span>    b=NROW(newtickers)</span><br><span>    my[a+1:b]=as.character(newtickers)</span><br><span>    </span><br><span>  }</span><br><span>  my = my[-1]</span><br><span>  tickers=my</span><br><span>  rm(t)</span><br><span>  rm(a)</span><br><span>  rm(b)</span><br><span>  rm(i)</span><br><span>  rm(my)</span><br><span>  rm(newtickers)</span><br><span>  return(tickers)</span><br><span>}</span></p>
<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://www.copula.de/2016/12/reading-table-from-yahoo-finance.html"> Copula</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://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="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/search/data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/search/map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/search/animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/search/sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/search/SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/search/git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/search/hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/search/PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/search/time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/search/trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/kwKuNmIYIqM"></a></div>