Hi there, I have a spreadsheet in excel which consists of first column of dates and then subsequent columns that refer to prices of different securities on those dates. (the first row contains each series name)
I saved the excel file as type csv and then imported to excel using prices=read.csv(file="C:/Documents and Settings/Hugh/My Documents/PhD/Option prices.csv",header = TRUE, sep = ",") This creates the correct time series data x<-ts(prices[,2]) but does not have the dates attached. However the dates refer to working days. So although in general they represent Monday-Friday this is not always the case because of holidays etc. How then can I create a time series where the dates are read in from the first column of the csv file? I can not find an example in R documentation where this is done? Thanks -- View this message in context: http://r.789695.n4.nabble.com/Adding-dates-to-time-series-tp3524679p3524679.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@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.