[R] Quantmod getSymbol.MySQL

From: priyadarshee sukhwal <priyadarshee.sukhwal_at_gmail.com>
Date: Thu, 17 Mar 2011 00:03:05 +0530


 I am trying to read a table from MySQL, I have loaded the file in "ts" database, in table name ACC. but i am unable to read it in R through getSymbol function.

mysql> show databases;

+--------------------------------+

| Database |
+--------------------------------+
| information_schema |
| mysql |
| test |
| ts |
+--------------------------------+

mysql> use ts;
Database changed

mysql> show tables;

+--------------------+

| Tables_in_ts |
+--------------------+

| ACC |
+--------------------+

mysql> select * from ACC;

+------------------------------+------------+---------+-------------+------------+-------------+

| Date | Open | High | Low | Close |
Volume |
+------------------------------+------------+---------+-------------+------------+-------------+

| 2006-11-30 09:55:00 | 1140 | 1150 | 1140 | 1150 | 33
  |
| 2006-11-30 09:56:00 | 1149.9 | 1153 | 1149.9 | 1150 | 3195 |
| 2006-11-30 09:57:00 | 1148 | 1150 | 1147 | 1147.25 | 3669 |
| 2006-11-30 09:58:00 | 1148 | 1148 | 1145.45 | 1146 | 1982 |

I created the database after becoming super user, without user name and password,
up-till here everything is fine.

library(quantmod)
library(RMySQL)

con <- dbConnect("MySQL",dbname ="ts")
data <- dbReadTable(con,"ACC")
tdata=(xts(data[,-1], as.POSIXct(data[,1]))) *barChart(tdata)*
dbDisconnect(con)

This thing works fine. I mean if done through DBI and RMySQL basic command, then table
get read properly and I get a wonderful chart.

But doing it through getSymbol is giving problem.

*first i tried *

setDefaults(getSymbols.MySQL, dbname='ts') getSymbols('ACC',src='MySQL')

Error in getSymbols.MySQL(Symbols = "ACC", env = <environment>, verbose = FALSE, :
  At least one connection argument ( ‘user’ ‘password’ ‘dbname’ ) is not set

*second i tried *

setDefaults(getSymbols.MySQL,user=' ',password=' ',dbname='ts') getSymbols('ACC',src='MySQL')

Error in mysqlExecStatement(conn, statement, ...) :   RS-DBI driver: (could not run statement: Unknown column 'o' in 'field list')

*third i tried this *

setDefaults(getSymbols.MySQL,user='', password='', dbname='ts', db.fields=c("Date","Open","High","Low","Close","Volume")) getSymbols('ACC',src='MySQL')

Error in mysqlExecStatement(conn, statement, ...) :   RS-DBI driver: (could not run statement: FUNCTION ts.c does not exist)

I know i am doing something wrong but, i am really not able to figure out what and where.
Please help me.

        [[alternative HTML version deleted]]



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Wed 16 Mar 2011 - 20:23:03 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 16 Mar 2011 - 20:30:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive