Bitcoin Forum
May 04, 2024, 12:36:35 AM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: An easy way to figure out what you have paid for BTC?  (Read 188 times)
Dr.Ona (OP)
Jr. Member
*
Offline Offline

Activity: 58
Merit: 13


View Profile
May 10, 2021, 11:31:00 AM
 #1

Hello All,
If you have made several purchases of BTC though out the last couple years, how do you figure out what price you've paid?
Is there an app or site that can do this type of spread sheet for you?

Thanks!
1714782995
Hero Member
*
Offline Offline

Posts: 1714782995

View Profile Personal Message (Offline)

Ignore
1714782995
Reply with quote  #2

1714782995
Report to moderator
I HATE TABLES I HATE TABLES I HA(╯°□°)╯︵ ┻━┻ TABLES I HATE TABLES I HATE TABLES
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714782995
Hero Member
*
Offline Offline

Posts: 1714782995

View Profile Personal Message (Offline)

Ignore
1714782995
Reply with quote  #2

1714782995
Report to moderator
1714782995
Hero Member
*
Offline Offline

Posts: 1714782995

View Profile Personal Message (Offline)

Ignore
1714782995
Reply with quote  #2

1714782995
Report to moderator
1714782995
Hero Member
*
Offline Offline

Posts: 1714782995

View Profile Personal Message (Offline)

Ignore
1714782995
Reply with quote  #2

1714782995
Report to moderator
20kevin20
Legendary
*
Offline Offline

Activity: 1134
Merit: 1597


View Profile
May 10, 2021, 11:37:07 AM
 #2

You can manually insert your transactions and prices in Delta, although it's closed source and I don't recommend it. I typically do this kind of stuff on a LibreOffice spreadsheet so that none of my tx info goes towards a centralized server.

There is also the option to track Bitcoin transactions through Delta by adding the public address, as far as I know. It should automatically process all your transactions and calculate the prices and all.
BlackHatCoiner
Legendary
*
Offline Offline

Activity: 1512
Merit: 7342


Farewell, Leo


View Profile
May 10, 2021, 11:43:29 AM
Last edit: May 12, 2021, 04:42:57 PM by BlackHatCoiner
 #3

The price comparing with the exchange rate of the time I purchased? In other words, the price in BTC or the price in BTC/USD?

If you mean the first one, then I can view my transactions on a block explorer, such as Blockchair, but you should note that the explorer will know what you're looking and thus, you may ruin your privacy. There are other ways to view your transactions too such as setting up your own Electrum server, that would require running your own Bitcoin node, but I won't keep going, because I don't know how familiar you are with these terms.

If you mean the second one, just create a spreadsheet and write your spent bitcoins along with the exchange rate it had when you made the purchase. On a third table, you could have the sum.

Example:

01/01/2021
BTC0.5
|
1 BTC = $29,111
|
$14,555.5



Edit: On Blockchair you can see the transaction value in USD of the exchange rate the time it was broadcasted. This is an example of Hal Finney receiving 50 bitcoins in 2009:


.
.HUGE.
▄██████████▄▄
▄█████████████████▄
▄█████████████████████▄
▄███████████████████████▄
▄█████████████████████████▄
███████▌██▌▐██▐██▐████▄███
████▐██▐████▌██▌██▌██▌██
█████▀███▀███▀▐██▐██▐█████

▀█████████████████████████▀

▀███████████████████████▀

▀█████████████████████▀

▀█████████████████▀

▀██████████▀▀
█▀▀▀▀











█▄▄▄▄
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
.
CASINSPORTSBOOK
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀▀█











▄▄▄▄█
noorman0
Hero Member
*****
Offline Offline

Activity: 1764
Merit: 694


[Nope]No hype delivers more than hope


View Profile WWW
May 10, 2021, 11:47:24 AM
 #4

If you buy through centralized exchanges, you can easily find trading history. Or if you buy in p2p or DEX (onchain transactions), just use blockchair .com to find out your bitcoin purchase history based on the USD pair at the time.

This space for rent.
Available in mid January 2024 - PM me
Oshosondy
Legendary
*
Offline Offline

Activity: 1442
Merit: 1125


Gamble responsibly


View Profile
May 10, 2021, 12:03:50 PM
 #5

You can track your bitcoin buy and sell using your addresses. If it is on a custodial exchange you buy the bitcoin, you can make use of the addresses, look for better blockchain explorer like https://blockchair.com or https://www.blockchain.com/explorer, you will be able to see you transaction history. If you buy from someone directly with noncustodial wallet, you can even do that with the help of master public key, the noncustodial wallet will even has the transaction history.

██
██
██
██
██
██
██
██
██
██
██
██
██
... LIVECASINO.io    Play Live Games with up to 20% cashback!...██
██
██
██
██
██
██
██
██
██
██
██
██
pixie85
Hero Member
*****
Offline Offline

Activity: 2142
Merit: 524


View Profile
May 10, 2021, 12:18:17 PM
 #6

There's a number of ways to do it. If you have no record of your transactions and no way to ask your exchange or person who you bought from for the data, check the dates of your transactions.

If you made a transaction the coins were transferred to your adddress. Compare that time to the average price of bitcoin at that exact day.

I guess we'd need more information about the way you were buying to help.
Fundamentals Of
Sr. Member
****
Offline Offline

Activity: 2310
Merit: 366


View Profile
May 10, 2021, 12:28:31 PM
 #7

I don't know of such an app or site, but you could simply do things manually instead. You could make use of blockchair.com. You could go over your previous transactions there, look out for the date and the amount of Bitcoin in that particular transaction, and then look for the price of Bitcoin on that specific date through coinmarketcap or coingecko.
Dr.Ona (OP)
Jr. Member
*
Offline Offline

Activity: 58
Merit: 13


View Profile
May 10, 2021, 12:32:27 PM
 #8

Thank you all for this info so far!

I've been buying on Coinbase only, no selling or trading.
But if I have say 30+ purchases on various dates/prices, is there an app or site that can organize/arrange to help figure out this info?

I guess I'm talking about s spread sheet of sorts... something of which I've never used before.

Thanks you again!
ReiMomo
Sr. Member
****
Offline Offline

Activity: 2366
Merit: 305


Duelbits - $100k Bonus/week


View Profile
May 10, 2021, 12:49:52 PM
 #9

I think the best way to track your payments with your previous transactions is to manually track them. The pro-sequences is that even when it’s been a long time already, you can still track each and every single transaction you had as long as you still have the access to your accounts.

If it’s in exchange you had your transactions with, you may check your trading history and the markdowns are there waiting for you to be checked.

If not, try to check the blockchain and you will see your entire transactions in the blockchain.

.
Duelbits
█▀▀▀▀▀











█▄▄▄▄▄▄▄
TRY OUR
  NEW  UNIQUE
GAMES!
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
DICE 
.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
███████████████████████████████
███▀▀                     ▀▀███
███    ▄▄▄▄         ▄▄▄▄    ███
███   ██████       ██████   ███
███   ▀████▀       ▀████▀   ███
███                         ███
███                         ███
███                         ███
███   ▄████▄       ▄████▄   ███
███   ██████       ██████   ███
███    ▀▀▀▀         ▀▀▀▀    ███
███▄▄                     ▄▄███
███████████████████████████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
MINES 
.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
███████████████████████████████
████████████████████████▄▀▄████
██████████████▀▄▄▄▀█████▄▀▄████
████████████▀ █████▄▀████ █████
██████████      █████▄▀▀▄██████
███████▀          ▀████████████
█████▀              ▀██████████
█████                ██████████
████▌                ▐█████████
█████                ██████████
██████▄            ▄███████████
████████▄▄      ▄▄█████████████
███████████████████████████████
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
PLINKO 
.
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
███████████████████████████████
█████████▀▀▀       ▀▀▀█████████
██████▀  ▄▄███ ███      ▀██████
█████  ▄▀▀                █████
████  ▀                    ████
███                         ███
███                         ███
███                         ███
████                       ████
█████                     █████
██████▄                 ▄██████
█████████▄▄▄       ▄▄▄█████████
███████████████████████████████
10,000x
MULTIPLIER
▀▀▀▀▀█











▄▄▄▄▄█
dkbit98
Legendary
*
Offline Offline

Activity: 2226
Merit: 7117



View Profile WWW
May 10, 2021, 01:01:14 PM
 #10

Hello All,
If you have made several purchases of BTC though out the last couple years, how do you figure out what price you've paid?
Is there an app or site that can do this type of spread sheet for you?

There are some apps that can track that for you like Delta or Rotki, and you can even use websites like Coingecko with portfolio you can create and enter every purchases manually.
You will see gains or losses and there is even option to directly connect your account with API from exchanges and track everything automatically.
One more option if you are using Electrum wallet is to add Labels with more information for each receiving addresses.

.
.HUGE.
▄██████████▄▄
▄█████████████████▄
▄█████████████████████▄
▄███████████████████████▄
▄█████████████████████████▄
███████▌██▌▐██▐██▐████▄███
████▐██▐████▌██▌██▌██▌██
█████▀███▀███▀▐██▐██▐█████

▀█████████████████████████▀

▀███████████████████████▀

▀█████████████████████▀

▀█████████████████▀

▀██████████▀▀
█▀▀▀▀











█▄▄▄▄
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
.
CASINSPORTSBOOK
▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄
▀▀▀▀█











▄▄▄▄█
temple
Hero Member
*****
Offline Offline

Activity: 1400
Merit: 538


Crypto Casino & Sportsbook


View Profile
May 10, 2021, 01:08:43 PM
 #11

If you buy through centralized exchanges, you can easily find trading history. Or if you buy in p2p or DEX (onchain transactions), just use blockchair .com to find out your bitcoin purchase history based on the USD pair at the time.

That's true but it still can end up being a total mess if you traded back and forth and used several exchanges. Best is to have different accounts for different activities. If you want to trade back and forth or even a couple of trades a week the best recommendation would be to have a different account for funds that you are planning to hold onto for a longer period of time. Will also save you from trouble with tax authorities.

..Stake.com..   ▄████████████████████████████████████▄
   ██ ▄▄▄▄▄▄▄▄▄▄            ▄▄▄▄▄▄▄▄▄▄ ██  ▄████▄
   ██ ▀▀▀▀▀▀▀▀▀▀ ██████████ ▀▀▀▀▀▀▀▀▀▀ ██  ██████
   ██ ██████████ ██      ██ ██████████ ██   ▀██▀
   ██ ██      ██ ██████  ██ ██      ██ ██    ██
   ██ ██████  ██ █████  ███ ██████  ██ ████▄ ██
   ██ █████  ███ ████  ████ █████  ███ ████████
   ██ ████  ████ ██████████ ████  ████ ████▀
   ██ ██████████ ▄▄▄▄▄▄▄▄▄▄ ██████████ ██
   ██            ▀▀▀▀▀▀▀▀▀▀            ██ 
   ▀█████████▀ ▄████████████▄ ▀█████████▀
  ▄▄▄▄▄▄▄▄▄▄▄▄███  ██  ██  ███▄▄▄▄▄▄▄▄▄▄▄▄
 ██████████████████████████████████████████
▄▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▄
█  ▄▀▄             █▀▀█▀▄▄
█  █▀█             █  ▐  ▐▌
█       ▄██▄       █  ▌  █
█     ▄██████▄     █  ▌ ▐▌
█    ██████████    █ ▐  █
█   ▐██████████▌   █ ▐ ▐▌
█    ▀▀██████▀▀    █ ▌ █
█     ▄▄▄██▄▄▄     █ ▌▐▌
█                  █▐ █
█                  █▐▐▌
█                  █▐█
▀▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▀█
▄▄█████████▄▄
▄██▀▀▀▀█████▀▀▀▀██▄
▄█▀       ▐█▌       ▀█▄
██         ▐█▌         ██
████▄     ▄█████▄     ▄████
████████▄███████████▄████████
███▀    █████████████    ▀███
██       ███████████       ██
▀█▄       █████████       ▄█▀
▀█▄    ▄██▀▀▀▀▀▀▀██▄  ▄▄▄█▀
▀███████         ███████▀
▀█████▄       ▄█████▀
▀▀▀███▄▄▄███▀▀▀
..PLAY NOW..
fiulpro
Hero Member
*****
Offline Offline

Activity: 1862
Merit: 830



View Profile
May 10, 2021, 01:29:07 PM
 #12

Hello All,
If you have made several purchases of BTC though out the last couple years, how do you figure out what price you've paid?
Is there an app or site that can do this type of spread sheet for you?

Thanks!

It should be very easily available in your history of purchase. If it is not then you would have to improvise, see just see how much money you deposited and how much BTC you got for that much. Then you can just compare the price from the market and calculate the exact price which you purchased BTC for.

Other than that there are indeed a lot of apps which can help you simplify such things. It all depends on your transaction history.

If all of this is not possible then just look for your bank account. You would have ofc transferred money from there to the wallet or exchange, you can then calculate from there also it's pretty easy.

▄▄▄███████▄▄▄
▄█████████████████▄▄
▄██
█████████▀██▀████████
████████▀
░░░░▀░░██████████
███████████▌░░▄▄▄░░░▀████████
███████
█████░░░███▌░░░█████████
███
████████░░░░░░░░░░▄█████████
█████████▀░░░▄████░░░░█████████
███
████▄▄░░░░▀▀▀░░░░▄████████
█████
███▌▄█░░▄▄▄▄█████████
▀████
██████▄██
██████████▀
▀▀█████████████████▀▀
▀▀▀███████▀▀
.
.BitcoinCleanUp.com.


















































.
.     Debunking Bitcoin's Energy Use     .
███████████████████████████████
███████████████████████████████
███████████████████████████████
███████▀█████████▀▀▀▀█▀████████
███████▌░▀▀████▀░░░░░░░▄███████
███████▀░░░░░░░░░░░░░░▐████████
████████▄░░░░░░░░░░░░░█████████
████████▄░░░░░░░░░░░▄██████████
███████▀▀▀░░░░░░░▄▄████████████
█████████▄▄▄▄▄▄████████████████
███████████████████████████████
███████████████████████████████
███████████████████████████████
...#EndTheFUD...
joniboini
Legendary
*
Offline Offline

Activity: 2184
Merit: 1789



View Profile WWW
May 10, 2021, 02:26:15 PM
 #13

I've been buying on Coinbase only, no selling or trading.
But if I have say 30+ purchases on various dates/prices, is there an app or site that can organize/arrange to help figure out this info?
Is that info not available on your account history page? Some trading tools will require an API to check the price for each purchase, as mentioned above. If it's less than 50 buying history, I think manually doing it is still an option.

███████████████████████████
███████▄████████████▄██████
████████▄████████▄████████
███▀█████▀▄███▄▀█████▀███
█████▀█▀▄██▀▀▀██▄▀█▀█████
███████▄███████████▄███████
███████████████████████████
███████▀███████████▀███████
████▄██▄▀██▄▄▄██▀▄██▄████
████▄████▄▀███▀▄████▄████
██▄███▀▀█▀██████▀█▀███▄███
██▀█▀████████████████▀█▀███
███████████████████████████
.
.Duelbits.
..........UNLEASH..........
THE ULTIMATE
GAMING EXPERIENCE
DUELBITS
FANTASY
SPORTS
████▄▄█████▄▄
░▄████
███████████▄
▐███
███████████████▄
███
████████████████
███
████████████████▌
███
██████████████████
████████████████▀▀▀
███████████████▌
███████████████▌
████████████████
████████████████
████████████████
████▀▀███████▀▀
.
▬▬
VS
▬▬
████▄▄▄█████▄▄▄
░▄████████████████▄
▐██████████████████▄
████████████████████
████████████████████▌
█████████████████████
███████████████████
███████████████▌
███████████████▌
████████████████
████████████████
████████████████
████▀▀███████▀▀
/// PLAY FOR  FREE  ///
WIN FOR REAL
..PLAY NOW..
acener
Full Member
***
Offline Offline

Activity: 1274
Merit: 115


★Bitvest.io★ Play Plinko or Invest!


View Profile
May 10, 2021, 02:46:04 PM
 #14

I am also looking for something similar like EthPlorer where all our transaction and price at that moment and current price is shown but for BTC.
I know that it would only make me regret those silly transactions that I had in the past but it could be my inspiration to hold and accumulate as much as I could.

Dr.Ona (OP)
Jr. Member
*
Offline Offline

Activity: 58
Merit: 13


View Profile
May 11, 2021, 12:24:57 AM
 #15

Thanks again everyone..
I do have the trade history available.. looks like I'll be trying to figure out a simple spread sheet, hahaha
mr_ROBOTT
Member
**
Offline Offline

Activity: 312
Merit: 24


View Profile
May 11, 2021, 05:34:25 AM
 #16

You can manually convert bitcoin by viewing the price at the time you bought it.
For example, in 2016, the price of bitcoin was $ 400. If you bought 0.5 bitcoins, it means that in 2016, you paid $ 200 for bitcoins, and at today's price of bitcoins, you will have $ 27,000.
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!