Import data
# excel file
data <- read_excel("data/QQQ.xlsx")
dfdata = data.frame(data)
dfdata
## Date Close Diff20Day
## 1 2022-04-27 314.3448 -0.0553
## 2 2022-04-28 325.5090 -0.0147
## 3 2022-04-29 310.8615 -0.0547
## 4 2022-05-02 316.0517 -0.0491
## 5 2022-05-03 316.3891 -0.0457
## 6 2022-05-04 327.0869 -0.0182
## 7 2022-05-05 310.6134 -0.0495
## 8 2022-05-06 306.8920 -0.0514
## 9 2022-05-09 294.8843 -0.0772
## 10 2022-05-10 298.4668 -0.0705
## 11 2022-05-11 289.6148 -0.0991
## 12 2022-05-12 288.9301 -0.1016
## 13 2022-05-13 299.6378 -0.0777
## 14 2022-05-16 296.1645 -0.1069
## 15 2022-05-17 303.8355 -0.0721
## 16 2022-05-18 288.9201 -0.0721
## 17 2022-05-19 287.3720 -0.0721
## 18 2022-05-20 286.4789 -0.0951
## 19 2022-05-23 291.2423 -0.0377
## 20 2022-05-24 285.0498 -0.0615
## 21 2022-05-25 289.0392 -0.0800
## 22 2022-05-26 297.0477 -0.0220
## 23 2022-05-27 306.7432 -0.0220
## 24 2022-05-31 305.9294 -0.0204
## 25 2022-06-01 303.6668 -0.0438
## 26 2022-06-02 311.9829 -0.0016
## 27 2022-06-03 303.8653 -0.0166
## 28 2022-06-06 304.8775 0.0347
## 29 2022-06-07 307.5073 0.0416
## 30 2022-06-08 305.2943 0.0567
## 31 2022-06-09 297.1171 0.0345
## 32 2022-06-10 286.6376 -0.0146
## 33 2022-06-13 273.3101 -0.0264
## 34 2022-06-14 273.8062 -0.0474
## 35 2022-06-15 280.6437 -0.0021
## 36 2022-06-16 269.3207 -0.0308
## 37 2022-06-17 272.5956 -0.0254
## 38 2022-06-21 279.4730 -0.0200
## 39 2022-06-22 279.0654 -0.0186
## 40 2022-06-23 283.2215 -0.0210
## 41 2022-06-24 292.9256 -0.0072
## 42 2022-06-27 290.7780 -0.0272
## 43 2022-06-28 281.9189 -0.0525
## 44 2022-06-29 282.1774 -0.0603
## 45 2022-06-30 278.6776 -0.0912
## 46 2022-07-01 280.5170 -0.0777
## 47 2022-07-05 285.3194 -0.0898
## 48 2022-07-06 287.1488 -0.0824
## 49 2022-07-07 293.2935 -0.0560
## 50 2022-07-08 293.6614 -0.0258
## 51 2022-07-11 287.3875 -0.0255
## 52 2022-07-12 284.6035 -0.0159
## 53 2022-07-13 284.0169 -0.0313
## 54 2022-07-14 285.0311 -0.0278
## 55 2022-07-15 290.2013 0.0291
## 56 2022-07-18 287.7455 0.0220
## 57 2022-07-19 296.5945 0.0228
## 58 2022-07-20 301.2975 0.0449
## 59 2022-07-21 305.6227 0.0393
## 60 2022-07-22 300.2635 -0.0170
## 61 2022-07-25 298.5533 -0.0144
## 62 2022-07-26 292.6870 -0.0046
## 63 2022-07-27 305.0559 0.0289
## 64 2022-07-28 308.0388 0.0490
## 65 2022-07-29 313.6564 0.0627
## 66 2022-08-01 313.4675 0.0565
## 67 2022-08-02 312.5329 0.0514
## 68 2022-08-03 321.0440 0.0417
## 69 2022-08-04 322.5453 0.0301
## 70 2022-08-05 319.9105 0.0634
## 71 2022-08-08 318.8764 0.0686
## 72 2022-08-09 315.2672 0.0770
## 73 2022-08-10 324.0666 0.0962
## 74 2022-08-11 322.2272 0.0860
## 75 2022-08-12 328.5011 0.1060
## 76 2022-08-15 331.1558 0.0737
## 77 2022-08-16 330.3803 0.0694
## 78 2022-08-17 326.6120 0.0685
## 79 2022-08-18 327.3975 0.0908
## 80 2022-08-19 321.0141 0.0804
## 81 2022-08-22 312.5627 0.0752
## 82 2022-08-23 312.3042 0.0507
## 83 2022-08-24 313.2090 0.0538
## 84 2022-08-25 318.7472 0.0472
## 85 2022-08-26 305.6823 0.0206
## 86 2022-08-29 302.6696 0.0130
## 87 2022-08-30 299.2990 -0.0090
## 88 2022-08-31 297.5590 -0.0064
## 89 2022-09-01 297.6883 -0.0061
## 90 2022-09-02 293.4825 -0.0152
## 91 2022-09-06 291.3746 -0.0071
## 92 2022-09-07 297.2607 -0.0155
## 93 2022-09-08 298.8018 -0.0127
## 94 2022-09-09 305.3343 -0.0094
## 95 2022-09-12 308.9634 0.0020
## 96 2022-09-13 292.0209 -0.0375
## 97 2022-09-14 294.3375 -0.0340
## 98 2022-09-15 289.4357 -0.0422
## 99 2022-09-16 287.6659 -0.0460
## 100 2022-09-19 289.9060 -0.0206
## 101 2022-09-20 287.5952 -0.0260
## 102 2022-09-21 282.4455 -0.0518
## 103 2022-09-22 278.9692 -0.0515
## 104 2022-09-23 274.4271 -0.0375
## 105 2022-09-26 273.2916 -0.0353
## 106 2022-09-27 273.4012 -0.0210
## 107 2022-09-28 278.8397 -0.0212
## 108 2022-09-29 270.8015 -0.0485
## 109 2022-09-30 266.2096 -0.0453
## 110 2022-10-03 272.4549 -0.0378
## 111 2022-10-04 281.0211 -0.0220
## 112 2022-10-05 280.8717 -0.0245
## 113 2022-10-06 278.6604 -0.0430
## 114 2022-10-07 268.0423 -0.0757
## 115 2022-10-10 265.3629 -0.0421
## 116 2022-10-11 261.7173 -0.0537
## 117 2022-10-12 261.6277 -0.0526
## 118 2022-10-13 267.7634 -0.0163
## 119 2022-10-14 259.7152 -0.0424
## 120 2022-10-17 268.2914 -0.0146
## 121 2022-10-18 270.4130 0.0143
## 122 2022-10-19 269.4269 0.0117
## 123 2022-10-20 268.0523 0.0281
## 124 2022-10-21 274.3375 0.0489
## 125 2022-10-24 277.3556 0.0588
## 126 2022-10-25 283.0930 0.0650
## 127 2022-10-26 276.8376 0.0692
## 128 2022-10-27 271.7975 0.0708
## 129 2022-10-28 280.1147 0.0825
## 130 2022-10-31 276.8576 0.0502
## 131 2022-11-01 274.0287 0.0415
## 132 2022-11-02 264.6358 0.0215
## 133 2022-11-03 259.4662 0.0394
## 134 2022-11-04 263.6397 0.0580
## 135 2022-11-07 266.5382 0.0814
## 136 2022-11-08 268.4806 0.0873
## 137 2022-11-09 262.2851 0.0307
## 138 2022-11-10 281.6387 0.0840
## 139 2022-11-11 286.8282 0.0699
## 140 2022-11-14 284.3181 0.0536
## 141 2022-11-15 288.2526 0.0515
## 142 2022-11-16 284.3181 0.0373
## 143 2022-11-17 283.6906 0.0177
## 144 2022-11-18 283.7006 0.0122
## 145 2022-11-21 280.7821 0.0051
## 146 2022-11-22 284.8261 0.0265
## 147 2022-11-23 287.6848 0.0401
## 148 2022-11-25 285.7923 0.0108
## 149 2022-11-28 281.5988 -0.0035
## 150 2022-11-29 279.4673 0.0008
## 151 2022-11-30 292.2070 0.0495
## 152 2022-12-01 292.5656 0.0463
## 153 2022-12-02 291.4001 0.0254
## 154 2022-12-05 286.5095 0.0026
## 155 2022-12-06 280.5729 -0.0175
## 156 2022-12-07 279.4274 -0.0036
## 157 2022-12-08 282.7344 -0.0213
## 158 2022-12-09 280.9315 -0.0328
## 159 2022-12-12 284.4576 -0.0115
## 160 2022-12-13 287.5155 -0.0179
## 161 2022-12-14 285.3839 -0.0119
## 162 2022-12-15 275.8017 -0.0404
## 163 2022-12-16 273.1721 -0.0581
## 164 2022-12-19 269.3330 -0.0548
## 165 2022-12-20 269.1234 -0.0536
## 166 2022-12-21 273.0273 -0.0410
## 167 2022-12-22 266.3477 -0.0540
## 168 2022-12-23 266.9467 -0.0288
## 169 2022-12-27 263.1726 -0.0267
## 170 2022-12-28 259.6980 -0.0559
## 171 2022-12-29 266.0282 -0.0356
## 172 2022-12-30 265.8684 -0.0306
## 173 2023-01-03 264.0712 -0.0351
## 174 2023-01-04 265.3292 -0.0153
## 175 2023-01-05 261.1757 -0.0184
## 176 2023-01-06 268.3845 -0.0184
## 177 2023-01-09 270.1218 -0.0218
## 178 2023-01-10 272.4083 -0.0235
## 179 2023-01-11 277.1210 -0.0123
## 180 2023-01-12 278.6187 -0.0087
## 181 2023-01-13 280.5357 0.0261
## 182 2023-01-17 281.1048 0.0375
## 183 2023-01-18 277.4505 0.0078
## 184 2023-01-19 274.7247 -0.0063
## 185 2023-01-20 282.2430 0.0053
## 186 2023-01-23 288.5133 0.0347
## 187 2023-01-24 287.9243 0.0181
## 188 2023-01-25 287.2852 0.0125
## 189 2023-01-26 292.8866 0.0383
## 190 2023-01-27 295.8021 0.0293
## 191 2023-01-30 289.8213 0.0169
## 192 2023-01-31 294.1646 0.0396
## 193 2023-02-01 300.4549 0.0454
## 194 2023-02-02 311.2382 0.0723
## 195 2023-02-03 305.7067 0.0607
## 196 2023-02-06 303.1207 0.0660
## 197 2023-02-07 309.4010 0.0682
## 198 2023-02-08 303.8995 0.0464
## 199 2023-02-09 301.2137 0.0468
## 200 2023-02-10 299.2368 0.0445
## 201 2023-02-13 304.0293 0.0530
## 202 2023-02-14 306.2758 0.0867
## 203 2023-02-15 308.6222 0.0987
## 204 2023-02-16 302.8312 0.0622
## 205 2023-02-17 300.6945 0.0414
## 206 2023-02-21 293.5755 0.0381
## 207 2023-02-22 293.7952 0.0355
## 208 2023-02-23 296.3612 0.0227
## 209 2023-02-24 291.3989 0.0140
## 210 2023-02-27 293.4857 0.0240
## 211 2023-02-28 293.1062 0.0095
## 212 2023-03-01 290.7499 0.0102
## 213 2023-03-02 293.1562 0.0074
## 214 2023-03-03 299.2168 0.0148
## 215 2023-03-06 299.5562 0.0154
## 216 2023-03-07 295.8819 -0.0151
## 217 2023-03-08 297.3596 0.0011
## 218 2023-03-09 292.2076 -0.0192
## 219 2023-03-10 288.1040 -0.0577
## 220 2023-03-13 290.2407 -0.0804
## 221 2023-03-14 296.9103 -0.0592
## 222 2023-03-15 298.4679 -0.0857
## 223 2023-03-16 306.3358 -0.0506
## 224 2023-03-17 304.8880 -0.0686
## 225 2023-03-20 305.9700 -0.0466
## 226 2023-03-21 310.3400 -0.0212
## 227 2023-03-22 306.1200 -0.0527
## 228 2023-03-23 309.7500 -0.0557
## 229 2023-03-24 310.8900 -0.0499
## 230 2023-03-27 308.7600 -0.0299
## 231 2023-03-28 307.1200 -0.0379
## 232 2023-03-29 312.7200 -0.0339
## 233 2023-03-30 315.6800 -0.0375
## 234 2023-03-31 320.9300 -0.0322
## 235 2023-04-03 320.1500 -0.0148
## 236 2023-04-04 319.0700 -0.0292
## 237 2023-04-05 315.9200 -0.0102
## 238 2023-04-06 318.0500 0.0274
## 239 2023-04-10 317.8700 0.0532
## 240 2023-04-11 315.8300 0.0262
## 241 2023-04-12 313.0400 0.0405
## 242 2023-04-13 319.1700 0.0303
## 243 2023-04-14 318.5700 0.0571
## 244 2023-04-17 318.8400 0.0528
## 245 2023-04-18 318.8600 0.0298
## 246 2023-04-19 318.7100 0.0624
## 247 2023-04-20 316.2800 0.0584
## 248 2023-04-21 316.6100 0.0549
## 249 2023-04-24 315.9500 0.0371
## 250 2023-04-25 309.9900 0.0117
## 251 2023-04-26 311.8700 -0.0048
## 252 2023-04-27 320.3500 0.0177
## 253 2023-04-28 322.5600 0.0103
## 254 2023-05-01 322.1900 0.0220
## 255 2023-05-02 319.3800 0.0096
## 256 2023-05-03 317.2900 0.0027
## 257 2023-05-04 316.1700 -0.0080
## 258 2023-05-05 322.8900 0.0053
## 259 2023-05-08 323.6900 0.0114
## 260 2023-05-09 321.6400 0.0146
## 261 2023-05-10 325.1400 -0.0048
## 262 2023-05-11 326.2000 -0.0124
## 263 2023-05-12 325.0300 -0.0175
Plot data
closeChart <- ggplot(data = data) +
geom_line(mapping = aes(x = Date, y = Close * 1, color = "green"))
closeChart
diffChart <- ggplot(data = data) +
geom_line(mapping = aes(x = Date, y = Diff20Day * 100, color = "green"))
diffChart
