General Trading Chat

[timepass]

Motabhai won't like this. Probably SEBI will get sued somewhere for this. Today, 40 crore is not much for these entities.

SEBI Imposes Rs 40 Crore Fine On Reliance Industries, Mukesh Ambani For Manipulative Trades In RPL

https://www.livelaw.in/top-stories/...ries-mukesh-ambani-manipulative-trades-167840

 

[timepass]

Another not good news for Jio ??

How scrapping of IUC will impact Reliance Jio, Airtel and Vodafone ..

Read more at:
https://www.gadgetsnow.com/tech-new...ofinterest&utm_medium=text&utm_campaign=cppst

 

[optionwriter]

Dear TJ Senior members and EXCEL experts,

i have a small query about "countif" function result

i attached snapshot

above R Column 2 more times or multi times the same Strike prices appear i need to filter it in "s" column with result as per above snapshot.
so i tried "= countif(R3:R15,R3) " FORMULA AND RESULT shows how many count same strike appear ,then used "if condition " to filer it but not able to get result as per above "s " column

please someone know help..

Happy trading.

 

[travi]

Dear TJ Senior members and EXCEL experts,

i have a small query about "countif" function result

i attached snapshot

above R Column 2 more times or multi times the same Strike prices appear i need to filter it in "s" column with result as per above snapshot.
so i tried "= countif(R3:R15,R3) " FORMULA AND RESULT shows how many count same strike appear ,then used "if condition " to filer it but not able to get result as per above "s " column

please someone know help..

Happy trading.

why don't reference the cell from column 'R' directly,
and put this formula in ''S3' and drag to S15

=IF(COUNTIF($R$3:$R$15, $R3)>1, "", $R3)

works for me.

 

[optionwriter]

Dear Travi. i applied the same as you mentioned , it returns only 73PE, 73.25CE ONLY ITS RIGHT AS PER Formula Because WE PUT >1 . SO THAT 74pe,73.5ce is omitted but we need as per my snapshot "S" COLUMN. (look into S column) 2nd time only need omitting.

PLEASE RETHINK AND REVERT ME SIR.

Happy Trading.

 

[travi]

Dear Travi. i applied the same as you mentioned , it returns only 73PE, 73.25CE ONLY ITS RIGHT AS PER Formula Because WE PUT >1 . SO THAT 74pe,73.5ce is omitted but we need as per my snapshot "S" COLUMN. (look into S column) 2nd time only need omitting.

PLEASE RETHINK AND REVERT ME SIR.

Happy Trading.

you are not clear with what you want. Explain in detail.

 

[optionwriter]

Dear travi sir, i got solution from Traderji member (click here)..

i am happy to say Thanks for you prompt reply with Helping kind...

Happy Trading.

 

[timepass]

Once again, BNF flattish, all CEs and PEs lose

 

[Nish]

But intraday CEs and PEs were fantastic trades !

 

[timepass]

But intraday CEs and PEs were fantastic trades !

Very volatile and unpredictable.