Kamis, 17 Maret 2016

[smf_addin] Digest Number 3659

2 Messages

Digest #3659
1a
VIX future quote by sdavis81
1b

Messages

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

sdavis81

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!












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)")




For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar