| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | See https://blog.dcycle.com/blog/2023-06-16/market-vs-limit-price-worth-it/ | |||||||
2 | ||||||||
3 | Percentage bid less than market price => | 0.50% | If always using market price | 257,699.12 | ||||
4 | Total USD purchased with CAD | 200,000.00 | If always using limit price | 258,307.05 | ||||
5 | Number of days to wait => | 20 | (gain) or loss (negative is good) | 607.92 | ||||
6 | % gain (negative is good) | 0.24% | ||||||
7 | Date | CAD-USD | Minimum price in the 20 next days | Percentage diff | Hit | Price on day 21 | Market transaction | Limit transaction |
8 | 2020-12-31 | 1.2730 | 1.2630 | 0.79% | TRUE | 1.2830 | 1.2730 | 1.2666 |
9 | 2021-01-01 | 1.2740 | 1.2630 | 0.87% | TRUE | 1.2780 | 1.2740 | 1.2676 |
10 | 2021-01-04 | 1.2784 | 1.2630 | 1.21% | TRUE | 1.2780 | 1.2784 | 1.2720 |
11 | 2021-01-05 | 1.2674 | 1.2630 | 0.35% | FALSE | 1.2850 | 1.2674 | 1.2850 |
12 | 2021-01-06 | 1.2679 | 1.2630 | 0.39% | FALSE | 1.2787 | 1.2679 | 1.2787 |
13 | 2021-01-07 | 1.2689 | 1.2630 | 0.47% | FALSE | 1.2785 | 1.2689 | 1.2785 |
14 | 2021-01-08 | 1.2694 | 1.2630 | 0.51% | TRUE | 1.2823 | 1.2694 | 1.2630 |
15 | 2021-01-11 | 1.2782 | 1.2630 | 1.20% | TRUE | 1.2762 | 1.2782 | 1.2718 |
16 | 2021-01-12 | 1.2714 | 1.2630 | 0.67% | TRUE | 1.2740 | 1.2714 | 1.2651 |
17 | 2021-01-13 | 1.2701 | 1.2630 | 0.56% | TRUE | 1.2697 | 1.2701 | 1.2638 |
18 | 2021-01-14 | 1.2644 | 1.2630 | 0.12% | FALSE | 1.2699 | 1.2644 | 1.2699 |
19 | 2021-01-15 | 1.2740 | 1.2630 | 0.87% | TRUE | 1.2701 | 1.2740 | 1.2677 |
20 | 2021-01-18 | 1.2755 | 1.2630 | 0.98% | TRUE | 1.2693 | 1.2755 | 1.2691 |
21 | 2021-01-19 | 1.2733 | 1.2630 | 0.81% | TRUE | 1.2642 | 1.2733 | 1.2669 |
22 | 2021-01-20 | 1.2630 | 1.2630 | 0.00% | FALSE | 1.2693 | 1.2630 | 1.2693 |
23 | 2021-01-21 | 1.2649 | 1.2642 | 0.06% | FALSE | 1.2705 | 1.2649 | 1.2705 |
24 | 2021-01-22 | 1.2733 | 1.2642 | 0.72% | TRUE | 1.2680 | 1.2733 | 1.2669 |
25 | 2021-01-25 | 1.2739 | 1.2642 | 0.77% | TRUE | 1.2617 | 1.2739 | 1.2676 |
26 | 2021-01-26 | 1.2692 | 1.2617 | 0.59% | TRUE | 1.2614 | 1.2692 | 1.2629 |
27 | 2021-01-27 | 1.2817 | 1.2614 | 1.58% | TRUE | 1.2591 | 1.2817 | 1.2753 |
28 | 2021-01-28 | 1.2830 | 1.2591 | 1.86% | TRUE | 1.2517 | 1.2830 | 1.2765 |
29 | 2021-01-29 | 1.2780 | 1.2517 | 2.05% | TRUE | 1.2598 | 1.2780 | 1.2716 |
30 | 2021-01-31 | 1.2780 | 1.2517 | 2.05% | TRUE | 1.2732 | 1.2780 | 1.2716 |
31 | 2021-02-01 | 1.2850 | 1.2517 | 2.59% | TRUE | 1.2644 | 1.2850 | 1.2786 |
32 | 2021-02-02 | 1.2787 | 1.2517 | 2.10% | TRUE | 1.2642 | 1.2787 | 1.2723 |
33 | 2021-02-03 | 1.2785 | 1.2517 | 2.09% | TRUE | 1.2656 | 1.2785 | 1.2721 |
34 | 2021-02-04 | 1.2823 | 1.2517 | 2.38% | TRUE | 1.2663 | 1.2823 | 1.2759 |
35 | 2021-02-05 | 1.2762 | 1.2517 | 1.92% | TRUE | 1.2656 | 1.2762 | 1.2698 |
36 | 2021-02-08 | 1.2740 | 1.2517 | 1.75% | TRUE | 1.2669 | 1.2740 | 1.2676 |
37 | 2021-02-09 | 1.2697 | 1.2517 | 1.42% | TRUE | 1.2637 | 1.2697 | 1.2634 |
38 | 2021-02-10 | 1.2699 | 1.2517 | 1.43% | TRUE | 1.2620 | 1.2699 | 1.2635 |
39 | 2021-02-11 | 1.2701 | 1.2517 | 1.44% | TRUE | 1.2535 | 1.2701 | 1.2637 |
40 | 2021-02-12 | 1.2693 | 1.2517 | 1.38% | TRUE | 1.2476 | 1.2693 | 1.2629 |
41 | 2021-02-15 | 1.2642 | 1.2476 | 1.31% | TRUE | 1.2479 | 1.2642 | 1.2578 |
42 | 2021-02-16 | 1.2693 | 1.2476 | 1.71% | TRUE | 1.2444 | 1.2693 | 1.2629 |
43 | 2021-02-17 | 1.2705 | 1.2444 | 2.06% | TRUE | 1.2408 | 1.2705 | 1.2641 |
44 | 2021-02-18 | 1.2680 | 1.2408 | 2.15% | TRUE | 1.2492 | 1.2680 | 1.2617 |
45 | 2021-02-19 | 1.2617 | 1.2408 | 1.66% | TRUE | 1.2506 | 1.2617 | 1.2553 |
46 | 2021-02-22 | 1.2614 | 1.2408 | 1.64% | TRUE | 1.2524 | 1.2614 | 1.2551 |
47 | 2021-02-23 | 1.2591 | 1.2408 | 1.46% | TRUE | 1.2578 | 1.2591 | 1.2528 |
48 | 2021-02-24 | 1.2517 | 1.2408 | 0.88% | TRUE | 1.2579 | 1.2517 | 1.2455 |
49 | 2021-02-25 | 1.2598 | 1.2408 | 1.51% | TRUE | 1.2608 | 1.2598 | 1.2535 |
50 | 2021-02-26 | 1.2732 | 1.2408 | 2.55% | TRUE | 1.2610 | 1.2732 | 1.2669 |
51 | 2021-03-01 | 1.2644 | 1.2408 | 1.87% | TRUE | 1.2593 | 1.2644 | 1.2581 |
52 | 2021-03-02 | 1.2642 | 1.2408 | 1.85% | TRUE | 1.2628 | 1.2642 | 1.2578 |
53 | 2021-03-03 | 1.2656 | 1.2408 | 1.96% | TRUE | 1.2563 | 1.2656 | 1.2593 |
54 | 2021-03-04 | 1.2663 | 1.2408 | 2.02% | TRUE | 1.2543 | 1.2663 | 1.2600 |
55 | 2021-03-05 | 1.2656 | 1.2408 | 1.96% | TRUE | 1.2575 | 1.2656 | 1.2593 |
56 | 2021-03-08 | 1.2669 | 1.2408 | 2.07% | TRUE | 1.2526 | 1.2669 | 1.2606 |
57 | 2021-03-09 | 1.2637 | 1.2408 | 1.82% | TRUE | 1.2570 | 1.2637 | 1.2574 |
58 | 2021-03-10 | 1.2620 | 1.2408 | 1.68% | TRUE | 1.2612 | 1.2620 | 1.2556 |
59 | 2021-03-11 | 1.2535 | 1.2408 | 1.01% | TRUE | 1.2564 | 1.2535 | 1.2472 |
60 | 2021-03-12 | 1.2476 | 1.2408 | 0.55% | TRUE | 1.2530 | 1.2476 | 1.2413 |
61 | 2021-03-15 | 1.2479 | 1.2408 | 0.57% | TRUE | 1.2564 | 1.2479 | 1.2417 |
62 | 2021-03-16 | 1.2444 | 1.2408 | 0.29% | FALSE | 1.2533 | 1.2444 | 1.2533 |
63 | 2021-03-17 | 1.2408 | 1.2408 | 0.00% | FALSE | 1.2519 | 1.2408 | 1.2519 |
64 | 2021-03-18 | 1.2492 | 1.2492 | 0.00% | FALSE | 1.2544 | 1.2492 | 1.2544 |
65 | 2021-03-19 | 1.2506 | 1.2506 | 0.00% | FALSE | 1.2509 | 1.2506 | 1.2509 |
66 | 2021-03-22 | 1.2524 | 1.2509 | 0.12% | FALSE | 1.2530 | 1.2524 | 1.2530 |
67 | 2021-03-23 | 1.2578 | 1.2509 | 0.56% | TRUE | 1.2610 | 1.2578 | 1.2516 |
68 | 2021-03-24 | 1.2579 | 1.2509 | 0.56% | TRUE | 1.2497 | 1.2579 | 1.2516 |
69 | 2021-03-25 | 1.2608 | 1.2497 | 0.88% | TRUE | 1.2504 | 1.2608 | 1.2544 |
70 | 2021-03-26 | 1.2610 | 1.2497 | 0.90% | TRUE | 1.2476 | 1.2610 | 1.2547 |
71 | 2021-03-29 | 1.2593 | 1.2476 | 0.93% | TRUE | 1.2394 | 1.2593 | 1.2530 |
72 | 2021-03-30 | 1.2628 | 1.2394 | 1.85% | TRUE | 1.2403 | 1.2628 | 1.2564 |
73 | 2021-03-31 | 1.2563 | 1.2394 | 1.34% | TRUE | 1.2316 | 1.2563 | 1.2500 |
74 | 2021-04-01 | 1.2543 | 1.2316 | 1.81% | TRUE | 1.2282 | 1.2543 | 1.2480 |
75 | 2021-04-02 | 1.2575 | 1.2282 | 2.33% | TRUE | 1.2292 | 1.2575 | 1.2512 |
76 | 2021-04-05 | 1.2526 | 1.2282 | 1.95% | TRUE | 1.2278 | 1.2526 | 1.2463 |
77 | 2021-04-06 | 1.2570 | 1.2278 | 2.33% | TRUE | 1.2307 | 1.2570 | 1.2507 |
78 | 2021-04-07 | 1.2612 | 1.2278 | 2.65% | TRUE | 1.2268 | 1.2612 | 1.2549 |
79 | 2021-04-08 | 1.2564 | 1.2268 | 2.36% | TRUE | 1.2155 | 1.2564 | 1.2501 |
80 | 2021-04-09 | 1.2530 | 1.2155 | 2.99% | TRUE | 1.2136 | 1.2530 | 1.2467 |
81 | 2021-04-12 | 1.2564 | 1.2136 | 3.41% | TRUE | 1.2103 | 1.2564 | 1.2501 |
82 | 2021-04-13 | 1.2533 | 1.2103 | 3.43% | TRUE | 1.2096 | 1.2533 | 1.2470 |
83 | 2021-04-14 | 1.2519 | 1.2096 | 3.38% | TRUE | 1.2133 | 1.2519 | 1.2456 |
84 | 2021-04-15 | 1.2544 | 1.2096 | 3.57% | TRUE | 1.2167 | 1.2544 | 1.2481 |
85 | 2021-04-16 | 1.2509 | 1.2096 | 3.30% | TRUE | 1.2108 | 1.2509 | 1.2446 |
86 | 2021-04-19 | 1.2530 | 1.2096 | 3.47% | TRUE | 1.2070 | 1.2530 | 1.2468 |
87 | 2021-04-20 | 1.2610 | 1.2070 | 4.28% | TRUE | 1.2064 | 1.2610 | 1.2547 |
88 | 2021-04-21 | 1.2497 | 1.2064 | 3.46% | TRUE | 1.2131 | 1.2497 | 1.2435 |
89 | 2021-04-22 | 1.2504 | 1.2064 | 3.52% | TRUE | 1.2059 | 1.2504 | 1.2441 |
90 | 2021-04-23 | 1.2476 | 1.2059 | 3.34% | TRUE | 1.2068 | 1.2476 | 1.2413 |
91 | 2021-04-26 | 1.2394 | 1.2059 | 2.71% | TRUE | 1.2047 | 1.2394 | 1.2332 |
92 | 2021-04-27 | 1.2403 | 1.2047 | 2.87% | TRUE | 1.2066 | 1.2403 | 1.2341 |
93 | 2021-04-28 | 1.2316 | 1.2047 | 2.18% | TRUE | 1.2123 | 1.2316 | 1.2254 |
94 | 2021-04-29 | 1.2282 | 1.2047 | 1.91% | TRUE | 1.2070 | 1.2282 | 1.2220 |
95 | 2021-04-30 | 1.2292 | 1.2047 | 1.99% | TRUE | 1.2078 | 1.2292 | 1.2230 |
96 | 2021-05-03 | 1.2278 | 1.2047 | 1.88% | TRUE | 1.2066 | 1.2278 | 1.2216 |
97 | 2021-05-04 | 1.2307 | 1.2047 | 2.11% | TRUE | 1.2072 | 1.2307 | 1.2245 |
98 | 2021-05-05 | 1.2268 | 1.2047 | 1.80% | TRUE | 1.2037 | 1.2268 | 1.2206 |
99 | 2021-05-06 | 1.2155 | 1.2037 | 0.98% | TRUE | 1.2110 | 1.2155 | 1.2095 |
100 | 2021-05-07 | 1.2136 | 1.2037 | 0.82% | TRUE | 1.2084 | 1.2136 | 1.2075 |