Mayowa Oladipupo
New Member
How do i write an Ms Excel function (e.g logical function) to rate a stock for "buy", "Hold" or "Sell"? Here there are three values instead of two value
if my Target price =$15 and the current price of the stock = $10
Then
"BUY" rating is when percentage change between target price and current price, that is (target Price/current price)-1 is greater than or equal to +20%
HOLD Rating is when the percentage change between target price and current price is between 0.00% and +19.99%
Sell Rating is when the percentage change between target price and current price is less than 0.00
if my Target price =$15 and the current price of the stock = $10
Then
"BUY" rating is when percentage change between target price and current price, that is (target Price/current price)-1 is greater than or equal to +20%
HOLD Rating is when the percentage change between target price and current price is between 0.00% and +19.99%
Sell Rating is when the percentage change between target price and current price is less than 0.00