Displaying 1 result from an estimated 1 matches for "sys_xts_year".
Did you mean:
sys_xts_yearly
2012 Aug 16
3
Reference a variable inside a string and another for object assingments
...olonne
sys$lokaldatotid <- as.POSIXct(sys$lokaldatotid)
#Make a XTS object
sys_xts <- xts(sys[,-1], order.by=sys[,1])
# Recalculate data from hours to daily, monthly and yearly averages
sys_xts_daily <- apply.daily(sys_xts, FUN=mean)
sys_xts_monthly <- apply.monthly(sys_xts, FUN=mean)
sys_xts_yearly <- apply.yearly(sys_xts, FUN=mean)
############################## DK1 spot #############################
# Hent data fra SQL Server
dk1 <- sqlQuery (ch, paste("SELECT SP.lokaldatotid, SP.pris FROM
DataIndsamling2.dbo.SpotPriser SP",
"WHERE (SP.om...