You are viewing a single comment's thread from:

RE: Excel Portfolio - How To Get Live Prices & Stats

in #cryptocurrency7 years ago (edited)

@tomshwom, when I started to implement your tips my screens did not match your screenshots. After a bit of fumbling I figured out that I did not have the Excel Power Query addin. Did that and everything works like a charm. I'm using the CoinMarketCap API for now but I would like to find one that has the daily OHLC info because that is not in the CMC data and I'm too lazy to write something to calculate it. You rock!

Coin Marketplace

STEEM 0.21
TRX 0.20
JST 0.033
BTC 94090.69
ETH 3092.78
USDT 1.00
SBD 2.99