AnalyzerXL?
Hi Nick,
I built a tool that downloads stock and option quotes by VBA hitting yahoo finance and getting the data in a CSV, which I then parse and load my access tables. This works fine.
But I would like to build a trade idea builder that would suggest vertical and calendar spreads. For that I need to download option chains - i.e., get options with the stock ticker and not the indivudal option ticker. Instead of building this time, I thought I would look for things that are available already.
Do you have experience with Analyzerxl ( http://www.analyzerxl.com/compare.htm ) or have any suggestions?
Thx
Laks
analyzerxl.com
analyzerxl.com looks to be technical analysis.. Personally, I don't believe in technicals..
What page are you looking at for option quotes ?
Yahoo finance API lets us get
Yahoo finance API lets us get the bid/ask of an option when u pass the ticker of the option.
To get the ticker, we can go to Yahoo finance again - http://finance.yahoo.com/q/op?s=IBM&m=2009-10 . (The VBA can text parse this page and glean the option tickers - but that is crude!)
I would like to give the stock ticker, expiration and strike and would like the tool to get the option ticker, which I can then pass to Yahoo api to get the price.