Jumat, 13 Maret 2015

[smf_addin] Digest Number 3354

3 Messages

Digest #3354

Messages

Thu Mar 12, 2015 10:44 am (PDT) . Posted by:

taillear2

Hi Randy,


I have been trying without much success to pull the implied volatility data from the Yahoo Option Quotes pages .


I've tried these two functions


RCHGetHTMLTable


RCHGetWebData


The existing template that pulls the Yahoo Option Quotes data seems to be pulling from another URL because the even the column headings are different...they are missing a few headings


I am wondering if you have ever looked into pulling the Implied Volatility data? It would be awesomely useful.


Thanks,


John

Thu Mar 12, 2015 1:05 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, there is no implied volatility on the Yahoo web
page...because the format of the web page in IE is the old format, and it's
the IE format web page that EXCEL and the add-in retrieve.

The new format of the option web pages does show up in FireFox and Chrome,
but Yahoo backed it out of IE.

You can get IV from OX.

On Thu, Mar 12, 2015 at 10:44 AM, cheval66@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I have been trying without much success to pull the implied volatility
> data from the Yahoo Option Quotes pages .
>
> I've tried these two functions
>
> RCHGetHTMLTable
>
> RCHGetWebData
>
> The existing template that pulls the Yahoo Option Quotes data seems to be
> pulling from another URL because the even the column headings are
> different...they are missing a few headings
>
> I am wondering if you have ever looked into pulling the Implied Volatility
> data? It would be awesomely useful.
>
>

Fri Mar 13, 2015 12:58 am (PDT) . Posted by:

boo1712

Maybe u can try add a separate sheet and do a web query to login to Morningstar. U should use a .iqy file so that it can login


For example I use the following to login to FT:




WEB
1
https://registration.ft.com/registration/barrier/login
username=*********&password=********






Selection=EntirePage
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False










In the web query option, select refresh data when opening file.

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

Tidak ada komentar:

Posting Komentar