Excel Cryptotracker: Your Profit Solution
ฝัง
- เผยแพร่เมื่อ 29 ก.ย. 2024
- Download Free Excel Crypto Currency Tracker and Take Profits Strategy Workbook here www.ablockofcr...
Learn how to use and update the Cryptocurrency take profits cashout/exit strategy sheet with Simon from Crptorats
• Plan your Cryptocurren...
🚀 Ready to take control of your crypto investments and maximize your profits? Look no further! Introducing our updated Excel Cryptotracker and Exit Planner Strategy Workbook - now with enhanced features to streamline your crypto management journey!
With over 100K downloads and counting, our free Excel workbook offers a secure and personalized solution for tracking and managing your crypto portfolio. Say goodbye to complicated spreadsheets and hello to intuitive tools designed to keep you ahead in the ever-evolving crypto market.
Features include:
Personalized settings for currency preferences
Interactive dashboard to track and manage your portfolio
Notifications on trending coins and profit-taking opportunities
Exit strategy planner to safeguard your profits
Easy-to-use purchase and sales entry sheets
And much more!
Plus, rest assured that your data remains safe and secure - as you never connect your wallet so you are never sharing data, and you are NOT the product.
📥 Ready to get started? Click the link below to download our free Excel Cryptotracker and take control of your crypto journey today!
Download the Excel Cryptotracker Workbook Here: www.ablockofcr...
Don't forget to like, share, and subscribe for more valuable insights and updates on navigating the crypto market like a pro! 📈💼 #CryptoTracker #ExcelWorkbook #Cryptocurrency #Investing #MaximizeProfits
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..
you are welcome
Do you know of any existing API or platform that allows executing both market and limit orders directly from a spreadsheet or Excel file?
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.
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 😊
Does the public API work with VPN?
very often not!
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
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,
@@PaulaWeb3andCrypto Thank you soo much I can un protecd sheet , I have downloaded the latest file. Now it is reflecting 27 lines only.
@@PaulaWeb3andCrypto One more thing on the Action Page I can see only see 55 lines
@@sabudas7699you there?
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?
Kab seh use karre yeh sheet ?
@@sdabrarullah4919 Just started
That is Amazing, what if I dont want an exit strategy, ie long-term trading can I leave that exit strategy blank?
Yes you can
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?
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.
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
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!
Brilliant!
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
Ok I had to do an update of the workbook, can you download it again.
Brilliant .. thank you!
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.
do you have values in the sales exit strategy
@@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.
Welcome back Paula, Is there a daily limit of data pulling from public API when refreshing?
the documentation for coingecko api says 30 calls per second. count each coin you have as 1 call.
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
Good to be back, I hope you enjoy this tracker, there is a lot in it
@@PaulaWeb3andCrypto officially using this and its amazing!!! This will make my investment update video MUCH better! You are a gem!
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!
Hjghly appreciate your work, ❤, what about futures trading make one workbook for futures trading, or just add the futures trading dashboard in this workbook
For the data source, when i click on refresh, the price is not refreshed. Any help? i am using an apple macbook air
are you are able to get live prices via Excel? from the Data tab, via extracting data 'from the web'?
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?
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
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?
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
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?
Ok I had to do an update of the workbook, can you download it again.
Thank you very much.
you are welcome
Love it!!! TYVM!!!
you are welcome
Extra coin list tab does not have a table for URL address for API. Any suggestions? Thanks for this awesome workbook!
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)?
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!
is your exit strategy complete? this should populate then, if not, email me
@@PaulaWeb3andCrypto Hey again! Thanks for following up again. I sent an email today as I'm still having problems.
not support in excel mac ?
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.
the workbook is for excel 365, not google sheets, or mobile, sorry!
Got it. Thanks
Legendary!
thanks
wow, this is incredibly thorough!
thanks
Hello Paula and thank you very much for all the work you do. Is this version working with Excel on MacOS?
No, it does not work on a mac, sorry
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