Track cryptocurrency in realtime

Bitcoin Questions and AnswersCategory: General questionsTrack cryptocurrency in realtime
Gary Sandahl asked 10 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 10 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 

Know more than 99% of the population about Bitcoin. One email a day for 7 days, short and educational, guaranteed.