Sunday, January 19, 2014

yogi_Compute Row By Row Sum Of Trade IDs From Data In Another Sheet

                                          Google Spreadsheet   Post  #1489
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-17-2014
question by Dave Lalande (http://productforums.google.com/forum/?zx=15w267jsn7yv&usp=sheets_web#!category-topic/docs/spreadsheets/8ZQinT3_pJc)
Conditional SUM
My brother is learning how to trade options and I'm trying to setup a "trade log" for him.  Rather than him entering each trade he is copy/paste from his broker's transaction log into the sheet.  The problem is that when he buys (or sells) X contracts the broker might or might not buy those in one transaction.  I am trying to assemble the transaction log (sheet named "paste") into a "combined" sheet.

Here is the sheets in an shared editable form.


Will somoene help push me along on understanding how to add Total Cost to the "combined" sheet from the "paste" sheet where the Transaction ID is the same?

Thanks for your help always.

Dave
-----------------------------------------------------------------------------------------------------------------------------------------------------------