How do you calculate profit/loss from gdax report?

[CryptGo]

I have been looking on and off for weeks for an excel template or any way i can import the cvs report from gdax to see how profitable my trades have been and i have yet to find an easy solution.  I really dont want to have to manually copy and paste hundreds of trades from gdax! Please help!

I've been lurking for a while and know this isnt the most exciting post but i hope it will help others with the same frustration and curiousity.

much thanks

[BrewMaster]

there is no easy way to do this. depending on how the CSV file looks like and what information it contains it can be a lot of different approaches. i have not used GDAX to be know it, but usually they have a column saying buy or sell indicating the type of your order that was filled.

with some conditions you may be able to do it.

Code:

=if(Logical_Test,Value_if_true)

you can get the value like this then find the other matching values. for example you find buy order then find the sell order matching it using the AND operator.

Code:

=if(AND(test1,test2),Value_if_true))

and finally use these values to get the final result which is profit or loss.

[CryptGo]

so brutal.  I just made an excel sheet manually.  Whoever has an in at coinbase should push for a better report!  maybe they dont want people to see how much they are losing by day trading haha