EPS 2019OCT07

$cat eps.txt 

12/31/2020 $47.81 $44.23 16.53 18.00 $180.06 $165.38
9/30/2020 $46.25 $42.60 17.06 18.62 $174.46 $159.83
6/30/2020 $44.53 $40.53 17.61 19.29 $169.02 $154.31
3/31/2020 $41.47 $38.02 18.08 20.02 $164.63 $148.71
12/31/2019 $42.21 $38.69 18.47 20.43 $161.15 $145.71
9/30/2019 2976.74 $40.81 $37.08 19.33 21.89 $153.97 $135.99
6/30/2019 (97.7%) 2941.76 $40.14 $34.93 19.26 22.01 $154.54 $135.27

3/31/2019 2834.40 $37.99 $35.02 18.76 21.30 $153.05 $134.39

# use tac command to invert eps.txt.



$ tac eps.txt 

3/31/2019 2834.40 $37.99 $35.02 18.76 21.30 $153.05 $134.39
6/30/2019 (97.7%) 2941.76 $40.14 $34.93 19.26 22.01 $154.54 $135.27
9/30/2019 2976.74 $40.81 $37.08 19.33 21.89 $153.97 $135.99
12/31/2019 $42.21 $38.69 18.47 20.43 $161.15 $145.71
3/31/2020 $41.47 $38.02 18.08 20.02 $164.63 $148.71
6/30/2020 $44.53 $40.53 17.61 19.29 $169.02 $154.31
9/30/2020 $46.25 $42.60 17.06 18.62 $174.46 $159.83
12/31/2020 $47.81 $44.23 16.53 18.00 $180.06 $165.38

$ 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] <- 135.99
eps_year_xts["2019::"][4] <- 145.71
eps_year_xts["2019::"][5] <- 148.71
eps_year_xts["2019::"][6] <- 154.31
eps_year_xts["2019::"][7] <- 159.83
eps_year_xts["2019::"][8] <- 165.38


> eps_year_xts["2019::"]
             [,1]
2019-01-01 134.39
2019-04-01 135.44
2019-07-01 136.41
2019-10-01 146.35
2020-01-01 149.59
2020-04-01 155.21
2020-07-01 160.75
2020-10-01 166.45
> eps_year_xts["2019::"][1] <- 134.39
> eps_year_xts["2019::"][2] <- 135.27
> eps_year_xts["2019::"][3] <- 135.99
> eps_year_xts["2019::"][4] <- 145.71
> eps_year_xts["2019::"][5] <- 148.71
> eps_year_xts["2019::"][6] <- 154.31
> eps_year_xts["2019::"][7] <- 159.83
> eps_year_xts["2019::"][8] <- 165.38
> eps_year_xts["2019::"]
             [,1]
2019-01-01 134.39
2019-04-01 135.27
2019-07-01 135.99
2019-10-01 145.71
2020-01-01 148.71
2020-04-01 154.31
2020-07-01 159.83
2020-10-01 165.38