Displaying 1 result from an estimated 1 matches for "stock_ticker_yahoo".
2011 Mar 23
1
using R variables in RMySQL query
...h", password="blahblah",
dbname="blahblah",
host="localhost")
rs <- dbGetQuery(con, "SELECT price.close FROM price INNER JOIN stocks ON
stocks.stock_id=price.stock_ID
WHERE (price.date_holding BETWEEN 'startdate' AND 'enddate') AND
stocks.stock_ticker_yahoo IN ticker";)
}
I get all sorts of errors. I want to pass variables startdate, enddate and
ticker. It would also be nice to pass the username, password and dbname
information in the function.
I have read through a few posts here regarding using "paste" but I still get
errors. Can...