I have made 2 tables, one a sheet listing all of my trades, and a second table with just basic statistical info on stocks I've traded (avg daily volume, market cap, etc).
What I would like to do is add a column TOTAL P/L on the second table which will sum up my p/l for each stock that I have traded. First, is it possible to use a calculated field in my second table based on multiple entries in the first table? (I'm guessing it's not possible). If I need to instead use a query, how would I go about writing an expression which will find each trade for a given stock in table 1, sum up the P/L, and return the value into a single field for each stock in table 2? All replies appreciated.
What I would like to do is add a column TOTAL P/L on the second table which will sum up my p/l for each stock that I have traded. First, is it possible to use a calculated field in my second table based on multiple entries in the first table? (I'm guessing it's not possible). If I need to instead use a query, how would I go about writing an expression which will find each trade for a given stock in table 1, sum up the P/L, and return the value into a single field for each stock in table 2? All replies appreciated.