Very nice tracker, thanks you !!! Just couple of feedback question: 1. what if i bought crypto using another crypto? examble XRP/BNB need to add a new currency ? and register double transactions? 2. Regarding the dashboard do you have any KPI measuring time performance, example my unrealize ROI in november?
Hi Juan, thanks so much for your comment! Currently this tracker is only for purchases with cash or a fiat currency. I will apply crypto to crypto purchases in a 2nd Gen tracker. Thanks so much for the feedback. Currently the dashboard shows performance from the average purchase price of all transactions on a rolling cost average. You could look at the CAGR formula and adjust the time frame from date of first transaction to a date of your choice. Please let me know if you have trouble with that, I'm happy to help.
Very nice tool. Just have something to ask. When I sell coins the cash I get and the cash balance I've isn't shown in the dashboard. Any advice on how to show the cash balance I've in the platforms when I deposit or sell my coins?
Hi Santiago, thanks for your comment! This crypto tracker does not provide cash balances in the dashboard. I would recommend you check out my latest Portfolio Tracker video, which includes crypto and also cash balances with these. Cheers!
Thank you for your videos could you please make a crypto Portfolio Growth Chart (hourly - daily - monthly and yearly ) with timestamps, i mean record all the price changes (history) that happen to the portfolio balance overtime thanks.
Anybody having issues with having more than one different account with the same asset? Doesn't allow for splitting the assets between different brokerages and or exchanges. Am I doing something wrong?
Hi David, this tracker should be able to capture cross-platform transfers in the platform breakdown table. Feel free to email me if you are still having issues! Happy to help.
Hey! They will be empty unless you enter the crypto name in the name column. Could also be that it's refreshing the IMPORTXML web scraping. Let me know if this issue persists and I can take a look at your sheet!
@@mrccc797 Looks like the XPATH for certain coins changes, in this case to fix it you need to enter this XPATH under the other ones you entered: //*[@id="__next"]/div[1]/div/div[2]/div/div[1]/div[3]/div/div[2]/div[1]/div/span Once you enter it in cell X10 you will need to change the current price formula in cell AB24 (or in the line where Pola is): =IF(ISBLANK(W24),"",IFERROR(IMPORTXML("coinmarketcap.com/currencies/"&X24,$X$10),"")) This should fix your issue. Let me know how you go!
It is a god send!
Very nice tracker, thanks you !!! Just couple of feedback question:
1. what if i bought crypto using another crypto? examble XRP/BNB need to add a new currency ? and register double transactions?
2. Regarding the dashboard do you have any KPI measuring time performance, example my unrealize ROI in november?
Hi Juan, thanks so much for your comment! Currently this tracker is only for purchases with cash or a fiat currency. I will apply crypto to crypto purchases in a 2nd Gen tracker. Thanks so much for the feedback. Currently the dashboard shows performance from the average purchase price of all transactions on a rolling cost average. You could look at the CAGR formula and adjust the time frame from date of first transaction to a date of your choice. Please let me know if you have trouble with that, I'm happy to help.
Very nice tool. Just have something to ask. When I sell coins the cash I get and the cash balance I've isn't shown in the dashboard. Any advice on how to show the cash balance I've in the platforms when I deposit or sell my coins?
Also on the coins I bought and sold all of them, the profit or loss I made of them doesn't seem to be on the dashboard. Any advice on this?
Hi Santiago, thanks for your comment! This crypto tracker does not provide cash balances in the dashboard. I would recommend you check out my latest Portfolio Tracker video, which includes crypto and also cash balances with these. Cheers!
Thank you for your videos could you please make a crypto Portfolio Growth Chart (hourly - daily - monthly and yearly ) with timestamps, i mean record all the price changes (history) that happen to the portfolio balance overtime thanks.
Is there a limit to number of crypto assets in this sheet?
Hey! No there isn't a limit
Anybody having issues with having more than one different account with the same asset? Doesn't allow for splitting the assets between different brokerages and or exchanges. Am I doing something wrong?
Hi David, this tracker should be able to capture cross-platform transfers in the platform breakdown table. Feel free to email me if you are still having issues! Happy to help.
The current price for some cryptos are sometimes empty even do everything was entered correctly. What could be the issue?
Hey! They will be empty unless you enter the crypto name in the name column. Could also be that it's refreshing the IMPORTXML web scraping. Let me know if this issue persists and I can take a look at your sheet!
@@PlanetFinanceOfficial it seems like polka is not working. I used the correct name but it doesn't get updated
@@mrccc797 Looks like the XPATH for certain coins changes, in this case to fix it you need to enter this XPATH under the other ones you entered: //*[@id="__next"]/div[1]/div/div[2]/div/div[1]/div[3]/div/div[2]/div[1]/div/span
Once you enter it in cell X10 you will need to change the current price formula in cell AB24 (or in the line where Pola is): =IF(ISBLANK(W24),"",IFERROR(IMPORTXML("coinmarketcap.com/currencies/"&X24,$X$10),""))
This should fix your issue. Let me know how you go!
did it change again ? @@PlanetFinanceOfficial
did god send you?