PS. to all my subscribers, you can request content for my channel here: link.tariosultan.com/request
@votrung25128 ай бұрын
do you have updated version, Cryptofinance was adopted by Kraken already
@oruumeh15233 жыл бұрын
Wow!!! I have been learning how to pool real time crypto prices to google sheet for the past 7months and with little success. I am so lucky to have watched your video. You are the greatest and the best video so far I have followed; you were so efficient and so precise! I would like to Thank you so much. You are a blessing to mankind. May God bless you. Thanks again
@tariosultan3 жыл бұрын
You're very welcome!
@paulspears48152 жыл бұрын
Good Job. I was already working on doing this same thing but yours is much further along so I am using it now.
@tariosultan2 жыл бұрын
Nice work!
@edv88192 жыл бұрын
Thank you for taking the time to make this video!
@tariosultan2 жыл бұрын
Most welcome Ed!
@Anero492 жыл бұрын
your a genius bro thank you so much
@tariosultan2 жыл бұрын
Glad to help
@snipestream13223 жыл бұрын
amazing work, liked and subscribed !
@tariosultan3 жыл бұрын
Thank you! Much appreciated!
@sallombardonyc2 жыл бұрын
Hi Tario, thanks for putting out such great content such as this video. I have a few questions regarding the Crypto Portfolio Tracker that I hope you can clarify. 1. How do we add a SELL function? Ideally, this would be within the Google form and would allow us to keep track of our current holdings BUYs and SELLs. 2. Similarly, how would we add a TRANSFER IN & TRANSFER OUT function to keep track of when we move coins across wallets and document the associated gas fees. 3. Last question, how do we connect to a free API such as CoinMarketCap, the current API you share in this video needs a paid subscription.
@japboy200810 ай бұрын
Great tutorial! Thank you for sharing!
@TheAramian2 жыл бұрын
Thank you Sultan 👍👍👍
@tariosultan2 жыл бұрын
My pleasure
@bv_benhur20872 жыл бұрын
Thanks my man, what a great tutorial.
@tariosultan2 жыл бұрын
You're welcome!
@CarmeloSerrano_3 жыл бұрын
Wow... Tario, you just simplified everything for tracking crypto! Thank you so much!
@tariosultan3 жыл бұрын
My pleasure!
@PepiCzech2 жыл бұрын
Hi, thanks for the video! Great stuff! I have a question. I followed your steps and created my portfolio, it was working great but the next day all of the fields are showing Error! I refreshed all data but it doesn't help. Do you have any suggestion? Thanks!
@kara.mcmaster2 жыл бұрын
Crazy valuable. Thanks so much!
@tariosultan2 жыл бұрын
Most welcome Kara!
@andreapastor23806 ай бұрын
thank you for your video!
@thiagofvm3 жыл бұрын
Hey Tario, thanks a lot for this! Super well made and explained! I do have one quick question: how about when you sell parts of your holdings? Where do you input that and how do you track it properly? I find it quite complex once you start trading frequently to actually not get all your data mixed up. Cheers!
@tariosultan3 жыл бұрын
You can create a new google form, or add to the existing form a dropdown menu with options of "BUY" & "SELL", this way you can filter out buy and sell transactions.
@shally19983 жыл бұрын
Hey Thiago and Tario, did you manage to implement the sell side of the platform? If so, could you please explain what you did? I have added the buy/sell option to the form, but Im not sure how to adapt the current holdings to take into account a sell transaction, any help would be appreciated!
@4L3224NDR03 жыл бұрын
I have the same question here... i've created my own Google Sheet Cripto Tracker, but I don't know how to manage when I sell coins :(
@maxsood31092 жыл бұрын
@@tariosultan exactly. Without having a SELL field this sheet really is useless unless you are a long time HODLER
@darrenphillips81582 жыл бұрын
Hi Tario, please do a video that includes the selling option, I really want to create your tracker but without the selling being tracked it just will not be 100%
@luisllerena51173 жыл бұрын
You are an actual badass Tario 🤙🏼
@tariosultan3 жыл бұрын
Thank you Luis!
@malanaidoo3687 Жыл бұрын
Thank you so much
@tariosultan Жыл бұрын
You're most welcome
@k.jk92873 жыл бұрын
Thank you for your sharing It's very clear and awesome.
@tariosultan3 жыл бұрын
You’re very welcome K.
@mmmfosters3 жыл бұрын
Fantastic, clear tutorial. Thank you! One thing I'm still struggling with is how to capture sales and profits in google sheets...
@tariosultan3 жыл бұрын
You’re welcome Timothy. Stay tuned, I will do some more Gsheets videos in the near future.
@danjo27142 жыл бұрын
@@tariosultan looking forward to it!
@UpUpDnDnLtRtLtRtBAStart2 жыл бұрын
Very solid
@tariosultan2 жыл бұрын
Thank you!
@dedennugraha49393 жыл бұрын
Thank you for this tutorial, amazing !!!!
@tariosultan3 жыл бұрын
You’re welcome Deden!
@kadinmccallummusic52102 жыл бұрын
I took the time to make this spreadsheet and loved it. however my data stopped loading and I now get an ERROR signal. I don't want to let all this hard work go to waste, what should I do?
@alextownsend94372 жыл бұрын
Amazing looking sheet! However, I'm having a similar issue to others - the replies are hidden so not sure if there is an easy solution - my sheet now says ERROR everywhere, saying I need to change my subscription. Can I still use a free version in some way?
@boonladaamarutanonda77433 жыл бұрын
Thank you for the video..it is so nice although it is al little too fast for me but I will keep watching again..by the way..if I want to sell some coin what I should do..thank you
@tariosultan3 жыл бұрын
You're welcome Boonlada, feel free to drop your questions if you get confused. :)
@MrDpl0963 жыл бұрын
how would you go about figuring in transaction fees to get a more accurate final profit/loss picture? Outstanding video - ty
@tariosultan3 жыл бұрын
You can subtract the transaction fee by only calculating the final amount or creating another field to capture all the transaction fees.
@mahmouddiab51873 жыл бұрын
You're awesome!
@tariosultan3 жыл бұрын
Thank you!
@mahmouddiab51873 жыл бұрын
@@tariosultan Bro, the sheet stopped working. do we have any alternatives for cryptofinance functions?
@heawiechow2 жыл бұрын
Awesome content bro! Would be great if you added the sell column into the sheet so it is easier to track all your transaction!
@tariosultan2 жыл бұрын
Thank you bro! I will see what I can do in the near future.
@arthurk88082 жыл бұрын
@@tariosultan Hey man thank you so much for the video- was super helpful! Is there any chance you can do another video with the sell component added to the sheet? Thanks and all the best
@aliciagomez786 Жыл бұрын
Hey, thanks for ur content , video looks good but do you think you can do a free version of this?? where you only use features in the free plan of cryptowatch
@CarlosRodriguez-vg2ob3 жыл бұрын
This is a great video. i have a question, in regards to those tickers like mononoke-inu and other meme tokens that are not listed on cryptofinance but they are on coinmarketcap, is there a way to add the refresh feature so i can force the update?
@lukesmith32882 жыл бұрын
Hey, great vid! I've been trying to make a slightly more advanced tracker to record the performance of coins when there are other trading pair buys and sells e.g. ETH/BTC but I've found that it's pretty hard. I can't find a single KZbin on it actually, maybe you could consider it for a future video?
@tariosultan2 жыл бұрын
Sure thing! I will play around with it and potentially make a future updated video. Stay tuned!
@simd592 жыл бұрын
Thanks bro. I had to pay but it's ok. Do you use the same for STAKING / FARMING ?
@GamersAhoy2 жыл бұрын
Hey man what keys are you typing when putting ticker + exchange ticker, it magically appears... but you don't say what you just did to show that
@shally19983 жыл бұрын
Tario, you're a legend for making this video, thank you! I have one question: say I wanted to do a bulk upload of new positions to form the initial portfolio, is there a way to automate multiple form submissions into the spreadsheet without manually inputting data into a form and submitting individually? Or is there a way to adapt the google form to add multiple transactions at a time to the google sheet? Cheers :)
@tariosultan3 жыл бұрын
You can insert/upload the new position onto the google sheet, doesn't have to go through form.
@jamescampbell22542 жыл бұрын
Hey Tario, can you pull 52 week high and low data from this plugin? Cheers!
@bv_benhur20872 жыл бұрын
I have a question. Why the tracker doesn't allow me to see anything after a few click's on the check box? It is showing me an error with the message "This information is available only for standard Cryptofinance subscribers." How can I fix this?
@Tdg_Ralph2 жыл бұрын
I've done everything like in the video, but the prices and all the other data that's attached to the price data won't show, it keeps "loading" but nothing happens eventually.
@miltonnuevo9722 жыл бұрын
Hi Tario! Congrats for the awesome spreadsheet! You gave me lots of ideas by linking a form to the sheet! I had a simple question: when I copy your spreadsheet, I automatically copy the form linked to it. It shows up in my google forms list. I tried to make a spreadsheet myself, linked to a form. But when I share it, the person receiving it doesn't get the linked form. Just the spreadsheet. What could I be doing wrong?
@tariosultan2 жыл бұрын
I don't think you can share a sheet and automatically attach a form to it. Give this a watch: kzbin.info/www/bejne/jqmYkoNrgrGor80 This is how I share a template that has sheet + form.
@inattadhsa2 жыл бұрын
great tracker - followed all the instructions inc setting up the account but still getting an error when pulling the price - its just not working. Checked script, re ran it, checked api key etc - same problem. Cell says loading and error loading data on the tool tip - Just odd - please help
@whosagooner3 жыл бұрын
Is it possible to use this sheet with a mix of FIAT currencies? I live in UK and bought most crypto in GBP but have a couple in USD.
@tariosultan3 жыл бұрын
Absolutely! Try google finance formula, it works great.
@pip54613 жыл бұрын
Interesting, but spreadsheets are my Achilles Heel, and I'm not too sure that I want all my listings stored on Google... (not that I have anything to hide or distrust Google). Hackers on the other hand, like to safe crack... Aren't most of the trades already stored on the various exchanges?
@tariosultan3 жыл бұрын
If you think Gsheets aren't safe, simply go with some other tracker tool. This video is more for those who really into Gsheets.
@makerepetuha-pilimai91303 жыл бұрын
Bro thank you so much for this tutorial, I took the time (3-4 hrs) and went through step by step and rebuilt from scratch, during the process formulas were working, then I noticed throughout and at the end of the entire process most of the formulas are no longer working all I am getting are #ERROR messages across my spreadsheet and on dashboard also, any insight as to why and how I can resolve this is greatly appreciated?
@tariosultan3 жыл бұрын
In the video description, I have a section called "IMPORTANT NOTE", give it a read.
@makerepetuha-pilimai91303 жыл бұрын
@@tariosultan Hello again, yes I saw you make that comment when someone else had a similar problem, my query is that it is only the second day so I should still have full access if the trial period is 7 days free right? Also I have less than 10 coins so it should still be within the 100 per month ratio either way, am I correct?
@makerepetuha-pilimai91303 жыл бұрын
Any further info regarding my last comment please?? Thanks in advance for all support regarding this..
@areebraja62302 жыл бұрын
Hey, were you able to figure out a solution to your problem? I had the same problem. For me the #ERROR occured while I was still making the spreadsheet. The way I "fixed" it was by generating new API key everytime I got the error and pasting it in the spreadsheet. But it is getting annoying because every 2nd "refresh" gives me the error along the whole spreadsheet...But one error that is not going away at all is under the 7D Price. I am not getting the lines. Even through I have tried to rewrite and even copy the formula from Tairo's spreadsheet.
@yafimuhammad4804 Жыл бұрын
hey i use cryptofinance but it said something like "this is a paid function: for the cryptofinance liva price data any ideas?
@edmo-l4d3 жыл бұрын
Thank you for this tutorial. I had this setup but it stopped working for me yesterday. Is it still pulling data for you?
@tariosultan3 жыл бұрын
In the video description, I have a section called "IMPORTANT NOTE", give it a read.
@edmo-l4d3 жыл бұрын
@@tariosultan That explains it! I like this service and I think I will pay for a month. The one problem I seem to be having is data not being pulled back consistently and getting an error message in cells but if it doesn't improve I will look for alternatives. Seems like you are from Toronto. Lived there for 13 years and miss it a lot! Thank you for making a great tutorial.
@tariosultan3 жыл бұрын
No worries, glad it helped! You might want to click on the refresh checkbox if you see/get error message. Enjoy the tracker! PS. I'm based in Vancouver.
@edmo-l4d3 жыл бұрын
@@tariosultan Vancouver is great too. My wife and I used to live in False Creek. Our Bitcoin dream is to own a place in Kitsilano. Maybe someday!
@mahmoudabdelgelil31913 жыл бұрын
thanks, bro, can you make a video about who we can make sheet-like block folio or ftx app which make the same thing but I tried it and it has a lot of lag, what i mean we can sync data with exchanges by and you can compine what blockfolio do
@meikehd3 жыл бұрын
i have copy your docs and it works but when i will use it whit a other format and i copy/pasted te formule to a other docs or somthing (whit the same formules) it didnt work. did you now how this works?
@tariosultan3 жыл бұрын
That might be that you didn't install the plugin to the new sheet.
@AdrianFlude6 ай бұрын
Great content, but needs an update with new data sources. Thanks.
@Zack829993 жыл бұрын
when i refresh it comes up with error everywhere
@ritzfit3693 жыл бұрын
If a token isn't recognized by the plugin then just fill out the sheet manually?
@elfo22853 жыл бұрын
Hi, Do you have a version that take into account the sells of the crypto (trading) ?
@tobe45142 жыл бұрын
Hi Tario, is it possible to shut off the helium miner while sync process?
@tariosultan2 жыл бұрын
Not ideal. But won’t be end of the world.
@tobe45142 жыл бұрын
@@tariosultan will the sync stop and go on later, or will it start from the beginning again? Greetings from Germany
@tariosultan2 жыл бұрын
It will pick up from where it left off.
@paulmess18932 жыл бұрын
great video, but i keep getting stuck when i get this message, trying to run cryptowatch: This app is blocked This app tried to access sensitive info in your Google Account. To keep your account safe, Google blocked this access.
@tariosultan2 жыл бұрын
Give this a shot: kzbin.info/www/bejne/sGmkiYevarV7lbc
@souvikghosh50873 жыл бұрын
What will be time lag ?
@mgustynugroho3 жыл бұрын
can it used in android ?
@ss2345hvj Жыл бұрын
is that script safe??
@sandorhatvany8392 жыл бұрын
Lol, I can't even figure out how to do the refresh data because you don't show the steps. you just copy pasted it.