Crypto Portfolio Management - Review history and build/maintain Spreadsheet for TAX

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

Hi,

You should know everything about crypto portfolio management and help me to track my current holdings / trades made and calc Profit/Loss going back 8 months for TAX purposes .... things like MEW usage / ICO tokens / airdrops / BTC ETH historical conversion calcs / swing trades / using blockchain explorer for tracking.

Easy to understand Historical spreadsheet to be built that will be updated each month ( Using pivot tables and VBA if required )

Key Milestones required (Looking for Part 1 and / or 2 only for now.. )

Part 1)

Build a historic spreadsheet based on tokens bought / Movements made going back 9 months

by

Reviewing Transaction History on 3 MEW wallets (using blockchain explorer for tracking )

Understanding the IN/OUT movement of transactions made ( generally between exchanges + new tokens send via ICO's)

460 trans + 200 trans + 300 trans .. approx

Exchange Deposit / Withdrawal Reports given in order to build accurate history

Part 2 )

Calculate Profit / Loss ( Gains ) on a FIFO basis and end up with current holdings after calcs

by using trade history reports given from various exchanges used

(manual is acceptable but preferably Automatically using arrays with VBA scripting)

Part 3) Ongoing management of the portfolio by updating it every month with new reports given ( Outside the scope of this project for now but could be ongoing work if things work out )

Accounting Business Analysis Excel Finance Financial Analysis

Project ID: #16530260

About the project

13 proposals Remote project Active 5 years ago

13 freelancers are bidding on average €334 for this job

schoudhary1553

Hi there..... Warm Greetings We came along with your request for build/maintain Spreadsheet for TAX and we reviewed your project description. We'd like to help you with confidence and satisfying results... We More

€350 EUR in 6 days
(214 Reviews)
7.3
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More

€250 EUR in 10 days
(71 Reviews)
6.4
sheak

Hello! I have read all the requirements carefully and your project seems very interesting. I would love to work and invest my knowledge, skills and research in this task. I am an experienced professional and one of the More

€388 EUR in 10 days
(50 Reviews)
6.4
kevivu

Dear Sir, I am based out of Jersey City, NJ, USA. Completed numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. You can refer my freelancer profile for reviews More

€250 EUR in 5 days
(70 Reviews)
5.8
yogesh701

Hello there! Hope you are doing good. I am a Chartered Accountant who has expertise in trading related matters. I have helped my clients in building excel sheets for the purpose of their tax computation on their tra More

€611 EUR in 10 days
(32 Reviews)
5.3
supper5guy

Hello there, after reading your project description and with a drive for excellence, with a keen attention to details and with more than 10 years experience working with Microsoft office especially excel VBA and after More

€120 EUR in 10 days
(25 Reviews)
4.2
rakibmsnc

Hi, I hope you are doing fine. Being a professional, I would like to let you know that, I have read through your description and understand your requirement perfectly. For your assurance, I would like to let you kno More

€250 EUR in 10 days
(1 Review)
2.3
nanda1208

I think I can help you on your project. I believe that I can solve your project with VBA. I'm an investor on brazilian stock market, experienced with register my trades on spreadsheets. This way I have developed some More

€100 EUR in 4 days
(3 Reviews)
1.9
mayurimehta51

A proposal has not yet been provided

€444 EUR in 4 days
(0 Reviews)
0.0
alembaptista

Hello . Please read my profile. I am an accountant and I studied MBA in finance, accounting and administration too. I have experience in Excel. I am sure that I can help you. Thanks

€222 EUR in 10 days
(0 Reviews)
0.0
samyakvermani1

Please select me. I am pretty good i guess.

€111 EUR in 1 day
(0 Reviews)
0.0