Importing and Managing Financial Data in R
Learn how to access financial data from local files as well as from internet sources.
Comience El Curso Gratis5 horas15 vídeos57 ejercicios
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.¿Entrenar a 2 o más personas?Pruebe DataCamp para empresas
Preferido por estudiantes en miles de empresas
Descripción del curso
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.
Empresas
¿Entrenar a 2 o más personas?
Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y másEn las siguientes pistas
Fundamentos de Finanzas en R
Ir a la pistaAnalista cuantitativo in R
Ir a la pista- 1
Introduction and Downloading Data
GratuitoA wealth of financial and economic data are available online. Learn how getSymbols() and Quandl() make it easy to access data from a variety of sources.
Welcome to the course!50 xpIntroducing getSymbols()100 xpData sources100 xpMake getSymbols() return the data it retrieves100 xpIntroduction to Quandl50 xpIntroducing Quandl()100 xpReturn data type100 xpFinding data from internet sources50 xpFind stock ticker from Yahoo Finance100 xpDownload exchange rate data from Oanda100 xpFind and import Unemployment Rate data from FRED100 xp - 2
Extracting and Transforming Data
You've learned how to import data from online sources, now it's time to see how to extract columns from the imported data. After you've learned how to extract columns from a single object, you will explore how to import, transform, and extract data from multiple instruments.
Extracting columns from financial time series50 xpExtract one column from one instrument100 xpExtract multiple columns from one instrument100 xpUse getPrice to extract other columns100 xpImporting and transforming multiple instruments50 xpUse Quandl to download quarterly returns data100 xpCombine many instruments into one object100 xpExtract the Close column from many instruments100 xp - 3
Managing Data from Multiple Sources
Learn how to simplify and streamline your workflow by taking advantage of the ability to customize default arguments to `getSymbols()`. You will see how to customize defaults by data source, and then how to customize defaults by symbol. You will also learn how to handle problematic instrument symbols.
Setting default arguments for getSymbols()50 xpSet a default data source100 xpSet default arguments for a getSymbols source100 xpSetting per-instrument default arguments50 xpSet default data source for one symbol100 xpSave and load symbol lookup table100 xpHow *not* to specify the getSymbols() source50 xpHandling instrument symbols that clash or are not valid R names50 xpAccess the object using get() or backticks100 xpCreate valid name for one instrument100 xpCreate valid names for multiple instruments100 xp - 4
Aligning Data with Different Periodicities
You've learned how to import, extract, and transform data from multiple data sources. You often have to manipulate data from different sources in order to combine them into a single data set. First, you will learn how to convert sparse, irregular data into a regular series. Then you will review how to aggregate dense data to a lower frequency. Finally, you will learn how to handle issues with intra-day data.
Making irregular data regular50 xpCreate a zero-width and regular xts object100 xpUse merge to make an irregular index regular100 xpAggregating to lower frequency50 xpAggregate daily data and merge with monthly data100 xpAlign series to first and last day of month100 xpAggregate to weekly, ending on Wednesdays100 xpAggregating and combining intraday data50 xpCombine data that have timezones100 xpMake irregular intra-day data regular100 xpFill missing values by trading day100 xpAggregate irregular intra-day data100 xp - 5
Importing Text Data, and Adjusting for Corporate Actions
You've learned the core workflow of importing and manipulating financial data. Now you will see how to import data from text files of various formats. Then you will learn how to check data for weirdness and handle missing values. Finally, you will learn how to adjust stock prices for splits and dividends.
Importing text files50 xpImport well-formatted daily OHLC data100 xpImport text files in other formats100 xpHandle date and time in separate columns100 xpRead text file containing multiple instruments100 xpChecking for weirdness50 xpHandle missing values100 xpVisualize imported data100 xpCross reference sources100 xpAdjusting for corporate actions50 xpAdjust for stock splits and dividends100 xpDownload split and dividend data100 xpAdjust univariate data for splits and dividends100 xpWhen to adjust data50 xpCongratulations!50 xp
Empresas
¿Entrenar a 2 o más personas?
Obtenga acceso de su equipo a la biblioteca completa de DataCamp, con informes centralizados, tareas, proyectos y másEn las siguientes pistas
Fundamentos de Finanzas en R
Ir a la pistaAnalista cuantitativo in R
Ir a la pistacolaboradores
requisitos previos
Manipulating Time Series Data in RJoshua Ulrich
Ver Más
Quantitative Analyst & member of R/Finance Conference committee
¿Qué tienen que decir otros alumnos?
¡Únete a 14 millones de estudiantes y empieza Importing and Managing Financial Data in R hoy mismo!
Crea Tu Cuenta Gratuita
o
Al continuar, acepta nuestros Términos de uso, nuestra Política de privacidad y que sus datos se almacenan en los EE. UU.