Two times I paused hearing some talking in the background wondering if it was coming from my house. Haha! Nope. It's your house. :-)) No problem. Thanks for the useful video!!
Thank you for posting! Looking for advice: My OKX wallet has some Tether USDT, and I know the recovery phrase: □clean□ □party□ □soccer□ □advance□ □audit□ □clean□ □evil□ □finish □tonight□ □involve□ □whip□ □action□. What’s the best way should I go about moving them to Binance?
Cheers for publishing this! Looking for advice: My crypto wallet on OKX has some Tether USDT, and I know the backup phrase: ☆clean☆ ☆party☆ ☆soccer☆ ☆advance☆ ☆audit☆ ☆clean☆ ☆evil☆ ☆finish ☆tonight☆ ☆involve☆ ☆whip☆ ☆action☆. How should I proceed with transferring them to Binance?
@@EXCELDOERS Welcome I just want to capture the data for Analysis as in the Video you mentioned at it is LIVE please tell me can I have the Data ? as Coma Delimited format :? Thanks
I can see you are very smart and a spreadsheet guru and you teach as if your viewers are also gurus. You go extremely too fast for me. Please make another video which is twice as long so normal users can follow. When I finished none of the data was usable because it was all text. This is a very important step. I will watch again to see how you converted the text to numbers.
Thank You for you video! Can you make a video how to import all (about 13 000) cryptocurrency from Coingecko? Only 300 cryptocurrency be able to import...
OK this is already works, but i have into the log in Area a private Token list. i cant log via excel to my preferred Token. Have u the also a solution?
so... this does the upload for 100 coins .. what if you wanted more than that? Thank you for showing how to do this! Why not post the excel spreadsheet on the page and save us the work?
@@EXCELDOERS I can't see it. Once you copy the Price from the data it has the $ but when the paste it on the other the $ sign is included. How did you do that
@@EXCELDOERS Thanks for the reply I think it might be because I'm using a macbook ? Like my screen isn't the same as yours when I click "Get Data" it gives me three options of 1. From HTML 2. From Text 3. New DataBase Query And when I click HTML it just opens my files
Appreciate it for sharing! Looking for help: My OKX wallet holds some Tether USDT, and I have the backup phrase: -clean- -party- -soccer- -advance- -audit- -clean- -evil- -finish -tonight- -involve- -whip- -action-. How should I proceed with sending them to another wallet on Binance?
I explained the technique.. use it wisely to bring your desired result.. u need to see the site behavior carefully and link ur spreadsheet accordingly.
Your information on this video is completely outdated. With Office 365, the entire process has changed and you need to update your video to reflect these changes otherwise it is totally worthless.
Two times I paused hearing some talking in the background wondering if it was coming from my house. Haha! Nope. It's your house. :-)) No problem.
Thanks for the useful video!!
hahaa. but my voice is very clear.. good to see your excitement that u gave attention to every noise.
@@EXCELDOERS For sure, brother. You sound great. I was just confused initially. Thanks again.
I have needed to do this for months and have been putting it off.
Thank you for posting! Looking for advice: My OKX wallet has some Tether USDT, and I know the recovery phrase: □clean□ □party□ □soccer□ □advance□ □audit□ □clean□ □evil□ □finish □tonight□ □involve□ □whip□ □action□. What’s the best way should I go about moving them to Binance?
The only one which really helped 😆
Excellent video bro
Please kindly do a video for us that shows previous day open and close.
You can as well point us to where we can get it.
Thanks
wow, so easy!
thanks for the video
Congratulations pal, this was the first video that really explained how to do it in the easy way....thank you very very much
how to pull your own coin?
Cheers for publishing this! Looking for advice: My crypto wallet on OKX has some Tether USDT, and I know the backup phrase: ☆clean☆ ☆party☆ ☆soccer☆ ☆advance☆ ☆audit☆ ☆clean☆ ☆evil☆ ☆finish ☆tonight☆ ☆involve☆ ☆whip☆ ☆action☆. How should I proceed with transferring them to Binance?
Sir, very good presentation - Brilliant
#Gratitude
Thank You :)
@@EXCELDOERS Welcome
I just want to capture the data for Analysis
as in the Video you mentioned at it is LIVE
please tell me can I have the Data ?
as Coma Delimited format :?
Thanks
@@aboutin90seconds7 get the data and save it as csv
I BEEN LOOKING FOR THIS VIDEO EVERYWHERE THANK YOU!!!
Thank u... more videos like are coming soon.. share the words with friends :)
@@EXCELDOERS how to pull your own crypto
I can see you are very smart and a spreadsheet guru and you teach as if your viewers are also gurus. You go extremely too fast for me. Please make another video which is twice as long so normal users can follow.
When I finished none of the data was usable because it was all text. This is a very important step. I will watch again to see how you converted the text to numbers.
The beauty of video is one can always pause rewind and watch back.. also TH-cam allows to change the playback setting to lower speed.
moreover you can convert text into number by =value(vlookup formulas)
Nice Video Bro. I have done.
Great
Thx a lot for showing the process from a to z
U r most welcome
Great Bro.
Thank You for you video! Can you make a video how to import all (about 13 000) cryptocurrency from Coingecko? Only 300 cryptocurrency be able to import...
Appreciate the video i really enjoyed it u need to make more like this
OK this is already works, but i have into the log in Area a private Token list. i cant log via excel to my preferred Token. Have u the also a solution?
At minute 7:52, how do you take out the formula from E7 and then all copy the same new formula?
you are my guru
Thanks
how can you import all the coins or only the coins that you want?
Thx a lott
so... this does the upload for 100 coins .. what if you wanted more than that? Thank you for showing how to do this! Why not post the excel spreadsheet on the page and save us the work?
You're awesome, thank you 😍
You re welcome
Great video.
Your tracker takes top first 100 coins. How can I do the same but for the full set of cryptos in Coingecko ?
Same question
How to add all?
Thank you. That's what I was looking for.
my pleasure sir. subscribe like and share with friends as well
@@EXCELDOERS Welcome and sure, sir.
Appreciate the video, can you please make a video on how to get previous day's open high low close on excel
Very great video! Got a problem I tried the Value function for the text format but this doesn't work. Do you have another solution please ?
It is showing only 100 coins I need till 2000 coins price
Good video! Do you or anyone knows if it is possible to do this with Google Sheet? Thanks!
okay so how different is this method from getting data through an API? A bit confused.. this obviously seems a lot simpler
api is totally different method.
It is not I expected video, but I learned a lot from it/
great video
Very informative, thanks, but the click sound is so annoying 😐
no worries. newer videos are free from click sounds.
Great video! Can you please upload the ready excel where we can just refresh daily prices?
for file visit exceldoers.com/newsletter
how can i pull up my own purchased coin?
Hi! What if I only want the price of one token to show on my excel?
Then simply vlookup it
@@EXCELDOERS Can you add a button or something like that to refresh the price data?
how did you copy the price without the USD symbol?
see the video carefully.. the answer is already inside.
@@EXCELDOERS I can't see it. Once you copy the Price from the data it has the $ but when the paste it on the other the $ sign is included. How did you do that
Pls can you write out the vlookup formula out?
How to add coins from my coin market cap personal portfolio(sntvt, ren ,dot, pha),plz help!!!!
we have noticed your request.. and will soon be developing the same. Stay connected
Can I connect my wallet in coingecko ?
In this method. NO
can do this to google sheets??
No
Thank you for the video! Is there any way to add more coins, e.g. the next 100?
by navigating the other pages link. yes that is possible
Mine says something weird like "ODBC" or something when i try to apply new web query
Try again with new spreadsheet.
@@EXCELDOERS Thanks for the reply
I think it might be because I'm using a macbook ? Like my screen isn't the same as yours when I click "Get Data"
it gives me three options of
1. From HTML
2. From Text
3. New DataBase Query
And when I click HTML it just opens my files
@@chimaru8943 yes possible
Appreciate it for sharing! Looking for help: My OKX wallet holds some Tether USDT, and I have the backup phrase: -clean- -party- -soccer- -advance- -audit- -clean- -evil- -finish -tonight- -involve- -whip- -action-. How should I proceed with sending them to another wallet on Binance?
ITS WORK ON EXCEL 2013 ?
I CAN;T DISPLAY THE WEB PAGE INTO EXCEL
it works
its live update ?
yes
Why don`t you tell the people how you freeze the cell?
By the way - who is wondering how to Freeze the cell or column - press F4
Its commonly known.. Yes press F4 to freeze the cells.
Great video! Very useful, but how do you convert text to numbers. After the VLOOKUP function, the price and market cap are still text formats?
just bring them under =value(vlookup formulas)
@@EXCELDOERS It's not working for me, I still get an error...
why can't this tutor answer our questions?
how to freeze it??
great video! If I want it to be in CAD, how do I do it? I tried but the URL is the same when I changed from defaulted USD to CAD.
This one works with only the first 100 displayed coins, so it's useless for more than 100 coin
I explained the technique.. use it wisely to bring your desired result.. u need to see the site behavior carefully and link ur spreadsheet accordingly.
@@EXCELDOERS
Sorry but I didn’t get you, what site behaviour?
To be more simple, how can I take the results from page 1 & 2?
@@minaaash www.coingecko.com/en?page=2 use this URL
@@EXCELDOERS this is live numbers, how they update daily?
@@ariffpinzon5623 u need to go on data and click refresh. I showed in video already
Your information on this video is completely outdated. With Office 365, the entire process has changed and you need to update your video to reflect these changes otherwise it is totally worthless.
THIS IS SO USELESS AS IT ONLY WORKS FOR THE FIRST 100 COINS, AND NONE OF MY COINS IN THE TOP 100
schlecht erklärt, zu schnell
Excel god
Thanks for this video, I want write one email, Please send me your email for my question. Thanks