Getting 'Compile error in hidden module: mdlWin32API error' when opening file in Office 2013 on Windows 8.1 - can this be corrected? Thx
Peter
February 27th, 2014 at 4:15am
Hi Mary,
No, I've not seen this error before. What version of Office/Mac are you using? Do other Macro enabled spreadsheets work for you?
Mary
February 26th, 2014 at 4:32pm
Hi - I'm trying to use the volatility calculated on a Mac. I've received the error "File not Found: Kernel32" Are you familiar with this? Any way I can get around it? Thanks!
Peter
February 11th, 2014 at 3:34am
Hi Arun, the Historical Volatility spreadsheet is used to download prices from Yahoo and then calculate the volatility of the stock.
What is the underlying stock of your options?
Arun
February 6th, 2014 at 9:54am
how do i use your historical volotality calculator if i have employee stock option granted with 25% vest on the grant date, 25% on the first anniversay, 25% on the second anniversary and the last 25% on the third anniversary. Options are exercisable within 5 years from the grant date
Peter
December 3rd, 2013 at 2:58am
Hi Upendra Shah,
3 - 5% per annum is not a very good return - a buy and hold would most likely do better ;-) Do you mean per month?
Anonymous
December 3rd, 2013 at 2:56am
Thanks Vaibhav!
If you're building a Historical Calculator, make sure you check out my spreadsheet;
You might be able to use what I have created as a starting point for yours.
Let me know how you go.
Vaibhav
November 21st, 2013 at 5:03am
Hi Peter,
Thanks for doing a gr8 job by providing Option Trading Workbook to users like me. I am trying to create a volatility calculator so that it can reflect IV based on desired price and it will help in making trading decisions and triggers for strategies.
Vaibhav
upendra shah
October 29th, 2013 at 7:39am
Sir,
I know one fellow who is earning not less than 8% per month in option market for last eight years.
He is offering me 3% per month irrespective whether he earned or not.
Can you suggest stategy for making proftis upto 3-5% per annum?
Upendra Shah
Peter
February 11th, 2013 at 3:16pm
Hi RB,
I only have experience with Interactive Brokers - but they are great and I recommend them to anyone.
I would prefer to trade European options as it removes the risk of being assigned a position when short but many attractive assets (i.e. US stock options) only list American styled options.
58 Comments
VA April 1st, 2014 at 12:02am
Getting 'Compile error in hidden module: mdlWin32API error' when opening file in Office 2013 on Windows 8.1 - can this be corrected? Thx
Peter February 27th, 2014 at 4:15am
Hi Mary,
No, I've not seen this error before. What version of Office/Mac are you using? Do other Macro enabled spreadsheets work for you?
Mary February 26th, 2014 at 4:32pm
Hi - I'm trying to use the volatility calculated on a Mac. I've received the error "File not Found: Kernel32" Are you familiar with this? Any way I can get around it?
Thanks!
Peter February 11th, 2014 at 3:34am
Hi Arun, the Historical Volatility spreadsheet is used to download prices from Yahoo and then calculate the volatility of the stock.
What is the underlying stock of your options?
Arun February 6th, 2014 at 9:54am
how do i use your historical volotality calculator if i have employee stock option granted with 25% vest on the grant date, 25% on the first anniversay, 25% on the second anniversary and the last 25% on the third anniversary. Options are exercisable within 5 years from the grant date
Peter December 3rd, 2013 at 2:58am
Hi Upendra Shah,
3 - 5% per annum is not a very good return - a buy and hold would most likely do better ;-) Do you mean per month?
Anonymous December 3rd, 2013 at 2:56am
Thanks Vaibhav!
If you're building a Historical Calculator, make sure you check out my spreadsheet;
Historical Volatility Calculator
You might be able to use what I have created as a starting point for yours.
Let me know how you go.
Vaibhav November 21st, 2013 at 5:03am
Hi Peter,
Thanks for doing a gr8 job by providing Option Trading Workbook to users like me.
I am trying to create a volatility calculator so that it can reflect IV based on desired price and it will help in making trading decisions and triggers for strategies.
Vaibhav
upendra shah October 29th, 2013 at 7:39am
Sir,
I know one fellow who is earning not less than 8% per month in option market for last eight years.
He is offering me 3% per month irrespective whether he earned or not.
Can you suggest stategy for making proftis upto 3-5% per annum?
Upendra Shah
Peter February 11th, 2013 at 3:16pm
Hi RB,
I only have experience with Interactive Brokers - but they are great and I recommend them to anyone.
I would prefer to trade European options as it removes the risk of being assigned a position when short but many attractive assets (i.e. US stock options) only list American styled options.
Add a Comment