Low Risk Options Trading Strategy - Option Spreads

[adityasaraf007]

Thanks a lot Aditya :thumb:, will try it out

Thanks
NT

EDIT: Shows today's data and nice graphs on sheet 2 & 3, will it auto update every day or i need to put it in the oven

You would just have to refresh the Sheet to fetch the latest data from NSE.... From Data Tab >> in the Connections area >> Refresh All (Ctrl+Alt+F5)....

And some adjustments have to be made when the total number of Strikes changes (generally at the time of new Series)...... Nothing difficult, just basic stuff....

 

[VJAY]

You would just have to refresh the Sheet to fetch the latest data from NSE.... From Data Tab >> in the Connections area >> Refresh All (Ctrl+Alt+F5)....

And some adjustments have to be made when the total number of Strikes changes (generally at the time of new Series)...... Nothing difficult, just basic stuff....

Dear Aditya,
Thanks for sharing this sheet with us.....can you please explain how can we modify for get other scrips like RIL/LT?

 

[adityasaraf007]

Dear Aditya,
Thanks for sharing this sheet with us.....can you please explain how can we modify for get other scrips like RIL/LT?

1. Open that Excel File...... Navigate to the Data Tab >> In the Connections Area >> Click on Connections

2. In the Window that Opens up.... there is already a "Connection" present.... Select that and click on Properties....

3. A new Window would open up..... It has two tabs: "Usage" & "Definition".....

4. Under "Usage" Tab there are various Refresh Options..... Select those as per your preferences......

5. Under "Definition" Tab.... Click on "Edit Query..."

6. A new Browser Window would pop up inside Excel...... It would automatically open the Option Chain Page for Nifty..... If you want it for Reliance..... then type Reliance in the field "Search for an Underlying Stock".... and Hit the "Go" Button as you do in a normal Browser....

7. The page would refresh and show the data for Reliance.... Now, Click on the "Import" Button..... It would copy the data in Excel and save the query.....

8. You shall now see the charts getting updated.... This is just a one time process.....

9. Next time, just go to the Data Tab >> and press Refresh All (Ctrl+Alt+F5)....

 

[dashr]

That's great work. How did you create such an automated excel file?

 

[NTrader42]

Thanks Aditya

So you have send in the cake, the recipe and the oven :thumb:

Thanks
NT

 

[adityasaraf007]

That's great work. How did you create such an automated excel file?

Open a New Excel Workbook..... Navigate to Data Tab >> there's an area called "Get External Data" >> Over here there's an option called "From Web".... This pops a browser within excel...... So, if you want to import any Tables from a Webpage, you may use this option...... For further information on this you may refer the Help Manual present within Excel......

 

[DanPickUp]

Thanks Aditya

So you have send in the cake, the recipe and the oven :thumb:

Thanks
NT

But not the taste :lol:

 

[adityasaraf007]

Does anyone want the Charts of OptionPain in that Excel File.......

If you said yes.... then wait for the new Series to begin ie; 27th Jan....... Since, Total number of Strikes available would change, the formulas have to be adjusted in all the cells..... And the formula for Option Pain is very Long and in all the cells it has to be feeded manually...... So, once the new Series starts would prepare an Option Pain Sheet for it..... And then, you would have to adjust the formulas when the Total Number of Strikes changes the next time......

Till then, if someone has any better solution..... Do share it with us.....

 

[VJAY]

1. Open that Excel File...... Navigate to the Data Tab >> In the Connections Area >> Click on Connections

2. In the Window that Opens up.... there is already a "Connection" present.... Select that and click on Properties....

3. A new Window would open up..... It has two tabs: "Usage" & "Definition".....

4. Under "Usage" Tab there are various Refresh Options..... Select those as per your preferences......

5. Under "Definition" Tab.... Click on "Edit Query..."

6. A new Browser Window would pop up inside Excel...... It would automatically open the Option Chain Page for Nifty..... If you want it for Reliance..... then type Reliance in the field "Search for an Underlying Stock".... and Hit the "Go" Button as you do in a normal Browser....

7. The page would refresh and show the data for Reliance.... Now, Click on the "Import" Button..... It would copy the data in Excel and save the query.....

8. You shall now see the charts getting updated.... This is just a one time process.....

9. Next time, just go to the Data Tab >> and press Refresh All (Ctrl+Alt+F5)....

Wow!!!! great ...thanks Aditya....

 

[NTrader42]

I will try to track the above position for Feb Series,

The books say it is called an Long Iron Condor.

Basically a short Strangle with wings for protection from extreme moves.


Thanks
NT