I can edit my works with this kind of strategy to build my own portfolio in google spreadsheet, but this one is a detailed one which is good to check assets if confused to calculate all expenses (i don't really know the term for it -expenses-)
However, did you use some kind of formula to complete any pages when total?
Topic: Crypto Portfolio Builder in Google Spreadsheet (FREE) (Read 139 times)
I cannot believe no one has come in to thank you. Thank you! This is awesome, and a lot of work was put into this. I will certainly be using it to start building my portoflio, and that way you made it truly make it easier.
To be honest, I prefer this to things like Delta or other protfolio managers on iOS. Every time I get a notification I'm immediate in either panic sell or FOMO buy mode
I hope by this bumps the thread to get more attention. Great job mate, hats off.
Below is a screenshot of Google Spreadsheet which helped me to create my investment portfolio for 2018.
I want to share this tool with community
https://docs.google.com/spreadsheets/d/1wNWU8DtdO9LqajZW6egKt5r7TTqBvvjvm-5QtSsEo3M/edit?usp=sharing
Go to File > Create a copy to get editable copy to your Gdrive
https://imgur.com/ThwTxw7.jpg
How can this spreadsheet be useful for a novice and experienced investor?
1.The investor can classify blockchain assets into different sections (add his own sections) and evaluate these classes.
Example of classifications I used:
by directions: currency, smart-contracts platforms, privacy, dex, funds/investments, payments, lending, governance, VPN, identity, stable coins, decentralized computing, decentralized storage, mesh networks, energy, others. Of course, this is not a complete list, this classification is partially taken from here https://techcrunch.com/2017/10/16/mapping-the-blockchain-project-ecosystem/
by token type: equity the token security token, the token utility, base level, pegged token, asset-backed token
by consensus algorithm: Proof-of-Stake, Proof-Of-Work, dPoS, PoW+PoS, Proof-of-Importance, DAG, Loop-Fault-Tolerance, Byzantine-Fault-Tolerance, Proof-of-Authority, Proof-of - Weight, Federated Byzantine Agreement
by risk: storage facility, medium risk, high risk, extreme risk, Fiat
by age of the project: from 5 years, 2-5 years, 6 months-2 years, up to 6 months, ICO
by market capitalization: TOP 10, TOP 10-50, 50-150 TOP, TOP 301-600, TOP 600+
by turnover: 50%+, 30-50%, 10-30%, 5-10%, 2-5%, 0,5-2%, 0-0,5%
The idea is to give fundamental estimates and plan a portfolio within frames of each classification. It is easier not to look away at the name and brand of coins, and focus on specific fundamental ideas. For example, I allocate 26.9% for smart-contracts platforms, and 13.8% for currencies, 7.2% for privacy and etc.
It's all subjective, so you can (and good) to change the classification in your own way.
2. As the classifications are ready, the next step is to match blockchain assets to them.
Here you will find a painstaking intellectual work. For example, I made a classification for the first 20 assets by capitalization (see screen) - NOTE there are subjective errors!
https://imgur.com/eoZn2f2.jpg
The good news is that classifications for capitalization and turnover - works in automatic mode. Up-to-date data is taken from coinmarketcap at each launch, and assets are sorted by capitalization and trading volume data is also updated.
However, this can cause failures in the classification, because the assets change their positions! Therefore it is necessary to check everything before the third step
3.The idea is to sum up all the scores by classifications and get a total score for each asset that has ON (i.e. selected for portfolio)
Because not all classifications are equivalent. You can adjust the "weight" of each classification by simply selecting a different scale for the scores. For example, for "by directions" use from 1 to 100, and for "by turnover" from 1 to 10.
After pressing the button "Recalculate points" on the "Builder" tab will appear this final table.
https://imgur.com/fdhkfhb.jpg
As can be seen here:
all assets that are included in the portfolio are their total score.
share % in the portfolio
current price (from coinmarketcap)
the quantity of asset, how much the actual pieces to buy
The value in $
The value in someothercurrency.
Exchange name
Why we need exchange name and volume in someothercurrency? Well, a typical situation, your first BTC lie on localbitcoins or on your wallet and in waiting until you spend them for your portfolio. And here it is necessary to understand exactly how many BTC on every exchange need to be sent? Columns (I) and (J) refer to this point.
And since the BTC is not the cheapest transaction currency, it is possible to calculate in any other crypto. For example, in ETH
Like if it turned out to be useful for you!
We're in Telegram https://t.me/encryptmymoney
The link here. Need to make a copy of itself using the File > make a copy.
https://docs.google.com/spreadsheets/d/1wNWU8DtdO9LqajZW6egKt5r7TTqBvvjvm-5QtSsEo3M/edit?usp=sharing
I want to share this tool with community
https://docs.google.com/spreadsheets/d/1wNWU8DtdO9LqajZW6egKt5r7TTqBvvjvm-5QtSsEo3M/edit?usp=sharing
Go to File > Create a copy to get editable copy to your Gdrive
https://imgur.com/ThwTxw7.jpg
How can this spreadsheet be useful for a novice and experienced investor?
1.The investor can classify blockchain assets into different sections (add his own sections) and evaluate these classes.
Example of classifications I used:
by directions: currency, smart-contracts platforms, privacy, dex, funds/investments, payments, lending, governance, VPN, identity, stable coins, decentralized computing, decentralized storage, mesh networks, energy, others. Of course, this is not a complete list, this classification is partially taken from here https://techcrunch.com/2017/10/16/mapping-the-blockchain-project-ecosystem/
by token type: equity the token security token, the token utility, base level, pegged token, asset-backed token
by consensus algorithm: Proof-of-Stake, Proof-Of-Work, dPoS, PoW+PoS, Proof-of-Importance, DAG, Loop-Fault-Tolerance, Byzantine-Fault-Tolerance, Proof-of-Authority, Proof-of - Weight, Federated Byzantine Agreement
by risk: storage facility, medium risk, high risk, extreme risk, Fiat
by age of the project: from 5 years, 2-5 years, 6 months-2 years, up to 6 months, ICO
by market capitalization: TOP 10, TOP 10-50, 50-150 TOP, TOP 301-600, TOP 600+
by turnover: 50%+, 30-50%, 10-30%, 5-10%, 2-5%, 0,5-2%, 0-0,5%
The idea is to give fundamental estimates and plan a portfolio within frames of each classification. It is easier not to look away at the name and brand of coins, and focus on specific fundamental ideas. For example, I allocate 26.9% for smart-contracts platforms, and 13.8% for currencies, 7.2% for privacy and etc.
It's all subjective, so you can (and good) to change the classification in your own way.
2. As the classifications are ready, the next step is to match blockchain assets to them.
Here you will find a painstaking intellectual work. For example, I made a classification for the first 20 assets by capitalization (see screen) - NOTE there are subjective errors!
https://imgur.com/eoZn2f2.jpg
The good news is that classifications for capitalization and turnover - works in automatic mode. Up-to-date data is taken from coinmarketcap at each launch, and assets are sorted by capitalization and trading volume data is also updated.
However, this can cause failures in the classification, because the assets change their positions! Therefore it is necessary to check everything before the third step
3.The idea is to sum up all the scores by classifications and get a total score for each asset that has ON (i.e. selected for portfolio)
Because not all classifications are equivalent. You can adjust the "weight" of each classification by simply selecting a different scale for the scores. For example, for "by directions" use from 1 to 100, and for "by turnover" from 1 to 10.
After pressing the button "Recalculate points" on the "Builder" tab will appear this final table.
https://imgur.com/fdhkfhb.jpg
As can be seen here:
all assets that are included in the portfolio are their total score.
share % in the portfolio
current price (from coinmarketcap)
the quantity of asset, how much the actual pieces to buy
The value in $
The value in someothercurrency.
Exchange name
Why we need exchange name and volume in someothercurrency? Well, a typical situation, your first BTC lie on localbitcoins or on your wallet and in waiting until you spend them for your portfolio. And here it is necessary to understand exactly how many BTC on every exchange need to be sent? Columns (I) and (J) refer to this point.
And since the BTC is not the cheapest transaction currency, it is possible to calculate in any other crypto. For example, in ETH
Like if it turned out to be useful for you!
We're in Telegram https://t.me/encryptmymoney
The link here. Need to make a copy of itself using the File > make a copy.
https://docs.google.com/spreadsheets/d/1wNWU8DtdO9LqajZW6egKt5r7TTqBvvjvm-5QtSsEo3M/edit?usp=sharing
Jump to: