How To Import LIVE data to EXCEL?

in improt •  7 years ago  (edited)


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.


▶️ DTube
▶️ IPFS
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!