Thank you a lot for your awesome tracker and for your video. Much appreciated :)
@Elisa-o9r5z2 сағат бұрын
Thanks for helping beginners like me understand crypto better! I have USDT in my wallet but feel stuck when it comes to transferring. This is what I noted down: (summer topic topple similar physical seminar object upset deposit spot estate ripple). Is this part of the process?
@nigeldbird19 ай бұрын
This is amazing, thank you for all your effort.. Such a helpful tool, I had multiple sheets before and the data was all over the place..
@PaulaWeb3andCrypto9 ай бұрын
you are welcome
@MrOrionhan26 күн бұрын
This is amazing! in the transaction page under sales, i'm unable to enter "Per coin" column. Can you advise?
@bmich1964Ай бұрын
Hey Paula...amazing... but my XDC wont update anymore for some reason...any help would be appreciated
@markus916120 күн бұрын
Thank you for the great video and tool 😻Often, when I buy a coin, I use another coin for payment. In other words, it’s an exchange, meaning both buying and selling occur simultaneously. For example, if I buy XRP with Solana, should I immediately add the Solana on the selling side with its profit calculations (let's assume that SOL was purchased earlier)? However, it’s a bit tricky to do this without breaking the formulas, as the selling side is linked to Selling Points. Can you help a bit with how currency exchanges should be added in the sheet?
@x2xtreme36016 күн бұрын
I would like insight on this as well. I often trade one crypto for another. I could be selling it at a profit or a loss, but it's still unrealized as I never traded it for USD.
@Financial_Failure9 ай бұрын
Welcome back! And Next video I make I'll use this tracker and give you a S/O! Because my excel sheet that i used in my last video... was trash haha
@PaulaWeb3andCrypto9 ай бұрын
Good to be back, I hope you enjoy this tracker, there is a lot in it
@Financial_Failure9 ай бұрын
@@PaulaWeb3andCrypto officially using this and its amazing!!! This will make my investment update video MUCH better! You are a gem!
@rajeshmaharaj70517 күн бұрын
Hi, excellent resource. Long search now over perhaps. Will this work in Open Office? If not which version of Excel is this? Any other assistance re a way forwad will assist me tremendously. Well done and may god Bless You and Yours for selflessly sharing such an amazing practical tool.
@mikeany71039 ай бұрын
The "tokens sold2", 3 and so on isn't working for me. When I'm trying to enter the sales i did on the "transactions" page. Only "tokens sold" works. Also, thanks for this template as this could be a real game changer for me.
@PaulaWeb3andCrypto9 ай бұрын
do you have values in the sales exit strategy
@mikeany71038 ай бұрын
@@PaulaWeb3andCrypto Thanks for the quick reply! Yes, i just cleared ALL the example values on the sheet and tried filling it with new values and it worked well.
@firstalawal9 ай бұрын
Welcome back Paula, Is there a daily limit of data pulling from public API when refreshing?
@PaulaWeb3andCrypto9 ай бұрын
the documentation for coingecko api says 30 calls per second. count each coin you have as 1 call.
@davidmacholz307214 күн бұрын
Wish this worked for me but I am not able to edit data Permissions
@TheAgreenable9 ай бұрын
Does the public API work with VPN?
@PaulaWeb3andCrypto9 ай бұрын
very often not!
@IKagerockz3 ай бұрын
HI Paula , thanks you so much for the work sheet it is a great help . iam wonder to why in th extra coin section its capped to 25 coins max?
@spencookie4 ай бұрын
Question Paula, trying to input data since 2017 is a nightmare. Do we have to enter each transaction along with the taxes we paid? I was hoping I could just take figures from 2023 and enter them and then add new transactions from this year. I'm a newbie so your help would be appreciated. Also, I didn't see the edit permissions from data source at beginning of your video. I'm assuming it's already set. I have the latest version of Excel, so just wondering. Thanks
@LicoInvestments7 ай бұрын
are you are able to get live prices via Excel? from the Data tab, via extracting data 'from the web'?
@msb99973 ай бұрын
Hi Paula - thanks for the great Tracker. Not sure if you saw my email the other day - might be in spam box? I just wanted to let you know I think Cell E35 & E36 in "ENTER TRANSCATIONS" might need a correction as in my file it shows Euro instead of USD. I had chosen USD as the currency. Same in EXIT STRATEGY sheet "Selling Point' column shows Euro instead of USD. DASHBOARD I think under Column Price any coins under 1.00 seem to show as 0 instead of identifying the number in cent in cents. Thanks again 😊
@CosmicLifeAI4 ай бұрын
Do you know of any existing API or platform that allows executing both market and limit orders directly from a spreadsheet or Excel file?
@donsatcher99214 ай бұрын
Hello Paula, does this workbook work with MS Excel 2013? I've enabled the data connections to public but am receiving a "initialization of data source failed" error. Thanks.
@OvalboreTech9 ай бұрын
wow, this is incredibly thorough!
@PaulaWeb3andCrypto9 ай бұрын
thanks
@walitiansay28378 ай бұрын
For the data source, when i click on refresh, the price is not refreshed. Any help? i am using an apple macbook air
@darrylbrown94694 ай бұрын
Hello, I am trying to run this on an Apple Macbook and it do not seem runable. The Menu icons do not work, when I click on them the images are not highlighted. I can see the word agree to click on it. Is there anything I can do to fix this problem? Thanks!
@raphaelkolacz9 ай бұрын
Hello Paula and thank you very much for all the work you do. Is this version working with Excel on MacOS?
@PaulaWeb3andCrypto9 ай бұрын
No, it does not work on a mac, sorry
@raphaelkolacz9 ай бұрын
Don't be sorry. It's just amazing how much you do! Thank you very much. I follow step by step the portfolio tracker you create online 3 years ago. Till now it works like a charme! Thank you again.@@PaulaWeb3andCrypto
@JohnDawson-p4t7 ай бұрын
Hello. What if my extra coins are not listed on coin gecko? How do I find API ID for much lower cap coins? Thanks for the help! Awesome portfolio tracker!
@alexanderalisoso46838 ай бұрын
i have spome issues everytime i refesh the data. it took so long and a window opens like an error.. espcially in adding the coin. it is not reflecting the entry that i entered. can u please help me how to solve this issue? much appreciated
@nzsurfer8 ай бұрын
Hi, this is fantastic, thanks so much. I have one problem. I'm based in New Zealand and use NZD is there a way I can add this as a currency option?
@user-wp2eb2cz9h9 ай бұрын
Extra coin list tab does not have a table for URL address for API. Any suggestions? Thanks for this awesome workbook!
@PaulaWeb3andCrypto9 ай бұрын
yes I just spotted this, thanks. Here are the steps to fix it. On the extra coins list, go to the review tab, and select unprotect sheet, the on the view ribbon, make sure there is a tick beside headings. then unhide columns c and g. Then untick headings in the view ribbon and also on the review tab, select protect sheet and agree to the settings. Or you can download it again(as I have made this update) and re-enter your data(copy paste)?
@Don-vt1eo8 ай бұрын
Thanks for all of your hard work. I've entered some data for BTC, ETH and LINK. Only ETH is showing on the dashboard. I have hit Data refresh. Suggestions?
@PaulaWeb3andCrypto8 ай бұрын
Ok I had to do an update of the workbook, can you download it again.
@user-bg9ku1zq4n8 ай бұрын
In Germany we don't pay taxes for cryptos which we hold longer than 1 year. Is it possible to implement a feature that shows which cryptos have reached that timeframe and are tax free? Also when selling tax free cryptos and cryptos which are not taxfree yet is it possible to make a difference between those taken profits? Like showing them seperately. It would be helpfull for a tax report. Thank you for your work.
@sabudas76998 ай бұрын
On the Dashboard bottom table (Ticker,currrent prize 24% Change ,Invetment value, Acquision Cost Unrealizes profit etc)only shows 5 coins out of 100 Coins on the list. Is there anything I am missing?
@sdabrarullah49198 ай бұрын
Kab seh use karre yeh sheet ?
@sabudas76998 ай бұрын
@@sdabrarullah4919 Just started
@Crypto_Manny9 ай бұрын
Love it!!! TYVM!!!
@PaulaWeb3andCrypto9 ай бұрын
you are welcome
@sabudas76998 ай бұрын
Great work, just want to check if there is possibility to increase the number of coins that can be added ? when I stretch the cells it says sheet protected
@PaulaWeb3andCrypto8 ай бұрын
you can just unprotect, there is no password. also there is an error in the workook, I have just updated, can you download it again and copy paste your data,
@sabudas76998 ай бұрын
@@PaulaWeb3andCrypto Thank you soo much I can un protecd sheet , I have downloaded the latest file. Now it is reflecting 27 lines only.
@sabudas76998 ай бұрын
@@PaulaWeb3andCrypto One more thing on the Action Page I can see only see 55 lines
@sdabrarullah49198 ай бұрын
@@sabudas7699you there?
@sdabrarullah49199 ай бұрын
The video and sheet are amazing! 👏 Thanks for sharing them with us. Moreover, I'd like to know if I can use them on phone apps like Excel and Google Sheets? If yes, do I need to change some settings? Because when I tried to open them on both apps, I got an error on Excel saying "found a problem with this file", and on Google Sheets, it opens but I can't operate it.
@PaulaWeb3andCrypto9 ай бұрын
the workbook is for excel 365, not google sheets, or mobile, sorry!
@sdabrarullah49198 ай бұрын
Got it. Thanks
@ComputerDivaVancouver9 ай бұрын
HI Paula - I love this spreadsheet and was using the old one as well. I was never able to figure out how to properly document a trade. Say I traded BTC for USDC. The I traded USDC for ETH. How would I enter these transactions?
@PaulaWeb3andCrypto9 ай бұрын
enter the sale into the sales sheet, you can then enter the recieved amount of usdc into the purchases, because you bought usdc with btc. then enter a sale of usdc and a purchase of eth
@mikeany71038 ай бұрын
Though, now my problem is that on the Dashboard, the table at the bottom is full of #NAME? and #REF! instead of the expected data. Please help
@PaulaWeb3andCrypto8 ай бұрын
Ok I had to do an update of the workbook, can you download it again.
@Crypto_Diaries8 ай бұрын
not support in excel mac ?
@hikmatullah86867 ай бұрын
Hjghly appreciate your work, ❤, what about futures trading make one workbook for futures trading, or just add the futures trading dashboard in this workbook
@amulpatel4 ай бұрын
Brilliant .. thank you!
@alexramos5879 ай бұрын
Thank you very much.
@PaulaWeb3andCrypto9 ай бұрын
you are welcome
@msb99973 ай бұрын
Brilliant!
@carlomoretti.x9 ай бұрын
Legendary!
@PaulaWeb3andCrypto9 ай бұрын
thanks
@mikeany71038 ай бұрын
The "ticker", "current price" and "24hr changes" - all show well now (no more #REF! errors) But "Investment value", "Acquision Cost", "Series Value" "Profits taken", "COGS" - all still show the same error of #NAME? This is after doing an initial refresh all under the data tab (i did nothing else on the chart) and then set the privacy level to public Again, thank you very much for getting back to me so fast!
@PaulaWeb3andCrypto8 ай бұрын
is your exit strategy complete? this should populate then, if not, email me
@mikeany71036 ай бұрын
@@PaulaWeb3andCrypto Hey again! Thanks for following up again. I sent an email today as I'm still having problems.
@SandraTaylor-n9g6 күн бұрын
The video is very interesting! Something I don't understand: I have TRC20 USDT in my OKX wallet and I have the recovery phrase: [pride pole obtain together second when future mask review nature potato bulb]. How should I convert them into Bitcoin?
@charlesmaou63759 ай бұрын
That is Amazing, what if I dont want an exit strategy, ie long-term trading can I leave that exit strategy blank?