Hi,
I have a workbook containing numerous stocks' monthly returns, and their monthly media coverage. What I am trying to do is picking "media winners" and adding these to a portfolio to evaluate the strategy's return against the market.
In the attached workbook I am having trouble to build a formula that will pick out the "n" (I want this to be a changeable number, it could also be a percentile if that is easier?) largest values (in "∆media") and return the subsequent data (from "returns iferror") to the sheet "portfolio". It has to pick stocks on a monthly basis, as the portfolio is to be rebalanced every month, based on the numerous stock's media coverage in the prior month.
I am clueless as of now all help would be greatly appreciated, thanks in advance
Bookmarks