<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/datacamp-course-importing-and-managing-financial-data/"></div></div><div><a data-url="http://www.r-bloggers.com/datacamp-course-importing-and-managing-financial-data/" data-counturl="http://www.r-bloggers.com/datacamp-course-importing-and-managing-financial-data/" data-count="horizontal" data-text="DataCamp course: Importing and managing financial data" 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://blog.fosstrading.com/2016/06/importing-and-managing-financial-data.html"> FOSS Trading</a></strong>, and kindly contributed to <a rel="nofollow" href="http://www.r-bloggers.com/">R-bloggers)</a> </div>
<p>The team at <a target="_blank" href="https://www.datacamp.com/">DataCamp</a> announced a new R/Finance course series in a recent email:<br>
<blockquote>Subject: Data Mining Tutorial, R/Finance course series, and more!
<p><b>R/Finance – A new course series in the works</b><br>We are working on a whole new course series on applied finance using R. This new series will cover topics such as time series (David S. Matteson), portfolio analysis (Kris Boudt), the xts and zoo packages (Jeffrey Ryan), and much more. Start our first course <a target="_blank" href="https://www.datacamp.com/courses/introduction-to-credit-risk-modeling-in-r">Intro to Credit Risk Modeling in R</a> today. </p></blockquote>
<p>I’m excited to announce that I’m working on a course for this new series! It will provide an introduction to importing and managing financial data.</p>
<p>If you’ve ever done anything with financial or economic time series, you know the data come in various shapes, sizes, and periodicities. Getting the data into R can be stressful and time-consuming, especially when you need to merge data from several different sources into one data set. This course will cover importing data from local files as well as from internet sources.</p>
<p>The tentative course outline is below. I’d really appreciate your feedback on what should be included in this introductory course! So let me know if I’ve omitted something, or if you think any of the topics are too advanced.</p>
<p><u>Introduction to importing and managing financial data</u>
<ol>
<li>Introduction and downloading data</li>
<ol>
<li><span>getSymbols</span> design overview, <span>Quandl</span></li>
<li>Finding and downloading data from internet sources</li>
<ol>
<li>E.g. <span>getSymbols.yahoo</span>, <span>getSymbols.FRED</span>, <span>Quandl</span></li>
</ol>
<li>Loading and transforming multiple instruments</li>
<li>Checking for errors (i.e. summary stats, visualizing)</li>
</ol>
<li>Managing data from multiple sources</li>
<ol>
<li>Setting per-instrument sources and default arguments</li>
<ol>
<li><span>setSymbolLookup</span>, <span>saveSymbolLookup</span>, <span>loadSymbolLookup</span>, <span>setDefaults</span></li>
</ol>
<li>Handling instruments names that clash or are not valid R object names</li>
</ol>
<li>Aligning data with different periodicities</li>
<ol>
<li>Making irregular data regular</li>
<li>Aggregating to lowest frequency</li>
<li>Combining monthly with daily</li>
<li>Combining daily with intraday</li>
</ol>
<li>Storing and updating data</li>
<ol>
<li>Creating an initial RData-backed storage</li>
<li>Adjusting financial time-series</li>
<li>Handling errors during update process</li>
</ol>
</ol>
<div></div>
<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/datacamp-course-importing-and-managing-financial-data/"></div></div><div><a data-url="http://www.r-bloggers.com/datacamp-course-importing-and-managing-financial-data/" data-counturl="http://www.r-bloggers.com/datacamp-course-importing-and-managing-financial-data/" data-count="vertical" data-text="DataCamp course: Importing and managing financial data" 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://blog.fosstrading.com/2016/06/importing-and-managing-financial-data.html"> FOSS Trading</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/otwQlof4aUQ"></a></div>