daily pastebin goal
35%
SHARE
TWEET

Untitled

a guest Jul 20th, 2018 58 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 'select stkData$close from stkData where symbol = symbol[k] and date = dates[j]'
  2.    
  3. Error in sqliteExecStatement(con, statement, bind.data) :
  4. RS-DBI driver: (error in statement: near "[4,]": syntax error)
  5.    
  6. sqldf(paste('select close from stkData where symbol = ', symbol[k],
  7.             ' and date = ', dates[j]))
  8.    
  9. combo_kj <- expand.grid(ksym=symbol[1:k], jdates=dates[1:j])
  10.  
  11. SQLcalls <- paste('select close from stkData where symbol = ',
  12.                    combo_kj$ksym,
  13.                    ' and date = '
  14.                    combo_kj$jdates,
  15.                    sep="")
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top