What is the point of doing a Calendar Spread?

Discussion in 'Options' started by RGLD, Dec 22, 2016.

  1. RGLD

    RGLD

    I wish i had access to historical option closing prices. That way we can do a comparison between the 2 strategies.
     
    #21     Dec 23, 2016
  2. RGLD: Do you have TOS and Excel?
     
    #22     Dec 23, 2016
  3. RGLD

    RGLD

    I have scottrade pro and excel.
     
    #23     Dec 23, 2016
  4. With TOS, you can RTD to Excel, and can manually set date/time to access historical data. (Excel is there only to allow automation of the data you access)
     
    #24     Dec 23, 2016
  5. RGLD

    RGLD

    I wonder if scottrade has it too. Scott pro was made as an advanced options platform to compete with TOS. So I'd be surpised if they didnt have this as well.
     
    #25     Dec 23, 2016
  6. xandman

    xandman

    The horizontal takes advantage of how the vol curve could evolve. Not a big source of risk/return, but a keen optimization of the desired exposure. You might also be able to make a new spread with a nice positioning after the front month goes into expiration...morphing the exposure.

    Some days, I question all the trouble that I make for myself.
     
    #26     Dec 23, 2016
    RGLD likes this.
  7. To my knowledge, TOS is only broker that supports RTD. And is only broker supporting historic data via RTD. You can purchase data from Livevol (and perhaps others), that may result in less work.
     
    #27     Dec 23, 2016
  8. Robert Morse

    Robert Morse Sponsor

    Do you mean an excel link?
     
    #28     Dec 23, 2016
  9. Robert:
    The "link" is via RTD. Example formula in Excel is: =RTD("tos.rtd",,"BID",".SPXW161227P2550")
     
    #29     Dec 23, 2016
  10. Robert Morse

    Robert Morse Sponsor

    Silexx OEMS has an Excel DDE link.

    upload_2016-12-23_18-42-43.png
     
    #30     Dec 23, 2016