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

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

I am existing customer of yours. really like what you created with your calculators.

Im fairly new to options trading, been doing it for about 2 years now. still a lot of learning.

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

I bought your spreadsheets and they're great.

Hi, I just downloaded the option portfolio manager. I'm new to options and was looking for a solution and your calculator is perfect.

Petr,

Thanks for your introduction. I recently purchased the Option Portfolio Manager, and the workbook is just what I was looking for to explore the setup of complicated, multi-leg option strategies, in particular iron condors combined with double diagonals.

who bought Option Strategy Simulator and Option Strategy Payoff Calculator in December 2021

I purchased few of your calculators and its awesome.

Hi Petr,

This tool is really amazing. For this I have been struggling for the past 2

years. Thanks a Million for creating such an Awesome Product.

Hello,

I have used the model and it works well. However, I inadvertently

overwrote the cell that calculates call delta and it no longer

calculates it.

How do I repair it?

who bought Option Strategy Payoff Calculator in April 2022

Have been looking at your files and really like them. I have my own but they don't look near as neat and organized as yours.

who bought Black-Scholes Calculator, Implied Volatility Calculator and Futures Price Calculator in March 2022 and Historical Volatility Calculator in April 2022

Hi Petr,

Awesome, thanks so much. Your calculators are super helpful, thanks for making these available to people like me who don't have the time to get into the excel part of the work, helps so much having these.

I have been using your "Option Strategy Payoff Calculator" for about a year. Great.

I have been working on a trading indicator and comparison sheet in Excel. I downloaded you ATR calculator and really like its clean design and easy to use interface. Do you have an hourly rate you charge for custom excel work?

Comment:

For more details on custom work, see Services.

Wow! awesome! Thank you Petr.

I just bought your RSI indicator, thanks for good work.

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

I own a bunch of your spreadsheets and they are great.

who bought Option Strategy Simulator and Option Strategy Payoff Calculator in December 2021

I've purchased your Option Stimulator and OSPC for quite sometimes and it really benefit me.

who bought Option Strategy Payoff Calculator in October 2021

Having an awesome time utilizing your payoff calc!

I must say a good job on excel.

who bought Black-Scholes Calculator, ATR Calculator, RSI Calculator, Descriptive Statistics Calculator, Option Strategy Simulator, Option Strategy Payoff Calculator, Binomial Option Pricing Calculator, Price Probability Calculator and Option Portfolio Manager in December 2021

I'm an advanced Excel guy and your instructions are top notch. I really enjoy going through this and using your calculators.

who bought Historical Volatility Calculator in December 2021

Thanks for getting back to me so quickly!

Your guidance was very helpful. We have our own simplistic volatility calculation in excel and I wanted to validate it. Both Models get the same result. Thank you!

who bought Option Strategy Simulator, Option Strategy Payoff Calculator and Price Probability Calculator in November 2021

Hello,

I recently purchased the Price Probability Calculator, works well.

who bought Option Strategy Payoff Calculator in November 2019, Option Strategy Simulator in December 2019, Binomial Option Pricing Calculator in April 2020, Black-Scholes Calculator in December 2020 and Price Probability Calculator and Option Portfolio Manager in October 2021

Perfect!! it worked! thanks Petr once again for the awesome support!

who bought Option Portfolio Manager in November 2021 and Implied Volatility Calculator in December 2021

Petr, thanks I got it to work, I like your spreadsheet, exactly what I was looking for!

who bought Implied Volatility Calculator, Option Strategy Simulator and Binomial Option Pricing Calculator in December 2020 and Historical Volatility Calculator in January 2021

Hi,

excellent, thanks!

Perfect service!

:)

who bought Black-Scholes Calculator, Historical Volatility Calculator, Implied Volatility Calculator, Option Strategy Simulator and Option Strategy Payoff Calculator in May 2019 and Price Probability Calculator and Option Portfolio Manager in October 2021

Love your products, if you need a review or survey feedback, i would be glad to help!

who bought Black-Scholes Calculator in March 2019 and Historical Volatility Calculator in October 2021

I want to thank you for your spreadsheet. I used it quite offen

Thank you

who bought Black-Scholes Calculator in January 2013 and Option Strategy Simulator in March 2019

Hi, I bought the Option Strategie Simulator a while ago and I am very satisfied with the product.

I purchase your ATR calculator and I find it easy to use and well designed.

who bought Option Strategy Simulator in September 2021

Hi Petr, I just bought the OSS calculator. I am very impressed by what you have put together. It's a remarkable library of useful tools you have on your website. More than likely I will purchase more in the future.

who bought Option Strategy Simulator, Option Strategy Payoff Calculator and Binomial Option Pricing Calculator in July 2021 and Price Probability Calculator, Historical Volatility Calculator and Descriptive Statistics Calculator in August 2021

Thanks a lot, I bought a bunch more of the calculators. They are really great.

who bought Black-Scholes Calculator and Historical Volatility Calculator in August 2021

Petr -

Perfect; all is working now. Thanks for the fast response!

BTW:

I have written a lot of Excel macros over the years, and kudos to you for

the extremely clean and intuitive layout you have in these! :)

Well done!

who bought Option Strategy Simulator and Option Strategy Payoff Calculator in July 2021

Thanks Petr!

Great work that you have done there!

I'm a financial analyst for the chemical industry and have recently started

studying options... I'm focused on the Sell Put/Sell Covered Call side

right now, and have used your software to help verify my own math on a put

I sold on TSLA

who bought Option Strategy Payoff Calculator in July 2020, Black-Scholes Calculator in October 2020 and Option Strategy Simulator in July 2021

Good Morning, I have three of your calculators the Option Strategy Payoff, Option Strategy Simulator and the Black-Scholes calculator, I really appreciate your work and the benefits that I derive through the application of these calculators in my trading.

who bought Black-Scholes Calculator in March 2021, Option Strategy Simulator in April 2021 and Option Strategy Payoff Calculator in October 2021

Thank you. I already bought the OSS a few weeks ago.. Yes, I would love to get a new copy and beta test for you. These programs help me manage my hedging. I have two and I am pleased.

who bought Black-Scholes Calculator, Historical Volatility Calculator, Implied Volatility Calculator, Option Strategy Simulator, Option Strategy Payoff Calculator, Binomial Option Pricing Calculator and Price Probability Calculator in May 2021

What a wonderful job!

for the price of a month's subscription of the best sites on option strategies, I got the same or better results.

Bravo Petr

who bought Black-Scholes Calculator and Option Strategy Simulator in April 2021

I just purchased your Option Strategy Simulator and I am very happy using it and I am very impressed by that excellent work.

who bought Option Strategy Simulator in February 2021, Option Strategy Payoff Calculator in March 2021, Black-Scholes Calculator, Binomial Option Pricing Calculator, Price Probability Calculator, Historical Volatility Calculator and Implied Volatility Calculator in July 2021 and Option Portfolio Manager in September 2021

Thank you so much. Also i want to tell you that you made an amazing job with that. Thanks so much for this wonderful world. I am very happy for that excel.

who bought Black-Scholes Calculator, Historical Volatility Calculator, Option Strategy Simulator, Option Strategy Payoff Calculator, Binomial Option Pricing Calculator, Futures Price Calculator and Price Probability Calculator in February 2021

Ok, thank you for clearing things up for me. As you produce more tools, I will be sure to purchase more from you. I'm already very impressed with my purchase.

Thank you and Good luck

who bought Option Strategy Payoff Calculator in February 2021

I have used Excel for about 20 years and I have never seen anything so incredible. You've turned Excel into an application platform. Your spreadsheets should win awards.

I have been struggling to gain an intuitive understanding of options strategies and having your payoff calculator at hand is like having a superpower. Not only that, you've made the calculations transparent, even explaining them in detail in your tutorials. Amazing.

So thanks for all of your hard work, both on the calculators and on the tutorials.

who bought Option Strategy Payoff Calculator and Implied Volatility Calculator in March 2020, Historical Volatility Calculator and Black-Scholes Calculator in September 2020, ATR Calculator in January 2021 and Price Probability Calculator in March 2021

I am an option trader from Hong Kong. I've bought some calculators from you and it is really helpful for me.

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

I purchased the "Option Strategy Payoff Calculator," and the "Option Strategy Simulator," and wanted to thank you for creating 2 great products.

who bought Option Strategy Payoff Calculator in January 2021, Historical Volatility Calculator, Implied Volatility Calculator and Price Probability Calculator in February 2021 and Option Portfolio Manager in August 2021

Just got a copy of OSS, nice interface and very easy to use.

who bought Option Strategy Simulator and Option Strategy Payoff Calculator in October 2019, Black-Scholes Calculator and Binomial Option Pricing Calculator in April 2020, Price Probability Calculator in March 2021 and Historical Volatility Calculator, Implied Volatility Calculator and Option Portfolio Manager in January 2022

I would like to try your price probability calculator if possible. I have purchased the OSPC, OSS, BS, and Binomial calculators in the past and found them to be very useful.

who bought Option Strategy Simulator and Option Strategy Payoff Calculator in March 2018 and Black-Scholes Calculator and Implied Volatility Calculator in December 2020

Hi Petr,

Just a review for your website if you want to post it.

I had previously purchased the OSPC and OSS calculators and have just purchased the BSC and IVC calculators. As i am now taking options trading more seriously i just want to thank you for creating these calculators which i have to say i cannot find anywhere else and at such very reasonable prices.

I would highly recommend your site to anyone who trades or is looking to trade options.

who bought Black-Scholes Calculator, Option Strategy Payoff Calculator and Binomial Option Pricing Calculator in December 2020

Hi, I just started using your BOPC, OSPC and Black-Scholes calculator and I would love to also try the Future Price calculator.

Your bsc excel work so well. I am still using it everyday.

who bought Option Strategy Payoff Calculator in October 2020

I am very much impressed with the OSPC

who bought Option Strategy Payoff Calculator in October 2020

Hello!

I bought your OPSC spreadsheet yesterday and have been playing around with it. It is the best/only spreadsheet that I have found that handles more complex options strategies. Thank you for such a great product!

who bought Option Strategy Payoff Calculator in October 2019

I had purchased the OSPC calculator, which is arguably the best $29 I have spent ever.

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

I got your OSS (and then the OSPC) and I'm extremely impressed. I rarely trust anyone's code and do things from scratch but since trading and generally portfolio management is not an everyday job for me (I have a completely different full-time job), I don't have time to prepare everything from scratch. I have enough understanding to be able to customize an already prepared Excel sheet/Python code.

I'm already planning to buy most of your Excel sheets (although I have mine, yours are much cleaner and come with your support).

Thank you so much for the great service

who bought Black-Scholes Calculator and Option Strategy Payoff Calculator in June 2017, Option Strategy Simulator and Historical Volatility Calculator in July 2017, Implied Volatility Calculator in May 2018, Descriptive Statistics Calculator in June 2018, Binomial Option Pricing Calculator in February 2020, Price Probability Calculator in February 2021 and Option Portfolio Manager in August 2021

Hi Petr,

Thank you for the quick response. I feel so lucky to have found your site. I tried many option tools and your calculators are the most intuitive and reasonably priced calculators. And I'm very good at google searching. Thanks again and look forward to the next release.

who bought Black-Scholes Calculator, Historical Volatility Calculator and Descriptive Statistics Calculator in July 2020

Hi Petr,

I have bought the Black - Scholes Calculator, Historical Volatility and Descriptive Calculator - very helpful thank you!

who bought Binomial Option Pricing Calculator in July 2020

Thank you for providing these Excel sheets.

Thank you Petr.

I was already impressed by your website

and the detailed information that it provides.

Now I am impressed by your customer service as well.

Many thanks for this wonderful resource.

I have to congratulate you on your web site and the tremendous work put into your spreadsheets.

Dear Petr,

Your tool is really nicely built and very intuitive to manipulate.

Congratulations for your great work and thank you ?

It is very useful for me.

who bought Option Strategy Simulator in April 2020 and Option Strategy Payoff Calculator in May 2020

Hi Petr, I hope all is well.

I bought your OSPC as well and both of them are amazing tools.

who bought Black-Scholes Calculator, Option Strategy Simulator, Historical Volatility Calculator, ATR Calculator, Implied Volatility Calculator and Option Strategy Payoff 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.

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).

who bought Option Strategy Simulator and Black-Scholes Calculator in December 2017 and Binomial Option Pricing Calculator in September 2021

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 Historical Volatility Calculator, ATR Calculator, Implied Volatility Calculator, Option Strategy Simulator, Option Strategy Payoff Calculator, 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:

To model complex positions with more than 5 legs, you can use the Option Portfolio Manager.

who bought Historical Volatility Calculator, ATR Calculator, Implied Volatility Calculator, Option Strategy Simulator, Option Strategy Payoff Calculator, 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 Simulator and Option Strategy Payoff Calculator 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 Implied Volatility Calculator and Option Strategy Simulator in September 2019 and Option Strategy Payoff Calculator and Binomial Option Pricing 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, Historical Volatility Calculator, Implied Volatility Calculator and Option Strategy Simulator in August 2019, Descriptive Statistics Calculator in June 2020 and Option Strategy Payoff Calculator in July 2022

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, Historical Volatility Calculator, Implied Volatility Calculator and Option Strategy Simulator in August 2019, Descriptive Statistics Calculator in June 2020 and Option Strategy Payoff Calculator in July 2022

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 :)

who bought Option Strategy Simulator in January 2019 and Historical Volatility Calculator and Option Strategy Payoff Calculator in May 2021

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 Simulator and Option Strategy Payoff Calculator 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 and Binomial Option Pricing Calculator in September 2021

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, Implied Volatility Calculator and Option Strategy Simulator 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, Historical Volatility Calculator and Option Strategy Simulator in June 2017

Thanks, love the file btw!!

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

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, Historical Volatility Calculator, Descriptive Statistics Calculator and Implied Volatility 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 Implied Volatility Calculator, Option Strategy Simulator and Option Strategy Payoff 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, Implied Volatility Calculator, Option Strategy Simulator and Option Strategy Payoff 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, Implied Volatility Calculator, Option Strategy Simulator and Option Strategy Payoff 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 Descriptive Statistics Calculator, Option Strategy Simulator and Option Strategy Payoff 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:

To model complex positions with more than 5 legs, you can use the Option Portfolio Manager.

who bought Option Strategy Simulator in December 2016 and Implied Volatility Calculator in April 2020

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 Descriptive Statistics Calculator, Option Strategy Simulator and Option Strategy Payoff 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 Historical Volatility Calculator, Implied Volatility Calculator, Option Strategy Simulator and Option Strategy Payoff 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, Historical Volatility Calculator, ATR Calculator, RSI Calculator, Descriptive Statistics Calculator, Implied Volatility Calculator, Option Strategy Simulator and Option Strategy Payoff 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 Historical Volatility Calculator, Implied Volatility Calculator and Option Strategy Simulator 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:

If you happen to lose or inadvertently overwrite the calculator file, you can always download it again from the website. You will also have access to future updated versions at no extra cost.