(Ok damn, 1h later and 1 tokens is already worth $1 while it was $0.06 just an hour ago. This is absolutely crazy.

You can get $100 just with their airdrop now and another $50 fo…

The feedback you provide will help us show you more relevant content in the future.

, co-author of Zapiers Ultimate Guide to Google Sheets.

You can use Google Sheets built-inGoogle Finance functionto find the current price of Bitcoin, or any other currency or stock ticker.

Just enter=GOOGLEFINANCE(CURRENCY:BTCUSD)in your spreadsheet to find the current price of Bitcoin in US Dollar. ReplaceUSDwith the currency name of your choice to find the BTC price in that currency.

Or, you can make a more advanced function like the following to find the weekly BTC-USD rates for the past six months:

=GOOGLEFINANCE(CURRENCY:BTCUSD,price,DATE(2016,1,1),DATE(2016,6,30),WEEKLY)

For more info on advanced Google Sheets functions like t…

How can I track the price changes of a product in Flipkart using Google Sheets?

How can I track the price changes of a product in Flipkart using Google Sheets?

Is it possible to automatically pull stock prices into Google Sheets?

How can I get stock prices and fundprices into a Google spreadsheet?

How do I set up Google Sheets to automatically add data from an external source to Google Sheets?

Why do Bitcoin exchanges have different buy and sell prices even before they add fees on top?

Will the price of Bitcoin go up? I bought Bitcoin and price went down 50%?

What is the bitcoin price prediction for 2019?

How do I use Google Finance in Google Sheets?

What makes Bitcoin and Ethereum prices go up and down?

How can I track the price changes of a product in Flipkart using Google Sheets?