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 follows

|    Date    | Price |
| 16/03/2016 |       |
| 19/04/2016 |       |
| 03/12/2017 |       |

I have tried entering using:


However, I get the error:

When evaluating GOOGLEFINANCE, the query for the symbol: 'BTCAUD' returned no data.

1 Answer 1


Date format is incorrect, try as 03/16/2016 and in formula =GOOGLEFINANCE("BTCUSD", "price",A2).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.