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.
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.