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.
Dave
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.
https://docs.google.com/ spreadsheets/d/ 1NycdsBS9d81EKHbid5Hohg4atHWdp 7zkCn89_fLWD5Y/edit?usp= sharing
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
-----------------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment