eNote.Page

Checklist for Indian Stock Options Traders M Kanagasabapathy   According to SEBI , a bout 89% of individual F&O, options traders lost, with average loss of ₹1.1 lakh. SEBI's updated report shows 93% of individual traders incurred losses.   General risk management, for minimizing the loses 1. Never risk more than 1.5 % of trading capital. For 1,00,000, maximum risk is 15,000.   2. Hedging the position reduces risk of sudden events - Selling a Call option at deep OTM and buying at ATM.   3. Physical delivery risk (critical for stock options)- Since stock options in India are physically settled, avoid holding at ITM on expiry.   4. Always place, correct stop-loss.   5. Never average a losing options, instead take hedging.   6. Book partial profits intermittently.   7. Check Liquidity and volume.   8. Check News and Events.   9. Brokerage cost is significant, eat s...

Video tutorial on how to get live option chain data for NIFTY and Bank NIFTY in Excel sheet - VBA code   Getting Live Option Chain Data (CE & PE) in Excel sheet is handy and useful to predict the market trend for option traders.   Price and open interest (OI) data in Excel sheet can be useful to analyze the directions of NIFTY & Bank NIFTY.   Following Excel gives the Excel VBA code to get live option chain data few Strike Prices above & below Underlying Price in the Excel sheet.   This video tutorial explains the Excel VBA code to get NIFTY and Bank NIFTY option chain data in Excel.   Coded Excel sheet can be downloaded (See the Link below).   Designed by, Dr. M Kanagasabapathy Associate Professor of Chemistry Coordinator, Incubation Centre Rajapalayam Rajus College Madurai Kamaraj University Rajapalayam 626117 (TN)   About Dr. M Kanagasabapathy     Download the Exc...

Fetch the last traded price (LTP) as well as Price Change (%) for NIFTY 50 (50 stocks) and Bank NIFTY (12 banking stocks) in Excel sheet.   With this the fetched data can be analyzed to predict the price movements of both NIFTY 50 as well Bank NIFTY in Excel.   With the Refresh Button the price data can be updated.   Since the Excel files are VBA Macro based, enable the contents, and allow to fetch the data. ERRORS These works are in beta stage, so there are many unexpected errors. Due to the lag to fetch the data from the NSE server, Run-Time Error can occurs. See the screenshot. Save and close the Excel. Open after some time and Refresh. If it takes long time to fetch the data, close. Open after some time and Refresh. DISCLAIMER These Excel files are designed for purely educational purposes only and strictly not for commercial purposes. Either Dr. M Kanagasabapathy (owne...

          Assume charging a completely discharged capacitor, under resistance, R with an applied potential, E having the capacitance, C. Potential across the capacitor is E c . At time, t = 0s or t o :   E C < E; E C = 0 V. If it is fully charged then E C = E and t = t c . ‘E’ is the maximum potential attained by the capacitor. Time to reach maximum potential is: (t c – t o ).   At any given time, ‘t’ on charging in between t o and t c the potential of the capacitor, E C is related to the maximum potential, E by the relation, where ‘t’ is the elapsed time during charging ‘R’ is the resistance in Ω ‘C’ is the capacitance in F.   The product of R and C is called the time constant and is represented as, τ. So, τ = R × C.   Unit for τ τ = R × C = Ω × {F} = Ω × {C × V –1 } C = Charge in Coulombs = A × s = Ω × {A × s × V –1 } = = Ω × ...