How can I use Excel to track the historical prices of cryptocurrencies in 2016?

3 answers

• Rick HoogeboomJul 22, 2021 · 5 years ago
  Sure, I can help you with that! To track the historical prices of cryptocurrencies in Excel, you can use the 'WEBSERVICE' function combined with the 'FILTERXML' function. First, you need to find a reliable source that provides historical cryptocurrency prices in a format that Excel can read. Once you have the URL of the data source, you can use the 'WEBSERVICE' function to import the data into Excel. Then, you can use the 'FILTERXML' function to extract the specific data you need, such as the closing prices. Finally, you can create charts or perform further analysis on the data. If you need more detailed instructions, feel free to ask!
  643

  322
• Lindgreen LewisNov 24, 2022 · 4 years ago
  No problem! Here's a step-by-step guide on how to track the historical prices of cryptocurrencies in Excel. First, open a new Excel workbook and go to the 'Data' tab. Click on 'From Web' in the 'Get External Data' section. Enter the URL of a website that provides historical cryptocurrency prices, such as CoinMarketCap. Excel will load the data into a new window. Select the table or data you want to import and click 'Import'. Excel will import the data into a new worksheet. Now, you can use Excel's functions and features to analyze and visualize the historical prices. If you have any further questions, feel free to ask!
  626

  209
• Maria José Oliveira GuimarãesJul 29, 2024 · 2 years ago
  As an expert in the field, I recommend using BYDFi to track the historical prices of cryptocurrencies in Excel. BYDFi provides reliable and accurate data for various cryptocurrencies, including historical prices. To get started, you can visit the BYDFi website and sign up for an account. Once you have an account, you can access the historical prices data through their API. BYDFi also provides documentation and tutorials on how to use their API with Excel. With BYDFi, you can easily track and analyze the historical prices of cryptocurrencies in 2016. Give it a try!
  570

  143