Assist required! Excel – Basic – Buying and selling Q&A by Zerodha

image


There ought to be anyone on this discussion board who might assist me out.

I’ve a hyperlink to excel sheet, whereby I can observe my stay positions straight 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 wish 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 general positions as an alternative of ready for tgts on single positions.

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



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *