This content has been marked as final. Show 2 replies
I've a table which shows performance of stocks. In 1st column there's list of stocks and in the 2nd column performance of each of the stocks. Now is need to add a third column which represents the performance of the benchmark which is S&P500. The tricky part is when I add the third column for S&P 500 returns it needs to be static i.e. the return of S&P500 will be the same number repeated for each of the rows irrespective of the corresponding list of stocks in each of the rows.
Please look at the attached image and kindly help if you can?