How To Build a Crypto Portfolio Tracker in Google Sheets 📈 Real-Time Portfolio Tracker
HTML-код
- Опубликовано: 13 сен 2024
- 🔥 CoinSutra Portfolio Tracker - docs.google.co... [Make a Copy]
📹 How To Generate CoinMarketCap API - • How To Generate CoinMa...
Hey SutraPunks, in this video, learn to build a crypto portfolio tracker in Google Sheets. Simply make a copy of CoinSutra Portfolio Tracker & follow the instructions in this video to create your own real-time crypto tracker.
🔗 CoinMarketCap API - coinmarketcap....
------------------------------
📙 Download the Free eBook on Crypto Trading: bit.ly/3hTfgyk
✅ 20% Binance discount: coinsutra.com/...
📲 CoinSutra Official Social Channels 👉 coinsutra.com/...
Join CoinSutra on:
✈ Telegram: telegram.me/co...
💬 Discord - / discord
🔥 Twitter: / coinsutra
🖼️ Instagram - / coinsutra
This video was brought to you by Coinsutra.
Join the most popular Bitcoin community: CoinSutra.com
#Crypto #CryptoPortfolio
----------------------------- Disclaimer -----------------------------
This video is copyright of CoinSutra.
The content published on CoinSutra Channel is for informational, educational, and recreational purposes only and should not be considered to be legal, tax, accounting, or any other professional advice. I'm not a professional financial adviser, and you should always do your own research. I may hold the cryptocurrencies talked about in the video.
📹 How To Generate CoinMarketCap API - ruclips.net/video/zFsDuYfs9ho/видео.html
🔗 CoinMarketCap API - coinmarketcap.com/api
🔥 Get 20% Binance Discount - coinsutra.com/visit/binance20/
✅ Buy, Sell & Trade Crypto on Bybit - coinsutra.com/visit/bybit/
📙 Download the Free eBook on Crypto Trading: bit.ly/3hTfgyk
📲 CoinSutra Official Social Channels 👉 coinsutra.com/socials/
Join CoinSutra on:
✈ Telegram: telegram.me/coinsutra
💬 Discord - discord.gg/UXyXFrhkJK
🔥 Twitter: twitter.com/coinsutra
🖼 Instagram - instagram.com/coinsutra/
Brilliant idea and helpful sheet. I did same as like your video instructions I also create my API key but problem is than whenever I run the price process that time show some date in token price and #value in market cap valvule please help me how can I solve this problem ? I need this sheet. I am trying to correct this sheet from last 3 hrs.🙏
hey heyyy, would you consider making an updated version of this?? maybe including individual tabs for tokens and exchanges where they can be linked to API??? that would look amazing
Many many thanks..atlast I have found..
Hey Biswa, Glad it helps.
Great work! thanks a lot!
Glad you liked it
Great Initative & thanks a lot, also please try if you could bring the same for Equities as well.
Hey Vamsi, Glad we could help.
can you plz make a video on fundamental analysis of a coin before investment?? how can we find a good coin before listing in exchanges so that we can get it with fair price??
Hi Biswa, we will surely keep that in our pipeline
Very cool! Managed to get it going. Is there a way I can add my limit buy and sell transactions to calculate profit/loss?
Hi Abhishek, Glad you liked it. However, we are still struggling to incorporate cost in this tracker. Although we are open to suggestions.
This is great, thanks! Is column T 'Cost' referring to the cost of the coin when purchased? Ive bought the same coin multiple times. Im guessing its not built for that?
Yeah you need to calculate the weighted average cost
How can I adjust the tracker to track in EUR instead of USD? Thanks so much!
Will need to research that. But their are different API settings for that and the whole portfolio will show EUR values.
Won't show token price. I made a copy and followed directions exactly as stated, what am I missing?
great video!!
Thanks Tomas. Glad you liked it.
how Can i edit in this google sheet?? there is view only showing
You cant edit this sheet. Go to file and make a copy of this sheet.
Thanks to guide me sir
Hey Amar, Glad we could help.
Should I have to enter the COIN COST in USD? Not INR?
USD
Thank you
You're welcome
Hi mate! Has been running perfectly, until today when I updated the api connector and the token prices no longer appear, but the formula is still there, did you know what happen?
Hi, please setup and use your own API key. Our API key is overused.
Hii
Your portfolio tracker is just awesome. i really appreciate it. But I have many questions.if you guide us then it will be very helpfull to all the Sutra Family..
1. If i want to increase the number of coins to more than 20 then what steps should i follow??
2. Do we need to exclude/include the fees in USDT to fill in the Cost section In the portfolio sheet ??
3. If I have BUSD as the cost price to buy any coin in that case can i fill it in the COST section??
Kindly answer so that we can use this tool in full potential.
Hi Biswa. Its glad to know that we could help the Sutrapunk community. Thank you so much.
The answer to your questions is as follows:
1. If i want to increase the number of coins to more than 20 then what steps should I follow??
Ans. Our next video is a comprehensive one, where you can create this format from scratch. Or else we can increase the number of tokens to 40. Let me know if we should do that.
2. Do we need to exclude/include the fees in USDT to fill in the Cost section In the portfolio sheet ??
Ans. Yes, fee should be included in the cost.
3. If I have BUSD as the cost price to buy any coin in that case can i fill it in the COST section??
Ans. Yes, more or less the value is around $1. So that minor deviation should not make much of a difference.
Hope this helps. Will look forward to your response on Anwer 1.
Sir Can I add another alt coins like Polygon matic in this sheet if yes then how?
Yes you can. Watch the video for that.
great tracker. but i'm facing one problem. why it can't find IDs of some tokens? I wrote the ID of XRP in the list of my portfolio. but it says error. it can't find this ID in Vlook or something like that
thank u
Try again
Similar. Entered all IDs according to the G column of the IDs sheet but multiple show value not found in the portfolio overview.
nice vid
brilliant video thanks
Glad you enjoyed it
I love this tracker! Is there any chance of adding a transaction sheet for tracking daily transactions? Thanks
Hey Doug, You will have to copy paste transactions from your exchange. But the problem is that this sheet does not calculate your cost. We are open to solutions for that.
Hey love this! But, I'm having problems... I've done exactly as the video teaches, AND used my own API value, but Token Prices are not showing??
Hey Carl, You can connect with us on Discord and ask for Digant. He will help you. Link for channel is in the video description.
Will this work in Microsoft excel 365
Method of Connecting API is different for Excel. Rest everything should work.
I want to delete some coin from the list..what should I do ??do I need to update ID sheet?
No Just delete the data from Portfolio sheet. Hope this helps.
Thanks..it will help lots
can we do in excel?
Hello, yes but the process of connection API is a bit different.
Great tutorial, followed it step by step and I was abel to build my tracker, but I noticed it doesn't update the coin prices. I refreshed the page, but nothing happend. I would appreacite you help. Thank you in advance !!!!!!
Hey Anthony, Please generate your own API key. Our key is overused. Let me know if you need any further help.
no response of all queries....
then how can you support
Hi, what is your query?
ID of quantum coin isnt available . how to get it?
Wallet Or Trade History
For those that don't know, you can find the token/coin ID by ctrl+F and typed UCID. It is the UCID number. Otherwise, you can copy the logo image URL and it is the last digits in the URL.
Does it autorefresh ? yes then after how much time it auto refresh ?
No, you need to refresh manually.
these link are out of date, not getting prices
it will update now, check again
There is no option now to make a copy of the file
Click on File and Click on Make Copy
Hi, does this thing still work? Did everything according your guideline, when (your) portfolio is updating with my API, there is everywhere an error with #N/A, no clue what I did wrong.
Thanks for an advise :)
also wondering if this still works. I followed directions to connect API for id's and prices using my own coinmarketcap API key and I only get current prices for Lido and Raydium. I didn't change any of the crypto names or tickers to reflect my own holdings but entered in col S & T my holding information for Polkadot. The pricing for DOT is now blank. All the prices are blank except for the 2 I just mentioned.
I have also tried setting up this tracker 2 different times using the formatted one you provided.
wont work for wazirx wallet.
What dint work?
@@CoinSutra Theres difference in price from wazirx to global crypto prices hence.