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!
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...
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
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 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.
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?
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
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.
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!
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
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
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.
@@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.
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.
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?
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.
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?
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?
@@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?