EPS 2020MAY09

> eps_year_xts["2020::"]
             [,1]
2020-01-01 129.39
2020-04-01 117.62
2020-07-01 113.96
2020-10-01 113.05
2021-01-01 121.56
2021-04-01 133.87
2021-07-01 142.67
2021-10-01 149.17

~$ 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 (71.8%) 2584.59 $27.89 $21.10 19.25 22.55 $147.02 $125.55
6/30/2020 $24.57 $21.54 21.53 25.24 $131.45 $112.16
9/30/2020 $32.39 $29.58 22.82 26.27 $124.03 $107.75
12/31/2020 $37.09 $34.75 23.21 26.46 $121.94 $106.97
3/31/2021 $37.61 $33.28 21.50 23.76 $131.66 $119.15
6/30/2021 $39.19 $35.68 19.35 21.24 $146.28 $133.29
9/30/2021 $43.07 $39.53 18.03 19.76 $156.96 $143.24
12/31/2021 $45.25 $41.82 17.14 18.83 $165.12 $150.31
~$ 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] <- 125.55
eps_year_xts["2019::"][6] <- 112.16
eps_year_xts["2019::"][7] <- 107.75
eps_year_xts["2019::"][8] <- 106.97
eps_year_xts["2019::"][9] <- 119.15
eps_year_xts["2019::"][10] <- 133.29
eps_year_xts["2019::"][11] <- 143.24
eps_year_xts["2019::"][12] <- 150.31