Gerard van Wijk
Sep 1, 2018 · 3 min read
CrypteXL Portfoliomanager

As an alternative to using Blockfolio or other crypto tracking apps I created this CrypteXL Portfolio Manager in Excel (Windows only). It is easy, free & ready to use and offers better functionality than all the paid versions of crypto-sheets available. A number of features you will find below, but it is better to try and find out for yourself!

Most important features:

- 5 tabs : Start|My Transactions | My Portfolio | My Statistics | Donation

- It draws live data from CoinMarketCap.com and refreshes on demand for nearly all coins (1–1600)

- Tab [Start]:
- Set your Native and Portfolio currency ; choose from 10 currencies:
USD, EUR, AUD, CAD, GBP, NZD, JPY, CHF, NOK, INR
- Easily transfer your existing portfolio to CrypteXL Manager with the transfer button

- Tab [My Transactions]:

- Simply enter the details of your executed orders: date, type, coin, amount and ‘bought with/sold to’
- Average cost price is noted before and after the recent transaction, so you can monitor the immediate effect of the recent transaction on the average price

- Tab [My Portfolio]:

  • All transactions are automatically transferred to this page
    - Refresh price feed on demand (green refresh button)
    - Display your portfolio in alphabetical order or ranking order (switch between both)
    - You can make a snapshot of your result to display in graph
    - Display for your portfolio coins:
    * 1 hr, 24 hr and 7 days % changes,
    * quantity, average price, current price in BTC and in choosen currency
    * portfolio value in BTC and in choosen currencie
    * distribution (% of each coin in portfolio) and profit (absolute & %)
    * conversion calculator between the 10 currencies and BTC/ETH
    * watch & alert function to monitor the coins of your choice

- Tab [My Statistics]:
-
Graphic display of your portfolio with best & worst performing 3 coins in it

- Tab [Donation]:
- If you like CrypteXL Portfoliomanager you can make a small donation in your native currency using PayPal or donate in BTC, ETH or XMR (Monero)

To make full use of CrypteXL Portfoliomanager you have to “Enable Content” in macro settings.

Here is the link to download the CrypteXL Portfoliomanager file from:

1. Mega: https://mega.nz/#!PHxh1YiD!Akyhr3J11G_4nDjKqVqtJBz9fEIeoDsfQPKhRvPgkBM

2. Filedropper: : http://www.filedropper.com/cryptexl

Happy investing! Please read disclaimer below.

Gerard van Wijk (the Netherlands)

Disclaimer: the author cannot be held responsible for any disadvantage due to the use of CrypteXL Portfoliomanager. By downloading the file you automatically accept this condition. If you do not accept: do not download the file!

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade