Concepto

Una serie de tiempo es una colección de observaciones sobre un determinado fenómeno, efactuadas en momento sucesivos, usualmente equiespaciados.

Algunos ejemplos de series de tiempo son:
1. Precios de acciones
2. Niveles de inventario
3. Rotación de personal
4. Ventas 5. PIB (GDP)

Más información:
R for Data Science (2e)

Ejercicio en clase

Instalar paquetes y librerías

# install.packages("forecast")
library(forecast)
## Registered S3 method overwritten by 'quantmod':
##   method            from
##   as.zoo.data.frame zoo

Crear serie de tiempo

Ejemplo:
Los siguientes datos de producción trimestral inician en el primer trimestre del 2020.
Se busca pronosticar la producción de los sigientes cinco 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

Modelo ARIMA

ARIMA sigifica 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 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)

Hershey’s

##Crear serie de tiempo

ventas <- read.csv("/Users/liz/Downloads/OCTAVO SEMESTRE/ESCENARIOS FUTUROS/MÓDULO 1 - PROF RAÚL/ventas_hersheys.csv")

ts_hersheys <- ts(data = ventas$Ventas, start = c(2017,1), frequency = 12)
ts_hersheys
##           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

Modelo ARIMA

arima_hersheys <- auto.arima(ts_hersheys)
arima_hersheys
## Series: ts_hersheys 
## 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(arima_hersheys)
## Series: ts_hersheys 
## 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 pronóstico

pronostico_hersheys <- forecast(arima_hersheys, level = c(95), h = 12)
pronostico_hersheys
##          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
## Jun 2020       37102.65 35958.91 38246.40
## Jul 2020       37151.04 36005.74 38296.35
## Aug 2020       38564.65 37418.71 39710.59
## Sep 2020       38755.23 37609.03 39901.42
## Oct 2020       39779.03 38632.73 40925.33
## Nov 2020       38741.63 37595.29 39887.97
## Dec 2020       38645.86 37499.50 39792.22
plot(pronostico_hersheys)

Actividad 3 | Finanzas corporativas

Instalar paquetes y librerías

#install.packages("finreportr")
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 le nombre, fecha y número de acceso
- GetIncome() = Brinda el Estado de Resultados
- GetBalanceSheet() = Brinda el Balance General
- GetCashFlow() = Brinda el Flujo de Efectivo

Ejemplos de reportes que se pueden sacar con la librería

options(HTTPUserAgent = "a a@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_balance <- GetBalanceSheet("AMZN", 2015)
apple_cash <- GetCashFlow("AAPL", 2014)
LS0tCnRpdGxlOiAic2VyaWVzIGRlIHRpZW1wbyIKYXV0aG9yOiAibGl6IGFndWlsZXJhIGNhcnJlw7FvIHwgYTAxMzgyOTk1IgpkYXRlOiAiMjAyNC0wMi0xNiIKb3V0cHV0OgogIGh0bWxfZG9jdW1lbnQ6CiAgICB0b2M6IFRSVUUKICAgIHRvY19mbG9hdDogVFJVRQogICAgY29kZV9kb3dubG9hZDogVFJVRQotLS0KCmBgYHtyIHNldHVwLCBpbmNsdWRlPUZBTFNFfQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IFRSVUUpCmBgYAoKIVtdKHNlcmllcyUyMGRlJTIwdGllbXBvLmpwZWcpCgojIyBDb25jZXB0bwoKVW5hICoqc2VyaWUgZGUgdGllbXBvKiogZXMgdW5hIGNvbGVjY2nDs24gZGUgb2JzZXJ2YWNpb25lcyBzb2JyZSB1biBkZXRlcm1pbmFkbyBmZW7Ds21lbm8sIGVmYWN0dWFkYXMgZW4gbW9tZW50byBzdWNlc2l2b3MsIHVzdWFsbWVudGUgZXF1aWVzcGFjaWFkb3MuCgpBbGd1bm9zIGVqZW1wbG9zIGRlIHNlcmllcyBkZSB0aWVtcG8gc29uOlwKMS4gUHJlY2lvcyBkZSBhY2Npb25lc1wKMi4gTml2ZWxlcyBkZSBpbnZlbnRhcmlvXAozLiBSb3RhY2nDs24gZGUgcGVyc29uYWxcCjQuIFZlbnRhcyA1LiBQSUIgKCpHRFAqKQoKTcOhcyBpbmZvcm1hY2nDs246XApbKlIgZm9yIERhdGEgU2NpZW5jZSAoMmUpKl0oaHR0cHM6Ly9lcy5yNGRzLmhhZGxleS5uei8pCgojIEVqZXJjaWNpbyBlbiBjbGFzZQoKIyMgSW5zdGFsYXIgcGFxdWV0ZXMgeSBsaWJyZXLDrWFzCgpgYGB7ciwgbGlicmVyw61hc30KIyBpbnN0YWxsLnBhY2thZ2VzKCJmb3JlY2FzdCIpCmxpYnJhcnkoZm9yZWNhc3QpCmBgYAoKIyMgQ3JlYXIgc2VyaWUgZGUgdGllbXBvCgoqKkVqZW1wbG86KipcCkxvcyBzaWd1aWVudGVzIGRhdG9zIGRlIHByb2R1Y2Npw7NuIHRyaW1lc3RyYWwgaW5pY2lhbiBlbiBlbCBwcmltZXIgdHJpbWVzdHJlIGRlbCAyMDIwLlwKU2UgYnVzY2EgcHJvbm9zdGljYXIgbGEgcHJvZHVjY2nDs24gZGUgbG9zIHNpZ2llbnRlcyBjaW5jbyB0cmltZXN0cmVzCgpgYGB7ciwgY3JlYWNpw7NuIHNlcmllIGRlIHRpZW1wb30KcHJvZHVjY2lvbiA8LSBjKDUwLCA1MywgNTUsIDU3LCA1NSwgNjApCgp0cyA8LSB0cyhkYXRhID0gcHJvZHVjY2lvbiwgc3RhcnQgPSBjKDIwMjAsMSksIGZyZXF1ZW5jeSA9IDQpCnRzCmBgYAoKIyMgTW9kZWxvIEFSSU1BCgoqKkFSSU1BKiogc2lnaWZpY2EgKkF1dG9SZWdyZXNzaXZlIEludGVncmF0ZWQgTW92aW5nIEF2ZXJhZ2UqIG8gTW9kZWxvIEF1dG9yZWdyZXNpdm8gSW50ZWdyYWRvIGRlIFByb21lZGlvIE1vdmlsLgoKYGBge3IsIGFyaW1hfQphcmltYSA8LSBhdXRvLmFyaW1hKHRzLCBEID0gMSkKYXJpbWEKc3VtbWFyeShhcmltYSkKYGBgCgojIyBHZW5lcmFyIHByb27Ds3N0aWNvCgpgYGB7ciwgcHJvbsOzc3RpY299CnByb25vc3RpY28gPC0gZm9yZWNhc3QoYXJpbWEsIGxldmVsID0gYyg5NSksIGggPSA1KQpwcm9ub3N0aWNvCnBsb3QocHJvbm9zdGljbykKYGBgCgojIEhlcnNoZXkncwoKIVshW10oZmluYW56YXMlMjBjb3Jwb3JhdGl2c3MuanBlZyldKGhlcnNoZXlzLmpwZWcpCgojI0NyZWFyIHNlcmllIGRlIHRpZW1wbwoKYGBge3IsIGNyZWFjacOzbiBzZXJpZSBkZSB0aWVtcG8gaGVyc2hleXN9CnZlbnRhcyA8LSByZWFkLmNzdigiL1VzZXJzL2xpei9Eb3dubG9hZHMvT0NUQVZPIFNFTUVTVFJFL0VTQ0VOQVJJT1MgRlVUVVJPUy9NT8yBRFVMTyAxIC0gUFJPRiBSQVXMgUwvdmVudGFzX2hlcnNoZXlzLmNzdiIpCgp0c19oZXJzaGV5cyA8LSB0cyhkYXRhID0gdmVudGFzJFZlbnRhcywgc3RhcnQgPSBjKDIwMTcsMSksIGZyZXF1ZW5jeSA9IDEyKQp0c19oZXJzaGV5cwpgYGAKCiMjIE1vZGVsbyBBUklNQQoKYGBge3IsIGFyaW1hIGhlcnNoZXlzfQphcmltYV9oZXJzaGV5cyA8LSBhdXRvLmFyaW1hKHRzX2hlcnNoZXlzKQphcmltYV9oZXJzaGV5cwpzdW1tYXJ5KGFyaW1hX2hlcnNoZXlzKQpgYGAKCiMjIEdlbmVyYXIgcHJvbsOzc3RpY28KCmBgYHtyLCBwcm9uw7NzdGljbyBoZXJzaGV5c30KcHJvbm9zdGljb19oZXJzaGV5cyA8LSBmb3JlY2FzdChhcmltYV9oZXJzaGV5cywgbGV2ZWwgPSBjKDk1KSwgaCA9IDEyKQpwcm9ub3N0aWNvX2hlcnNoZXlzCnBsb3QocHJvbm9zdGljb19oZXJzaGV5cykKYGBgCgojIEFjdGl2aWRhZCAzIFx8IEZpbmFuemFzIGNvcnBvcmF0aXZhcwoKIVtdKGZpbmFuemFzJTIwY29ycG9yYXRpdmFzLmpwZWcpCgojIyBJbnN0YWxhciBwYXF1ZXRlcyB5IGxpYnJlcsOtYXMKCmBgYHtyLCBwYXF1ZXRlcyB5IGxpYnJlcsOtYXN9CiNpbnN0YWxsLnBhY2thZ2VzKCJmaW5yZXBvcnRyIikKbGlicmFyeShmaW5yZXBvcnRyKQpgYGAKCiMjIEluZm9ybWFjacOzbiBkaXNwb25pYmxlCgpDb24gbGEgZnVuY2nDs24gKmZpbnJlcG9ydHIqIHBvZGVtb3Mgb2J0ZW5lciBsYSBzaWd1aWVudGUgaW5mb3JtYWNpw7NuOlwKLSBDb21wYW55SW5mbygpID0gQnJpbmRhIGluZm9ybWFjacOzbiBnZW5lcmFsIGNvbW8gTm9tYnJlLCBVYmljYWNpw7NuLCBaSVAsIGV0Yy5cCi0gQW5udWFsUmVwb3J0cygpID0gQnJpbmRhIGxlIG5vbWJyZSwgZmVjaGEgeSBuw7ptZXJvIGRlIGFjY2Vzb1wKLSBHZXRJbmNvbWUoKSA9IEJyaW5kYSBlbCBFc3RhZG8gZGUgUmVzdWx0YWRvc1wKLSBHZXRCYWxhbmNlU2hlZXQoKSA9IEJyaW5kYSBlbCBCYWxhbmNlIEdlbmVyYWxcCi0gR2V0Q2FzaEZsb3coKSA9IEJyaW5kYSBlbCBGbHVqbyBkZSBFZmVjdGl2bwoKIyMgRWplbXBsb3MgZGUgcmVwb3J0ZXMgcXVlIHNlIHB1ZWRlbiBzYWNhciBjb24gbGEgbGlicmVyw61hCmBgYHtyLCBjb21wYW55IGluZm99Cm9wdGlvbnMoSFRUUFVzZXJBZ2VudCA9ICJhIGFAZ21haWwuY29tIikKQ29tcGFueUluZm8oIkpQTSIpCmBgYAoKYGBge3IsIGFubnVhbCByZXBvcnRzfQpBbm51YWxSZXBvcnRzKCJCQUJBIiwgZm9yZWlnbiA9IFRSVUUpCmBgYAoKYGBge3IsIGVzdGFkbyBkZSByZXN1bHRhZG9zfQpnb29nbGVfaW5jb21lIDwtIEdldEluY29tZSgiR09PRyIsIDIwMTYpCmBgYAoKYGBge3IsIGJhbGFuY2UgZ2VuZXJhbH0KYW1hem9uX2JhbGFuY2UgPC0gR2V0QmFsYW5jZVNoZWV0KCJBTVpOIiwgMjAxNSkKYGBgCgpgYGB7ciwgZmx1am8gZGUgZWZlY3Rpdm99CmFwcGxlX2Nhc2ggPC0gR2V0Q2FzaEZsb3coIkFBUEwiLCAyMDE0KQpgYGA=