I'm a finance professional and have been dabbling in cryptocurrencies recently. However, I find it challenging to keep track of their prices and movements manually. I've heard that Excel is a powerful tool for data analysis, but I'm not sure how to utilize it for tracking cryptocurrencies. Could you explain in simple terms how I can set up an Excel sheet to track the prices of multiple cryptos, say Bitcoin, Ethereum, and Litecoin? What are the key steps I should follow, and are there any plugins or add-ons that can make this process easier? I'm hoping to have a real-time or at least regularly updated view of their prices and any significant changes.
9 answers
Tommaso
Thu Jul 11 2024
Launch Microsoft Excel or Google Sheets on your computer.
JejuSunshine
Thu Jul 11 2024
Label another column "Cryptocurrency" to identify the digital currency you're tracking.
SejongWisdomKeeperEliteMind
Thu Jul 11 2024
Add "Price" to record the value of the cryptocurrency at the time of the transaction.
Stefano
Thu Jul 11 2024
Initiate a fresh spreadsheet and begin customizing it for your cryptocurrency tracking needs.
Margherita
Thu Jul 11 2024
Designate a column for "Quantity" to keep track of the amount of cryptocurrency bought or sold.