Import Live Cryptocurrency Price (And More) In Google Sheets & Schedule Auto Refresh

[@jiejenn]

PS: I have updated the source code to fetch values from nested fields like links.website, delta.year, etc. What else would you like to see. Comment below!

[@420brexit5]

Legend - great tutorial! For those struggling with the coins that have the same identifier, you need to use the ticker in the specific link.

[@jiejenn]

Thanks for the info.

[@cosmincalea3700]

how can i do that?

[@ImperialMustache]

which specific link, and which ticker

[@caleacosmin7927]

@@ImperialMustache didnt get u

[@ImperialMustache]

@@caleacosmin7927 where do. u need help with

[@BastienDesveaux]

I can get the datas updated but only when I run the function force_update manually. With the trigger, it doesn't update the datas automatically. And when I close the Apps script tab and re open it again, the function selected automatically go back to the getCoinInfo one. I guess I'm missing something...

[@jiejenn]

Makes sure in the function, you reference the correct cell.

[@Rishancr1365]

Kesalahan(eror) Exception: You do not have permission to call setValue (baris 52). It makes this notification when i following 100% the same steps annd set up as you do in the video for the =force_update() can you help me?

[@dennispaul8510]

your cell, that is referenced in the force_update code, must be the same as the cell where your timestamp in the sheet is.

[@WarrMachine]

Worked perfectly thanks!

[@johnnymulgrew6424]

Good morning, I am wondering how I can get a certain coin that may have the same name as others. i.e. btc will bring in bitcoin but the coin I am wanting is called LANDWOLF and there are multiple coins that go by the same name. Is there any way to get the exact coin imported that I want. Thank you for your help

[@johnnymulgrew6424]

could there maybe be a way to connect URL instead of the name

[@jiejenn]

look me look into it. I don't even know multiple coins can have the same name.

[@cosmincalea3700]

@@jiejenn yeah its true. have 2 coins with same name symbol IMX and ML

[@ImperialMustache]

any idea meanwhile?

[@nazar_zen]

@@jiejenn Hi, did you have a chance to solve this?

[@karlmdennis]

Cheers for this! I managed to knock up a monitoring sheet in no time at all. Thanks!

[@jiejenn]

Good to hear!

[@iHyperTV]

God bless you my dear. it was very helpful

[@jiejenn]

Glad to hear!

[@henkvinck888]

Good afternoon, I have set everything as through the video. Everything works so far however I am not getting any crypto data in my sheet. Time also work fine and the refresh is also good no errors in my code GS. Now I do not know what goes wrong here. Can you find or indicate a solution. Thank you very much for your answer

[@jiejenn]

Hard to tell without looking your set up. Perhaps your project is not authenticated? That's my only guess. Otherwise there may be a typo in the function somewhere.

[@jiejenn]

@@diegocoolen7057 user-agent is just telling the service what browser wthr request is coming from, you can change to anything you want. I'm fact, you can ommit user-agent it would still work.

[@jojosao]

Auto Refresh is showing many data errors. Help

[@technologyforall539]

how to keep date and time updated as well? refresh doesnt help

[@jiejenn]

Can you be more specific? Maybe give an example.

[@MuhammadHassan-d9t5j]

I added delta.hour and delta.month, however it is not fetching the data

[@jiejenn]

I see. For delta.month, because it has two layers, the function need to be modified to handle those fields. I will look into when I get a chance.

[@dogbear_]

Awesome video man, thank you for uploading this

[@jiejenn]

👍

[@killerishak]

Hello, first of all thank you very much for this video. I have a problem, the DATA refresh is only work manually and when I modify the code (when I add a space for example), the automatic refresh is not working, I have done the maneuver several times and meticulously but nothing happens, however, the cell "B2" to indicate the date and time of the refresh it is refreshed every minute, but not the prices. However, the refresh function doesn't indicate any error rate (0%). Note: When I execute the GetCoinInfo code, I also get the error code 500, as others in the comments. The code with force_update works without error.

[@jiejenn]

Error 500 is server error, so most likely you have a typo somewhere in your code.

[@killerishak]

@@jiejenn Thanks for your feedback. I only changed the API key in the code.

[@scroopmd6306]

@@jiejenn Thanks for the great tutorial. I also have the same problem and will not abdate automaticly as it give me the same 500 error. and i copied the same code and change the API only.

[@killerishak]

@@scroopmd6306 I still have the problem on my side, let me know if you find a solution.

[@AliceStormArt]

I also have the same problem error 500

[@vitaliiprokopenko9307]

Hey, I'm facing a problem that some token prices are not event displayed, and some of them are displayed incorrectly, is there any way to fix that manually? thanks!

[@jiejenn]

I will look into it.

[@vitaliiprokopenko9307]

@@jiejenn for example price for (STRK "Starknet token" is different) and for SUI or ALT doesn't even display :(

[@kommunitasnet]

Nice Job Bro, Thanks

[@jiejenn]

👍

[@jonathanhalim8612]

Why the source code link said page not found?

[@jiejenn]

It should be live. Check again wp.me/payCAw-1mQ

[@Jamie23piggy]

How do you differentiate same tickers but two different coins? For example both Jupiter and Jupiter Project using JUP but it defaults to Jupiter Project.

[@jiejenn]

I'm not sure to be honest.

[@revified]

use the ticker in the link

[@basedgod3703]

@@revified what do you mean by use the ticker in the link? i am also struggling with the duplicate ticker issue.

[@adanj8342]

Hi I am using brave browser, will that be an issue with receiving the data or, do i need use firefox javascript function too work

[@jiejenn]

Shouldn't matter. You can use almost all browsers except IE.

[@lofinights9583]

Hi, greatly appreciated for the information. Got stuck with Apps Script giving me an error "Exception: Request failed for... returned code 500..." Any idea what went wrong?

[@jiejenn]

Hard to tell without looking at your script. My guess is probably the header. Not sure.

[@macrobody]

500 Internal Server Error We had a problem with our server. Try again later. I have the same problem and I got this from the docs. Did you manage to get it working?

[@WaqasKhan-pc6eu]

Hi Jie, I came across your channel, very informative videos. I have a question, can you guide me how to extract historical volume of top 100 coins on a daily or hourly basis?

[@jiejenn]

You can use the coins/list method and sort by rank.

[@seannn90]

Awesome video! Thank you, I implemented this and it works, except for auto refresh. I created a trigger to refresh every minute: doesn't work I created a trigger to refresh every time I open the document: it works. Any idea what I could be doing wrong for the time-based trigger? I did select the correct function. Cheers.

[@jiejenn]

Hard to tell the issue without looking at your setup, my guess is probably a cell reference is off somewhere.

[@seannn90]

@@jiejenn Thank you!

[@laurensdewitte9083]

Very nice video, Thank you very much! I have one question, the force update works since it shows no errors and changes the timestamp every minute but the pulled values don't change, any idea on how to fix that? thanks in advance

[@jiejenn]

Hard to tell without looking at your set up.

[@yosoymemetronic7751]

Do you have a tutorial about Forex? i need real time dollar index, canadian dollar index, japanese yen index, etc in google sheets

[@jiejenn]

I don't unfortunately.

[@diegov555]

Hey, Jie! Thanks for your video! Please, can you help me to sort a problem I'm facing, please? When trying to run the formula "=force_update()", I'm receiving the following meesage: "Exception: You do not have permission to call setValue (line 52)." How can I get around this situation? In addition to this, my script isn't updating automatically even after configuring everything accourdingly. Can anyone help me with this?

[@jiejenn]

That means you didn't provide the correct permission scope when you authorize the app. Makes sure you create the project within your Google Sheets file.

[@ImperialMustache]

Do you have also wrong name output? here is the solution try to put an "_" underline before the coin identifier, if its still the wrong one put another underline "__" : example "ML" = Market Lab, "_ML" = Mintlayer

[@jiejenn]

Just tested, I stand correct.

[@chadofafrica]

How would you use this code for a mac book running MacOS, Big Sur version 11.7.10 and also using a brave browser?

[@jiejenn]

The instructions should be the same regardless the OS or browser.

[@devondoyle8942]

Does this script work on Google Chrome? All my data is blank

[@jiejenn]

Not sure. You will have to try it on your own.

[@devondoyle8942]

@@jiejenn I'm using Chrome. All my data came back blank. const headers = { 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:123.0) Gecko/20100101 Firefox/123.0', I don't see Chrome here. Does that matter?

[@devondoyle8942]

Update: The fields are case sensitive. IE - Name should be "name"

[@scroopmd6306]

@@devondoyle8942 does it work with you in chrome browser? i have to update the sheet manually .

[@secretsoffireband]

Yes it does

[@8brands]

this is so hard for us normies

[@SleepyPlug420]

you are a boss

[@jiejenn]

Thanks for the comment.

[@thangnguyenduc1040]

Thank you but it works not steadily.

[@devenderpathania1646]

tHANK YOU!

[@jiejenn]

👍