Bitcoin Forum
April 20, 2024, 12:30:28 AM *
News: Latest Bitcoin Core release: 26.0 [Torrent]
 
   Home   Help Search Login Register More  
Pages: [1]
  Print  
Author Topic: Reading CoinCap.io or coinmarketcap.com prices in Excel ?  (Read 1209 times)
thhjs (OP)
Newbie
*
Offline Offline

Activity: 39
Merit: 0


View Profile
May 04, 2017, 05:37:38 AM
 #1

Hello,

I don't know if I'm at the right forum place to ask this question.

I want to read some prices of Bitcoin and Altcoins in Excel.

Yesterday I have found a simple solution in Google Sheets :

=IMPORTXML("http://coinmarketcap.com/currencies/bitcoin/","//span[@class='text-large']")

This works good. But I want to make this in Excel and tried the =WEBSERVICE() funtion. But it doesn't work.
Is there someone who made this to work in Excel or is it not possible ?
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!