2 Messages

Digest #3659

VIX future quote by sdavis81

Re: VIX future quote by sdavis81

Messages

1a

How can I retrieve the last price for the VIX future from this webpage?

http://www.barchart.com/quotes/stocks/VIJ6 http://www.barchart.com/quotes/stocks/VIJ6

I am not sure which function to use or how to use the find parameters in the documentation,

Thanks!

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: VIX future quote

Wed Mar 16, 2016 2:49 pm (PDT) . Posted by:

sdavis81

Talking to myself!

Figured it out, found another page with a real table to pull cells from:

http://www.barchart.com/commodityfutures/CBOE_S%26P_500_VIX_Futures/VI http://www.barchart.com/commodityfutures/CBOE_S%26P_500_VIX_Futures/VI

=RCHGetTableCell("http://www.barchart.com/commodityfutures/CBOE_S%26P_500_VIX_Futures/VI",1,"VIJ16 (Apr '16)")