2019年6月19日水曜日

EPS 2019JUN19



> eps_year_xts["2019::"]
             [,1]
2019-01-01 134.48
2019-04-01 137.14
2019-07-01 139.58
2019-10-01 150.77
2020-01-01 153.98
2020-04-01 158.28
2020-07-01 162.93
2020-10-01 167.58
> eps_year_xts["2019::"][1]
             [,1]
2019-01-01 134.48
> eps_year_xts["2019::"][1] <- 134.32
> eps_year_xts["2019::"][2] <- 137.01
> eps_year_xts["2019::"][3] <- 139.53
> eps_year_xts["2019::"][4] <- 150.72
> eps_year_xts["2019::"][5] <- 154.31
> eps_year_xts["2019::"][6] <- 158.70
> eps_year_xts["2019::"][7] <- 163.52
> eps_year_xts["2019::"][8] <- 168.46
> eps_year_xts["2019::"]
             [,1]
2019-01-01 134.32
2019-04-01 137.01
2019-07-01 139.53
2019-10-01 150.72
2020-01-01 154.31
2020-04-01 158.70
2020-07-01 163.52
2020-10-01 168.46

eps_year_xts["2019::"][1] <- 134.32
eps_year_xts["2019::"][2] <- 137.01
eps_year_xts["2019::"][3] <- 139.53
eps_year_xts["2019::"][4] <- 150.72
eps_year_xts["2019::"][5] <- 154.31
eps_year_xts["2019::"][6] <- 158.70
eps_year_xts["2019::"][7] <- 163.52
eps_year_xts["2019::"][8] <- 168.46

$cat eps.txt 
12/31/2020 $49.27 $45.10 15.65 17.17 $184.82 $168.46
9/30/2020 $47.66 $43.70 16.09 17.68 $179.67 $163.52
6/30/2020 $45.31 $41.13 16.55 18.22 $174.77 $158.70
3/31/2020 $42.58 $38.53 17.06 18.74 $169.53 $154.31
12/31/2019 $44.12 $40.16 17.53 19.19 $164.93 $150.72
9/30/2019 $42.76 $38.88 18.56 20.72 $155.84 $139.53
6/30/2019 $40.07 $36.74 18.72 21.11 $154.46 $137.01
3/31/2019 (98.2%) 2834.40 $37.98 $34.95 18.89 21.53 $153.04 $134.32

のとき

$tac eps.txt | awk '{gsub("\\$","",$NF);print "eps_year_xts[\"2019::\"]["NR"] <- "$NF}'
eps_year_xts["2019::"][1] <- 134.32
eps_year_xts["2019::"][2] <- 137.01
eps_year_xts["2019::"][3] <- 139.53
eps_year_xts["2019::"][4] <- 150.72
eps_year_xts["2019::"][5] <- 154.31
eps_year_xts["2019::"][6] <- 158.70
eps_year_xts["2019::"][7] <- 163.52

eps_year_xts["2019::"][8] <- 168.46

0 件のコメント: