cryptocurrency portfolio tracker spreadsheet

Follow the spread sheet format EXACTLY as below:

Please go through it once :

[url removed, login to view]

For the 1st sheet is the transaction sheet.

[url removed, login to view]

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.

[url removed, login to view] shares and cost column must be grab all the info from transaction sheet.

[url removed, login to view]

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.


Taidot: Excel

Näytä lisää: 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, portfolio database spreadsheet, stock portfolio options spreadsheet, portfolio tracker wordpress, stock portfolio excel spreadsheet, portfolio backtesting spreadsheet, loan portfolio excel spreadsheet, portfolio accounting spreadsheet

Tietoa työnantajasta:
( 0 arvostelua ) seri kembangan, Malaysia

Projektin tunnus: #16061943

Myönnetty käyttäjälle:


mphil in computer science and expert in Excel.

825 RM MYR 1 päivässä
(19 arvostelua)

6 freelanceria on tarjonnut keskimäärin 456 RM tähän työhön


I have good knowledge of excel and can work very efficiently and quickly on excel spreadsheets. I can do your work very efficiently and quickly. Thanks

350 RM MYR 3 päivässä
(0 arvostelua)

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.

444 RM MYR 4 päivässä
(0 arvostelua)

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 Lisää

116 RM MYR 3 päivässä
(0 arvostelua)

"""cryptocurrency portfolio tracker spreadsheet"" Please check the work below: Crypto-currency website: [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] Lisää

444 RM MYR 3 päivässä
(0 arvostelua)

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 Lisää

555 RM MYR 1 päivässä
(0 arvostelua)