cryptocurrency portfolio tracker spreadsheet

Follow the spread sheet format EXACTLY as below: Please go through it once : [login to view URL] For the 1st sheet is the transaction sheet. [login to view URL] All the column inside the sheet is essential. e.g : date,type , exchange, coin ticker , transacted units, transacted price (BTC) , Fees (BTC) , Previous units, cumulative units , transacted value , previous cost, cost of transaction, cost of transaction(per unit) , cumulative cost, gain/losses from sale , realised gain/losses % Each column inside the sheet already constructed accordingly with attached formula. However, the main task here is import the API exchange rate from 5 different EXCHANGE : Bittrex, binance, coinexcharge,hitbtc, crytopia . Different exchange will have different charges fees( BTC) , for instance : Bittrex will charge 2.5% for each transaction. 2nd sheet is the summary of the transaction sheet main task here is grab all the value from transaction sheet. 1. Investment category: position/hodl ,swing, day, speculation. 2. Exchange rate, when the user select the specific exchange rate only the respective quote and price will be used/ shown. for instance: when select bittrex as exchange only bittrex quote and bittrex price will shown. [login to view URL] shares and cost column must be grab all the info from transaction sheet. [login to view URL] 3rd sheet: portfolio summary this is the whole portfolio summary sheet where it summarize the total portfolio cost , value & four investment category :position/HODL , swing, day, speculation. Please make sure that you are fully understand before u start to work on this sheet don't hesitate to ask any questions & let me know when u can start work on it. Thanks