I have included a spreadsheet that attempts to rank share price relationship data choosing the highest ranking data too choos eteh appropriate stock, picking the stocks and then assessing the performance.. unfortunately the same rank appears for quite a bit of the data causing an error signal when i try and calculate the top ranking shares and their subsequent performance.
i want to be able to chose from 1 to 10 of the top performing ratios to figure out if I bought the shares what the performance would be for the week after.
if something ranks the same im indifferent which ranks first , i just want to have a clear rank that is not duplicated . also if the data registers at -100 it was not in existence and shouldnt be ranked at all.
many thanks
Bookmarks