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.


Kemahiran: Excel

Lihat lagi: portfolio database spreadsheet, stock portfolio options spreadsheet, portfolio tracker wordpress, crypto portfolio spreadsheet, cryptocurrency excel spreadsheet tracker, cryptocurrency tracking spreadsheet, cryptocurrency investment tracking, cryptocurrency google spreadsheet, crypto investment spreadsheet, cryptocurrency excel sheet, crypto trading spreadsheet, stock portfolio excel spreadsheet, portfolio backtesting spreadsheet, loan portfolio excel spreadsheet, portfolio accounting spreadsheet, stock portfolio tracker website, sales tracker spreadsheet, portfolio tracker sms facility, portfolio tracker sms, portfolio management spreadsheet

Tentang Majikan:
( 1 ulasan ) seri kembangan, Malaysia

ID Projek: #16061943

Dianugerahkan kepada:


mphil in computer science and expert in Excel.

RM825 MYR dalam sehari
(38 Ulasan)

5 pekerja bebas membida secara purata RM477 untuk pekerjaan ini


Hello, I am Tanvir I have read your job post. I can do this job. I have done few job this related. If you are interested…? contact me.

RM444 MYR dalam 4 hari
(0 Ulasan)

Hi I'm   RICH P. I've reviewed your complete job description, and I fulfill all the qualifications required for this project. I have done many projects and I always try to provide good quality work to my clients Lagi

RM116 MYR dalam 3 hari
(0 Ulasan)

"""cryptocurrency portfolio tracker spreadsheet"" Please check the work below: Crypto-currency website: [login to view URL] [login to view URL] [login to view URL] [login to view URL] Lagi

RM444 MYR dalam 3 hari
(0 Ulasan)

Hi, My name is Marcos. I also work with cryptocurrencies and have done a spreadsheet to me to work with all that you explained. I'm available to do yours as soon as possible if you want. I can deliver it in 1-2 worday Lagi

RM555 MYR dalam sehari
(0 Ulasan)