Excel stock options analysis software

By: RoyaryBoats Date of post: 25.05.2017

Options Analysis Software for Excel. Make money in down markets. Profit whether the stock goes up or down. Try Options as an alternative investment. Options give you a virtually unlimited number of profit opportunities for ANY direction up, down, choppy, or still you think the stock is headed.

You can limit both your profits and losses. You can control much larger quantities of stock for the same cost of buying the stock. Perhaps you have invested in a k.

Black Scholes Excel Option Calculator by Kai Reinke

Maybe you have bought or sold stocks, bonds, or mutual funds. Options can be the next step in your short or long term investment strategies. Different forms of options are used everyday.

excel stock options analysis software

Why do you have insurance on your house and car? It's to protect your property from an unlikely catastrophe for a small amount known as a premium. In the same way some investors buy options on stocks and indexes as insurance protection against their holdings.

The biggest advantage of options is their flexiblity. They can be as conservative or speculative as your investment style needs to be. Here are some examples of strategies you can do with options:. Protect your existing stock or mutual funds from big declines.

The most fundamental options strategy is to buy call or buy puts. First select a stock you are interested and go to an options chain quote service such as: The Chicago Board Options Exchange CBOE: Select an option you would like to purchase.

The Calls are on the left and Puts are on the right. You will see the expiration date and exercise price for each option. The premium quotes are listed under: In order to calculate the cost of the option, multiply the premium x number of contracts x shares per contract Myths about options Myth 1: They are gambling" While this can be certainly true for just buying options, option writing or selling gives the investor many very conservative and high probability options strategies.

Options can even be used as insurance against existing stock positions. Read the intro section for a very easy way to understand options. Now, options are available on over stocks. If you become the SELLER of the options than you can take advantage of this.

Options are "rain checks" An option is a right to buy or sell an asset for a specified price and time. Let's say you want to buy a TV on sale at Wal-Mart. You drive there only to find out that it's "sold out".

So you go to the clerk and ask for a "rain check". This "rain check" is a guarantee that you will get the TV for the sale price when they are back in stock.

There may be an expiration date on the "rain check" for 1 month from the out of stock date. This rain check qualifies as an Call option.

Optionstar options analysis software

You have the right to purchase the TV for the sale price up to 1 month regardless of how much the TV goes up or down in price during that period. You are the buying this call option and Wal Mart is the seller. The only difference of this rain check versus a real option is that there is NO value on this option and it is probably non-transferable.

Now, let's use this same concept for a stock. On the other side of this deal, there is someone who is willing to sell you this right for you to buy Microsoft from him for Stock option VS Rain check for TV.

Rain check for TV Expiration Date.

excel stock options analysis software

A profit loss table for 1 call option contract shares, total cost: You also limit your maximum risk to the lower cost of the option. The only downside to buying options is that your probability is high that the stock will stay the same resulting in you losing some or all of your option value.

excel stock options analysis software

Buying put options are the same strategy as buying calls, only betting the stock will go down instead of up. A profit loss table for 1 put option contract shares, total cost: A "naked put" is simply selling or writing a put option instead of buying it. A "covered call" has the same exact profit and loss table as a naked put. If you own an existing stock and are worried that there may be huge correction in the short term, you can buy a put to insure the stock against such a catastrophe.

Bull Spread - a conservative option play. A more conservative approach to just buying a call would be the bull spread. This involves buying one call and selling another call further out. This would result in a spread position where you max loss and profit are limited. A straddle option spread allows you to make money whether the stock moves up OR down.

Service Temporarily Unavailable

It is simply combining a buy put and buy call option. The Straddle will only lose if the stock stays the same.

A Short Straddle is the opposite of the straddle. It is combining a SELL call and SELL put option. CLICK HERE to download FREE Options Analyzer Options as an alternative investment Learn more advanced strategies than buy and hold..

Option Basics Perhaps you have invested in a k. Here are some examples of strategies you can do with options: Stock option VS Rain check for TV Option components: Rain check for TV.

Call buy or Put sell. NO VALUE non transferrable. Neither Star Research, Inc. None of the charts or information contained in these pages should be construed as a solicitation to trade any of these strategies.

In addition, none of the prices contained in the graphs are current. All data is provided solely as theoretical examples for informational purposes. Consult a qualified options broker before assuming a position you are unfamiliar with.

There is risk of loss in all trading.

inserted by FC2 system