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
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...
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.
>
>
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...
>
> 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 example I use the following to login to FT:
WEB
1
https://registration.ft.com/registration/barrier/login
username=***
Selection=EntirePag
Formatting=None
PreFormattedTextToC
ConsecutiveDelimite
SingleBlockTextImpo
DisableDateRecognit
DisableRedirections
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