Changing that isn’t complicated, go to: File / Excel Options / Advanced Optionsĭeselect the 'Use system separators' box.Select “Decimal Separator'.
The automatically imported prices have a '.“ and therefore cannot be used for calculations. NB: Depending on the version of excel you use, it may be necessary you have to modify the decimal separator from a '.” to a ','. The user simply needs to specify the Ticker, the amount purchased and at what price to then have the current capital gain (or loss) in real time. In this example, I have included a mini virtual portfolio.
Price variation over 1hr, 24hrs, and 7 daysįollowing this first import, you can carry out a lot of processes. Classification according to its capitalization This file also includes the following information for each cryptocurrency: This data is offered free of charge and can be automatically retrieved by any user.Īttached is an Excel file which refreshes the prices on all cryptocurrencies (more than 1600) every minute.
Many sites offer an API to directly retrieve cryptocurrency prices, historical prices, and various information directly on Excel.
