T
Trevor Greene
Hello, I have a brief question with an issue I have been struggling
with in Excel 2007 Pivottables.
I am organizing a pivot table in excel based on trades made.
I have particular fields added, and then from those fields I formulate
a new column with that fields average, sum etc.
For ex:
I have a Field from the reference sheet: Edge/contract.
I then go to find the average edge/contract for each symbol traded
between the numerous trades.
My next Field I have: P&L/contract.
I then have the column calculated with the sum of p&l/contract.
The goal is to find the percentage of profit/loss per amount of
edge.
I am trying to create a formula that calculates the previous
columns... I would like the formula to look like this...
" 'Sum of p&l/contract'/average 'edge/contract' "... The problem is
this calculation doesn't formulate right. I know by looking at the
values themselves what the actual number should be, but it doesn't
equate to the right value. Essentially i want to use a formula to
reference two already calculated columns, not the field itself
uncalculated with the sum or average.
Any help would be much appreciated
with in Excel 2007 Pivottables.
I am organizing a pivot table in excel based on trades made.
I have particular fields added, and then from those fields I formulate
a new column with that fields average, sum etc.
For ex:
I have a Field from the reference sheet: Edge/contract.
I then go to find the average edge/contract for each symbol traded
between the numerous trades.
My next Field I have: P&L/contract.
I then have the column calculated with the sum of p&l/contract.
The goal is to find the percentage of profit/loss per amount of
edge.
I am trying to create a formula that calculates the previous
columns... I would like the formula to look like this...
" 'Sum of p&l/contract'/average 'edge/contract' "... The problem is
this calculation doesn't formulate right. I know by looking at the
values themselves what the actual number should be, but it doesn't
equate to the right value. Essentially i want to use a formula to
reference two already calculated columns, not the field itself
uncalculated with the sum or average.
Any help would be much appreciated