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
I've read your description very carefully. I understood what you actually need. I'm really interested in winning this task.
Please have faith in my words, I'll provide you accurate work & give you my best service.
Thanks
Hello
This is Tazul Islam from Dhaka. I am an interest to work your project. and I have 10+ years experienced . So, please give me this work. I am thankful to you.
Thank you so much