Software for backtesting Options portfolios

Discussion in 'Options' started by vladbby, Aug 2, 2017.

  1. vladbby

    vladbby

    Hello Everyone,

    I'd appreciate if someone can recommend me an options software/database that will help me with the following:

    Here's what i'd like to backtest: I have a list of tickers, and on a specific day I'd like to buy/sell ATM calls/puts for each single one of them, and would like to check the PNL of each position and the entire portfolio on another day in the future. There're many stocks and many periods that I'd like to backtest, so manually is not an option. It doesn't have to be software, could just be a database that can be imported into Excel/R. DOESN'T have to be free, I'm ready to pay for something that will get the job done.

    Any advice on what would be the best way to do it?

    Thank you
     
  2. are you putting criteria or filter on your stocks? or just buy an ATM spread daily?
     
  3. 1) Do you only require EOD data? -- or finer granularity, such a minute? - Costs range from free, to > $20K for data. (how much history do you require? -- 180 days, 10 years, ...?)
    2) Will you develop your software, or do you want someone to develop for you?

    Your request seems vague, but perhaps you are testing the waters here!
     
  4. truetype

    truetype

    ajacobson likes this.
  5. vladbby

    vladbby

    No, I filter stocks ahead of time, and have a list of tickers that I'd like to backtest. I'm also only looking to do one sided trades - no spreads.

    Yup, only EOD is fine. The longer, the better. 7+ yrs at least, preferably more.

    I'm not looking to do any heavy stats, just need to get portfolio values and drawdowns. I'd prefer to just use Excel or R, if I can get the data i need.

    This looks interesting, thank you!
     
  6. TT is a Font of knowledge! :D

    Good trading to all.



     
    vladbby likes this.
  7. solk

    solk

    I can't seem to find pricing information