EVOLUTION-MANAGER
Edit File: getSymbols.SQLite.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><title>R: Retrieve Data from SQLite Database</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="R.css" /> </head><body> <table width="100%" summary="page for getSymbols.SQLite {quantmod}"><tr><td>getSymbols.SQLite {quantmod}</td><td style="text-align: right;">R Documentation</td></tr></table> <h2> Retrieve Data from SQLite Database </h2> <h3>Description</h3> <p>Fetch data from SQLite database. As with other methods extending <code>getSymbols</code> this function should <em>NOT</em> be called directly. </p> <h3>Usage</h3> <pre> 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, ...) </pre> <h3>Arguments</h3> <table summary="R argblock"> <tr valign="top"><td><code>Symbols</code></td> <td> <p> a character vector specifying the names of each symbol to be loaded </p> </td></tr> <tr valign="top"><td><code>env</code></td> <td> <p> where to create the objects </p> </td></tr> <tr valign="top"><td><code>return.class</code></td> <td> <p> desired class of returned object </p> </td></tr> <tr valign="top"><td><code>db.fields</code></td> <td> <p> character vector naming fields to retrieve </p> </td></tr> <tr valign="top"><td><code>field.names</code></td> <td> <p> names to assign to returned columns </p> </td></tr> <tr valign="top"><td><code>dbname</code></td> <td> <p> database name </p> </td></tr> <tr valign="top"><td><code>POSIX</code></td> <td> <p> are rownames numeric </p> </td></tr> <tr valign="top"><td><code>...</code></td> <td> <p> additional arguments </p> </td></tr> </table> <h3>Details</h3> <p>Meant to be called internally by <code>getSymbols</code> (see also) </p> <p>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. </p> <p>The purpose of this abstraction is to make transparent the 'source' of the data, allowing instead the user to concentrate on the data itself. </p> <h3>Value</h3> <p>A call to getSymbols.SQLite will load into the specified environment one object for each 'Symbol' specified, with class defined by 'return.class'. </p> <h3>Note</h3> <p>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. </p> <h3>Author(s)</h3> <p>Jeffrey A. Ryan</p> <h3>References</h3> <p><cite>SQLite <a href="https://www.sqlite.org/index.html">https://www.sqlite.org/index.html</a></cite> </p> <p><cite>David A. James RSQLite: SQLite interface for R </cite> </p> <p><cite>R-SIG-DB. DBI: R Database Interface</cite> </p> <h3>See Also</h3> <p><code><a href="getSymbols.html">getSymbols</a></code></p> <h3>Examples</h3> <pre> ## Not run: getSymbols("QQQQ",src="SQLite") ## End(Not run) </pre> <hr /><div style="text-align: center;">[Package <em>quantmod</em> version 0.4.20 <a href="00Index.html">Index</a>]</div> </body></html>