Track cryptocurrency in realtime

Bitcoin Questions and AnswersCategory: General questionsTrack cryptocurrency in realtime

Gary Sandahl asked 12 months ago

Is there a function in Excel or Google Sheets that will track cryptocurrency prices in real time?  I have spreadsheets that connect to yahoo finance for tracking my stock portfolio.  I’d like to do that with my portfolio of currencies in Poloniex – or somehow connect to the data used by coinmarketcap.

1 Answers
Zsofia Elek answered 12 months ago

Hi Gary,
You have to use the exchange’s API key and develop something for your own as this functionality currently does not exists in Poloniex to directly extract real time data into excel. Here you can fund some further resources on how to apply a web query in excel to source real time Bitcoin price data. 

Bitcoin Video Crash Course 

Join over 94,000 students and know all you need to know about Bitcoin. One email a day for 7 days, short and educational, guaranteed.

We hate spam as much as you do. You can unsubscribe with one click.