Import Cryptocurrency Price In Real Time In Google Sheets

30 gedachten over “Import Cryptocurrency Price In Real Time In Google Sheets”

1. I made a follow up video to address some of the limitations were brought to my attention 1) trigger didn't update the price, 2) how to pull the rest of information from CoinMarketCap currency page
   Video Link: https://youtu.be/LC00b7TYVQc

   Also, depending on your region settings, for U.S. the formula separator is a comma (,), but for some of the countries (European for example), the formula separator is a semi-colon (;).

2. 57k 😢

3. Can you help me to extract data token from alcor exchange for wax tokens. Please

4. God bless u, thx a lot!!!😘

5. does this only works for cmc?

6. Hello man.
   Everything clear and great but I don't see any update that was mentioned in the video. It is not working

7. TY !

8. is there a way to log BTC price at a specific time in the day? (say 12am)

9. Ok so I watched more of your videos, which are great BTW, and I had the same issue of the text to number value as everyone has commented, and so on one of your videos you issued a free spreadsheet which I got, and then copied the code from the extract just the number cell, changing the cell to my first bitcoin cell, which for me was B6, and as I am useless at excel, and even after reading 20 times, couldn't get the substitute thing to work to change the dollar column text to a number to multiply, I have just copied and pasted this and then created my column to multiply my holdings, by the current price as a number. So for everyone, here is what I pasted =SUBSTITUTE(SUBSTITUTE(B6,"$",""),"%","") hope that's ok to put here 🙂 Please keep doing more videos, I'm really getting into this a lot now. Thank you.

10. Thank you mate

11. Awesome, thanks a lot for sharing your knowledge 😉

12. thanks bro!!

13. Hi – Sorry for the noob question – But the result is text, which I cant use in an equation. How do I convert it into a number?

14. this is just brilliant. Now when i the currency name I get the price, but in the cell below the price I seems to have a random figure in it, anyone know what this is please and how to get rid

15. Hey thanks for info, code works fine, but it adds a column beyond with 24h volume numbers, although i did everything as you did, any suggestions how to get rid of it?

16. How can I get the price in GBP?

17. Great video. I have a small problem. When I created a code, I've got a value and automatically below another value like 0.0353. I can't delete that automatically generated value. Also, if I delete a row i got #REF in btc code area and it says "Array result was not expanded because it would overwrite data in B4." I don't understand where is the problem.

18. nice but i wanna se only currency value, not 24h Volume / Market Cap below the price. How fix tha?

19. Do you know how to get the close price?

20. thx very much bu showm th e market cap 24h vilume how to hide

21. I have two numbers that display for me. The correct bitcoin price in your cell C5. But a second number populates below automatically in your cell D5. How can we fix that so the second number doesn't display automatically in D5?

22. How about change percent ?

23. it's not work now, can you update the formula? please <3

24. It's just amazing to learn crypto industry about rising and down 0:45 fall of this industry

25. Hi. Can you update it for 2023, seems it does not work. Also can you show how to get result in numbers not in text or currency, Thank you.,

26. Hi there. I`ve managed to to do it, but im getting some array results too below each listed price. How do I get rid of them?

27. I have tried more & more. But I can't do it yet. please help me!!!

28. I need price number version. Because I work for math

29. Thank you so much. Excellent video.

30. i'm using google sheet and i copied paste the formula exact like you but i got this msg:
    Error Imported content is empty.

Reacties zijn gesloten.