11 New Messages
Digest #2612
Messages
Fri May 10, 2013 3:22 pm (PDT) . Posted by:
"Lawrence" lawleesh
Hi Randy
Pls see below.
regards
LL
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Hmmm. That function works fine here. Could have been a temporary page
> retrieval issue from Google.
It worked on a Windows 8 machine but not on another Windows 7 machine even though data from Yahoo loaded properly.
What happens if you run the
> smfForceRecalculation macro (see LINKS area of Yahoo group for more info on
> it)?
> I did that and also set IE to load page every time I visit website and also deleted all temporary files but still does not work on second machine.
> Otherwise, what do you get with: Pls see below.
>
> =RCHGetElementNumber("Version") TRUE
> =smfGetAParms(2742)
Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV; (except for per share items); ; ;0;</TABLE;0;0
> =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=AA ",1,20)
#VALUE!
> =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=AA ",1,"per
> share items")
TRUE
> =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=aa ",1,"per
> share items")
TRUE
> =RCHGetElementNumber("MMM";, 2742)
Error
>
> On Thu, May 9, 2013 at 6:33 PM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > I thought that Google might have switched to dynamic web pages which
> > caused info not to be downloaded.
> >
> > One of the formulas I have difficulty with is
> > =RCHGetElementNumber("aa",2742). It returned "Error".
> >
>
Pls see below.
regards
LL
--- In smf_addin@yahoogrou
>
> Hmmm. That function works fine here. Could have been a temporary page
> retrieval issue from Google.
It worked on a Windows 8 machine but not on another Windows 7 machine even though data from Yahoo loaded properly.
What happens if you run the
> smfForceRecalculati
> it)?
> I did that and also set IE to load page every time I visit website and also deleted all temporary files but still does not work on second machine.
> Otherwise, what do you get with: Pls see below.
>
> =RCHGetElementNumbe
> =smfGetAParms(
Google;Quarterly Income Statement -- Date -- FQ1;http://www.google.
> =RCHGetWebData(
#VALUE!
> =RCHGetTableCell(
> share items")
TRUE
> =RCHGetTableCell(
> share items")
TRUE
> =RCHGetElementNumbe
Error
>
> On Thu, May 9, 2013 at 6:33 PM, Lawrence <lawrence.
>
> >
> > I thought that Google might have switched to dynamic web pages which
> > caused info not to be downloaded.
> >
> > One of the formulas I have difficulty with is
> > =RCHGetElementNumbe
> >
>
Fri May 10, 2013 6:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you got #VALUE! and TRUE values returned, something is so wrong I can't
help...
Do you have your cells formatted incorrectly?
On Fri, May 10, 2013 at 3:22 PM, Lawrence <lawrence.leesh@gmail.com > wrote:
> Hi Randy
>
> Pls see below.
>
> regards
>
> LL
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Hmmm. That function works fine here. Could have been a temporary page
> > retrieval issue from Google.
> It worked on a Windows 8 machine but not on another Windows 7 machine even
> though data from Yahoo loaded properly.
>
> What happens if you run the
> > smfForceRecalculation macro (see LINKS area of Yahoo group for more info
> on
> > it)?
> > I did that and also set IE to load page every time I visit website and
> also deleted all temporary files but still does not work on second machine.
>
> > Otherwise, what do you get with: Pls see below.
> >
> > =RCHGetElementNumber("Version") TRUE
> > =smfGetAParms(2742)
> Google;Quarterly Income Statement -- Date -- FQ1;
> http://www.google.com/finance?fstype=ii&q=~~~~~;1;INCINTERIMDIV; (exceptfor per share items); ; ;0;</TABLE;0;0
>
> > =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=AA ",1,20)
> #VALUE!
> > =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=AA ",1,"per
> > share items")
> TRUE
> > =RCHGetTableCell("http://www.google.com/finance?fstype=ii&q=aa ",1,"per
> > share items")
> TRUE
> > =RCHGetElementNumber("MMM";, 2742)
> Error
> >
> > On Thu, May 9, 2013 at 6:33 PM, Lawrence <lawrence.leesh@...> wrote:
> >
> > >
> > > I thought that Google might have switched to dynamic web pages which
> > > caused info not to be downloaded.
> > >
> > > One of the formulas I have difficulty with is
> > > =RCHGetElementNumber("aa",2742). It returned "Error".
> > >
>
help...
Do you have your cells formatted incorrectly?
On Fri, May 10, 2013 at 3:22 PM, Lawrence <lawrence.leesh@
> Hi Randy
>
> Pls see below.
>
> regards
>
> LL
>
> --- In smf_addin@yahoogrou
> >
> > Hmmm. That function works fine here. Could have been a temporary page
> > retrieval issue from Google.
> It worked on a Windows 8 machine but not on another Windows 7 machine even
> though data from Yahoo loaded properly.
>
> What happens if you run the
> > smfForceRecalculati
> on
> > it)?
> > I did that and also set IE to load page every time I visit website and
> also deleted all temporary files but still does not work on second machine.
>
> > Otherwise, what do you get with: Pls see below.
> >
> > =RCHGetElementNumbe
> > =smfGetAParms(
> Google;Quarterly Income Statement -- Date -- FQ1;
> http://www.google.
>
> > =RCHGetWebData(
> #VALUE!
> > =RCHGetTableCell(
> > share items")
> TRUE
> > =RCHGetTableCell(
> > share items")
> TRUE
> > =RCHGetElementNumbe
> Error
> >
> > On Thu, May 9, 2013 at 6:33 PM, Lawrence <lawrence.
> >
> > >
> > > I thought that Google might have switched to dynamic web pages which
> > > caused info not to be downloaded.
> > >
> > > One of the formulas I have difficulty with is
> > > =RCHGetElementNumbe
> > >
>
Fri May 10, 2013 8:24 pm (PDT) . Posted by:
"zbgb952" zbgb952
Anyone having trouble getting Zacks rating? I also note that the www.zacks.com website isn't working recently.
Fri May 10, 2013 8:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If the Zacks website isn't up, you won't be able to get the rating. Because
the add-in just uses a browser object to grab the source code of the web
page, and then extract the data. So if it can't get the web page...
On Fri, May 10, 2013 at 8:24 PM, zbgb952 <mb0329@msn.com> wrote:
> Anyone having trouble getting Zacks rating? I also note that the
> www.zacks.com website isn't working recently.
>
>
the add-in just uses a browser object to grab the source code of the web
page, and then extract the data. So if it can't get the web page...
On Fri, May 10, 2013 at 8:24 PM, zbgb952 <mb0329@msn.com> wrote:
> Anyone having trouble getting Zacks rating? I also note that the
> www.zacks.com website isn't working recently.
>
>
Fri May 10, 2013 9:01 pm (PDT) . Posted by:
"zbgb952" zbgb952
Hello Randy...are you able to get to www.zacks.com ? I currently am not...but it just may be me..pls let me know. Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> If the Zacks website isn't up, you won't be able to get the rating. Because
> the add-in just uses a browser object to grab the source code of the web
> page, and then extract the data. So if it can't get the web page...
>
> On Fri, May 10, 2013 at 8:24 PM, zbgb952 <mb0329@...> wrote:
>
> > Anyone having trouble getting Zacks rating? I also note that the
> > www.zacks.com website isn't working recently.
> >
> >
>
--- In smf_addin@yahoogrou
>
> If the Zacks website isn't up, you won't be able to get the rating. Because
> the add-in just uses a browser object to grab the source code of the web
> page, and then extract the data. So if it can't get the web page...
>
> On Fri, May 10, 2013 at 8:24 PM, zbgb952 <mb0329@.
>
> > Anyone having trouble getting Zacks rating? I also note that the
> > www.zacks.com website isn't working recently.
> >
> >
>
Fri May 10, 2013 9:10 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I currently can with both the add-in and with FireFox.
On Fri, May 10, 2013 at 9:01 PM, zbgb952 <mb0329@msn.com> wrote:
> Hello Randy...are you able to get to www.zacks.com ? I currently am
> not...but it just may be me..pls let me know.
>
On Fri, May 10, 2013 at 9:01 PM, zbgb952 <mb0329@msn.com> wrote:
> Hello Randy...are you able to get to www.zacks.com ? I currently am
> not...but it just may be me..pls let me know.
>
Fri May 10, 2013 10:41 pm (PDT) . Posted by:
"zbgb952" zbgb952
I cannot for some reason..neither with the addin nor Firefox. With Firefox, when i try to go to www.zacks.com ... the screen stays white and nothing happens. I get the same results on both computers that I have. This just started happening yesterday, I think. Have you any idea what could be causing this and how i could fix it? thx.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I currently can with both the add-in and with FireFox.
>
> On Fri, May 10, 2013 at 9:01 PM, zbgb952 <mb0329@...> wrote:
>
> > Hello Randy...are you able to get to www.zacks.com ? I currently am
> > not...but it just may be me..pls let me know.
> >
>
--- In smf_addin@yahoogrou
>
> I currently can with both the add-in and with FireFox.
>
> On Fri, May 10, 2013 at 9:01 PM, zbgb952 <mb0329@.
>
> > Hello Randy...are you able to get to www.zacks.com ? I currently am
> > not...but it just may be me..pls let me know.
> >
>
Fri May 10, 2013 11:12 pm (PDT) . Posted by:
"zbgb952" zbgb952
Randy,
I just tried the function =RCHGetElementNumber(E8,848), where E8
is the ticker (I tried it for ticker= ibm and t )...and got an
'error' message in my spreadsheet. For some reason, i am unable to get zacks data. Can they be blocking me for some reason.
Also..like i said..when i try to go to www.zacks.com .. the page remains white and blank and goes nowhere. This only happens with www.zacks.com . It happens on both my computers (same internet service though). It doesn't happen for any other website i try to go to. Any idea what would cause this?
--- In smf_addin@yahoogroups.com , "zbgb952" <mb0329@...> wrote:
>
> I cannot for some reason..neither with the addin nor Firefox. With Firefox, when i try to go to www.zacks.com ... the screen stays white and nothing happens. I get the same results on both computers that I have. This just started happening yesterday, I think. Have you any idea what could be causing this and how i could fix it? thx.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > I currently can with both the add-in and with FireFox.
> >
> > On Fri, May 10, 2013 at 9:01 PM, zbgb952 <mb0329@> wrote:
> >
> > > Hello Randy...are you able to get to www.zacks.com ? I currently am
> > > not...but it just may be me..pls let me know.
> > >
> >
>
I just tried the function =RCHGetElementNumbe
is the ticker (I tried it for ticker= ibm and t )...and got an
'error&#
Also..like i said..when i try to go to www.zacks.com .. the page remains white and blank and goes nowhere. This only happens with www.zacks.com . It happens on both my computers (same internet service though). It doesn't happen for any other website i try to go to. Any idea what would cause this?
--- In smf_addin@yahoogrou
>
> I cannot for some reason..neither with the addin nor Firefox. With Firefox, when i try to go to www.zacks.com ... the screen stays white and nothing happens. I get the same results on both computers that I have. This just started happening yesterday, I think. Have you any idea what could be causing this and how i could fix it? thx.
>
> --- In smf_addin@yahoogrou
> >
> > I currently can with both the add-in and with FireFox.
> >
> > On Fri, May 10, 2013 at 9:01 PM, zbgb952 <mb0329@> wrote:
> >
> > > Hello Randy...are you able to get to www.zacks.com ? I currently am
> > > not...but it just may be me..pls let me know.
> > >
> >
>
Fri May 10, 2013 11:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try a different page in FireFox:
http://www.zacks.com/stock/quote/MMM?q=MMM
...and take a look at the source code if you still get a blank page. But if
you are getting an abnormal page, "Error" from the function would be the
expected result.
On Fri, May 10, 2013 at 11:12 PM, zbgb952 <mb0329@msn.com> wrote:
> Randy,
> I just tried the function =RCHGetElementNumber(E8,848), where E8
> is the ticker (I tried it for ticker= ibm and t )...and got an
> 'error' message in my spreadsheet. For some reason, i am unable to get
> zacks data. Can they be blocking me for some reason.
>
> Also..like i said..when i try to go to www.zacks.com .. the page remains
> white and blank and goes nowhere. This only happens with www.zacks.com .
> It happens on both my computers (same internet service though). It doesn't
> happen for any other website i try to go to. Any idea what would cause this?
>
http://www.zacks.
...and take a look at the source code if you still get a blank page. But if
you are getting an abnormal page, "Error" from the function would be the
expected result.
On Fri, May 10, 2013 at 11:12 PM, zbgb952 <mb0329@msn.com> wrote:
> Randy,
> I just tried the function =RCHGetElementNumbe
> is the ticker (I tried it for ticker= ibm and t )...and got an
> 'error&#
> zacks data. Can they be blocking me for some reason.
>
> Also..like i said..when i try to go to www.zacks.com .. the page remains
> white and blank and goes nowhere. This only happens with www.zacks.com .
> It happens on both my computers (same internet service though). It doesn't
> happen for any other website i try to go to. Any idea what would cause this?
>
Fri May 10, 2013 11:38 pm (PDT) . Posted by:
"zbgb952" zbgb952
Hello Randy,
I clicked on you link and got the same thing...a blank page. When i try to open the source..that page also opens blank (white) with nothing in it. I only get this for zacks and it started last nite.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try a different page in FireFox:
>
> http://www.zacks.com/stock/quote/MMM?q=MMM
>
> ...and take a look at the source code if you still get a blank page. But if
> you are getting an abnormal page, "Error" from the function would be the
> expected result.
>
> On Fri, May 10, 2013 at 11:12 PM, zbgb952 <mb0329@...> wrote:
>
> > Randy,
> > I just tried the function =RCHGetElementNumber(E8,848), where E8
> > is the ticker (I tried it for ticker= ibm and t )...and got an
> > 'error' message in my spreadsheet. For some reason, i am unable to get
> > zacks data. Can they be blocking me for some reason.
> >
> > Also..like i said..when i try to go to www.zacks.com .. the page remains
> > white and blank and goes nowhere. This only happens with www.zacks.com .
> > It happens on both my computers (same internet service though). It doesn't
> > happen for any other website i try to go to. Any idea what would cause this?
> >
>
I clicked on you link and got the same thing...a blank page. When i try to open the source..that page also opens blank (white) with nothing in it. I only get this for zacks and it started last nite.
--- In smf_addin@yahoogrou
>
> Try a different page in FireFox:
>
> http://www.zacks.
>
> ...and take a look at the source code if you still get a blank page. But if
> you are getting an abnormal page, "Error" from the function would be the
> expected result.
>
> On Fri, May 10, 2013 at 11:12 PM, zbgb952 <mb0329@.
>
> > Randy,
> > I just tried the function =RCHGetElementNumbe
> > is the ticker (I tried it for ticker= ibm and t )...and got an
> > 'error&#
> > zacks data. Can they be blocking me for some reason.
> >
> > Also..like i said..when i try to go to www.zacks.com .. the page remains
> > white and blank and goes nowhere. This only happens with www.zacks.com .
> > It happens on both my computers (same internet service though). It doesn't
> > happen for any other website i try to go to. Any idea what would cause this?
> >
>
Sat May 11, 2013 12:18 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You could try Ctrl+F5 (reload ignoring any cache).
Or clearing cache and Zacks cookies?
On Fri, May 10, 2013 at 11:38 PM, zbgb952 <mb0329@msn.com> wrote:
>
> I clicked on you link and got the same thing...a blank page. When i try to
> open the source..that page also opens blank (white) with nothing in it. I
> only get this for zacks and it started last nite.
>
Or clearing cache and Zacks cookies?
On Fri, May 10, 2013 at 11:38 PM, zbgb952 <mb0329@msn.com> wrote:
>
> I clicked on you link and got the same thing...a blank page. When i try to
> open the source..that page also opens blank (white) with nothing in it. I
> only get this for zacks and it started last nite.
>
Tidak ada komentar:
Posting Komentar