/biz/ - Business & Finance

>>27644819
Why not use Blockfolio?

ask Chainlink's Jason Parser

>>27644868
because that's mobile only and it wants a bunch of permissions I don't want to give it

>>27644819
nigga this isn't tech support try calling chandrupar he can help u out

>>27645047
I'm just probably missing something really basic but I don't have any idea how any of this works.

I thought you should be able to just copy paste it and it should work (and then edit the id for each coin) but that didn't happen. I tried another one from reddit and that does work but it doesn't have all of the coins in my portfolio so I don't want to use that

>>27644819
Did you forget to add the ImportJSON function to your script editor anon?

>>27645268
Yes but you have to define ImportJSON before you are able to invoke it. See step 5 here brah: https://www.upbuild.io/blog/lighthouse-reports-multiple-pages/

>>27644819
Looks like you need to add the function in the script editor first.

ImportJSON() isn't a native sheets function

https://medium.com/unly-org/how-to-consume-any-json-api-using-google-sheets-and-keep-it-up-to-date-automagically-fb6e94521abd

>>27645726
>>27646153
Thanks, I did that now but I get the error:

Exception: Request failed for https://api.coingecko.com returned code 429. Truncated server response: error code: 1015 (use muteHttpExceptions option to examine full response) (line 127).

>>27646703
429 is to many requests maybe you should not ask for 1000 shit coins at once

>>27646703
I though ImportJSON was a generic script but I may have been incorrect. Replace the script you added to the script editor with the code in step one of this documentation and you should be g2g brah: https://blog.coingecko.com/import-coingecko-cryptocurrency-data-into-google-sheets/

>>27647279
I didn't ask for 429. I used the default =importJSON("https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&ids=bitcoin","0.current_price") that they have on their website

I only have about 10 coins I am wanting to update and once every 30 secs or every minute is fine

>>27647478
wtf I'm retarded, how did I miss that lol. I updated it and it works now, thanks

I don't do any coding, but why was another importJSON code like 400 lines long while this one is only 30. What are all the extra lines for if they both perform similar functions?

Anyone know how to fix it from randomly not loading the data sometimes? I have a list of 10 shitcoin current prices in my google sheet and when I load it up for the first time I always get 3-4 that don't work (#VALUE! error) that I have to manually refresh the code a couple times. It's fucking annoying. My guess is it's some kind of rate limit, but is there any way around that?

>>27648042
Why do I have a weird feeling I'm doing some hedgie interns work here?

Anyone know how to set the refresh frequency or why it sometimes says error getting data?

>>27648346
Kek

>>27648346
if you fix this for me I'll tell you my list of my ultra rare gem shitcoins plz sirs. I've had my spreadsheet working for a month it's just this stupid rate limit shit driving me crazy