I am trying to find out how to get the price of bitcoin, ethereum, litecoin and bitcoin cash in AUD at a particular date.
I have a table as shown below:-
+------------+-------+ | Date | Price | +------------+-------+ | 16/03/2016 | | | 19/04/2016 | | | 03/12/2017 | | +------------+-------+
I have tried entering =IMPORTXML("http://coinmarketcap.com/currencies/bitcoin/","//span[@id='quote_price']") in the price column but it doesn't seem to work.