Skip to contents

Format Uphold file

Source: R/format_uphold.R
format_uphold.Rd

Format a .csv transaction history file from Uphold for later ACB processing.

Usage

format_uphold(data, list.prices = NULL, force = FALSE)

Arguments

data

The dataframe

list.prices

An optional explicit list.prices object from which to fetch coin prices. For exchanges that require external pricing, it must contain at least currency, spot.rate2, and date2.

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 of exchange transactions, formatted for further processing.

Examples

format_uphold(data_uphold)
#> Using cached 'list.prices'. To force a fresh download, use argument 'force = TRUE'.
#>                   date currency    quantity total.price spot.rate transaction
#> 1  2021-01-07 02:40:31      BAT  1.59081275          NA        NA     revenue
#> 2  2021-02-09 14:26:49      BAT 12.69812163          NA        NA     revenue
#> 3  2021-03-06 21:32:36      BAT  0.37591275          NA        NA     revenue
#> 4  2021-03-07 21:46:57      LTC  0.24129740          NA        NA         buy
#> 5  2021-03-07 21:46:57      BAT 52.59871206          NA        NA        sell
#> 6  2021-03-07 21:54:09      LTC  0.00300000          NA        NA        sell
#> 7  2021-04-05 12:22:00      BAT  8.52198415          NA        NA     revenue
#> 8  2021-04-06 03:41:42      LTC  0.00300000          NA        NA        sell
#> 9  2021-04-06 04:47:00      LTC  0.03605981          NA        NA         buy
#> 10 2021-04-06 04:47:00      BAT  8.52198415          NA        NA        sell
#> 11 2021-05-11 07:12:24      BAT  0.47521985          NA        NA     revenue
#> 12 2021-06-09 04:52:23      BAT  0.67207415          NA        NA     revenue
#>    description         comment revenue.type exchange               rate.source
#> 1           in            <NA>     airdrops   uphold             coinmarketcap
#> 2           in            <NA>     airdrops   uphold             coinmarketcap
#> 3           in            <NA>     airdrops   uphold             coinmarketcap
#> 4        trade         BAT-LTC         <NA>   uphold             coinmarketcap
#> 5        trade         BAT-LTC         <NA>   uphold coinmarketcap (buy price)
#> 6          out withdrawal fees         <NA>   uphold             coinmarketcap
#> 7           in            <NA>     airdrops   uphold             coinmarketcap
#> 8          out withdrawal fees         <NA>   uphold             coinmarketcap
#> 9        trade         BAT-LTC         <NA>   uphold             coinmarketcap
#> 10       trade         BAT-LTC         <NA>   uphold coinmarketcap (buy price)
#> 11          in            <NA>     airdrops   uphold             coinmarketcap
#> 12          in            <NA>     airdrops   uphold             coinmarketcap