Convert data frame with date column to timeseries

by

Your DATE column may represent a date, but it is actually either a character, factor, integer, or a numeric vector.

First, you need to convert the DATE column to a Date object. Then you can create an xts object from the CLOSE and DATE columns of your PRICE data.frame. Finally, you can use the xts object to calculate returns and the Calmar ratio.

PRICE <- structure(list(
  DATE = c(20070103L, 20070104L, 20070105L, 20070108L, 20070109L,
           20070110L, 20070111L, 20070112L, 20070115L),
  CLOSE = c(54.7, 54.77, 55.12, 54.87, 54.86, 54.27, 54.77, 55.36, 55.76)),
  .Names = c("DATE", "CLOSE"), class = "data.frame",
  row.names = c("1", "2", "3", "4", "5", "6", "7", "8", "9"))

library(PerformanceAnalytics)  # loads/attaches xts
# Convert DATE to Date class
PRICE$DATE <- as.Date(as.character(PRICE$DATE),format="%Y%m%d")
# create xts object
x <- xts(PRICE$CLOSE,PRICE$DATE)
CalmarRatio(Return.calculate(x))
#                  [,1]
# Calmar Ratio 52.82026

More Related Contents:

  1. Conversion of a data into time series object
  2. Basic lag in R vector/dataframe
  3. Why apply() returns a transposed xts matrix?
  4. Converting a data frame to xts
  5. Forecasting time series data
  6. Which is the best method to apply a script repetitively to n .csv files in R?
  7. How to aggregate a dataframe by week?
  8. Return data subset time frames within another timeframes?
  9. Creating regular 15-minute time-series from irregular time-series
  10. Rolling Sum by Another Variable in R
  11. Subset xts object by time of day
  12. Fill NA in a time series only to a limited number
  13. How can I change XTS to data.frame and keep Index?
  14. merging a large list of xts objects
  15. What is an efficient method for partitioning and aggregating intervals from timestamped rows in a data frame?
  16. Painless way to install a new version of R?
  17. How to use an image as a point in ggplot?
  18. How to put labels over geom_bar in R with ggplot2
  19. How to efficiently calculate distance between pair of coordinates using data.table :=
  20. Access variable value where the name of variable is stored in a string
  21. R Shiny – add tabPanel to tabsetPanel dynamically (with the use of renderUI)
  22. How do I change the formatting of numbers on an axis with ggplot? [duplicate]
  23. How to concatenate factors, without them being converted to integer level?
  24. how to return number of decimal places in R
  25. merge data.frames based on year and fill in missing values
  26. How to extract certain columns from a list of data frames
  27. How to find out which package version is loaded in R?
  28. Moving color key in R heatmap.2 (function of gplots package)
  29. Shifting a column down by one
  30. How to change stacking order in stacked bar chart in R?

Leave a Comment