3 New Messages
Digest #2835
Messages
Fri Nov 1, 2013 1:31 am (PDT) . Posted by:
"Shekhar Marathe" ckppmarathe
Hello Randy,
Thanks for this add-in.
The function smfGetCSVFile ha three more parameters in addition to the
URL. But the documentation does not describe these three. Even the
example file also has only the URL and it works.
-Shekhar
Thanks for this add-in.
The function smfGetCSVFile ha three more parameters in addition to the
URL. But the documentation does not describe these three. Even the
example file also has only the URL and it works.
-Shekhar
Fri Nov 1, 2013 2:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I added those parameters for special uses I needed of the function,
primarily so I could use it in VBA. I thought documenting them would cause
more issues than not.
On Fri, Nov 1, 2013 at 1:22 AM, Shekhar Marathe <ckppmarathe@gmail.com>wrote:
>
> The function smfGetCSVFile ha three more parameters in addition to the
> URL. But the documentation does not describe these three. Even the
> example file also has only the URL and it works.
>
>
primarily so I could use it in VBA. I thought documenting them would cause
more issues than not.
On Fri, Nov 1, 2013 at 1:22 AM, Shekhar Marathe <ckppmarathe@
>
> The function smfGetCSVFile ha three more parameters in addition to the
> URL. But the documentation does not describe these three. Even the
> example file also has only the URL and it works.
>
>
Fri Nov 1, 2013 6:20 pm (PDT) . Posted by:
"c1sander" c1sander
Randy,
I thought that I had put in a quote before. Anyway, I did so tonight and now it works just fine. Thanks for your help and patience.
Craig
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need to do more than just open the site. You actually have to go to a
> quotes page. Because the quotes page is displaying a frame of data from
> iVolatility.com. The process needs a security cookies so data can be
> retrieved from their website. So just opening 888options.com (and their
> redirection), won't work.
>
> The actual web page it might end up using is something like:
>
> http://oic.ivolatility.com/oic_adv_options.j?exp_date=-1&ticker=SPY
>
> If you bookmark that URL and try to visit it after the security cookie has
> expired, it won't work at all. Try visiting that web page with the EXCEL
> Web Query dialog and see if you see option quotes and volatility
> information.
>
> On Wed, Oct 30, 2013 at 12:19 PM, c1sander <craig.sander@...> wrote:
>
> >
> > I opened up the site from Excel and the formula (after forced
> > recalculation) still gives an error. Is there something that might be
> > preventing the creation of the cookie?
> >
>
I thought that I had put in a quote before. Anyway, I did so tonight and now it works just fine. Thanks for your help and patience.
Craig
--- In smf_addin@yahoogrou
>
> You need to do more than just open the site. You actually have to go to a
> quotes page. Because the quotes page is displaying a frame of data from
> iVolatility.
> retrieved from their website. So just opening 888options.com (and their
> redirection)
>
> The actual web page it might end up using is something like:
>
> http://oic.ivolatil
>
> If you bookmark that URL and try to visit it after the security cookie has
> expired, it won't work at all. Try visiting that web page with the EXCEL
> Web Query dialog and see if you see option quotes and volatility
> information.
>
> On Wed, Oct 30, 2013 at 12:19 PM, c1sander <craig.sander@
>
> >
> > I opened up the site from Excel and the formula (after forced
> > recalculation) still gives an error. Is there something that might be
> > preventing the creation of the cookie?
> >
>
Tidak ada komentar:
Posting Komentar