If I’m anything as a trader, I’m curious. I wonder constantly. What about this? What about that? How do these interact? What has happened historically in this particular situation?
Excel has been my go to fact checker for probably close to a decade now. It’s simple enough for me and does what I need it to do. It has also convinced me that I could never be a computer programmer. My go to condition checking formula is a basic if>then statement:
“IF this condition exists, (and this, or this, occur at the same time), THEN state it as the value of: (the upper bollinger, current price, 10MA + $5, etc.)”
They can get pretty complicated sometimes and anything beyond a few conditions and I’m likely to have a formula error because I missed a parenthesis or a comma, and then my eyes start to cross and my brain gets the blue screen of death. My solution in these cases is to break the formula down in a basic word doc and put it together piece by piece.
(more…)