library(readxl)
## Warning: package 'readxl' was built under R version 4.5.3
datos<- read_excel("C:/Users/admin/Documents/Maestria en Finanzas/Analitica de negocios/Clase #1/Datos Practica/Colombina.xlsx",
col_types = c("date", "numeric", "numeric",
"numeric", "numeric", "numeric",
"numeric", "numeric", "numeric",
"numeric", "numeric", "numeric"))
## Warning: Coercing numeric to date in A48 / R48C1
## Warning: Coercing numeric to date in A49 / R49C1
## Warning: Coercing numeric to date in A50 / R50C1
## Warning: Coercing numeric to date in A51 / R51C1
## Warning: Coercing numeric to date in A52 / R52C1
## Warning: Coercing numeric to date in A53 / R53C1
## Warning: Coercing numeric to date in A54 / R54C1
## Warning: Coercing numeric to date in A55 / R55C1
## Warning: Coercing numeric to date in A56 / R56C1
head(datos)
## # A tibble: 6 × 12
## FECHA INGRESOS UTILIDADOPER ACTIVOS PASIVOS EBITDA QUICKRATIO
## <dttm> <dbl> <dbl> <dbl> <dbl> <dbl> <dbl>
## 1 2016-01-01 00:00:00 400871238 134228489 1.39e9 1.20e9 4.78e7 0.46
## 2 2016-04-01 00:00:00 398002762 132113511 1.38e9 1.19e9 3.65e7 0.61
## 3 2016-07-01 00:00:00 480807000 163638000 1.40e9 1.20e9 5.52e7 0.59
## 4 2016-10-01 00:00:00 469500000 158209000 1.42e9 1.18e9 7.80e7 0.5
## 5 2017-01-01 00:00:00 397086000 138297000 1.43e9 1.24e9 4.99e7 0.54
## 6 2017-04-01 00:00:00 398514000 136094000 1.46e9 1.27e9 4.37e7 0.56
## # ℹ 5 more variables: MEBITDA <dbl>, MBRUTO <dbl>, MOPERACIONAL <dbl>,
## # ROA <dbl>, ROE <dbl>