I have various formulas taking the difference between the two months if the issuer shows up in both quarters
possible to set these up as calculated fields instead ? need the formulas to be dynamic as the dates will change every quarter
(i scrubbed out the issuer name and they're unique so that's why there's no instance of an issuer in both quarters but i hope you understand the intent here ).
possible to set these up as calculated fields instead ? need the formulas to be dynamic as the dates will change every quarter
(i scrubbed out the issuer name and they're unique so that's why there's no instance of an issuer in both quarters but i hope you understand the intent here ).
Sample Data (6).xlsx
Sheet2 DATE - Month, Values Mar, Dec NAME OF ISSUER, Sum of Qty, Sum of VALUE, Sum of Qty, Sum of VALUE,Qty Change,MV Change,Previous Price,Current Price,Change in Price,% Change Price A, 100 , 630 ,100,630,N/A,6.30,N/A,N/A AA, 26 , 2,877 ,26,2,877,N/A,110.67,N/A,N/A AB, 22 , 1,128 ,22,...
docs.google.com