2020年5月13日水曜日

EPS 2020MAY13


> eps_year_xts["2020::"]
             [,1]
2020-01-01 125.55
2020-04-01 112.16
2020-07-01 107.75
2020-10-01 106.97
2021-01-01 119.15
2021-04-01 133.29
2021-07-01 143.24
2021-10-01 150.31

~$ cat eps.txt 
12/31/2021 $45.05 $41.12 17.84 19.84 $164.19 $147.68
9/30/2021 $42.79 $38.61 18.79 20.86 $155.89 $140.44
6/30/2021 $38.88 $34.70 20.21 22.50 $144.98 $130.19
3/31/2021 $37.47 $33.25 22.52 25.31 $130.07 $115.77
12/31/2020 $36.75 $33.89 25.92 30.79 $113.03 $95.16
9/30/2020 $31.88 $28.35 25.38 30.27 $115.46 $96.80
6/30/2020 $23.97 $20.28 23.74 28.60 $123.39 $102.44
3/31/2020 (88.1%) 2584.59 $20.43 $12.64 20.99 25.02 $139.56 $117.09
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

~$ tac eps.txt | awk '{gsub("\\$","",$NF);print "eps_year_xts[\"2019::\"]["NR"] <- "$NF}'
eps_year_xts["2019::"][1] <- 135.27
eps_year_xts["2019::"][2] <- 132.90
eps_year_xts["2019::"][3] <- 139.47
eps_year_xts["2019::"][4] <- 117.09
eps_year_xts["2019::"][5] <- 102.44
eps_year_xts["2019::"][6] <- 96.80
eps_year_xts["2019::"][7] <- 95.16
eps_year_xts["2019::"][8] <- 115.77
eps_year_xts["2019::"][9] <- 130.19
eps_year_xts["2019::"][10] <- 140.44
eps_year_xts["2019::"][11] <- 147.68

0 件のコメント: