Options Calculation - Aussie Stock Forums

Results 1 to 7 of 7
  1. #1

    Default Options Calculation

    G'day Guys,
    I was wondering if anyone has a calculator or spreadsheet that can assist with determining which shares to write options on. There are a lot of variables to consider and a well prepared spreadsheet can assist with determining which options may return the best premiuims for initial outlay. ..hmm.. does anyone understand what I am asking? lol

  2. #2

    Join Date
    Oct 2004

    Default Re: Options Calculation


    Try this Site. I have not used it myself, but have heard that it is not bad, if you can work out how to use it.

  3. #3

    Default Re: Options Calculation

    Hi Darren ... I created a simple manual Options series analyser spreadsheet for HC members awhile back.

    You might find it useful and can be downloaded from my webspace ...

    www.users.bigpond.com/equus2/hc buffalo template.xls

    Note: the Implied Volatility calcs for the Option series are computed by a macro (run by Ctrl+g) I wrote and are derived from the Options FAIR VALUE's. Be sure to follow the directions slowly and carefully at first for best results.

    Have fun ...

    Cheers ...

  4. #4

    Default Re: Options Calculation

    Hi Darren ... the link doesn't work ... do it manually from your browzer.


    Cheers ...

  5. #5

    Default Re: Options Calculation

    Apologies folks ... appears there is a problem with the spreadsheet.

    A modified version has now been uploaded ... those who downloaded please do so again ... apologies for the inconvenience.

    (http://www.users.bigpond.com/equus2/hc buffalo template.xls)

    Any feedback welcome.

    Cheers ...

  6. #6

    Join Date
    Jul 2004

    Default Re: Options Calculation


    There is a free v1 software (real basic) > and a 30 day trial v4 ....i liked it so much I bought v4 (awesome).

    This software is quick and easy and you can play with variables (share price, volatility, interest rate, time, etc) to see what effects these have on ALL the option prices for a particular share. (data is downloaded free from the asx ;-)

    It saves me heaps of time identifying underpriced/overpriced or even fair value for any share, NOT one at a time which is a chore, but the whole series.

    Think it cost me around $400AU after conversion to canadian rupee's. The support has been fantastico as well.
    Last edited by SuperTed; 8th-February-2005 at 02:57 PM.

  7. #7
    Rotaredom wayneL's Avatar
    Join Date
    Jul 2004

    Default Re: Options Calculation

    Looks interesting Ted...downloading as I type.

    Thanks for the heads up.


Similar Threads

  1. How to learn about options...
    By wayneL in forum Derivatives
    Replies: 28
    Last Post: 30th-April-2011, 04:21 PM
  2. Company options - basics
    By Gordon in forum Beginner's Lounge
    Replies: 22
    Last Post: 27th-January-2010, 11:33 PM
  3. What to do with company issued options?
    By bonkerrs in forum Beginner's Lounge
    Replies: 4
    Last Post: 9th-August-2007, 11:11 AM
  4. Replies: 5
    Last Post: 11th-February-2007, 03:22 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Aussie Stock Forums