EPS 2020APR29

> eps_year_xts["2019::"]
             [,1]
2019-01-01 134.39
2019-04-01 135.27
2019-07-01 132.90
2019-10-01 139.47
2020-01-01 138.15
2020-04-01 139.29
2020-07-01 144.62
2020-10-01 149.92
2021-01-01 154.52
2021-04-01 159.07
2021-07-01 163.75
2021-10-01 166.82

~$ tac eps.txt 
3/31/2019 2834.40 $37.99 $35.02 18.52 21.09 $153.05 $134.39
6/30/2019 2941.76 $40.14 $34.93 19.04 21.75 $154.54 $135.27
9/30/2019  2976.74 $39.81 $33.99 19.46 22.40 $152.97 $132.90
12/31/2019 3230.78 $39.18 $35.53 20.56 23.16 $157.12 $139.47
3/31/2020 (27.6%) 2584.59 $31.90 $24.94 18.52 21.62 $151.03 $129.39
6/30/2020 $29.40 $23.16 19.94 23.79 $140.29 $117.62
9/30/2020 $35.66 $30.33 20.55 24.55 $136.14 $113.96
12/31/2020 $39.12 $34.62 20.56 24.75 $136.08 $113.05
3/31/2021 $38.75 $33.45 19.57 23.02 $142.93 $121.56
6/30/2021 $41.34 $35.47 18.07 20.90 $154.87 $133.87
9/30/2021 $44.53 $39.12 17.09 19.61 $163.74 $142.67
12/31/2021 $46.25 $41.13 16.37 18.76 $170.87 $149.17

   
~$ 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] <- 129.39
eps_year_xts["2019::"][6] <- 117.62
eps_year_xts["2019::"][7] <- 113.96
eps_year_xts["2019::"][8] <- 113.05
eps_year_xts["2019::"][9] <- 121.56
eps_year_xts["2019::"][10] <- 133.87
eps_year_xts["2019::"][11] <- 142.67
eps_year_xts["2019::"][12] <- 149.17