Assist required! Excel – #4 by Anikethan – Common – Buying and selling Q&A by Zerodha

image


There needs to be any person 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 selected 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 difficulty is, it ll replicate 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 total positions as an alternative of ready for tgts on single positions.

Please spare just a little 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.