4 Messages
Digest #4436
Messages
Thu Dec 6, 2018 12:02 pm (PST) . Posted by:
lexstar
Is the function RCHGetElementNumber() no longer working for Yahoo Data? I ran the smf-Template-Yahoo-Mutual-Fund-Data template and receive only "NOT FOUND" as the results.
File found here: http://ogres-crypt.com/SMF/Templates/#Yahoo http://ogres-crypt.com/SMF/Templates/#Yahoo
File found here: http://ogres-crypt.com/SMF/Templates/#Yahoo http://ogres-crypt.com/SMF/Templates/#Yahoo
Thu Dec 6, 2018 1:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I just tried the template with ticker symbol VFINX and everything looked OK
to me?
On Thu, Dec 6, 2018 at 1:02 PM lexstar@... wrote:
> Is the function RCHGetElementNumber() no longer working for Yahoo Data? I
> ran the smf-Template-Yahoo-Mutual-Fund-Data template and receive only "NOT
> FOUND" as the results.
>
>
>
to me?
On Thu, Dec 6, 2018 at 1:02 PM lexstar@... wrote:
> Is the function RCHGetElementNumber
> ran the smf-Template-
> FOUND" as the results.
>
>
>
Thu Dec 6, 2018 11:21 pm (PST) . Posted by:
alankc_mok
Randy,
I am interested in the Excel IE method you indicated. Can you elaborate ?
Should the command be initiated in Excel environment or that I need to set up a macro to avoid the splash page ?
Regards
Alan
I am interested in the Excel IE method you indicated. Can you elaborate ?
Should the command be initiated in Excel environment or that I need to set up a macro to avoid the splash page ?
Regards
Alan
Thu Dec 6, 2018 11:41 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
When you are in excel, just use the keyboard shortcut alt+d+d+w. That's the
old method of the "New Web query" process. It uses an IE object that you
can interface with, although it throws all kinds of JavaScript errors you
have to ignore. But it does create cookies that remove the need for the
site to throw up a splash page again, or a login page again. But the cookie
can expire and you'd need to do it again if that happens. How long such a
cookie lasts varies significantly from site to site -- 15 minutes is about
the shortest I've seen, but others can be more or less permanent.
On Fri, Dec 7, 2018 at 12:21 AM alankc_mok@... wrote:
>
> I am interested in the Excel IE method you indicated. Can you elaborate ?
>
> Should the command be initiated in Excel environment or that I need to set
> up a macro to avoid the splash page ?
>
>
>
old method of the "New Web query" process. It uses an IE object that you
can interface with, although it throws all kinds of JavaScript errors you
have to ignore. But it does create cookies that remove the need for the
site to throw up a splash page again, or a login page again. But the cookie
can expire and you'd need to do it again if that happens. How long such a
cookie lasts varies significantly from site to site -- 15 minutes is about
the shortest I've seen, but others can be more or less permanent.
On Fri, Dec 7, 2018 at 12:21 AM alankc_mok@.
>
> I am interested in the Excel IE method you indicated. Can you elaborate ?
>
> Should the command be initiated in Excel environment or that I need to set
> up a macro to avoid the splash page ?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar