Hi Everyone, I have been working on this Google Spreadsheet, I use it myself but wanted to share with you all.
This spreadsheet downloads and updates the information from CoinMarketCap every minute connecting to the Coinmarketcap API and shows the data in the spreadsheet, but the most important thing is that I added 2 new columns that are not currently avaiable in Coinmarketcap that shows:
1) Price (USD) Normalized by BTC/Crypto Available Supply: This column indicates the price of that coin if it had the same current available supply that bitcoin taking into account the current supply of that crypto.
- For example: Ripple currently has 38 billion coins available from the total of 100 billion while Bitcoin has 16 million from the 21 million total.
In this case based on current prices Ripple should be valued 7050 dollars if it had the Bitcoin current 16 million supply.
2) Price (USD) Normalized by BTC/Crypto Max Supply: This column indicates the price of that coin if it had the same total max supply that bitcoin (21 million) taking into account the total supply of that crypto.
- For example: Ripple max supply is 100 billion while Bitcoin max supply is 21 million.
In this case based on current prices Ripple should be valued 14500 dollars if it had the Bitcoin max 21 million supply.
If you want to use filters and ordering you can click on the Google Spreadsheets filter icon.
Please, let me know if you see any flaws or improvements I can work on, I know is a simple tool but it has been helpful to me.
Here is the link: https://docs.google.com/spreadsheets/d/1h75cvLJSj5QRyTDLM-u-XqTTO0316xfsJctpLtjX3-c/edit?usp=sharing
Hope you enjoy!
Greetings good doctor. I was wondering if you can show me the equation you use to come up with these normalized prices. I have seen this analysis before and I don't understand it at all or the rationale behind it. Thanks for helping a fellow crypto head.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit