.: Option Trading Workbook 2
Free option pricing spreadsheet. Uses Black and Scholes to calculate the theoretical price and option greek derivatives of call and put options. Includes a strategy simulation worksheet, which enables a user to enter up to 10 option legs that will be used as a single option combination. This combination will then be graphed to show the expected profit and loss at the expiration date as well as the combined option greeks for the strategy. The Black and Scholes code that is used for this spreadsheet is fully disclosed and available for editing using the Visual Basic editor.
|
Size |
0.05 MB |
|
License |
Freeware |
|
Price |
0 USD |
|
Category |
Business & Finance / Spreadsheets |
|
Operating System |
Win 3.1x,Win95,Win98,WinME,WinXP,WinNT 3.x,WinNT 4.x,Windows2000,Windows2003,Mac OS X |
|
Developer |
Option Trading Tips |
|
Program system requirements: Microsoft Excel New in this version: 1/10/06. Added support for Dividend Yield. 28/08/06. Fixed a small calculation bug for the Option Theta, which now has a near perfect accuracy. 27/04/06. Fixed a bug that failed to calculate the theoretical change in P&L for stocks in the strategies tab. |
|
Screenshot:
|
Download NowFile size 0.05 MB |
| option pricing,
option trading,
option pricing spreadsheet,
black and scholes,
|
|
.: Top Spreadsheets / Business & Finance programs
.: New Spreadsheets / Business & Finance programs
|
|
1)
2)
3)
4)
5)
6)
7)
1)
2)
3)
4)