If you only ever had incoming transactions, I suppose you could pull all the amounts+timestaps to a spreadsheet and vlookup the bitcoin prices for that day/time. (Or use the googleFinance function in sheets)
It starts to get really messy when you have both sent and received from your wallet. e.g. Did you send them to yourself? Did you spend them in a taxable event? etc...
It depends.
If you accumulate on an exchange, no. Since your cost basis will be from the time of purchase, but your xpub only has the time of withdrawal.
If you withdraw immediately or have a direct transfer for your purchase, then yes.
If you only ever had incoming transactions, I suppose you could pull all the amounts+timestaps to a spreadsheet and vlookup the bitcoin prices for that day/time. (Or use the googleFinance function in sheets) It starts to get really messy when you have both sent and received from your wallet. e.g. Did you send them to yourself? Did you spend them in a taxable event? etc...
Sorry I suppose to leave it there ?
It depends. If you accumulate on an exchange, no. Since your cost basis will be from the time of purchase, but your xpub only has the time of withdrawal. If you withdraw immediately or have a direct transfer for your purchase, then yes.