How to Display Cryptocurrency Prices in Google Sheets

A few days ago, I was using CryptoFinance to import cryptocurrency prices into Google Sheets. Unfortunately, the import function kept on timing out due to a CoinMarketCap API error. I suspect this has something to do with CMC’s recent move to a tiered API system which limits non-paying users to 6,000 calls per month. After a little research, I discovered the stock =GoogleFinance function supports major cryptocurrency pairs.

Just copy and paste the function below.


Supported currencies (for now) are limited to BTC, ETH, BCH, and LTC.

ICON Partners with SK-Planet to Build Blockchain Services

Earlier today, ICON Foundation revealed that they have signed an MOU with SK-Planet to “work together to create new customer values and business opportunities by linking ICON’s blockchain technology with Korea’s leading mobile services.” This news comes just four months after ICONLOOP’s announcement regarding implementation of its CHAIN ID authentication system into Samsung Pass. Together, these two developments suggest that ICON is absolutely dominating the blockchain mobile services niche in South Korea.

Continue Reading →

Substratum is Losing Vision & Focus

Substratum is currently trying to build a decentralized Internet, a payments processing platform, and a decentralized exchange. I think these goals are overly ambitious, but that’s just my opinion. Let’s get into it.

Disclaimer: Stop reading here if you’re a SUB bagholder. If you choose to continue reading, I am not responsible for hospitalization costs due to high blood pressure. You’ve been warned.

Continue Reading →

BitMex Rents Hong Kong’s Most Expensive Office Space →


The average rent per square foot at the new location is US$28.66, more than nine times higher compared to the US$3.18 per square foot that BitMEX was paying at its old headquarters – a logistics and warehouse district in Hong Kong’s Victoria Harbor. With the entire floor consisting of 20,000 square feet, the leasing expenses will add up to US$573,200.

This is almost comical.

I understand the concept of allocating financial resources to different departments in the corporation, but does BitMex really need an office space that’s 10x more expensive when their technical infrastructure can’t even handle current trading volumes?

« Permalink »

ICONLOOP, ICX Buyback Program, and ICON Open Sourcing

Today, ICON Foundation announced the rebranding of theloop to ICONLOOP, an ICX buyback program, and open sourcing of the ICON project. Let’s get into it.

Continue Reading →


Have a question, or just want to chat about life?
Find me on Twitter, or send me an email.