How To Import Rates from "Coinmarketcap" and any other DATA you would like!

in crypto •  7 years ago 

Any of you who would like to import live rate from any finance site, now can do so.
With Google drive excel sheet, you can import any table you like with one simple formula.

The formula you need to use is:
"=IMPORTHTML("https://coinmarketcap.com/","table",1)" in our example.

As the formula separates to 3 :

  1. Domain - from where.
  2. Table - what to take.
  3. 1 - which one of them to take.

That's can help any trader from any field - Crypto & Stocks to be updated with his portfolio.

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Congratulations @tomerdrey! You have completed some achievement on Steemit and have been rewarded with new badge(s) :

You published your First Post
You made your First Vote
You got a First Vote

Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here

If you no longer want to receive notifications, reply to this comment with the word STOP

By upvoting this notification, you can help all Steemit users. Learn how here!

Congratulations @tomerdrey! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 2 years!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Do not miss the last post from @steemitboard:

SteemitBoard Ranking update - A better rich list comparator
Vote for @Steemitboard as a witness to get one more award and increased upvotes!

Congratulations @tomerdrey! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 1 year!

Click here to view your Board

Support SteemitBoard's project! Vote for its witness and get one more award!