Search results

  1. K

    How to create an Excel table containing butterfly prices

    I've upgraded to v7.87 today. Besides fixing the critical problems of 7.86, what I'm most excited about is the ability to add suffix to the file name to be exported. Before this version, the exported file will overwrite any file with the same file name. Therefore, the auto download...
  2. K

    How to create an Excel table containing butterfly prices

    These are good info to study. After looking at IV changes for a period of time, you will develop an intuitive sense of how they change with time and underlying movement. I find that developing a deep understanding of the anatomy of a butterfly trade is more beneficial than learning multiple...
  3. K

    How to create an Excel table containing butterfly prices

    Hi, Actually Ron Bertino has done an in depth discussion of how skew works and how it affects a trade, using a IV skew comparison graph I did. It very well done. Have you seen it ?
  4. K

    How to create an Excel table containing butterfly prices

    Hi Sergei, I'm glad what I shared could help. My answers to your questions : 1. The analysis of options behavior isn't an exact science. Unlike physics or engineering where the measurements are precise, options analysis is at best a crude approximation of reality. Therefore, analyzing 10 pts...
  5. K

    How to create an Excel table containing butterfly prices

    Hi all, I did an interview with John Locke few weeks ago and during the interview I showed an Excel table that I use to monitor butterfly prices. I received emails asking me how that table was generated. So I thought it's easier if I just record a video to show. Here it is....
  6. K

    Excel for Options Trading

    Sorry for the delay. My July schedule is packed and I’ll be traveling most of August. I’ll try to find time to do it Sep.
  7. K

    thoughts of experience trader on all income trading strategies

    There is no strategy, RTT or any other, that is all weather proof. A strategy will work in certain market environment and not in others. Question is whether the strategy produces positive expected value over the long term and whether the behavior of the strategy fits a trader's personality. If...
  8. K

    Excel for Options Trading

    3D charts is an Excel function. Once you have the data, creating it is easy. VBA is more convenient but not necessary in most cases. The objecitve of the videos is to help traders create applications without VBA in most part. In the later videos, I might introduce some simple VBA that can spice...
  9. K

    Excel for Options Trading

    Yes, I think I have seen the IB spreadsheet before in other presentations that he presented. But I haven't used it myself. I use TOS primarily as the live data source. This reminds me I haven't had time to update the youtube video... totally swamped. Hopefully I can get back to that soon.
  10. K

    Excel for Options Trading

    I used to record synthetic mid prices along with many other parameters using VBA every 15 mins every day. That was part of my learning and getting familiar with prices in different market environment. But I don't do that anymore. Nowadays I just use OV Spread function to compare before I do a trade.
  11. K

    Excel for Options Trading

    You have to put the OFFSET formula inside the named ranged like below
  12. K

    Excel for Options Trading

    When I was using 2007 or 2003, I can't remember which version for sure, I could move the validation list table to another sheet by using named range. That means firstly, you move the validation table to a blank sheet, create a named range and put the OFFSET formula in the named range. After that...
  13. K

    Excel for Options Trading

    Uploaded part 3. Remember to view in 1080P. Otherwise the words might not be clear enough.
  14. K

    Excel for Options Trading

    This is part 2 of the series
  15. K

    M3 - The best strategy?

    Stock = Call - Put Therefore Stock - Call = - Put. So a covered call is synthetically equivalent to a naked short Put. Naked short Put works wonder during a up market but horribly in a down market.
  16. K

    Excel for Options Trading

    You're right... I realized I lost a segment of the videos during editing. Not sure why. My bad. In the next video, I zoom in more. I have a 34 inc monitor. I didn't realize how small the text can look in a normal monitor.
  17. K

    Excel for Options Trading

    I've just started a YouTube video series on building simple but useful options trading applications with Excel. Meant for traders who wish to learn how to connect Excel to Thinkorswim (TOS) and some other spreadsheet techniques to manipulate options data, including live data and OptionVue (OV)...
  18. K

    M3 - The best strategy?

    This is so true.... I have been trying to find protection that doesn't cost too much. I have seen people promoting so-called "free" hedge but those are not really free. In a nutshell, it's using some form of credit spreads or even naked shorts to pay for the cost of hedge either entirely or...
  19. K

    Optionvue Update

    Firstly, the context is the skew must be flat to begin with. That means, the expectation is for the skew to steepen once the market moves up and the IV drops. IV of strikes above ATM will drop relative more than IV of strikes below ATM. In that case, it's advantageous to place the short above...
  20. K

    Sheridan Mentoring $4k on 20K monthly

    Interesting discussions.... I do want to pick up on a point that Srini made, which I think is extremely important. To me, the primary objective of back testing isn't to find out whether a strategy will offer x% or y% profits, but rather to study in detail how the strategy will perform in various...
Top
Contact Us