Signatures and other personal details have been removed from customer messages.

who bought Black-Scholes Calculator, Option Strategy Simulator, Option Strategy Payoff Calculator, Historical Volatility Calculator, ATR Calculator and Implied Volatility Calculator in November 2017 and Binomial Option Pricing Calculator in February 2020

Hi, I purchased about 5 of your excel models about 2 years ago having been an ex trader. I am now trialling trading the market in single stock options. Your options are models are really great, but appear to be geared towards index and bond products. Do you know how it might be possible to add an EX dividend date to the pricing models so I can trade stock options? I am unable to correctly price or delta the ATM strike .Thank you for your help.

who bought Option Strategy Simulator and Black-Scholes Calculator in December 2017

Petr,

I still think you tool is excellent. I use it daily and don't know what I would do without it. I have one suggestion. I live in Sweden and trade in New York. I would like some way to set the time in OSS for New York time. I have tried changing the time on my desktop but it is clumsy. A way to set New York time in the OSS would be nice.

Comment:

This has a simple solution (which I also use myself). Enter expirations in your local timezone (e.g. 22:15 instead of 16:15 if you trade US markets from Europe). No need to mess with operating system time settings.

who bought ATR Calculator, Implied Volatility Calculator, Historical Volatility Calculator, Option Strategy Payoff Calculator, Option Strategy Simulator, Descriptive Statistics Calculator, Binomial Option Pricing Calculator and RSI Calculator in January 2020

Hi Petr,

I think all the calculators are great. My only feedback is that for the ATR and RSI calcs, it would be handy to be able to calculate 4 or 5 at once (ideally 5) instead of 3 if possible

As an example, especially with the RSI, I like to calculate 10, 20, 60, but it would also be good to be able to add another in at the same time for just 5. Reason being is that its good to see it as far out as 60 for long term, but the 5 can highlight particular flow weeks compared to 10 - and it'd just be good to have the option to graph all at once.

Comment:

In ATR and RSI Calculators, you can draw up to 3 lines (e.g. RSI with 3 different periods) in the chart simultaneously.

It is unlikely this will be expanded to more, because it is sufficient for vast majority of users, but if you really need more lines at the same time, it is possible to customize (generally, all Macroption calculators can be customized).

Hi! I love your OSS product. I was just wondering if it is possible to expand the number of holdings in the calculator to 10 or 20 so I can model my entire portfolio? Thanks again!

Comment:

More legs in the Option Strategy Simulator has been frequently asked for and will come in a future update. Currently OSS supports up to 5 legs, which is enough for all standard strategies (condors need the most - 4).

who bought ATR Calculator, Implied Volatility Calculator, Historical Volatility Calculator, Option Strategy Payoff Calculator, Option Strategy Simulator, Descriptive Statistics Calculator, Binomial Option Pricing Calculator and RSI Calculator in January 2020

Hi again Petr,

just wanted to say thanks - managed to add in the strategy myself and works perfectly.

So helpful to allow additional strategies to be added so easily!

Comment:

In the Option Strategy Payoff Calculator, it is possible to add your own custom strategies in addition to the 54 predefined ones.

who bought Option Strategy Payoff Calculator and Option Strategy Simulator in January 2020

Hi i have recently downloaded your options strategy simulator & your options strategy payoff calculator. They're great!

who bought Implied Volatility Calculator and Option Strategy Payoff Calculator in October 2019 and Option Strategy Simulator and Binomial Option Pricing Calculator in November 2019

Hi there just wondering if it would be possible for you to create or perhaps what it would cost for you to create an Options table importer sheet to bring in and import from say directly this link? http://www.cboe.com/delayedquote/quote-table-download with the idea being that a macro or something could complete those steps automatically from the .dat file and generate an options chain table directly in excel with a shader to generate the ITM/OTM point?

Would just like to also say your website and the calculators are brilliant - well done - its my go to!

Hello Petr,

First of all thank you for making the Option Strategy Simulator. It helps me a lot in visualising what is going on with my strategies. I bought it back in March and worked fine, but recently I stumbled upon a bug. I'm using Office 365 on OSX and since a few months (I guess after some automatic update) the expiration date dropdown shows for example 'nov yyyy' i.s.o. 'nov 2019'. The Days columns still calculates the days to expiration correctly. Can you have a look?

Thank you and kind regards

Comment:

The bug was a system locale issue (Dutch date formats), which we have quickly fixed.

who bought Option Strategy Payoff Calculator in September 2019

Just a quick note of thanks for the great site. I purchased the options strategy calculator and it was the best $25 I've spent in a long time. Really clarified the Iron Condor for me.

who bought Option Strategy Simulator and Implied Volatility Calculator in September 2019 and Binomial Option Pricing Calculator and Option Strategy Payoff Calculator in December 2019

Thanks for getting back with this so quickly. Impressive support thus far.

Thank you very much

I will spread the word...excellent calculators.

who bought Option Strategy Payoff Calculator in August 2019 and Option Strategy Simulator in September 2019

Hi Petr,

I finally ordered the calculator today. I found the guide to be extremely helpful. Thank you for putting together such a smart product. I will recommend it to others.

All the best

who bought Black-Scholes Calculator, Option Strategy Simulator, Historical Volatility Calculator and Implied Volatility Calculator in August 2019

I have purchased several of your spreadsheets and think they are excellent. Good job!. Can you add Calendars to the Option Strategy Payoff calculator?

Comment:

Calendar spreads (and other positions involving multiple expirations) can't be modeled with the Option Strategy Payoff Calculator, because payoff at expiration can't be calculated for them.

For these positions use the Option Strategy Simulator, which provides complete flexibility with expirations.

who bought Black-Scholes Calculator, Option Strategy Simulator, Historical Volatility Calculator and Implied Volatility Calculator in August 2019

Thank you for your response. I've spent some time w the spreadsheets & comparing to other platforms data. I'm very impressed.

Just a suggestion but, maybe if you did some YouTube videos about your product, you could sell more.

Great!

Thanks for your marvellous Calc :)

Hi, I'm using your Strategy Calculator and very happy with that. Now I think about your Payoff Calculator, but missing the Calendar Strategy. Therefor I have to input different dates. Calculation with dates and showing different timelines would be wonderful.

Comment:

Calendar spreads (and other positions involving multiple expirations) can't be modeled with the Option Strategy Payoff Calculator, because payoff at expiration can't be calculated for them.

For these positions use the Option Strategy Simulator, which provides complete flexibility with expirations.

who bought Historical Volatility Calculator in March 2019, Implied Volatility Calculator in April 2019 and Option Strategy Simulator in December 2019

Many thanks, I am very satisfied with your HVC, i am looking to add more to my arsenal.

Bello Petr,

Thank you very much for your help, and so soon after my e-mail!!

The problem is fixed now.

Everything is working correct now.

Again: thanks!!

who bought RSI Calculator in June 2018 and Historical Volatility Calculator in September 2018

I have recently purchased your excellent Historical Volatility product and find it provides me with information to suit my needs

I am an experienced user of Excel and develop systems heavily dependent on VBA background coding

My most recent system is an automated Stock Trading system which relies on indicators such as MACD / RSI / ATR - HV will be a useful addition

who bought Option Strategy Payoff Calculator and Option Strategy Simulator in August 2018

Hi,

It worked fine. I also got OSS.

Great software!

who bought Black-Scholes Calculator, Option Strategy Simulator and Option Strategy Payoff Calculator in May 2018

I do program VBA and write my own user functions in Excel, although so far your spreadsheets seem so complete that I probably won't make any major changes. They have been very helpful in my understanding of options - more than any other medium that I have studied. I've traded equities for many years, and in the short time that I have spent with options, and especially from doing some simulations in your programs, I have confirmed my original suspicion that as with equities, you still need to have a good understanding of the technical and fundamental basis of stock price movement to profit from the derivatives.

I do appreciate your excellent technical support that is so difficult to find these days.

Very well done! Thank you

who bought Option Strategy Payoff Calculator in March 2018

Petr,

I just bought the Option Strategy Payoff Calculator. It works as expected. Thank you.

who bought Option Strategy Payoff Calculator and Option Strategy Simulator in February 2018

Recently retired and now have more time to do some things I never had time for before. You have a great product and I thank you for that.

who bought Option Strategy Simulator and Black-Scholes Calculator in December 2017

Hi Petr,

I have worked quite a lot with simulations now. I don't think there is anything you forgot. I have just tested out a very funny (my patent) combo. When I ran it on the simulator, it worked fine. What I like is that after certain legs expire, I can just replace them with new legs and continue to expiration. It is also helpful to decide if it is a good time to close an combo before expiration. What I think is really useful is when I am not happy with the way a combo is performing, I can simulate adding a put or selling another call or rolling a strike to another price to tweek the combo. Then I can test it to see if the idea was right before committing to buy/sell.

Also, the simulator tracks live combo's very closely. I can easily see if the market is mispricing legs of a combo as well. And I like that I can use IV for each individual leg.

Great stuff.

who bought Black-Scholes Calculator, Option Strategy Simulator and Implied Volatility Calculator in June 2017

I truly appreciate your work. It's awesome with the graphics as well. I love it and I think it's easy to use.

who bought Black-Scholes Calculator, Option Strategy Payoff Calculator and Historical Volatility Calculator in July 2017

Nice work Petr,

I am a nearing retirement Petroleum Engineer that has been using Excel and later VB and Excel, since 1988, and have done some very nice work with them through the years that has turbocharged my career, so I hope you appreciate the compliment.

Your .pdf files are great - very descriptive and your Excel is very clean and straightforward. I haven't peeked at the Macro's but I can imagine they are nice too.

I am very new to the game of options (weeks and days). My old boss and his son are in the game extensively and reached out to me for help. So naturally I started with Black Sholes in Excel, but I had no verification of errors. The $25 was well worth it for verification alone, but yours is far more than mine, so I was able to drop the effort. I hate "compiled software", if I can't calculate it myself in Excel i don't trust the numbers

You have saved me many, many hours, and I look forward to working with your other two products. Great value in my opinion. i'll probably buy the rest of your set, once I've mastered the three. I've been using Goal Seek for Implied Volatility manually - bet you have it in a Macro.

who bought Implied Volatility Calculator, Option Strategy Simulator and Historical Volatility Calculator in June 2017

Thanks, love the file btw!!

who bought Option Strategy Payoff Calculator, Black-Scholes Calculator, Implied Volatility Calculator, ATR Calculator and Historical Volatility Calculator in June 2017 and Binomial Option Pricing Calculator in December 2019

Petr,

Your customer service is absolutely outstanding. The best and easiest that I have ever encountered.

Thank you very much.

who bought Black-Scholes Calculator and Implied Volatility Calculator in May 2017

Fantastic, thanks. So many people are to vague or way too detailed, technical, speaking words I don't understand and would have to study a lot to understand, when all along when you get to the bottom of it, there is no need to get that deep.

What you supplied is perfect; usable, actionable information that makes sense and immediately gives me knowledge and understanding, thorough and complete enough that I don't window up with just a whole lot more questions. These same qualities are in your website.

Really good stuff!! Not the norm at all.

I'll no doubt be purchasing some more of your spreadsheets.

Thanks again

who bought Option Strategy Simulator in June 2016 and Black-Scholes Calculator, Implied Volatility Calculator, Historical Volatility Calculator and Descriptive Statistics Calculator in April 2017

I have a bunch of your calculators and they all work great - plus they are simple to use!

Do you do user requested calculators?

Comment:

For custom work, see Services.

who bought Option Strategy Payoff Calculator, Option Strategy Simulator and Implied Volatility Calculator in February 2017

Thank you.

Now, i will study and come back if I need help.

Looks nice. You have done good job ......I am impressed.

Dear Sir,

thank you for the software, great work! Looking forward for more. Maybe integrate a skew model?

Kind regards

who bought Black-Scholes Calculator, Option Strategy Payoff Calculator, Option Strategy Simulator and Implied Volatility Calculator in February 2017

Hi Petr,

I just purchased a couple of excel models.

I haven't checked all of them but i'm looking at the implied volatility model. I'm so impressed by the sophisticated functions!!

I'd trying to customize the model to suit my use. And in the model cell B36, which is the output for the IV, I cannot see how the value is calculated. Is there anyway I can track the calculation? Thank you very much.

Comment:

Model calculations are explained in each calculator's user guide (and also in the various tutorials on the website).

who bought Black-Scholes Calculator, Option Strategy Payoff Calculator, Option Strategy Simulator and Implied Volatility Calculator in February 2017

I see. Thank you very much for guiding me to the right direction.

What I'm trying to do is incorporating Bloomberg ADI to the spreadsheets so I can get a live trading data feeding to the models.

Bloomberg terminal has a quite comprehensive system of database, charting, etc but I'm using your excel models to complement my end use, which is so brilliant!!

Pleasure doing business with you Petr.

Thank you

Comment:

All the calculators can be linked to external data sources such as Bloomberg BDP, Reuters, broker data feeds - generally anything that can be linked to Excel. For example, you can have the underlying price input updated in real time using data from your broker.

who bought Option Strategy Payoff Calculator, Option Strategy Simulator and Descriptive Statistics Calculator in November 2016

Hi Petr,

I'm making extensive use of your spreadsheets and they've helped me with my work and research.

In the OSS spreadsheet is there a way to increase the number of legs? I saved the spreadsheet under a different name and tried inserting new rows and that didn't work. Unfortunately I have enough knowledge of excel to be dangerous.

Thanks

Comment:

More legs in the Option Strategy Simulator has been frequently asked for and will come in a future update. Currently OSS supports up to 5 legs, which is enough for all standard strategies (condors need the most - 4).

A few days ago I bought your Option Strategy Symulator. I am delighted with your product and it has helped me a lot to simulate my strategies with options.

Hi,

I just bought your Excel options calculator. It looks to be very good and what I was looking for.

who bought Option Strategy Payoff Calculator, Option Strategy Simulator and Descriptive Statistics Calculator in November 2016

Fantastic spreadsheets. I've been looking for a long time for something like them.

who bought Option Strategy Payoff Calculator and Option Strategy Simulator in September 2016

Dear Sir/Madame:

Good day. I just bought the "Option Strategy Payoff Calculator". I took a quick tour and I am impressed with the quality of the file. Though, I was actually looking for the diagonal strategy to be included. I do not know if it's missing or may be it can not be done. Please advise.

Sincerely yours;

Comment:

Calendar and diagonal spreads (and other positions involving multiple expirations) can't be modeled with the Option Strategy Payoff Calculator, because payoff at expiration can't be calculated for them.

For these positions use the Option Strategy Simulator, which this customer also got.

who bought Black-Scholes Calculator in March 2016 and Option Strategy Payoff Calculator, Option Strategy Simulator, Implied Volatility Calculator and Historical Volatility Calculator in August 2016

The Black-Scholes spreadsheet has really helped my understanding of the formula. Thank you for putting these spreadsheets together.

who bought Black-Scholes Calculator, Option Strategy Payoff Calculator, Option Strategy Simulator, Implied Volatility Calculator, Historical Volatility Calculator, ATR Calculator, RSI Calculator and Descriptive Statistics Calculator in June 2016

Hello Petr,

Sorry for the late answer. Unfortunately I was on vacation in Thailand and didn't get internet access. So I was unable to receive your e-mail. I really apologize for the inconvenience.

Thanks so much for your support. Today I tried your new file. It works perfect. Thanks so much. I really appreciate your grate support.

Best regards

Petr,

All Good, very happy with the product. I had to use the email rather than website.

Will purchase the other products over the weekend.

If the download doesn't work I'll let you know Monday and you can send them direct via email.

Apologies for all the hassle, old Market Makers tend to be modern technology allergic...!!!

who bought Option Strategy Simulator and Option Strategy Payoff Calculator in June 2016

your excel options calculators are something i was looking for for a long time.

is there a way to IMPORT option prices instead of typing it all in ... i use IB (interactive brokers) as well as the tradestation, both live data.

i am getting the strategy simulator as well as the strategy payoff calculator to work with now.

thanks

Comment:

All the calculators can be linked to external data sources such as Bloomberg BDP, Reuters, broker data feeds - generally anything that can be linked to Excel. For example, you can have the underlying price input updated in real time using data from your broker. Interactive Brokers data works too.

Petr - thanks! Really like it - I've been doing much of it in makeshift excel sheets on my trading sheets - this is exactly what I was needing!

who bought Implied Volatility Calculator, Option Strategy Simulator and Historical Volatility Calculator in February 2016 and Binomial Option Pricing Calculator in February 2020

Hello Petr,

I ended up purchasing the Implied Volatility Calculator, the Historical Volatility Calculator and the Option Strategy Simulator. They are all great. Are you going to add the ability to enter a time to expiration of less than 1 day? I deal a lot with very short term options and noticed that the Black-Scholes Calculator had it so I assumed that the Option Strategy Simulator would also have it. It is a feature I really need and I was hoping that I would not have to purchase the other spreadsheet on top of the one I already purchased.

Thanks

Comment:

This was the earliest version of Option Strategy Simulator which only worked with end of day pricing. Now it also works intraday without any limitations.

Over the years, the calculators have been improved and features added also based on customer feedback like this one. It is always welcome and appreciated!

Comment:

Discrete dividends are supported in the Binomial Option Pricing Calculator, which this customer ended up buying.

Black-Scholes Calculator and Option Strategy Simulator (and Binomial Option Pricing Calculator as well) support continuous dividends, which are easier to work with and sufficiently accurate in most cases (except when the dividend is very soon and very big).