[R-SIG-Finance] TSdbi time series database interface

Paul Gilbert pgilbert902 at gmail.com
Fri Jun 12 23:43:08 CEST 2015


I have recently released several updated and some new packages using the 
TSdbi API for interfacing R to time series databases. The vignette in 
the package TSdata 
(http://cran.at.r-project.org/web/packages/TSdata/vignettes/Guide.pdf) 
gives an overview and usage examples for all the packages. The table in 
section 1 gives an indication of which package can be used for which 
source. In addition to the SQL databases originally supported by the 
API, the list of Internet data sources now includes: ABS (Australia), 
ECB, EuroStat, ILO, IMF, INEGI (Mexico), ISTAT (Italy), NBB (Belgium), 
OECD, UIS, Unesco, World Bank, BIS, FRED, Statistics Canada, Yahoo, 
Oanda, PiTrading, Quandl, Bloomberg. In most cases the TSdbi interface 
is a wrapper to other R packages and only provides a common API. The 
underlying packages are indicated in the vignette. Some of these sources 
should be considered beta, as indicated in the vignette. Details in 
addition to the vignette are available at 
http://tsdbi.r-forge.r-project.org/.

The TSdata vignette is the paper that would have been nice to have for 
my R/Finance 2012 presentation. The packages now provide several things 
promised at that time. The main breakthrough has been the package RJSDMX 
by Attilio Mattiocco, Diana Nicoletti, and Gianpaolo Lopez at the Banca 
d'Italia  (https://github.com/amattioc/SDMX/wiki).

If you are aware of other organizations supporting the SDMX/REST 
standard then please let me know so they can be added. If you would like 
to encourage your favourite data organization to use the SDMX/REST 
standard there are useful lists of working group representatives at
http://sdmx.org/wp-content/uploads/2011/03/SDMX-Statistical-Working-Group-members.pdf 
and 
http://sdmx.org/wp-content/uploads/2012/08/SDMX-Technical-Standards-Working-Group-members-2.pdf.

Constructive feedback is always appreciated.

Paul Gilbert



More information about the R-SIG-Finance mailing list