Assist required! Excel – #9 by Jay_Bhullar – Common – Buying and selling Q&A by Zerodha

image


There needs to be anyone on this discussion board who may assist me out.

I’ve a hyperlink to excel sheet, whereby I can monitor my stay positions instantly in excel.
What I really want?

image

If mtm cell hits a particular worth say, 3000, then, it ought to give a popup/notification/or cease calculating the cell.

I solely know few fundamentals of conditional formatting whereby I construct this sheet from scratch.
I can apply a situation, say, Cell I1
image

The problem is, it ll mirror TGT hit, however I ll by no means know, if I failed to take a look at the cell. I need to cease, the conditional calculation, as soon as it fulfils the situation. Means, tgt hit, ought to keep as textual content, not vanished if worth goes lower than 3000.

This may assist me to seize strikes on total positions as a substitute of ready for tgts on single positions.

Please spare a bit of your time to assist a fellow Tqna out. I do know this discussion board is stuffed with good males.



Source link

Leave a Reply

Your email address will not be published.