You can use google spreadsheets to update portfolio automatically from CMC. There was a formula that looks up price based on token ticker. You have to do some digging. I will update this post if I find the material.


Edited to add link:
Try this: https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14