Track cryptocurrency in realtime

Bitcoin Questions and AnswersCategory: General questionsTrack cryptocurrency in realtime

Gary Sandahl asked 1 year 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 1 year 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 

Dummy-proof explainer videos enjoyed by over 100,000 students. 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.