Format a .csv transaction history file from Presearch for later ACB processing.
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."
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