search for: spotpriser

Displaying 1 result from an estimated 1 matches for "spotpriser".

2012 Aug 16
3
Reference a variable inside a string and another for object assingments
...ET DATA ########################## ##################################################################### ############################## SYSTEM spot ########################## # Hent data fra SQL Server sys <- sqlQuery (ch, paste("SELECT SP.lokaldatotid, SP.pris FROM DataIndsamling2.dbo.SpotPriser SP", "WHERE (SP.omraade_id= 0 AND SP.lokaldatotid >= '2005-01-01 00:00:00')")) #Definer dato og tid kolonne sys$lokaldatotid <- as.POSIXct(sys$lokaldatotid) #Make a XTS object sys_xts <- xts(sys[,-1], order.by=sys[,1]) # Recalculate data...