Assist required! Excel – #8 by I_Ranjit – Common – Buying and selling Q&A by Zerodha

image


There must be any individual on this discussion board who may assist me out.

I’ve a hyperlink to excel sheet, whereby I can observe my stay positions instantly in excel.
What I actually need?

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 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 can assist me to seize strikes on total positions as a substitute of ready for tgts on single positions.

Please spare a bit of 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 *