Rabu, 11 November 2015

[smf_addin] Digest Number 3556

3 Messages

Digest #3556
1a
1b
Re: Help with Gettablecell please by "Randy Harmelink" rharmelink

Messages

Tue Nov 10, 2015 11:22 am (PST) . Posted by:

robertgerard667

Hi everyone. I've been struggling with a formula for gettablecell to retrieve a value from the OIC.

Here's what I have been trying.

I have a cell named URL which contains the string:

"http://oic.ivolatility.com/oic_options.j?cnt=439bf52d9db85535153e900f516f3a6a1e69b08e224cc574&ticker=HOG"

I want the current 30 Days Historical Volatility number (amongst others, but I'd be happy to get just one)



I've tried:
rchgettablecell(URL,1,"HISTORICAL","30 Days")
rchgettablecell(URL,12,"HISTORICAL")


and several other possible usages, including some using the ROW option, but all return "Error".


Any help would be greatly appreciated.


Bob.


Tue Nov 10, 2015 11:44 am (PST) . Posted by:

"Randy Harmelink" rharmelink

If I use your URL, I get a web page "Not Found" error. Because the "cnt="
is a security tag assigned to a session, so it will only be active a short
time, and probably not across different browsers.

However, I've found that once you have created the security cookie, you no
longer need the "cnt=" parameter.

Have you looked at the smfGet888OptionQuote() function? 888Options.com uses
the same iVolatility frame to display data (not sure how you got there,
since they have a number of portals into their data). But, once you use the
EXCEL Web Query dialog to get an option quote on 888options.com, you will
have the necessary iVolatility security cookie created and can use the
function. For example:

=smfGet888OptionQuote("HOG",,,,"hv10c")
=smfGet888OptionQuote("HOG",,,,"hv30c")
=smfGet888OptionQuote("HOG","C",DATE(2015,11,20),45,"b")

If you use it on equities that have a lot of contracts, such as SPY, it
will be VERY slow since it retrieves everything on one big web page.

On Tue, Nov 10, 2015 at 11:12 AM, robertgerard667@... wrote:

>
> Hi everyone. I've been struggling with a formula for gettablecell to
> retrieve a value from the OIC.
>
> Here's what I have been trying.
>
> I have a cell named URL which contains the string:
>
>
> "http://oic.ivolatility.com/oic_options.j?cnt=439bf52d9db85535153e900f516f3a6a1e69b08e224cc574&ticker=HOG
> "
>
> I want the current 30 Days Historical Volatility number (amongst others,
> but I'd be happy to get just one)
>
> I've tried:
>
> rchgettablecell(URL,1,"HISTORICAL","30 Days")
>
> rchgettablecell(URL,12,"HISTORICAL")
>
> and several other possible usages, including some using the ROW option,
> but all return "Error".
>
> Any help would be greatly appreciated.
>

Tue Nov 10, 2015 1:55 pm (PST) . Posted by:

robertgerard667

Thank you Randy, this is amazing. I had no idea get888optionsquote already has everything I need. You
have saved me a ton of trial and error work.

I can't tell you how beneficial your SMF's have been to me.

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

Tidak ada komentar:

Poskan Komentar