Excel Cryptotracker: Your Profit Solution

  Рет қаралды 3,698

Paula's Web3 & Crypto

Paula's Web3 & Crypto

Күн бұрын

Пікірлер: 74
@Fractal-Shots
@Fractal-Shots 5 күн бұрын
Thank you a lot for your awesome tracker and for your video. Much appreciated :)
@Elisa-o9r5z
@Elisa-o9r5z 2 сағат бұрын
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?
@nigeldbird1
@nigeldbird1 9 ай бұрын
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..
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
you are welcome
@MrOrionhan
@MrOrionhan 26 күн бұрын
This is amazing! in the transaction page under sales, i'm unable to enter "Per coin" column. Can you advise?
@bmich1964
@bmich1964 Ай бұрын
Hey Paula...amazing... but my XDC wont update anymore for some reason...any help would be appreciated
@markus9161
@markus9161 20 күн бұрын
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?
@x2xtreme360
@x2xtreme360 16 күн бұрын
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_Failure
@Financial_Failure 9 ай бұрын
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
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
Good to be back, I hope you enjoy this tracker, there is a lot in it
@Financial_Failure
@Financial_Failure 9 ай бұрын
@@PaulaWeb3andCrypto officially using this and its amazing!!! This will make my investment update video MUCH better! You are a gem!
@rajeshmaharaj7051
@rajeshmaharaj7051 7 күн бұрын
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.
@mikeany7103
@mikeany7103 9 ай бұрын
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.
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
do you have values in the sales exit strategy
@mikeany7103
@mikeany7103 8 ай бұрын
​@@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.
@firstalawal
@firstalawal 9 ай бұрын
Welcome back Paula, Is there a daily limit of data pulling from public API when refreshing?
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
the documentation for coingecko api says 30 calls per second. count each coin you have as 1 call.
@davidmacholz3072
@davidmacholz3072 14 күн бұрын
Wish this worked for me but I am not able to edit data Permissions
@TheAgreenable
@TheAgreenable 9 ай бұрын
Does the public API work with VPN?
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
very often not!
@IKagerockz
@IKagerockz 3 ай бұрын
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?
@spencookie
@spencookie 4 ай бұрын
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
@LicoInvestments
@LicoInvestments 7 ай бұрын
are you are able to get live prices via Excel? from the Data tab, via extracting data 'from the web'?
@msb9997
@msb9997 3 ай бұрын
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 😊
@CosmicLifeAI
@CosmicLifeAI 4 ай бұрын
Do you know of any existing API or platform that allows executing both market and limit orders directly from a spreadsheet or Excel file?
@donsatcher9921
@donsatcher9921 4 ай бұрын
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.
@OvalboreTech
@OvalboreTech 9 ай бұрын
wow, this is incredibly thorough!
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
thanks
@walitiansay2837
@walitiansay2837 8 ай бұрын
For the data source, when i click on refresh, the price is not refreshed. Any help? i am using an apple macbook air
@darrylbrown9469
@darrylbrown9469 4 ай бұрын
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!
@raphaelkolacz
@raphaelkolacz 9 ай бұрын
Hello Paula and thank you very much for all the work you do. Is this version working with Excel on MacOS?
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
No, it does not work on a mac, sorry
@raphaelkolacz
@raphaelkolacz 9 ай бұрын
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-p4t
@JohnDawson-p4t 7 ай бұрын
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!
@alexanderalisoso4683
@alexanderalisoso4683 8 ай бұрын
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
@nzsurfer
@nzsurfer 8 ай бұрын
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-wp2eb2cz9h
@user-wp2eb2cz9h 9 ай бұрын
Extra coin list tab does not have a table for URL address for API. Any suggestions? Thanks for this awesome workbook!
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
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-vt1eo
@Don-vt1eo 8 ай бұрын
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?
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 8 ай бұрын
Ok I had to do an update of the workbook, can you download it again.
@user-bg9ku1zq4n
@user-bg9ku1zq4n 8 ай бұрын
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.
@sabudas7699
@sabudas7699 8 ай бұрын
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?
@sdabrarullah4919
@sdabrarullah4919 8 ай бұрын
Kab seh use karre yeh sheet ?
@sabudas7699
@sabudas7699 8 ай бұрын
@@sdabrarullah4919 Just started
@Crypto_Manny
@Crypto_Manny 9 ай бұрын
Love it!!! TYVM!!!
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
you are welcome
@sabudas7699
@sabudas7699 8 ай бұрын
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
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 8 ай бұрын
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,
@sabudas7699
@sabudas7699 8 ай бұрын
@@PaulaWeb3andCrypto Thank you soo much I can un protecd sheet , I have downloaded the latest file. Now it is reflecting 27 lines only.
@sabudas7699
@sabudas7699 8 ай бұрын
@@PaulaWeb3andCrypto One more thing on the Action Page I can see only see 55 lines
@sdabrarullah4919
@sdabrarullah4919 8 ай бұрын
@@sabudas7699you there?
@sdabrarullah4919
@sdabrarullah4919 9 ай бұрын
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.
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
the workbook is for excel 365, not google sheets, or mobile, sorry!
@sdabrarullah4919
@sdabrarullah4919 8 ай бұрын
Got it. Thanks
@ComputerDivaVancouver
@ComputerDivaVancouver 9 ай бұрын
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?
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
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
@mikeany7103
@mikeany7103 8 ай бұрын
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
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 8 ай бұрын
Ok I had to do an update of the workbook, can you download it again.
@Crypto_Diaries
@Crypto_Diaries 8 ай бұрын
not support in excel mac ?
@hikmatullah8686
@hikmatullah8686 7 ай бұрын
Hjghly appreciate your work, ❤, what about futures trading make one workbook for futures trading, or just add the futures trading dashboard in this workbook
@amulpatel
@amulpatel 4 ай бұрын
Brilliant .. thank you!
@alexramos587
@alexramos587 9 ай бұрын
Thank you very much.
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
you are welcome
@msb9997
@msb9997 3 ай бұрын
Brilliant!
@carlomoretti.x
@carlomoretti.x 9 ай бұрын
Legendary!
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
thanks
@mikeany7103
@mikeany7103 8 ай бұрын
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!
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 8 ай бұрын
is your exit strategy complete? this should populate then, if not, email me
@mikeany7103
@mikeany7103 6 ай бұрын
@@PaulaWeb3andCrypto Hey again! Thanks for following up again. I sent an email today as I'm still having problems.
@SandraTaylor-n9g
@SandraTaylor-n9g 6 күн бұрын
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?
@charlesmaou6375
@charlesmaou6375 9 ай бұрын
That is Amazing, what if I dont want an exit strategy, ie long-term trading can I leave that exit strategy blank?
@PaulaWeb3andCrypto
@PaulaWeb3andCrypto 9 ай бұрын
Yes you can
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН
We Attempted The Impossible 😱
00:54
Topper Guild
Рет қаралды 56 МЛН
Cheerleader Transformation That Left Everyone Speechless! #shorts
00:27
Fabiosa Best Lifehacks
Рет қаралды 16 МЛН
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 54 МЛН
Why I Love Excel (And Why You Should Too) - Stocks and Spreadsheets
11:51
Interactive Excel Dashboard Tutorial in 3 Steps (+ FREE Template)
18:57
MyOnlineTrainingHub
Рет қаралды 153 М.
Excel Import CoinMarketCap API Data with Query
7:17
SyntaxByte
Рет қаралды 71 М.
Fastest Excel Currency and Accounting Formats
3:16
Technology for Teachers and Students
Рет қаралды 17 М.
ULTIMATE Personal Budget & Interactive Dashboard in Excel (FREE Template)
33:20
BRC20 Ultimate Beginner's Guide (With a Secret Alpha)
20:28
Paula's Web3 & Crypto
Рет қаралды 999
Excel Budget Template | Automate your budget in 15 minutes
9:29
Work Smarter Not Harder
Рет қаралды 3,1 МЛН
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН