 |
Amritendu Maji
2017-08-17 23:09:27
|
|
I would like to see if we can rank a portfolio of stocks in a pivot table.
Say, we have five stocks, A, B, C, D, E. We calculate their ROC(Close, 5), ROC(Close, 10), Alpha, and UPI. I can do that and list it in a Pivot table.
However, I want to rank them according to the formula [2*(ROC5 + ROC10) + Alpha + UPI]/6 and display the rank and possibly rearrange the rows in order of rank.
How can I do that using the Pivot Table in QS? I know I can export it to Excel and then do it, but I wanted to see if I can do it automatically.
Thank you.
|
|
0
