Excel Crypto Price Auto-Updater

I keep an asset register in Excel 2021 and want the price column to maintain itself. Whenever I enter a crypto ticker—ETH, BTC, etc.—in the cell to the left, the neighbouring cell should automatically pull the current New Zealand-dollar value from Coin Market Cap, refresh the figures once every day, and show six decimal places. I also need simple colour-coding so I can see at a glance whether today’s value is higher or lower than yesterday’s close. I would like to be able have a list of coins on one sheet that are updated. You may use VBA, Power Query, Office Scripts, or any other native-to-Excel approach as long as it works in the desktop version of Excel 2021 without extra paid add-ins. If an API key from Coin Market Cap is required, include clear, step-by-step notes on how I enter my own key and change the refresh schedule if I ever want to. Deliverables: • A ready-to-use .xlsx (or .xlsm) file demonstrating the live price pull and the colour logic. • A concise setup guide so I can replicate the solution in other workbooks. Once I open the file and see the NZD prices updating with proper formatting, the job is done.

Project ID: 39721590