Excel Cryptotracker: Your Profit Solution

[@nigeldbird1]

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]

you are welcome

[@IKagerockz]

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?

[@Financial_Failure]

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]

Good to be back, I hope you enjoy this tracker, there is a lot in it

[@Financial_Failure]

@@PaulaWeb3andCrypto officially using this and its amazing!!! This will make my investment update video MUCH better! You are a gem!

[@msb9997]

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 😊

[@firstalawal]

Welcome back Paula, Is there a daily limit of data pulling from public API when refreshing?

[@PaulaWeb3andCrypto]

the documentation for coingecko api says 30 calls per second. count each coin you have as 1 call.

[@Crypto_Manny]

Love it!!! TYVM!!!

[@PaulaWeb3andCrypto]

you are welcome

[@OvalboreTech]

wow, this is incredibly thorough!

[@PaulaWeb3andCrypto]

thanks

[@msb9997]

Brilliant!

[@amulpatel]

Brilliant .. thank you!

[@CosmicLifeAI]

Do you know of any existing API or platform that allows executing both market and limit orders directly from a spreadsheet or Excel file?

[@TheAgreenable]

Does the public API work with VPN?

[@PaulaWeb3andCrypto]

very often not!

[@alexramos587]

Thank you very much.

[@PaulaWeb3andCrypto]

you are welcome

[@mikeany7103]

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]

do you have values in the sales exit strategy

[@mikeany7103]

​@@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.

[@darrylbrown9469]

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!

[@spencookie]

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]

are you are able to get live prices via Excel? from the Data tab, via extracting data 'from the web'?

[@nzsurfer]

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?

[@carlomoretti.x]

Legendary!

[@PaulaWeb3andCrypto]

thanks

[@JohnDawson-p4t]

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!

[@raphaelkolacz]

Hello Paula and thank you very much for all the work you do. Is this version working with Excel on MacOS?

[@PaulaWeb3andCrypto]

No, it does not work on a mac, sorry

[@raphaelkolacz]

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

[@ComputerDivaVancouver]

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]

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

[@donsatcher9921]

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.

[@Don-vt1eo]

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]

Ok I had to do an update of the workbook, can you download it again.

[@sdabrarullah4919]

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]

the workbook is for excel 365, not google sheets, or mobile, sorry!

[@sdabrarullah4919]

Got it. Thanks

[@user-bg9ku1zq4n]

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]

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]

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]

@@PaulaWeb3andCrypto Thank you soo much I can un protecd sheet , I have downloaded the latest file. Now it is reflecting 27 lines only.

[@sabudas7699]

@@PaulaWeb3andCrypto One more thing on the Action Page I can see only see 55 lines

[@sdabrarullah4919]

@@sabudas7699you there?

[@alexanderalisoso4683]

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

[@charlesmaou6375]

That is Amazing, what if I dont want an exit strategy, ie long-term trading can I leave that exit strategy blank?

[@PaulaWeb3andCrypto]

Yes you can

[@user-wp2eb2cz9h]

Extra coin list tab does not have a table for URL address for API. Any suggestions? Thanks for this awesome workbook!

[@PaulaWeb3andCrypto]

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)?

[@hikmatullah8686]

Hjghly appreciate your work, ❤, what about futures trading make one workbook for futures trading, or just add the futures trading dashboard in this workbook

[@walitiansay2837]

For the data source, when i click on refresh, the price is not refreshed. Any help? i am using an apple macbook air

[@mikeany7103]

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]

is your exit strategy complete? this should populate then, if not, email me

[@mikeany7103]

@@PaulaWeb3andCrypto Hey again! Thanks for following up again. I sent an email today as I'm still having problems.

[@Crypto_Diaries]

not support in excel mac ?

[@sabudas7699]

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]

Kab seh use karre yeh sheet ?

[@sabudas7699]

@@sdabrarullah4919 Just started

[@mikeany7103]

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]

Ok I had to do an update of the workbook, can you download it again.