Function in VBA
Posted on 2005-04-10
I use a function TDCLOP(...) in VBA todetermine a cell value. This function itself takes as input a value returned by Bloomberg provided Excel Function that get the price of a security in realtime. TDCLOP(...) return a buy or a sell signal. I want to take some action ONLY when the signal chanes lets say form a BUY to a SELL value.
Please advice on how I can do that. Since this function gets evaluated all the time on relatime price update I do not want to take an action if the BUY is retained.
To further clarify the action I want ot take is:
print the time at which the signal changed from buy to sell or blank.