Join our new Discord Channel, SteemitStocks. It's a chat channel where crypto and stocks investors can meet, chat and share content about investing.
I made a crytocurrency portfolio in Excel for my investments which I want to share with you. It's freely available via this link. This is still a basic portfolio and it's under development. Around-Z-Blocks will implement API's in the spread sheet. Also live prices are on the list to add on the portfolio. Follow us to keep updated about upgraded portfolios.
The portfolio is divided in three tabs.
Tab 1: Portfolio
In this tab you can add the current price (I added the latest price in euro's) under the price column. I added three wallets where you can add your cryptocurrency holdings. More to the right is 'Other' where you can add some more crypto's to your portfolio. Fill in the amount of euro's (or other currency) you invested in per cryptocurrency, and per wallet. The value of you cryptocurrency and profit/loss are calculated automaticcaly. Try it out yourself!
Tab 2: Charts
Charts are given in this tab. They update automatically. You can add charts to your personal favour.
Tab 3: Notes
In this tab you can store important reminders and transactions you made. You can also store your cryptocurrency addresses.
I already filled in some fictive data to show how it works in the spread sheet. If you don't use euro's, you only have to change the currency (on the Start Excel tab). Try it out yourself and you can add things you like. It's just a basic portfolio that I wanted to share.
Don't forget to upvote, resteem and follow me to support the content. We have a new Discord channel for crypto and stock investors you can join
Let’s keep this BOOMING!
UnknowCrypto
Disclaimer:
Use this link to buy $100 worth of Bitcoin, Litecoin or Ethereum on Coinbase.com and we both get $10 for free!
You can earn up to $200 free Bitcoin every hour at freebitco.in. If you use my referral link we get both a bonus.
Our team at @around-z-block will be assisting @unknowncrypto with the implementation of API's in this spreadsheet. This will create an automated program through which users will hopefully have the ability to simply choose the tokens they purchased, as well as the dates on which they purchased the tokens.
Join the community too! It's really great having so many people as a resource for things like this.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for helping me @around-z-block with adding some cool futures. I'll give you a mention in my article. Awesome to see such initiatives on Steemit!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great work man. Just a suggestion, you can add an "analysis" sheet to know exactly where your gains or losses come from. They are mainly due to two reasons namely change in BTC price and change in equivalent BTC per unit of Altcoin(aka the altcoin price) You can create a sheet that separates the gains/losses due to change in btc price and change in btc equivalent.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks @dogeking. We will continue to develop the portfolio and will take your feedback along.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations! This post has been upvoted from the communal account, @minnowsupport, by Unknowncrypto from the Minnow Support Project. It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, and someguy123. The goal is to help Steemit grow by supporting Minnows and creating a social network. Please find us in the Peace, Abundance, and Liberty Network (PALnet) Discord Channel. It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.
If you like what we're doing please upvote this comment so we can continue to build the community account that's supporting all members.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I am going to get added to the discord.
Since this group seems relevant, can you guys review this ICO Review Series and tell me your feedback?
Next review in that series is going to be BitClave.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
buen post bro
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @unknowncrypto! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Award for the number of posts published
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOP
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for making this man, now to download Excel..
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good idea! I also recommend Blockfolio as a basic android portfolio app.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Is the Discord channel you are promoting here available to those also interested in learning or will a beginner be totally lost and unwelcomed?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@coquiunlimited It's available for everyone!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit