Finance with Excel: Options Graph

[@ahmedmagdyfarid]

Genius!!!! Very simple and very easy to follow!! Brilliant!!!!!!

[@황순호-j2l]

Could I download that excel file?

[@StkTradr9670]

For a clean end to the macro, add this:
Application.CutCopyMode = False
Range("B6").Select

[@zhengwang1769]

best way to understand various strategies, brilliant,many thanks!!!

[@alireza12399]

Thanks Peter. very good worksheet.

[@PauliedAmaro]

It is not necessary to use Ifs to show the P/L of an option. You can either use Max(0, Strike - St) - Premium for a put or Max(0, St - Strike) - Premium for a call. Makes it a little more elegant and saves you that long formula with Ifs.

[@peterdixon1473]

For access to this file please go my webpage at sites.google.com/site/peternephidixon/home
then click on the link near the bottom called 'Link to Finance With Excel Files', and you can download the file named Options Graph.xlsm.

[@marlierasmus2949]

Good day, Is this Excel file still available from your website?

[@vaclavvanek613]

Thanks man.

[@alvarogutierrezvargas2219]

Wow ! it's fantastic, but could you create a portfolio of options with different excercise dates?

[@billwang66]

Thank you! It helps me a lot!

[@Sonny1337]

Thank you very much, you saved my life :)

[@cherukurisaitharun5012]

wow awesome video

[@yukdavechan47]

Thanks so much, and useful!

[@AZ-lo7md]

Thank you very much!!!!!!!

[@antrikshkandhari3641]

Brilliant!!