I am trying to load a time series that only has weekdays (no weekends or holidays) to make exploratory analysis.
Here is the data: https://docs.google.com/spreadsheets/d/1xbeQJILqov3kKliPwfqyTt_HYwQWjY_2/edit?usp=sharing&ouid=107338479960484533369&rtpof=true&sd=true
temp <- tempfile(fileext = ".xlsx")
download.file("https://docs.google.com/spreadsheets/d/1xbeQJILqov3kKliPwfqyTt_HYwQWjY_2/edit?usp=sharing&ouid=107338479960484533369&rtpof=true&sd=true&export=download",
temp)
out <- unzip(temp, exdir = tempdir())
money <- readxl::read_excel(out)
> head(money)
# A tibble: 6 × 2
date Price
<dttm> <dbl>
1 2015-01-02 00:00:00 540.
2 2015-01-05 00:00:00 539.
3 2015-01-06 00:00:00 539.
4 2015-01-07 00:00:00 539.
5 2015-01-08 00:00:00 539.
6 2015-01-09 00:00:00 539.
How can I read it R as a time series to make al the analysis I have to do?