I've been trying to create a scoring system for expected stock market returns - Sheet
I'm having problems creating a formula to firstly give stocks a score in multiple conditions for example SS
I want the formula to return a score of 0 if the return is below -20% in each of the 6 scoring system in the right, I want it to return 1 if the value is between -20 and -15% and so on until it returns 10 if the expected return is over 30%.
It's probably a use of the
IFS formula, but I just can't get it to work with %.
-Later Edit: Managed to do fix them
I want to create an arrayformula with a weighted average formula based on the weight of each category: dcf low should have a 7.5% weight, dcf mid should have a 15% weight, dividends should have a 5% weight and so on. I'm trying the average.weighted function, but I can't really nail it.
This worked for me, but I would have liked to put it in an arrayformula but it simply gave errors when I tried.
The issue is now when I try to use toe sort function to sort by the overall score, it gives me an error saying that that will overwrite data in W8 but I simply don't understand why.