*****Important note************** this workbook does not work in Excel for Mac.
@wheelplace3 жыл бұрын
Hi Paula is this compatibility issue fixable? Would it be too complex to do so?
@Ida12fw3 жыл бұрын
Thank you, I just realise this. its a pity really a beautiful and well thoughout spreadsheet
@cryptoyang34862 жыл бұрын
It's too sad. I have only Mac
@Ucho2 жыл бұрын
Hi, love this. Is there work on for a Max Excel verision?
@cryptoyang34862 жыл бұрын
@@Ucho No, unfortunately didn't work on Mac.
@nisarjaffrey89603 жыл бұрын
Rubbing my eyes to believe that such spreadsheet exists and it’s for free! You are genius Paula
@PaulaWeb3andCrypto3 жыл бұрын
thanks, but a genius is a bit of a stretch :-)
@adhereclarke3 жыл бұрын
With the chaos of several exchanges both centralized and decentralized making purchases and storing in online wallets and cold wallets ....cryptos all over the place. THIS Excel workbook brings peace back to the CRYPTO UNIVERSE Thankyou Paula...Great job
@indalkp2 жыл бұрын
THIS EXCEL SHEET IS REALLY A FANTASY FOR TRADERS... IF SOMEHOW THIS COULD ALSO CONNECT OUR BINANCE WALLET AND ORDER DATA THROUGH API............ WELL THAT'S A DREAM.. THANKS FOR THIS AMAZING VIDEO...
@tradingsignallabs49393 жыл бұрын
Hey Paula .... this is amazing and exactly what I needed. Can't believe it's free. I'm in Dublin and can't wait to watch the 2nd video tonight. Also very interested in the meetup. Thank you so so much for this.
@PaulaWeb3andCrypto3 жыл бұрын
awesome, glad we could help. Hope to see you at the meetup.
@johannaschmidt71382 жыл бұрын
*Hello sorry for asking about this here, I'm new to crypto and forex trading and I've been making huge loses trading on my own but recently i see alot of people earning from it. can someone please give me a new strategy or at least tell me what I'm doing wrong?*
@stanlybetter30462 жыл бұрын
I'm actually trading with an expert Mrs Catherine nathan a regulated broker, met her sometime early last year at a start up funding event, she had some interesting things to say about the state of algorithmic trading today, very obviously I'm seeing the results.
@margaretmyles66832 жыл бұрын
WOW....amazing to see someone who trades with Mrs Catherine nathan, i am currently on my 5th trade with her and my portfolio has grown tremendously.
@johannaschmidt71382 жыл бұрын
@@stanlybetter3046 please how can I rεaςhout to your trader, I've so much loss in trading and need some guidelines.
@stanlybetter30462 жыл бұрын
@@johannaschmidt7138 *she can be liaised ,on Telegam,with the username >>>> @INVESTWITHNATHAN
@mikey-bigg44862 жыл бұрын
I have traded with a lot of individuals but i have never come across anyone as good as mrs catherine nathan, applying her strategies ,I now trade independently.she is the best i'd advise any novice in investing to trade with her.
@leanbanclog3 жыл бұрын
Hi Paula, thanks for a great resource, a lot of work went it to completing it. Unfortunately, it will not refresh. Privacy settings have been adjusted between private and organisational. When refreshing three alert windows popup with a query issues.
@dylandash54382 жыл бұрын
Paula can you respond to this? I have the same issue
@Ucho2 жыл бұрын
@@dylandash5438 What are you using Windows or MAC?
@gilsinhogma2 жыл бұрын
Hi Just had the same issue and solved! Go to -> Tab DATA - Get Data - > Launch Power Query editor - Select File > Options and Settings > Data Source Settings. Excel Select Data > Get Data > Data Source Settings. 2.Select Edit Permissions. The Edit Permissions dialog box appears. 3.Under Privacy Level, select an option from the drop-down list: Choose Public for the all 3. I hope it helps.
@janefinn90472 жыл бұрын
@@gilsinhogma This worked for me too, thank you so much!!!
@leanbanclog2 жыл бұрын
@@gilsinhogmaworked a treat, go raibh maith agat.
@ceeO_0cue10 ай бұрын
This looks amazing!! Is this still available to download? I'm getting an error.
@robbie59993 жыл бұрын
Paula, this is great. How do I change it to GBP? I use GBP for all my crypto purchases.
@Zevenwateren2 жыл бұрын
Thank you so much, I can't work with out it. I would've loved to have seen instructions on how to fill in the Sales part of the transactions lists also, instead of only the purchases part.
@PappaBearAsh2 жыл бұрын
Hi Paula, thanks for creating the crypto spreadsheet it’s help to tack and plan my trades. Could you please add a column to indicate the exchange the crypto was purchase. I’m also looking for a spreadsheet to track my entry points ie when BTC Hit $32k buy 10% of allocations when it hit $28k purchase 90% ..
@MrMoulme2 жыл бұрын
Amazing work, thanks so much ! I'm still strugling to change currency on the dashboard, I'm in Euro
@flowerroos2 жыл бұрын
I'm having the same issue's. I hope there is a solution for this.
@solomontinuoye29502 жыл бұрын
Wow, thanks Paula, you really have a unique heart, I can't thank you enough, keep on the good work. Please take care and enjoy the season...
@Rinkeshjindal3 жыл бұрын
Hey Paula, This sheet is good start, while lacking functionality to track the Conversions & transfer one Exchange to another exchange.
@suebenbow68602 жыл бұрын
Paula when I'm adding extra coins manually - can I pull the info from coin gecko in Australian dollars? Will your back ground calculations still work?
@mehdiizadi82433 жыл бұрын
Thanks a ton, Paula and Simon.
@ajlozadaro2 жыл бұрын
WWWWOOOOOOOOWWWWWW Paula! 😲 What incredible resource! THANKS! You are AMAZING!
@uqwee2 жыл бұрын
Hi Paula, many thanks for sharing your brilliant work with us all here!
@cryptokirbytrading69232 жыл бұрын
Hit Me up👆
@AniThrills7862 жыл бұрын
Hi Paula Your work is amazing never seen before love from me and hope more success for you:)
@zeeshan4639 Жыл бұрын
Hi paula first of all great work you saved my months and please reolve the issue in price_feed api as it is not accessible please.
@PaulaWeb3andCrypto Жыл бұрын
hi, yes there is a problem with the API. its out of my control.. please check status.coingecko.com/incidents/123015 for more info
@pjali99293 жыл бұрын
Thank you so much for this! I've recently just entered into crypto and had a hard time tracking my portfolio. I truly appreciate the effort and generosity of your work!
@PaulaWeb3andCrypto3 жыл бұрын
Very welcome!
@norrismasters26292 жыл бұрын
Paula & Simon, you are AWESOME! Thank you for this spreadsheet, I've been trying to create my own for years and here you have it, well programmed, well thought and fully functional! THANKS A MILLION TIMES!
@hussler1122 жыл бұрын
Great content Paula
@Acrnl3 жыл бұрын
Thank you, PG the spreadsheet is GREAT ...
@PaulaWeb3andCrypto3 жыл бұрын
Glad you like it!
@mmoellerdeoliveira2 жыл бұрын
Excelent!!! thank U so much
@sh4dowcrypto2512 жыл бұрын
Hi. Thank you so much for this. This is what I just needed. The video is explained well. Really underrated channel. You deserve more ma'am. You have my subscription. God bless
@rulow14143 жыл бұрын
i've been waiting long time for this video!!🙌
@PaulaWeb3andCrypto3 жыл бұрын
cool, I hope you like it
@naturalecosystems512 жыл бұрын
Awesome! Just what I was attempting to set up myself. I think you have saved me 2 months of trial and error. Thank you, Thank you.🙏
@jcspeer52 жыл бұрын
Thank you so much for this!! When I click to Refresh Data I get “Query 'Rurl' (step 'Renamed Columns') is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.”
@alfonsoquintero10783 жыл бұрын
Absolutely incredible !!! you are awesome Paula !! thank you ...
@wayneedmondson10653 жыл бұрын
Hi Paula. Nice to see you posting again. The planner / tracker looks awesome! Thanks so much for sharing it. Looking forward to more :)) Thumbs up!!
@PaulaWeb3andCrypto3 жыл бұрын
Thanks so much! 😊
@0770nacho2 жыл бұрын
Very Nice Ms Paula, are You planning to do a Mac version will be very appreciated for lots of people around the globe
@HenrikKKristensen2 жыл бұрын
Hi Paula. All my purchases was done in Euro.. any update on how to get this working (if not with multiple currencies, then where anyhow to fix it to Euro instead)?
@outnabout97852 жыл бұрын
Hi Paula Thanks for the free workbook and tutorial, they are both excellent. I'm having problems adding additional lines on the extra coins list could you help me with this.
@Sylvia-ur4bv2 жыл бұрын
Hi Paula! Thanks for the great sheet! How to use it with EUR as currency.. i tried to copy BTC copy in EUR but it keeps on displaying usd. You have an idea how to solve this?
@Ida12fw3 жыл бұрын
GREAT JOB PAULA, My excel sheet is only showing read only and cannot connect or refresh data connection
@lukev7302 жыл бұрын
Hi Paula Thank You so much for this tutorial and excel tracker. It is amazing!
@muzicanaturii108 Жыл бұрын
Thanks for the amazing work you do. I want to ask you, what is sell point column in the sales table, i ask because i am not an english speaking person, i inserted the price of the sell i made but it says incorrect. Thank you.
@hayderh.9522 жыл бұрын
Thank you Paula! I truly appreciate the effort.
@simplepassiveincome3 жыл бұрын
So awesome. Thank you so much Paula. You and Simon really did a great job with the spreadsheet. I have been looking for something like this for a very long time. There's always been something missing with the apps I used before, but the fact that you've also added an exit strategy rounds it all up for me. Thank you kindly.
@PaulaWeb3andCrypto3 жыл бұрын
Glad it was helpful!
@simplepassiveincome3 жыл бұрын
@@PaulaWeb3andCrypto I just sent you an email. Would be great to hear from you. It’s from Vincent Mbatha. It’s regarding the spreadsheet. I’m having a challenge. It won’t allow me to Refresh Data. I’m on a Mac 💻
@PaulaWeb3andCrypto3 жыл бұрын
this wont work on a mac, sorry
@alextabone132211 ай бұрын
Hi, im using the sheet, its awesome. Good Job. However I have some tokens which for some reason I enter all correct data however an error still pops up telling me to include them in the extra coins list. Can you assist me please ?
@jaymieknight2 жыл бұрын
Hello, just added a comment to the last video, does the .xls track staking rewards for offline coins in offline hard cold wallets? I have several public addresses I want to pull the staking rewards from. Thanks J
@hydakhan3292 жыл бұрын
Will this work for SHIB Calculation?
@domaniclieb20762 жыл бұрын
Hello Paula, first off, WOW! just a fantastic description and video. Have one question: entering selling data?
@LSOL-ln3hj3 жыл бұрын
Thank you very much, Paula. This workbook is amazing and really helpful!
@4sonsplus12 жыл бұрын
pretty awesome excel sheet thanks so much
@mrz0072 жыл бұрын
Hello Paula, I would like to thank you first of all for this great tool that you are providing us for free. I would like to ask you if is possible to change the "average per coin" value in the Sale Point Sheet, from a simple Average, to a Weighted Average (even if I have to add the formula manually somewhere). Sometimes it happens that you buy a LOT of coins at a certain price, and then you buy a LITTLE quantity of the same coin at a much higher price for example. The value that the "average per coin" shows it will not be the real one, but much higher as it doesn't weigh the amount of coins that you actually buy at each different price. If not possible, maybe just make it in a way that the value showed in the "average per coin" is a simple SUM of the purchase prices (value that we put in manually) / SUM of the number of coins (value that we put in manually). Or maybe there is a reason why it is like it is, as a simple average?
@NordicFireDKK2 жыл бұрын
Is there a way to track your portfolio win/loss ratio and stuff like in coinmarketmanager but in excel using an API key? Or a simpler way that to type all the values in. Love your videos by the way, they are nice to follow and understand
@srwilmoth Жыл бұрын
I really like your spread sheet. I have one question. Most of my coins on the dashboard are showing up 2 times. How do I fix this? THANKS
@cbruijns2 жыл бұрын
Is there a way to convert this to work in CAD?
@llMikeyBll Жыл бұрын
Unfortunately the workbook download isn't working anymore! Would of really liked to use this :(
@hazmanhussin3 жыл бұрын
Hi Paula. I ran into a problem when I put my coins and transaction history, it double the type of coin. For example, on dashboard I have two bars of BTC, ETH and so on. Have you encountered this problem and do you know how to solve this?
@cryptodecrypted66512 жыл бұрын
I have the same issue. The "Qty of Tokens" is double what I actually have, and the 'Acquisition Cost' is exactly double what it actually cost, which throws off the P/L and the ROI massively. Can't figure out why its doubling everything.
@horsehappiness51153 жыл бұрын
Very impressive. I've managed to get working on a PC I have access too. Shame it won't work on a Mac.
@georgemoschos50512 жыл бұрын
Absolute legends
@jimm22152 жыл бұрын
Hi Paula. Any chance you can add NFT's to this dashboard? Thanks!!
@calvinbrownjr2 жыл бұрын
Hi, how do you extend the width of the columns? I have coins such as SHIB and SAITAMA, which have a lot of zeros. The fact that the current price for these coins has so many zeros, I am unable to see the details of important columns on the Exist Strategy section such as: Tokens Sold, Tokens Over, Profit, etc. PLEASE HELP!!
@cryptokirbytrading69232 жыл бұрын
Messages👆
@PraiseTheLord95 Жыл бұрын
Quick question / Great spreadsheet. When I refreshed the data I get an error asking me to update my privacy settings. What are the correct settings for this workbook so it pulls the correct data? Thanks for your help / assistance. I tried to input setting - private but I get the following error " Query "Rurl" (step 'Renamed Columns " is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. Any idea how to correct this and get the workbook working?
@PaulaWeb3andCrypto Жыл бұрын
if you set it to private it should work fine as long as it is on your own pc or laptop, if it is a work device, you may have to check with your IT admin
@PraiseTheLord95 Жыл бұрын
@@PaulaWeb3andCrypto Hi Paula. Thanks for the quick response. It is a personal computer. I set everything to private in the privacy settings for data and I get the same error. Will try to look around for another import tool and see if I can understand what code needs to fixed. Probably some update from Microsoft with all the new privacy laws that is making this spreadsheet connection not work. I tried redownloading it and trying a second time and it came up with the same error. It looks like corrections need to be made after going into the power query editor as I see of lot of items broken and not loading correctly.
@PaulaWeb3andCrypto Жыл бұрын
@@PraiseTheLord95 if you are not sharing the laptop, you can change it to none. that should work fine then
@mfield431210 ай бұрын
Hi did you ever solve this problem? I seem to have the same issue @@PraiseTheLord95
@iwiecha3 жыл бұрын
Hello, At the beginning, words of appreciation for a great job :) I have a problem with calculating the average value per coin. For example, when we add two transactions: ticker - no. of coin - total cost - per coin 1. ADA - 97.52 - $ 141.4 - $ 1.45 2. ADA - 12 - $ 25.8 - $ 2.15 This average purchase price per coin should be ca. $ 1.53 but in the "Exit strategy" tab there is $ 1.8
@jscoobs10783 жыл бұрын
This is freaking awesome. Thank you!!!
@TechnicalDaust11 ай бұрын
Can you please tell me where is the calculation sheet which you used for calculation?
@seudialramsingh88612 жыл бұрын
Hello Paula, This Tool and the Video seems simple enough. My problem is that i cant get the "Refresh All" to work! I get this message: Query "Ruri' (Step "renamed Columns") is accessing data columns that have privacy levels that cannot be used together, etc. Can you point me in the right direction? Much appreciated
@graps16119 ай бұрын
Hi Paula, entering my crypto into your spreadsheets for the first time. When I enter a sale transaction what is the selling point column? I figured it was the price of the coin at the time of sale but the spreadsheet won't accept because it doesn't follow the format set up by the creator of the spreadsheet. Any idea what this col should be?
@martinhinneh16063 жыл бұрын
I have a little concern on "No. of Coin' column. How do you extend that column to be able to accommodate 12 digits? For example, the current column is not able to contain numbers like 0.000000000001. How do you get all the numbers in that column? Thanks very much for this wonderful work. I am very grateful and sharing it with my crypto team
@martinhinneh16063 жыл бұрын
Thanks
@sandraeastman97472 жыл бұрын
Hi Paula, thank you for the spreadsheet. Is there an easy way to convert the incoming prices from Coingecko to Canadian? After adding my data I realized it was in USD. Darn it. I need to track my Canadian Crypto and also my USD crypto. I thought I would create two spreadsheets, one for CAD and one for USD. Thanks in advance
@afgninja99142 жыл бұрын
HI Paula, awesome work!! I am stuck in the excel refresh data it just says initialization data source failed update: (updated excel and it works) Can the data base be reflected in another currency as I am not using USD. Another question can it be customised (different colours and images?)
@football-planet222 жыл бұрын
I'm shocked about this sheet thank you so mush , one question please about adding 0.01 BTC does the sheet accept this
@xXxPhenom3 жыл бұрын
Amazing, you deserve more!
@PaulaWeb3andCrypto3 жыл бұрын
Wow, thank you!
@valorkitchen567 Жыл бұрын
Hello. Thank you for a quick spreadsheet. When I try to refresh all, I'm getting an error saying " Query 'Rurl' (Step 'Renamed Columns') is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combine. Has anyone else experienced this and if so, do you know how to fix it?
@phirewoman Жыл бұрын
Me too
@mfield431210 ай бұрын
@valorKitchen567 did you ever solve this problem? I seem to have the same issue
@bobbrown-rm6ej Жыл бұрын
Hi Paula, thank you for the videos and spreadsheet. All working okay, however I have made changes to the queries/connections to show a different currency. This is working fine for most part except for the 'Extra Coins' there seems to be a hardcoded vs_currencies that I'm unable to find and modify to show the extra coins correctly. Can you help me? please
@bobbrown-rm6ej Жыл бұрын
Please disregard, as I found it. cheers
@PaulaWeb3andCrypto Жыл бұрын
awesome, great to have someone that can find there way around it with easy, nice!!!
@sparktabernermusic2 жыл бұрын
Does this work for EURO too?
@barrysaunders47142 жыл бұрын
Keep getting this error when I do Refresh all: Query 'Rurl' (step 'Rename Columns' is accessing data source that have privacy levels which cannot be used together. Please rebuild the data combination. Also on the ticker I can only see two of the coins I entered from my transaction list. Barry
@wallylafferty11666 ай бұрын
Will we be able to add the Bitcoin ETF to our tracker, or is that not possible? The URL for the ETF on the New Coin worksheet doesn't appear to work.
@j.c76642 жыл бұрын
It´s amazing Paula. Nevertheless, when I update the prices, I get the following Excel error: "Query Rurl (Step Renamed Conlumns) is accessing data sources that have privacy levels which cannot be used together. Pleease rebuild this data combination. Important to note that I have changed nothing from the original file.
@PraiseTheLord95 Жыл бұрын
I just downloaded the file and am getting the same error. Trying to change privacy settings but nothing seems to work. May have to go back over formulas and programming to see where the connection is breaking. The code probably has to be fixed on the PowerQueryEditor. May be above my expertise as this is pretty complex.
@johnnyboy32932 жыл бұрын
Hi Paula! Correct me if I'm wrong but there is something wrong with the selling points. Let's say I buy 10 BTC and sell 20%, I would have to sell 2 BTC, but if I buy 10 more, my first selling point is now 4 BTC instead of 2. Is it normal? Is there a way to search for purchase date and not add what I bought after my first selling point? Thanks
@gamerx92463 жыл бұрын
Hi Paula, I have a quick question on how to see a untracked listing using coin market cap or how to pass the command of untracked listing in the excel, the default list shows active listing but I want tot find the untracked listing, please help asap. Thank you and have a great day
@DougWalters333 жыл бұрын
Hi Paula - just watched the video again. All very clear. Just 1 query about the initial capital entry. I started by depositing (on Kraken) the BTC & Eth I had mined. As you suggested, I will enter their GBP value as my Initial Capital. A couple of months later I deposited some GBP on Kraken, and then a month or so later, some GBP on Coinbase and eToro. Do I add these deposits to my Initial Capital?
@PaulaWeb3andCrypto3 жыл бұрын
Yes, put fiat in as initial capital
@slashhhh23852 жыл бұрын
Hello, it's a great tool, thanks. I have problem with refreshing data - especially private levels, what to choose? I see this "the element "Rurl" is trying to get access to source data on private levels" How to fix it? Thanks for reply.
@cryptokirbytrading69232 жыл бұрын
Direct messages👆
@cryptokirbytrading69232 жыл бұрын
Direct messages👆
@robertog26742 жыл бұрын
how do you add more columns in the transactions schedule? Every time I try to add or drag down I get the following "Excel found a problem with one or more cell reference"
@Brewfoo2 жыл бұрын
Also looking to figure out how add more columns in the transactions schedule. Anyone figure out how to correctly do this?
@peterk9233 жыл бұрын
Paula. The workbook has been great help however I have a problem with 1 coin showing with 2 graphs on the dash and the values being doubled. Ive combined all the coins transactions to a single transaction without any luck. I thought I might try to find the problem however I cant see the Calculation Sheet. Can you offer any advice?
@ryangrady52172 жыл бұрын
This is amazing Paula! I am using a Mac, and was already in the process of building my own. This has given me a really nice guide. Too bad I won't be able to use it myself! Question - I see there is a hidden sheet called "Calculations" which is referenced quite a bit on the Dashboard. I don't see this sheet in the hidden sheets list however, and it's not listed on the tabs. Any ideas how I could get that so I can see how the calculations are made?
@tristennajarian12572 жыл бұрын
I am also building my own and would love to see if there is a calculations sheet
@steveseiter3172 жыл бұрын
My Acquisition cost aren't adding up and I'm trying to validate how its calculated and cannot find the Calculations sheet....where/how can I look at this sheet. Thank you Paula!
@lindseyjones34452 жыл бұрын
Hey Ryan, I am on a mac and trying to get this to work, wondered how you got on?
@same40743 ай бұрын
Why is the currency set to the Euro! and how can we change it to the dollar? seems to be greyed out..
@sabudas76992 жыл бұрын
Which Version of excel it support ?
@trishulini2 жыл бұрын
Hi Paula.. Getting this message on refresh - Query 'Rurl" (step 'Renamed Columns') is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.
@MK-qs8sf3 жыл бұрын
Great content. I subscribe.
@PaulaWeb3andCrypto3 жыл бұрын
Welcome aboard!
@gregghasslerjr1293 Жыл бұрын
Hello. New to the worksheet. I am putting in all of my transactions. All of my purchases are in, but I do not understand how to put in past Sales of coins for the price I sold them at. So say I sold 2 ETH in 2017 for a profit of $150. How can I enter that in when the Exit strategy doesn’t allow me to put in a number that is exact for a past time frame. I want to be able to enter a past sales transaction without using the exit strategy form. Or learn how to enter one in the exit strategy form. Any help?
@dragonfly78863 жыл бұрын
WOW thank you very much this is amazing!
@PaulaWeb3andCrypto3 жыл бұрын
Glad you like it!
@irmski312 жыл бұрын
Thanks Paula. This is so cool. I already made one from your first video but I guess this is cute :).
@mxxx312 жыл бұрын
This is a great and useful tool. I am looking for a file that can create a cake of my holdings and rebalancing my portfolio using a refresh button. Any idea of how can I get one?
@aviationchris50913 жыл бұрын
Amazing tutorial! Thank you for sharing this with us. You mentioned how to enter in the transactions for purchasing, but what about the sales? If I was to sell coins, but not exit, how can I enter these transactions? how would you enter sales transactions and where? It's only allowing purchases, and the exist strategy is only when you want to take profit once it reaches a percentage.
@jscoobs10783 жыл бұрын
I was kind of looking for the same answer here. Curious, how we would enter if we had a token and just sold or traded for another. How do we enter just a withdrawal, not necessarily a profit. I used a negative(-) amount not sure if that's going to update correctly.
@XF4n4tiX2 жыл бұрын
@@jscoobs1078 Did you find the solution ? Same problem here, thanks
@XF4n4tiX2 жыл бұрын
Did you find the solution ? Same problem here. Thanks
@helvigs12 жыл бұрын
@@XF4n4tiX Leaving a comment in case you find a solution. Looking for the same here
@XF4n4tiX2 жыл бұрын
@@helvigs1 unfortunatly even if the excel is a lot of ork and very good, the section for sells is incorrect
@reeld992 жыл бұрын
when i double click to get dollars per coin it stays blank ?
@lakegirlroxy98522 жыл бұрын
Looks amazing however my excel is 2004 so it looks like I cannot use it?
@cryptokirbytrading69232 жыл бұрын
⬆️Questions can come in 👆
@SamvadSoul2 жыл бұрын
Hi Paula, Very nice excel portfolio. Can we convert currency as I am from India?
@osteopathieposthuma6455 Жыл бұрын
The currency in the workbook is $. Is it possible to change it in Euro?
@flowerroos8 ай бұрын
hi Paula, I've asked this question earlier, and never received a reply... I would like to know how I can change the currency from Dollar to Euro. When I follow the link at the description of the video to the Excel sheet, it shows information about the excel sheet and it says I should be able to change the currency, I just don't see where I can do this.
@PaulaWeb3andCrypto7 ай бұрын
this is on the set up page
@FaizAli-ng4dy2 жыл бұрын
The coins entered were not getting reflected. Checked calculations sheet the coins with other values are hard coded/manually entered there. Can you share the formula used to pickup the coins or can you check this issue?
@cryptokirbytrading69232 жыл бұрын
Direct messge👆
@copycatt25793 жыл бұрын
wow this is awesome. thank you. do you have any plans to release a google sheets version? everything doesnt copy over when uploaded to sheets.
@user-hw1iq2rf5d3 жыл бұрын
HeLpLiNe 👆👆🚀🚀🚀
@dcommissaris3 жыл бұрын
Thank you so much Paula and Simon, this spreadsheet is a gamechanger! One question... how is the acquisition cost calculated? After entering my transaction history, the acquisition cost on the dashboard is significantly more than the total purchases. Is this factoring additional costs or should these be the same? Thanks
@samfareed3 жыл бұрын
I have the same situation. Acquisition cost and resulting Investment values are noticeably higher than actuals. I had more coins than the Transaction entry table initially allowed so I inserted more rows. Not sure if that impacted other areas or name range/table calculation in the spreadsheet. I love the sheet and implementation by Paula, so hoping to get to the bottom of the discrepancy.
@PaulaWeb3andCrypto3 жыл бұрын
Yeps you are correct there was a bug on the sheet for the acquisition cost, this has now been fixed along with another bug where coins like shiba with a fraction of a cent cost were not being recognized. we have uploaded a new version. just copy and past your data from the last one and all should be good.
@PaulaWeb3andCrypto3 жыл бұрын
Yeps you are correct there was a bug on the sheet for the acquisition cost, this has now been fixed along with another bug where coins like shiba with a fraction of a cent cost were not being recognized. we have uploaded a new version. just copy and past your data from the last one and all should be good.
@dcommissaris3 жыл бұрын
@@PaulaWeb3andCrypto Thank you so much for fixing the bug. Everything is working great now!
@craigscofield44913 жыл бұрын
Hey Paula, Fantastic spreedsheat. I had started working on one myself but never this in depth. So glad I found your video. Also a quick question. I have been mining and have been getting a few coins for free, and I have sent them to my wallet, but would like to add them to my portfolio within your spreadsheet. How do I add them in as they cost me $0.00? I have temporarily add them in saying they cost me $0.0000001.
@cattuong25 Жыл бұрын
Hi Paula, thanks for the workbook. But I have a problem: after I refresh the data,there is a warning appears: " Initialization of the data source fail. Check the database server..." What do I do? Please help. Thanks.
@PaulaWeb3andCrypto Жыл бұрын
what version of excel are you using? its really hard to tell, you may be missing something on the install of excel. See here for more details learn.microsoft.com/en-us/answers/questions/183511/excel-for-microsoft-365-initialization-of-the-data
@cattuong25 Жыл бұрын
@@PaulaWeb3andCrypto Thanks for answering. I am using Office 2010. Do I have to use a specific version (ex: Office365)? Thanks again.
@PaulaWeb3andCrypto Жыл бұрын
@@cattuong25 Yes, you need excel 13 or higher
@christieboles2 жыл бұрын
When I have added all my transactions and my extra coins ID's etc, I hit refresh but my Dashboard shows each coin twice and doubles the Investment, Cost, and Token amounts. I am using Windows 10.