How to convert dataframe into time series?

by

R has multiple ways of represeting time series. Since you’re working with daily prices of stocks, you may wish to consider that financial markets are closed on weekends and business holidays so that trading days and calendar days are not the same. However, you may need to work with your times series in terms of both trading days and calendar days. For example, daily returns are calculated from sequential daily closing prices regardless of whether a weekend intervenes. But you may also want to do calendar-based reporting such as weekly price summaries. For these reasons the xts package, an extension of zoo, is commonly used with financial data in R. An example of how it could be used with your data follows.

Assuming the data shown in your example is in the dataframe df

  library(xts)
  stocks <- xts(df[,-1], order.by=as.Date(df[,1], "%m/%d/%Y"))
#
#  daily returns
#
   returns <- diff(stocks, arithmetic=FALSE ) - 1
#
#  weekly open, high, low, close reports
#
   to.weekly(stocks$Hero_close, name="Hero")

which gives the output

           Hero.Open Hero.High Hero.Low Hero.Close
2013-03-15    1669.1   1684.45   1669.1    1684.45
2013-03-22    1690.5   1690.50   1623.3    1659.60
2013-03-28    1617.7   1617.70   1542.0    1542.00

More Related Contents:

  1. Subset of rows containing NA (missing) values in a chosen column of a data frame
  2. Converting a data frame to xts
  3. Transforming a time-series into a data frame and back
  4. Read and rbind multiple csv files
  5. write.csv for large data.table
  6. How to append a whole dataframe to a CSV in R
  7. Override column types when importing data using readr::read_csv() when there are many columns
  8. Interpolating timeseries
  9. Select the row with the maximum value in each group
  10. Find indices of duplicated rows [duplicate]
  11. How to drop columns by name in a data frame
  12. Reshape multiple values at once
  13. Remove columns from dataframe where ALL values are NA
  14. Call apply-like function on each row of dataframe with multiple arguments from each row
  15. Subtract a column in a dataframe from many columns in R
  16. Forecasting time series data
  17. Interpolate NA values in a data frame with na.approx
  18. How to subset data in R without losing NA rows?
  19. How to delete columns that contain ONLY NAs?
  20. Using grep to help subset a data frame
  21. How to sort a data frame by date
  22. Randomly insert NAs into dataframe proportionaly
  23. Return data subset time frames within another timeframes?
  24. Subset xts object by time of day
  25. R: Split unbalanced list in data.frame column
  26. Should I use a data.frame or a matrix?
  27. Add an image to a table-like output in R
  28. R how can I calculate difference between rows in a data frame
  29. Importing “csv” file with multiple-character separator to R?
  30. optimized rolling functions on irregular time series with time-based window

Leave a Comment