Ejercicio en clase: Teoría y Ejemplo de Producción Trimestral
Concepto
Una Serie de tiempo es una colección de observaciones sobre un determinado fenómeno, efectuadas en momentos sucesivos, usualmente esquiespaciados.
Algunos ejemplos de series de tiempo son:
Precios de acciones
Niveles de inventario
Rotación de personal
Ventas
PIB (GDP)
Más información: Libro R for Data Science (2e)
#install.packages("forecast")
library(forecast)
## Registered S3 method overwritten by 'quantmod':
## method from
## as.zoo.data.frame zoo
library(dplyr)
##
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
##
## filter, lag
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
Crear la serie de tiempo
Ejemplo:
Los siguientes datos de producción trimestral inician en el primer
trimestre de 2020. Se busca pronosticar la producción de los siguientes
5 trimestres.
produccion <- c(50,53,55,57,55,60)
ts <- ts(data=produccion,start = c(2020,1), frequency = 4)
ts
## Qtr1 Qtr2 Qtr3 Qtr4
## 2020 50 53 55 57
## 2021 55 60
Crear modelo ARIMA
ARIMA significa Autoregressive Integrated Moving Average o Modelo Autoregresivo Integrado de Promedio Movil.
arima <- auto.arima(ts, D=1)
arima
## Series: ts
## ARIMA(0,0,0)(0,1,0)[4] with drift
##
## Coefficients:
## drift
## 1.5000
## s.e. 0.1768
##
## sigma^2 = 2.01: log likelihood = -2.84
## AIC=9.68 AICc=-2.32 BIC=7.06
summary(arima)
## Series: ts
## ARIMA(0,0,0)(0,1,0)[4] with drift
##
## Coefficients:
## drift
## 1.5000
## s.e. 0.1768
##
## sigma^2 = 2.01: log likelihood = -2.84
## AIC=9.68 AICc=-2.32 BIC=7.06
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE
## Training set 0.03333332 0.5787923 0.3666667 0.03685269 0.6429133 0.06111111
## ACF1
## Training set -0.5073047
Generar el pronóstico
pronostico <- forecast(arima, level = c(95), h=5)
pronostico
## Point Forecast Lo 95 Hi 95
## 2021 Q3 61 58.22127 63.77873
## 2021 Q4 63 60.22127 65.77873
## 2022 Q1 61 58.22127 63.77873
## 2022 Q2 66 63.22127 68.77873
## 2022 Q3 67 63.07028 70.92972
plot(pronostico)
Actividad 2 - Hershey’s
Crear la serie de tiempo
lechita <- read.csv('lechitas.csv')
lechita$Ventas <- as.numeric(lechita$Ventas)
ts1 <- ts(data=lechita$Ventas,start = c(2017,1), frequency = 12)
ts1
## Jan Feb Mar Apr May Jun Jul Aug
## 2017 25520.51 23740.11 26253.58 25868.43 27072.87 27150.50 27067.10 28145.25
## 2018 28463.69 26996.11 29768.20 29292.51 29950.68 30099.17 30851.26 32271.76
## 2019 32496.44 31287.28 33376.02 32949.77 34004.11 33757.89 32927.30 34324.12
## Sep Oct Nov Dec
## 2017 27546.29 28400.37 27441.98 27852.47
## 2018 31940.74 32995.93 32197.12 31984.82
## 2019 35151.28 36133.07 34799.91 34846.17
Crear modelo ARIMA
ARIMA significa Autoregressive Integrated Moving Average o Modelo Autoregresivo Integrado de Promedio Movil.
arima1 <- auto.arima(ts1, D=1)
arima1
## Series: ts1
## ARIMA(1,0,0)(1,1,0)[12] with drift
##
## Coefficients:
## ar1 sar1 drift
## 0.6383 -0.5517 288.8980
## s.e. 0.1551 0.2047 14.5025
##
## sigma^2 = 202700: log likelihood = -181.5
## AIC=371 AICc=373.11 BIC=375.72
summary(arima1)
## Series: ts1
## ARIMA(1,0,0)(1,1,0)[12] with drift
##
## Coefficients:
## ar1 sar1 drift
## 0.6383 -0.5517 288.8980
## s.e. 0.1551 0.2047 14.5025
##
## sigma^2 = 202700: log likelihood = -181.5
## AIC=371 AICc=373.11 BIC=375.72
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE
## Training set 25.22163 343.863 227.1699 0.08059942 0.7069541 0.06491041
## ACF1
## Training set 0.2081043
Generar el pronóstico
pronostico1 <- forecast(arima1, level = c(95), h=5)
pronostico1
## Point Forecast Lo 95 Hi 95
## Jan 2020 35498.90 34616.48 36381.32
## Feb 2020 34202.17 33155.29 35249.05
## Mar 2020 36703.01 35596.10 37809.92
## Apr 2020 36271.90 35141.44 37402.36
## May 2020 37121.98 35982.07 38261.90
plot(pronostico1)
Finanzas corporativas
library(finreportr)
Información disponible
Con la función “finreportr” podemos obtener la siguiente información:
CompanyInfo() = Brinda información general como Nombre, Ubicación, ZIP, etc.
AnnualReports() = Brinda el nombre, fecha y número de acceso.
GetIncome()= Brinda el Estado de Resultados.
GetBalanceSheet() = Brinda el Balance general.
GetCashFlow() = Brinda el flujo de efectivo.
options(HTTPUserAgent = "b b@gmail.com")
CompanyInfo('JPM')
## company CIK SIC state state.inc FY.end street.address
## 1 JPMORGAN CHASE & CO 0000019617 6021 NY DE 1231 383 MADISON AVENUE
## city.state
## 1 NEW YORK NY 10017
AnnualReports('BABA', foreign = TRUE)
## filing.name filing.date accession.no
## 1 20-F/A 2024-02-23 0001193125-24-044480
## 2 20-F 2023-07-21 0000950170-23-033752
## 3 20-F 2022-07-26 0001104659-22-082622
## 4 20-F 2021-07-27 0001104659-21-096092
## 5 20-F 2020-07-09 0001104659-20-082409
## 6 20-F 2019-06-05 0001047469-19-003492
## 7 20-F 2018-07-27 0001047469-18-005257
## 8 20-F 2017-06-15 0001047469-17-004019
## 9 20-F 2016-05-24 0001047469-16-013400
## 10 20-F 2015-06-25 0001047469-15-005768
google_income <- GetIncome('GOOG',2016)
amazon <- GetBalanceSheet('AMZN', 2015)
apple_cash <- GetCashFlow('AAPL',2014)
Ejercicio con empresa “Wells Fargo (WFC)“
options(HTTPUserAgent = "GT@gmail.com")
CompanyInfo('WFC')
## company CIK SIC state state.inc FY.end
## 1 WELLS FARGO & COMPANY/MN 0000072971 6021 CA DE 1231
## street.address city.state
## 1 420 MONTGOMERY STREET SAN FRANCISCO CA 94104
AnnualReports('WFC')
## filing.name filing.date accession.no
## 1 10-K 2024-02-20 0000072971-24-000064
## 2 10-K 2023-02-21 0000072971-23-000071
## 3 10-K 2022-02-22 0000072971-22-000096
## 4 10-K 2021-02-23 0000072971-21-000197
## 5 10-K 2020-02-27 0000072971-20-000217
## 6 10-K 2019-02-27 0000072971-19-000227
## 7 10-K 2018-03-01 0000072971-18-000272
## 8 10-K 2017-03-01 0000072971-17-000278
## 9 10-K 2016-02-24 0000072971-16-001045
## 10 10-K 2015-02-25 0000072971-15-000449
## 11 10-K 2014-02-26 0000072971-14-000337
## 12 10-K 2013-02-27 0001193125-13-078820
## 13 10-K 2012-02-28 0001193125-12-084528
## 14 10-K 2011-02-25 0000950123-11-018541
## 15 10-K 2010-02-26 0000950123-10-017877
## 16 10-K 2009-02-27 0000950134-09-003967
## 17 10-K 2008-02-29 0000950134-08-003822
## 18 10-K 2007-03-01 0000950134-07-004518
## 19 10-K 2006-03-09 0000950149-06-000083
## 20 10-K/A 2005-03-17 0000950134-05-005350
## 21 10-K 2005-03-10 0000950134-05-004623
## 22 10-K 2004-03-12 0000950134-04-003387
## 23 10-K/A 2004-01-16 0000950149-04-000152
## 24 10-K 2003-03-14 0001047469-03-008749
## 25 10-K 2002-03-15 0000912057-02-010174
## 26 10-K 2001-03-16 0000912057-01-504042
## 27 10-K 2000-03-17 0000912057-00-012168
## 28 10-K/A 1999-03-23 0001047469-99-010910
## 29 10-K405 1999-03-17 0001047469-99-010171
## 30 10-K 1998-02-27 0001045969-98-000259
## 31 10-K 1997-03-04 0000950109-97-001905
## 32 10-K 1996-03-07 0000950131-96-000962
## 33 10-K 1995-03-16 0000950131-95-000611
## 34 10-K/A 1994-05-13 0000072971-94-000005
## 35 10-K 1994-03-08 0000072971-94-000003
ER5<- GetIncome('WFC',2013)
ER4 <- GetIncome('WFC',2014)
ER1 <- GetIncome('WFC',2015)
ER <- GetIncome('WFC',2016)
ER2 <- GetIncome('WFC',2017)
ER3 <- GetIncome('WFC',2018)
e1 <- ER5[c(16,17,18),]
e2 <- ER4[c(16,17,18),]
e3 <- ER1[c(63,64,65),]
e4 <- ER[c(63,64,65),]
e5 <- ER2[c(63,64,65),]
e6<- ER3[c(63,64,65),]
ER_<- rbind(e1,e2,e3,e4,e5,e6)
ER_$startDate<- as.Date(ER_$startDate)
ER_<- arrange(ER_, startDate)
ER_ <- ER_[c(1,2,4,7,10,13,16,18),]
ER_$Amount<- as.numeric(ER_$Amount)
Modelo Arima
arima2 <- auto.arima(ER_$Amount, D=1)
arima2
## Series: ER_$Amount
## ARIMA(0,1,0) with drift
##
## Coefficients:
## drift
## -153857143
## s.e. 51448140
##
## sigma^2 = 2.192e+16: log likelihood = -141.08
## AIC=286.17 AICc=289.17 BIC=286.06
summary(arima2)
## Series: ER_$Amount
## ARIMA(0,1,0) with drift
##
## Coefficients:
## drift
## -153857143
## s.e. 51448140
##
## sigma^2 = 2.192e+16: log likelihood = -141.08
## AIC=286.17 AICc=289.17 BIC=286.06
##
## Training set error measures:
## ME RMSE MAE MPE MAPE MASE ACF1
## Training set 284982 128204941 88927839 -1.030368 6.120293 0.5389566 -0.2415709
Generar el pronóstico
pronostico2 <- forecast(arima2, level = c(95), h=5)
pronostico2
## Point Forecast Lo 95 Hi 95
## 9 895142857 604993093 1185292621
## 10 741285714 330951983 1151619446
## 11 587428571 84874438 1089982705
## 12 433571429 -146728100 1013870957
## 13 279714286 -369080311 928508882
plot(pronostico2)