You are viewing a single comment's thread from:

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

@tomshwom, thanks for this article! I just joined steemit and this is my first comment. My whole investment method is built around a customized excel spreadsheet and the thinkorswim RTD functions, but they were no help when I decided to dip my toe in cryptos. You da man in my book, dude!

Sort:  

@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!