sqlServerConnectODBC: SQL Server Connection
In ivanliu1989/RQuantAPI: A collection of functions of API connections from different brokers
Description
Usage
Value
Examples
Description
Connect to Sql Server databases
Usage
1
Value
A conn of database
Examples
1
2
3
4
conn <- sqlServerConnect()
sqlquery1 <- "select capiq_symbol_ticker, capiq_symbol_exchange, pricing_date, price_close, volume from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
sqlquery2 <- "select distinct capiq_symbol_ticker, capiq_symbol_exchange from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
res <- sqlFetch(conn, sqlquery1)
ivanliu1989/RQuantAPI documentation built on Sept. 13, 2019, 11:54 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Value Examples
Description
Connect to Sql Server databases
Usage
1 |
Value
A conn of database
Examples
1 2 3 4 | conn <- sqlServerConnect()
sqlquery1 <- "select capiq_symbol_ticker, capiq_symbol_exchange, pricing_date, price_close, volume from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
sqlquery2 <- "select distinct capiq_symbol_ticker, capiq_symbol_exchange from insites_metrics_dev.meta.equity_price where pricing_date between GETDATE() - 500 and GETDATE()"
res <- sqlFetch(conn, sqlquery1)
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.