Skip to contents

Convert USD to CAD (Bank of Canada rates)

Source: R/USD2CAD.R
USD2CAD.Rd

This function allows you to convert USD to CAD. The data is extracted from the CSV available for download at https://www.bankofcanada.ca/rates/exchange/daily-exchange-rates/ The Bank of Canada only provides data for business days. On days which data is not available, the last known value is used instead.

Usage

USD2CAD(data, conversion = "USD", force = FALSE)

cur2CAD_table()

Arguments

data

The data

conversion

What to convert to

force

Whether to force recreating list.prices even though it already exists (e.g., if you added new coins or new dates).

Value

A data frame, with the following columns: date, CAD.rate.

Examples

formatted.dates <- format_shakepay(data_shakepay)[1]
USD2CAD(formatted.dates)
#>                  date CAD.rate
#> 1 2021-05-07 14:50:41   1.2156
#> 2 2021-05-08 12:12:57   1.2156
#> 3 2021-05-09 12:22:07   1.2156
#> 4 2021-05-21 12:47:14   1.2061
#> 5 2021-06-11 12:03:31   1.2148
#> 6 2021-06-23 12:21:49   1.2287
#> 7 2021-07-10 00:52:19   1.2476
x <- cur2CAD_table()
head(x)
#>         date    AUD    BRL    CNY    EUR    HKD     INR     IDR     JPY    MYR
#> 1 2017-01-03 0.9702 0.4121 0.1930 1.3973 0.1732 0.01965 1.0e-04 0.01140 0.2991
#> 2 2017-01-04 0.9678 0.4129 0.1920 1.3930 0.1717 0.01959 9.9e-05 0.01134 0.2961
#> 3 2017-01-05 0.9708 0.4133 0.1922 1.4008 0.1708 0.01954 9.9e-05 0.01145 0.2953
#> 4 2017-01-06 0.9668 0.4116 0.1911 1.3953 0.1706 0.01942 9.9e-05 0.01133 0.2957
#> 5 2017-01-07 0.9668 0.4116 0.1911 1.3953 0.1706 0.01942 9.9e-05 0.01133 0.2957
#> 6 2017-01-08 0.9668 0.4116 0.1911 1.3953 0.1706 0.01942 9.9e-05 0.01133 0.2957
#>       MXN    NZD    NOK    PEN     RUB    SAR    SGD     ZAR      KRW    SEK
#> 1 0.06439 0.9295 0.1551 0.3976 0.02210 0.3582 0.9264 0.09740 0.001112 0.1465
#> 2 0.06242 0.9251 0.1546 0.3930 0.02200 0.3550 0.9240 0.09767 0.001111 0.1460
#> 3 0.06195 0.9285 0.1555 0.3930 0.02225 0.3531 0.9260 0.09743 0.001118 0.1468
#> 4 0.06213 0.9230 0.1551 0.3921 0.02222 0.3526 0.9202 0.09647 0.001103 0.1461
#> 5 0.06213 0.9230 0.1551 0.3921 0.02222 0.3526 0.9202 0.09647 0.001103 0.1461
#> 6 0.06213 0.9230 0.1551 0.3921 0.02222 0.3526 0.9202 0.09647 0.001103 0.1461
#>      CHF     TWD     THB    TRY    GBP    USD     VND CAD
#> 1 1.3064 0.04150 0.03739 0.3744 1.6459 1.3435 5.9e-05   1
#> 2 1.3005 0.04141 0.03717 0.3722 1.6377 1.3315 5.9e-05   1
#> 3 1.3083 0.04161 0.03709 0.3674 1.6400 1.3244 5.8e-05   1
#> 4 1.3020 0.04131 0.03704 0.3640 1.6275 1.3214 5.9e-05   1
#> 5 1.3020 0.04131 0.03704 0.3640 1.6275 1.3214 5.9e-05   1
#> 6 1.3020 0.04131 0.03704 0.3640 1.6275 1.3214 5.9e-05   1