Looking for an advanced EXCEL / VBA Freelancer to use the uploaded spreadsheet and figure out the Profit / Loss on the trades made.
From my tech knowledge I believe this can be done utilizing a multidimensional array and clever Macro Vertical look ups to go through the BUY /SELLs of each stock type to populate array to make final calc on the particular trade type.
BTC USD Price can be obtained via api call (I can supply the lookup api call)
Similar trades data using this spreadsheet would be provided for future projects based on this project completion.
Please write a response giving reason why you can do this project please (not a copy and paste standard one) ...
18 freelancers are bidding on average €137 for this job
Great experience in automating spreadsheet using VBA Programming of Excel and all kind of formulas.. Fast and qualified work. I can do the import just exactly as you want. I can start right now!