Appreciate it! You know: let's say today I have Nov 10 's data in a .txt file, can I easily import these? That's the issue.
Yes it looks good but the trial version features are very limited and unable to clear up this specific issue for me. Thanks for your note.
Anyone using the hoadley XL add-in? Is it possible/easy to import historical *options* data? For example to analyze a vol. surface of some time...
In my opinion that formula is incorrect, or incomplete. The basis of the formula, I assume, is the equation Vol2^2 = (Vol1^2*T1 + Vol3^2*T3...
Grant, When you write SQRT(a)/b then of course b is not included in SQRT. Your earlier forvol formula also is not correct. It should be:...
Grant, in both formulas in cells B3 and B8 you have SQRT and parens a bit messed up. B3 should be: =SQRT((E2^2*C2-D2^2*B2)/(C2-B2)) (B3 just...
miscalc: forward vol = 7.94%
Thatâs correct. I recently asked about this in the IQFeed forum: http://forums.iqfeed.net/index.cfm?page=topic&topicID=1121 (3rd post...
Thanks for bringing me up to date on this. Unfortunately one cannot just hit the bid or lift the ask. Will a (SMART?) market order be executed...
I recently asked the OCC for a complete list of expiration cycles (of all optionable stocks). Much to my surprise there isn't such a list,...
Here are recent contract adjustments: http://theocc.com/market/infomemos/info_memos_form.jsp 3-2 splits in particular usually result in 150...
Thanks def, thatâs very interesting. In view of this I agree with MTE that the open/close data seems quite reliable. The question of what %...
Those would be the ones that provide the truly reliable open/close data. I will check with IB if indeed the software does this. This I find very...
Thanks MTE. Iâm sure you are correct about the clearing house having the info but I donât think this is CBOEâs source. They literally...
The new CBOE data service provides âOpen/Closeâ data, previously not available to the public. This data separates transactions into open...
a search for "spin-off" in http://theocc.com/market/infomemos/info_memos_form.jsp will give some examples of what *might* happen....
Serious limitation is that $600 only reports CBOE transactions, which is about 30% of stock options volume (referring to the âOpen Closeâ data...
I am not with optionsxpress so cannot log in, but if you refer to this info http://optionsxpress.com/educate/opt_symbols.aspx#weekly then...
I think weeklys expire on Friday http://cboe.com/Products/indexopts/weekly_XSP_spec.aspx and were settled at 1288.95....
Good point freehouse. If thereâs no symbol change like in 2-1 splits, OI will double. Additional exercise will in fact somewhat lessen the...
Separate names with a comma.