EPS 2020OCT25

 

>   eps_year_xts["2020::"]
             [,1]
2020-01-01 116.33
2020-04-01  99.16
2020-07-01  93.44
2020-10-01  89.68
2021-01-01 110.65
2021-04-01 129.66
2021-07-01 139.84
2021-10-01 148.29

$   tac eps.txt | awk '{gsub("\\$","",$NF);print "eps_year_xts[\"2019::\"]["NR"] <- "$NF}'

eps_year_xts["2019::"][1] <- 134.39

eps_year_xts["2019::"][2] <- 135.27

eps_year_xts["2019::"][3] <- 132.90

eps_year_xts["2019::"][4] <- 139.47

eps_year_xts["2019::"][5] <- 116.33

eps_year_xts["2019::"][6] <- 99.23

eps_year_xts["2019::"][7] <- 93.03

eps_year_xts["2019::"][8] <- 87.16

eps_year_xts["2019::"][9] <- 101.75

eps_year_xts["2019::"][10] <- 119.53

eps_year_xts["2019::"][11] <- 128.19

eps_year_xts["2019::"][12] <- 135.75

for reference

$    cat eps.txt 

12/31/2021 $44.69 $37.23 21.02 25.44 $164.30 $135.75

9/30/2021 $42.32 $36.45 22.20 26.94 $155.59 $128.19

6/30/2021 $40.10 $35.60 23.54 28.89 $146.68 $119.53

3/31/2021 $37.19 $26.47 25.89 33.94 $133.37 $101.75

12/31/2020 $35.98 $29.66 29.85 39.62 $115.68 $87.16

9/30/2020 (25.0%) 3363.00 $33.41 $27.79 29.05 37.12 $118.88 $93.03

6/30/2020 3100.29 $26.79 $17.83 24.75 31.24 $125.28 $99.23

3/31/2020 2584.59 $19.50 $11.88 18.64 22.22 $138.63 $116.33

12/31/2019 3230.78 $39.18 $35.53 20.56 23.16 $157.12 $139.47

9/30/2019  2976.74 $39.81 $33.99 19.46 22.40 $152.97 $132.90

6/30/2019 2941.76 $40.14 $34.93 19.04 21.75 $154.54 $135.27

3/31/2019 2834.40 $37.99 $35.02 18.52 21.09 $153.05 $134.39