发帖
雷达卡
***please give your idea and wish list to better it. What diagram do you want to see, what parameters to you need, etc. Thanks!
This file can
1. download options data from Google Finance, and show you the price and Greeks in a straddle view.
2. let you run your options strategies in the Strategy tab, and show you the 3D diagram of price and Greeks along time and price.
To-Dos:
1. add volatility skew into consideration, as IV of very out of money options may be very skewed.
2. try to factor in discrete dividend better by changing to Binomial option pricing
3. ultimate goal: strategy selector after you feed in 4 parameters: target time, target price, target volatility and target IV skew
(only the 2 tabs with color are need to operate on. others are back end tabs. You don't need to changes things in those.)
目前可以做的是：1。从Google Finance上下载json格式的stock options价格的代码。google finance比yahoo finance好用的一个原因是它直接给出json文件（如果是xml文件就好了。。。），所以比较快。
2。根据条件筛选目标价格和到期日的options，并计算出greeks和IV。
这个project目前用到一下代码：
json.xls
(57.5 KB, 需要: 1 个论坛币)
Matrix and Array handler.xls
(68 KB, 需要: 2 个论坛币)
现在为止的成果
Options workbook.xls
(486.5 KB, 需要: 8 个论坛币)
京公网安备 11010802022788号
