I have a stock trading work sheet, and there are two things I am trying to accomplish and stuggling a lot :
(1) In my trading sheet, I have Buy and Sell in a certain column which is based on certain conditions (strategy). So these Buys and Sells appear whenever the conditions are met, in Real Time (Trading sheet takes data from the internet and continues to update every 1 minute, so there are many Buys and Sells spawning from time to time). What I am looking for is the exact time stamp (data not so required as I know the sheet is being updated today). Strangely upon scouring the net, every body talks about the same formulae viz. IF(A2"",IF(B2"",B2,NOW()),"") and this does'nt serve my purpose at all. If this is all confusing, let me give a clear example here :
Columns A-E has data like High, Low, Close, Open etc etc
Column F has a signal : Buy or Sell
So all I want is some column after Column F which updates the time as and when a signal appears in the Column F. The reason is I want to see which are the new signals that appeared as I am handling 200 rows of scrips.
OR
(2) Can Column F which contains the signal, Buy or Sell be colored in such a manner it accomplishes the following :
(a) New signal BUY as and when it appears should carry a different color, let us say DARK GREEN
(b) Likewise New Signal SELL as and when it appears should carry a different color, let us say DARK RED
(c) All signals after a time decay, say 1 minute (which if configurable would be awesome), should change color. So in the case of Buy (Dark Green), color can change to Light Green and in case of Sell (Dark Red), color can change to say Orange
Just to add to the above, the formulae IF(A2"",IF(B2"",B2,NOW()),"") seem to accomplish, but my excel sheet refreshes every 1 minute, and the moment it refreshes, the time stamp changes to the local computer time (which is current and not the time when the signal came actually).
I even tried my own like =IF(F2="Buy",IF(F2="Sell",NOW(),"")), getting the time stamp, again when the excel refreshes, the time stamp changes to the current time. For e.g. if Buy or Sell came at say 10:15 hrs, after refreshing (let us say 2 minute refresh interval), the time reflected is 10:17 hrs.
Bookmarks