It is important to have an estimate of risk for a portfolio when trading with financial assets. Two basic and commonly used risk measures are value-at-risk and expected shortfall. We will illustrate the two concepts with an example and provide the necessary R code to actually calculate the values of both measures. If we take […]
08-Ago-2018 Update: Removed update and queries point to CoinFabrik servers to solve quota issues in both Google and Crypto APIs. You can get the spreadsheet here. To create your own version go to ‘File’ -> ‘Make a copy’. Keep updated on my Twitter account. Thanks to the smart contract development team.
We present an update of my previous article for cryptocurrency portfolio tracking. I received valuable feedback from some users, and I decided to update the spreadsheet based on those suggestions. The idea with this new spreadsheet, is to add only the transactions in the History tab: And reflect current asset position in the ‘Position’ tab: Also, ‘Prices’ tab […]
This Google Live Updated Cryptocurrency Investment Tracking Spreadsheet can help you track your cryptocurrency investments. It gets the prices from an external API and keeps them updated. It supports the 15 most popular cryptocurrencies. It uses Poloniex and Cryptocompare APIs to retrieve latest currency’s rates: It uses a script based on FastFedora Project which can […]