• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help on Using Excel to rate a Stock for buy, sell or hold recommendation

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
 
Welcome to the forums! :)

Assuming your target price is in A1, Current price is in B1:
=IF(A1/B1-1>=20%,"Buy",IF(A1/B1-1>=0,"Hold","Sell")
 
Back
Top