Compound Options (Binomial Tree) with VBA | This Excel spreadsheet prices compound options with a Cox-Ross-Rubinstein binomial tree, and also calculates the Greeks (Delta, Gamma and Theta). The VBA can be viewed and modified. | Buy Now $25 $12 |
Compound Options | This Excel spreadsheet prices compound options with the equations given by Rubinstein (1991) and Geske (1979). It is coded in VBA and uses an approximation for the bivariate cumulative probability distribution function. The VBA can be viewed and modified. | Buy Now $12 $6 |
American Options | Excel spreadsheet for Bjerksund & Stensland, Ju & Zhong, and Barone-Adesi & Whaley Approximations for American Options. The VBA can be viewed and is not protected. | Buy Now $25 $15 |
Asian Options | This Excel spreadsheet gives the price of an Asian Option based on geometric averages (Kemna & Vorst, 1990) and arithmetic averages (Levy, 1991). All formulas are exposed and can be modified. | Buy Now $30 $20 |
American Options (Binomial Tree) | This Excel spreadsheet prices an American option with a Binomial Tree. The spreadsheet also draws the pricing lattice. The VBA is unlocked and exposed | Buy Now $25 $15 |
American Option (Trinomial Tree) | This Excel spreadsheet prices an American option with a Trinomial Tree. The VBA is unlocked and can be viewed | Buy Now $25 $12 |
Credit Default Swap Calculator | This Excel spreadsheet implements the CreditGrades model to price CDS spreads. The VBA can be viewed and modified. | Buy Now $35 $20 |
American/European Option + Greeks via Binomial Tree | American & European Options + Greeks via Binomial Tree. The VBA is open and can be viewed | Buy Now $25 $10 |
Monte Carlo Option Pricing | Monte Carlo pricing of European, Lookback, Asian & Barrier options. The VBA is open and can be viewed/edited | Buy Now $35 $25 |
Options on Libor | This Excel 2010 spreadsheet prices Options on Libor with the Black 75 model | Buy Now $15 $10 |
Binomial Option Pricing | This Excel spreadsheet prices European, Compound, Shout and Complex Chooser options using a binomial tree. The VBA can be viewed and edited | Buy Now $35 $25 |
Do you have a spreadsheet for American Options that includes Skew / Kurtosis parameters?
Cheers
James
Hello
I am interested in downloading stock information from Yahoo in a excel format using MsAccess as the source of Stock Codes and the Stock Costs
Could you please advise me if this information is available from your company?
Thank you
Paul Finch
Hi Samir,
can you write for me formula that gets data from yahoo finance, like open, close, dividends, adjusted price etc.
e.g. I have a tickers in one colum, date in another column like:
MA 10/15/2014
AXP 10/16/2014
the formula should take ticker from one column and dates from another and place required data in next columns like:
MA 10/15/2014 24.15 24.20 24.45
AXP 10/16/2014 54.31 54.78 54.95
Why would I do that for you?
Hi Samir,
I can’t seem to locate your tutorial. Can you help direct me?
Thanx,
Sal
What tutorial?
I wanted to integrate your Live stock quote VBA into the Tading Journal Spreadsheet so I can keep the “last trade” accurate without manual input.
The Trading Journal is locked in the VBA editor and you mention to unlock it by buying the spreadsheet. I can only see the options sheets listed here for purchase and not the basic trading journal.
Hi Pricing Expert,
May I urgently seek for your help below:
1. Can you write a MC simulation for stock price simulation with a series of discrete dividend payments with non-constant volatility using Local Volatility Model?
2. In building Local Volatility Model, would you pls incorporate a series of discrete dividend payments with actual examples with call/put implied Vol Surface from Bloomberg / Reuters and build Local Volatility Modeling from Implied Vol Surface?
Thanks!
Clement
Hello Samir
I saw you awesome intraday excel file.
I would like buy an excel spreadsheet witch produces the following customized intraday data output:
CLOSE, HIGH, LOW, OPEN, VOLUME, DATE, TIME
(The DATE and TIME should be separated into different cells) and the data must be saved to csv file.
If possible, can the data be refreshed/loop every minute.
Thank you.
I had a spreadsheet I used to analyze dividend stocks. It used VBA functions that accessed the Yahoo historical stock data which no longer works as of May 2017. I am working to make my spreadsheet work again. I see that we can get historical closing prices for many stocks from Google Finance. Where can I download historical dividend data from?