EPS2020MAY13 has a serious problem. where data length should be 12, it has only 11 entries.
~$ 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 (90.3%) 2584.59 $20.00 $12.56 20.50 24.38 $139.13 $117.01
6/30/2020 $23.66 $21.18 23.26 27.62 $122.65 $103.26
9/30/2020 $31.60 $28.27 24.93 29.24 $114.44 $97.55
12/31/2020 $36.41 $33.57 25.54 29.84 $111.67 $95.59
3/31/2021 $37.29 $33.26 22.12 24.53 $128.96 $116.28
6/30/2021 $38.53 $34.73 19.83 21.97 $143.83 $129.84
9/30/2021 $42.52 $38.61 18.43 20.35 $154.75 $140.17
12/31/2021 $44.80 $40.82 17.49 19.35 $163.14 $147.42
~$ 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] <- 117.01
eps_year_xts["2019::"][6] <- 103.26
eps_year_xts["2019::"][7] <- 97.55
eps_year_xts["2019::"][8] <- 95.59
eps_year_xts["2019::"][9] <- 116.28
eps_year_xts["2019::"][10] <- 129.84
eps_year_xts["2019::"][11] <- 140.17
eps_year_xts["2019::"][12] <- 147.42
0 件のコメント:
コメントを投稿