• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

High break out

T

Techtrend

Member
Hi Team

I have a live sheet in that it records the open ,low ,high,close prices, I need to know when ever if the current price breaks the high the value of the CP or BUY will be published in Green.
The sample is also attached for your reference

I have a regular excel and VBA works,looking for a freelancer let me know if any one interested

Thanks
Narendra
 

Attachments

  • Nifty-Scripts-HL 4.xls
    26.5 KB · Views: 5
Not sure if i have understood it correct but you can try in cell I2
To publish Current Price if it is more than High
=IF(B2>D2,B2,"")
To publish "Buy" if Current Price if it is more than High
=IF(B2>D2,"BUY","")

Thanks
 
You must log in or register to reply here.
Back
Top