I had a question about excel that I was hoping someone could answer. Basically, lets say I have 3 columns set up for a set of stocks. I have a column for purchase price, current price and a sell trigger that .9*(current price). I want to be able to glance down my list of stocks and once the current price is entered, I would like the entire box to turn yellow (or any color) if the current price is below my sell trigger. Does anyone know how to set this up??
Your formula won't work The sell trigger will always be 90% of the current price. You have to rethink your logic. JJ
sorry I meant the sell trigger will be .9*(purchase price) because I will want to think about exiting the trade after the stock has lost 10% of its value
Here's how I would do it (see excel spreadsheet). If the current price is equal to OR below 90% of the purchse price, a sell trigger will be activated and the cell will turn red. 1. I'm using an excel formula to account for the "Equals To" OR "Less Than" condition that is inferred in your written statement. 2. I'm using conditional formatting to turn the "Sell" text comment RED. JJ