getSymbols.SQLite: Retrieve Data from SQLite Database

In quantmod: Quantitative Financial Modelling Framework

Retrieve Data from SQLite Database

Description

Fetch data from SQLite database. As with other methods extending getSymbols this function should NOT be called directly.

Usage

getSymbols.SQLite(Symbols,
                  env,
                  return.class = 'xts',
                  db.fields = c("row_names",
                                "Open",
                                "High",
                                "Low",
                                "Close",
                                "Volume",
                                "Adjusted"),
                  field.names = NULL,
                  dbname = NULL,
                  POSIX = TRUE,
                  ...)

Arguments

Symbols	a character vector specifying the names of each symbol to be loaded
env	where to create the objects
return.class	desired class of returned object
db.fields	character vector naming fields to retrieve
field.names	names to assign to returned columns
dbname	database name
POSIX	are rownames numeric
...	additional arguments

Details

Meant to be called internally by getSymbols (see also)

One of a few currently defined methods for loading data for use with 'quantmod'. Its use requires the packages 'DBI' and 'RSQLite', along with a SQLite database.

The purpose of this abstraction is to make transparent the 'source' of the data, allowing instead the user to concentrate on the data itself.

Value

A call to getSymbols.SQLite will load into the specified environment one object for each 'Symbol' specified, with class defined by 'return.class'.

Note

This function is experimental at best, and has not been thoroughly tested. Use with caution, and please report any bugs to the maintainer of quantmod.

Author(s)

Jeffrey A. Ryan

References

SQLite https://www.sqlite.org/index.html

David A. James RSQLite: SQLite interface for R

R-SIG-DB. DBI: R Database Interface

See Also

getSymbols

Examples

## Not run: 
getSymbols("QQQ",src="SQLite")

## End(Not run)

quantmod documentation built on May 29, 2024, 8:03 a.m.