Problem with post-style web query on CBOE.com

[Bas Mekel]

OS: Windows NT 4, SP6A
Excel: 10.2614.2625 (Office XP)
IE: 6.0.2800.1106


Hi all,

I'm dealing with the following problem:

www.CBOE.com has changed his website structure and I dicovered 2
changes.
1. The URL has changed,
2. The filename (to download) has changed.

* My old web query:
WEB
1
http://quoteservice.cboe.com/QuoteTable.dat

* My new web query:
WEB
1
http://www.cboe.com/delayedQuote/QuoteData.dat

* MY PROBLEM:
Right now I'm unable to retreive a QuoteData.dat file via Excel web
query with a required symbol (PostText value in VBA)

* The new page to enter the request manually (web form) is
http://www.cboe.com/delayedQuote/QuoteTableDownload.aspx


* Here is my code:

Sub ini_quotes()
'Initialize Quotes

Dim DR As Object 'Data Range
Dim PTV As String 'PostText Value

PTV = "Ticker=" & Range("QS") 'Example Ticker=MSFT
With ActiveSheet.QueryTables.Add(Connection:= _
"FINDER;C:\Temp\SSSKAT22\Filter.iqy",
Destination:=Range("A1"))
.Name = "DR"
.PostText = PTV
.Refresh BackgroundQuery:=False '<<-- UNABLE TO RETREIVE THE
QUOTEDATA.DAT FILE!
End With
End Sub

Unfortunately CBOE.com refused to help me:
"I apologize but we cannot assist you with that because we do not
allow the query you are attempting to perform because of the load it
can place on our
servers, and because of other additional security concerns. I
apologize for the inconvenience."

Has someone have an idea/suggestion how to solve this issue?
Thanks in advance for any comments!

Kind regards,

- Bas

 

[Don Guillett]

I went to your cboe. Modify this url to suit
http://www.cboe.com/DelayedQuote/SimpleQuote.aspx?ticker=msft

sym=msft 'or sym="msft"
"http://www.cboe.com/DelayedQuote/SimpleQuote.aspx?ticker="&sym

Let us know how it works out.

 

[Bas Mekel]

Hello Don,
I need a complete option chain, if possible in a compact .dat format(Ascii).
Thanks anyway for your suggestion!

- Bas