Select your cell with the ticker symbol and click the Stocks data type button. If you do not see this, you are currently using an Excel version that does not have this capability. After activating the Data tab, you should see a group of buttons called Data Types. Let’s visit Excel’s Data tab and see how we can set up a cryptocurrency data pull for Bitcoin in U.S. The formula essential goes like this: Cryptocurrency + Desired Price Currencyįor example, if you wanted to see Bitcoin in Euros, you could enter either “BTCEUR” or “BTC/EUR” and Excel will recognize that as a valid input. You actually need to merge the coin’s abbreviation with the desired price currency you want to output. Inputting the proper naming for cryptocurrencies is a little tricky as you can’t simply enter in the typical abbreviation for the coin and expect to get a result. The currently available cryptocurrencies in Excel include: Microsoft has only paid to receive data for the handful of major cryptocurrencies traded around the world. There are hundreds (if not thousands) of cryptocurrencies that are bought and sold every day.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |