Time Capture

[Techtrend]

Hello Team

Attached is the Live sheet where the data keeps getting updated in the live market,

In the W Col we have NEUTRAL / UPTREND / DNTREND
And Now in AA COL We need to publish the Current time as and when UPTREND or DNTREND comes in W Col.

By Default every thing will be Neutral and need to publish the current time only when it is UPTREND or DNTREND.


Thanks in Advance for your time
Narendra

 

[Khalid NGO]

Hi Narendra,

Can you check this:
=IF(OR(W2="UPTREND",W2="DETREND"),NOW(),"")
Format to Time
copy down.

Regards,

 

[Techtrend]

Hello

Not getting,
I have applied the formula in the AA Col and gets some dummy data.

Can you please apply the code in the excel sheet and mail me.

Thanks
Narendra

 

[Techtrend]

Ok i checked the issue is the time function takes the default current time for all,

It has to be like this

W3 says UPTREND(Lets says it comes at 11 AM)

and

W8 Uptrend gets published at 1 Pm ,

It has to show 11 and 1 PM only next to those scripts.

Hope its clear.
Narendra

 

[Khalid NGO]

Ok i checked the issue is the time function takes the default current time for all,

It has to be like this

W3 says UPTREND(Lets says it comes at 11 AM)

and

W8 Uptrend gets published at 1 Pm ,

It has to show 11 and 1 PM only next to those scripts.

Hope its clear.
Narendra

Sorry Narendar, my bad again...
I didn't understood your question and replied.
Now it is more clear.

I think this is not possible in formulas,
May be someone came with VBA solution, as I am almost zero in VBA.

Regards,

 

[Techtrend]

No probs

thanks

 

[Istiyak]

http://chandoo.org/forum/threads/static-timestamp.20951/

This might be help you out.