Skip to contents

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

Usage

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

Arguments

data

The dataframe

list.prices

A list.prices object from which to fetch coin prices.

force

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

The way to download this file is to go to https://account.presearch.com/tokens/pre-wallet and click on the orange "Export to CSV" button at the bottom right of the screen.

As of 2024-12-27, it seems like this file does not include search rewards anymore. One explanation is found on a Reddit post: "you have to keep in mind that the tokens are considered the user's only when they hit the claim button."

Value

A data frame of exchange transactions, formatted for further processing.

Examples

format_presearch(data_presearch)
#> Object 'list.prices' already exists. Reusing 'list.prices'. To force a fresh download, use argument 'force = TRUE'.
#>                   date currency quantity total.price  spot.rate transaction
#> 1  2021-04-27 17:45:18      PRE     0.13  0.01209966 0.09307434     revenue
#> 2  2021-04-27 17:48:00      PRE     0.13  0.01209966 0.09307434     revenue
#> 3  2021-04-27 17:48:18      PRE     0.13  0.01209966 0.09307434     revenue
#> 4  2021-04-27 17:55:24      PRE     0.13  0.01209966 0.09307434     revenue
#> 5  2021-04-27 17:57:29      PRE     0.13  0.01209966 0.09307434     revenue
#> 6  2021-04-27 19:00:31      PRE     0.13  0.01209966 0.09307434     revenue
#> 7  2021-04-27 19:00:41      PRE     0.13  0.01209966 0.09307434     revenue
#> 8  2021-04-27 19:01:57      PRE     0.13  0.01209966 0.09307434     revenue
#> 9  2021-04-27 19:08:59      PRE     0.13  0.01209966 0.09307434     revenue
#> 10 2021-04-27 19:12:15      PRE     0.13  0.01209966 0.09307434     revenue
#> 11 2021-05-07 05:55:33      PRE  1000.00 78.96908966 0.07896909         buy
#>                                        description revenue.type  exchange
#> 1                                    Search Reward     airdrops presearch
#> 2                                    Search Reward     airdrops presearch
#> 3                                    Search Reward     airdrops presearch
#> 4                                    Search Reward     airdrops presearch
#> 5                                    Search Reward     airdrops presearch
#> 6                                    Search Reward     airdrops presearch
#> 7                                    Search Reward     airdrops presearch
#> 8                                    Search Reward     airdrops presearch
#> 9                                    Search Reward     airdrops presearch
#> 10                                   Search Reward     airdrops presearch
#> 11 Transferred from Presearch Portal (PO#: 412893)         <NA> presearch
#>      rate.source
#> 1  coinmarketcap
#> 2  coinmarketcap
#> 3  coinmarketcap
#> 4  coinmarketcap
#> 5  coinmarketcap
#> 6  coinmarketcap
#> 7  coinmarketcap
#> 8  coinmarketcap
#> 9  coinmarketcap
#> 10 coinmarketcap
#> 11 coinmarketcap