15 New Messages
Digest #2780
1a
Re: Problem with Element No. 469 -- Earnings Surprise Difference by "raul_the_pool_boy" raul_the_pool_boy
Messages
Sat Sep 21, 2013 4:19 am (PDT) . Posted by:
"raul_the_pool_boy" raul_the_pool_boy
Works for me. For IBM I get .13 and for BG I get -.63. Looks correct.
--- In smf_addin@yahoogroups.com, "Douglas" <jurisdoctor74@...> wrote:
>
>
> Using RCHGetElementNumber("IBM",469)works normally for IBM and every other company I tried with one exception. When I tried pulling data for the symbol "BG" (Bunge Ltd., NYSE) I get an "NA" error rather than the the earnings surprise difference figure I was looking for. (There may be other exceptions but I haven't yet found any.)
>
> I checked the source code and observed that the data I seek is definitely there. Does anyone know why this command would not work with this one particular company?
>
> Thanks!
>
--- In smf_addin@yahoogrou
>
>
> Using RCHGetElementNumber
>
> I checked the source code and observed that the data I seek is definitely there. Does anyone know why this command would not work with this one particular company?
>
> Thanks!
>
Sat Sep 21, 2013 4:28 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you get "NA", it should be because it is what MSN is posting for that
field. That isn't a value the add-in would create.
If I try it now, I get the same value raul got: -.63, which is what I see
on the print report from MSN.
Maybe MSN was doing some updating while you were accessing it?
On Fri, Sep 20, 2013 at 8:43 PM, Douglas <jurisdoctor74@yahoo.com> wrote:
>
> Using RCHGetElementNumber("IBM",469)works normally for IBM and every other
> company I tried with one exception. When I tried pulling data for the
> symbol "BG" (Bunge Ltd., NYSE) I get an "NA" error rather than the the
> earnings surprise difference figure I was looking for. (There may be other
> exceptions but I haven't yet found any.)
>
> I checked the source code and observed that the data I seek is definitely
> there. Does anyone know why this command would not work with this one
> particular company?
>
field. That isn't a value the add-in would create.
If I try it now, I get the same value raul got: -.63, which is what I see
on the print report from MSN.
Maybe MSN was doing some updating while you were accessing it?
On Fri, Sep 20, 2013 at 8:43 PM, Douglas <jurisdoctor74@
>
> Using RCHGetElementNumber
> company I tried with one exception. When I tried pulling data for the
> symbol "BG" (Bunge Ltd., NYSE) I get an "NA" error rather than the the
> earnings surprise difference figure I was looking for. (There may be other
> exceptions but I haven't yet found any.)
>
> I checked the source code and observed that the data I seek is definitely
> there. Does anyone know why this command would not work with this one
> particular company?
>
Sat Sep 21, 2013 10:22 am (PDT) . Posted by:
"Douglas" jurisdoctor74
Well, -.63 is correct but I am still continuing to get the NA error. I'm using an older version of Excel (2003) but can't imagine how that would cause this problem.
Now I'm totally clueless because it makes no sense that this one valid symbol would create a problem but others do not. Nevertheless, I do appreciate your feedback. Thanks!
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you get "NA", it should be because it is what MSN is posting for that
> field. That isn't a value the add-in would create.
>
> If I try it now, I get the same value raul got: -.63, which is what I see
> on the print report from MSN.
>
> Maybe MSN was doing some updating while you were accessing it?
>
> On Fri, Sep 20, 2013 at 8:43 PM, Douglas <jurisdoctor74@...> wrote:
>
> >
> > Using RCHGetElementNumber("IBM",469)works normally for IBM and every other
> > company I tried with one exception. When I tried pulling data for the
> > symbol "BG" (Bunge Ltd., NYSE) I get an "NA" error rather than the the
> > earnings surprise difference figure I was looking for. (There may be other
> > exceptions but I haven't yet found any.)
> >
> > I checked the source code and observed that the data I seek is definitely
> > there. Does anyone know why this command would not work with this one
> > particular company?
> >
>
Now I'm totally clueless because it makes no sense that this one valid symbol would create a problem but others do not. Nevertheless, I do appreciate your feedback. Thanks!
--- In smf_addin@yahoogrou
>
> If you get "NA"
> field. That isn't a value the add-in would create.
>
> If I try it now, I get the same value raul got: -.63, which is what I see
> on the print report from MSN.
>
> Maybe MSN was doing some updating while you were accessing it?
>
> On Fri, Sep 20, 2013 at 8:43 PM, Douglas <jurisdoctor74@
>
> >
> > Using RCHGetElementNumber
> > company I tried with one exception. When I tried pulling data for the
> > symbol "BG" (Bunge Ltd., NYSE) I get an "NA" error rather than the the
> > earnings surprise difference figure I was looking for. (There may be other
> > exceptions but I haven't yet found any.)
> >
> > I checked the source code and observed that the data I seek is definitely
> > there. Does anyone know why this command would not work with this one
> > particular company?
> >
>
Sat Sep 21, 2013 10:40 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
When you say "continuing" to get it, does that mean you have exited and
restarted EXCEL, or run the smfForceRecalculation macro? If neither of
those are done, you'll continue to get the same value, because the add-in
extracts data from a saved copy of the web page. It doesn't refresh that
saved copy of the web page until you do either of those two things.
See the LINKS area of the Yahoo group for more info on the
smfForceRecalculation macro, and a related IE refresh issue.
On Sat, Sep 21, 2013 at 10:22 AM, Douglas <jurisdoctor74@yahoo.com> wrote:
> Well, -.63 is correct but I am still continuing to get the NA error. I'm
> using an older version of Excel (2003) but can't imagine how that would
> cause this problem.
>
> Now I'm totally clueless because it makes no sense that this one valid
> symbol would create a problem but others do not. Nevertheless, I do
> appreciate your feedback. Thanks!
>
restarted EXCEL, or run the smfForceRecalculati
those are done, you'll continue to get the same value, because the add-in
extracts data from a saved copy of the web page. It doesn't refresh that
saved copy of the web page until you do either of those two things.
See the LINKS area of the Yahoo group for more info on the
smfForceRecalculati
On Sat, Sep 21, 2013 at 10:22 AM, Douglas <jurisdoctor74@
> Well, -.63 is correct but I am still continuing to get the NA error. I'm
> using an older version of Excel (2003) but can't imagine how that would
> cause this problem.
>
> Now I'm totally clueless because it makes no sense that this one valid
> symbol would create a problem but others do not. Nevertheless, I do
> appreciate your feedback. Thanks!
>
Sat Sep 21, 2013 10:42 am (PDT) . Posted by:
"Douglas" jurisdoctor74
Progress! I just tried "Ctl+Shift+R" and it solved the problem as the NA changed to -.63. However, I don't understand why.
Is there some setting I need to change to keep the data constantly "fresh" in order to avoid having to use the "Ctl+Shift+R" procedure?
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> If you get "NA", it should be because it is what MSN is posting for that
> field. That isn't a value the add-in would create.
>
> If I try it now, I get the same value raul got: -.63, which is what I see
> on the print report from MSN.
>
> Maybe MSN was doing some updating while you were accessing it?
>
> On Fri, Sep 20, 2013 at 8:43 PM, Douglas <jurisdoctor74@...> wrote:
>
> >
> > Using RCHGetElementNumber("IBM",469)works normally for IBM and every other
> > company I tried with one exception. When I tried pulling data for the
> > symbol "BG" (Bunge Ltd., NYSE) I get an "NA" error rather than the the
> > earnings surprise difference figure I was looking for. (There may be other
> > exceptions but I haven't yet found any.)
> >
> > I checked the source code and observed that the data I seek is definitely
> > there. Does anyone know why this command would not work with this one
> > particular company?
> >
>
Is there some setting I need to change to keep the data constantly "fresh" in order to avoid having to use the "Ctl+Shift+
--- In smf_addin@yahoogrou
>
> If you get "NA"
> field. That isn't a value the add-in would create.
>
> If I try it now, I get the same value raul got: -.63, which is what I see
> on the print report from MSN.
>
> Maybe MSN was doing some updating while you were accessing it?
>
> On Fri, Sep 20, 2013 at 8:43 PM, Douglas <jurisdoctor74@
>
> >
> > Using RCHGetElementNumber
> > company I tried with one exception. When I tried pulling data for the
> > symbol "BG" (Bunge Ltd., NYSE) I get an "NA" error rather than the the
> > earnings surprise difference figure I was looking for. (There may be other
> > exceptions but I haven't yet found any.)
> >
> > I checked the source code and observed that the data I seek is definitely
> > there. Does anyone know why this command would not work with this one
> > particular company?
> >
>
Sat Sep 21, 2013 10:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Probably because Ctrl+Shift+R runs the smfForceRecalculation macro I just
mentioned.
That purges all saved copies of web pages and loads a fresh copy of the web
page into the "saved area" of the add-in, from where it extracts that data.
The add-in has a "saved area" like that so that if you are extracting 60
items from the same web page, it doesn't need to retrieve the web page 60
times. That would slow data retrieval down to a crawl.
So, no, there isn't a way to keep the data constantly "fresh", *except* by
running the smfForceRecalculation macro. I typically run it whenever I
close down a workbook or plan to open a new one. But I typically only use
one workbook at a time. The macro will affect ALL open workbooks. I also
run the macro when I get bad data, to see if a fresh copy of the web page
repeats the issue.
Some people have so many functions that the smfForceRecalculation macro can
cause the EXCEL to go into calculation mode for 20-40 minutes. Even more.
On Sat, Sep 21, 2013 at 10:42 AM, Douglas <jurisdoctor74@yahoo.com> wrote:
> Progress! I just tried "Ctl+Shift+R" and it solved the problem as the NA
> changed to -.63. However, I don't understand why.
>
> Is there some setting I need to change to keep the data constantly "fresh"
> in order to avoid having to use the "Ctl+Shift+R" procedure?
>
mentioned.
That purges all saved copies of web pages and loads a fresh copy of the web
page into the "saved area" of the add-in, from where it extracts that data.
The add-in has a "saved area" like that so that if you are extracting 60
items from the same web page, it doesn't need to retrieve the web page 60
times. That would slow data retrieval down to a crawl.
So, no, there isn't a way to keep the data constantly "fresh"
running the smfForceRecalculati
close down a workbook or plan to open a new one. But I typically only use
one workbook at a time. The macro will affect ALL open workbooks. I also
run the macro when I get bad data, to see if a fresh copy of the web page
repeats the issue.
Some people have so many functions that the smfForceRecalculati
cause the EXCEL to go into calculation mode for 20-40 minutes. Even more.
On Sat, Sep 21, 2013 at 10:42 AM, Douglas <jurisdoctor74@
> Progress! I just tried "Ctl+Shift+
> changed to -.63. However, I don't understand why.
>
> Is there some setting I need to change to keep the data constantly "fresh"
> in order to avoid having to use the "Ctl+Shift+
>
Sat Sep 21, 2013 11:03 am (PDT) . Posted by:
"Douglas" jurisdoctor74
Okay, now I understand.
But,in your reply, you said, "I typically run it whenever I close down a workbook or plan to open a new one". Doesn't the workbook have to be open at the time you run the macro?
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Probably because Ctrl+Shift+R runs the smfForceRecalculation macro I just
> mentioned.
>
> That purges all saved copies of web pages and loads a fresh copy of the web
> page into the "saved area" of the add-in, from where it extracts that data.
>
> The add-in has a "saved area" like that so that if you are extracting 60
> items from the same web page, it doesn't need to retrieve the web page 60
> times. That would slow data retrieval down to a crawl.
>
> So, no, there isn't a way to keep the data constantly "fresh", *except* by
> running the smfForceRecalculation macro. I typically run it whenever I
> close down a workbook or plan to open a new one. But I typically only use
> one workbook at a time. The macro will affect ALL open workbooks. I also
> run the macro when I get bad data, to see if a fresh copy of the web page
> repeats the issue.
>
> Some people have so many functions that the smfForceRecalculation macro can
> cause the EXCEL to go into calculation mode for 20-40 minutes. Even more.
>
> On Sat, Sep 21, 2013 at 10:42 AM, Douglas <jurisdoctor74@...> wrote:
>
> > Progress! I just tried "Ctl+Shift+R" and it solved the problem as the NA
> > changed to -.63. However, I don't understand why.
> >
> > Is there some setting I need to change to keep the data constantly "fresh"
> > in order to avoid having to use the "Ctl+Shift+R" procedure?
> >
>
But,in your reply, you said, "I typically run it whenever I close down a workbook or plan to open a new one". Doesn't the workbook have to be open at the time you run the macro?
--- In smf_addin@yahoogrou
>
> Probably because Ctrl+Shift+R runs the smfForceRecalculati
> mentioned.
>
> That purges all saved copies of web pages and loads a fresh copy of the web
> page into the "saved area" of the add-in, from where it extracts that data.
>
> The add-in has a "saved area" like that so that if you are extracting 60
> items from the same web page, it doesn't need to retrieve the web page 60
> times. That would slow data retrieval down to a crawl.
>
> So, no, there isn't a way to keep the data constantly "fresh"
> running the smfForceRecalculati
> close down a workbook or plan to open a new one. But I typically only use
> one workbook at a time. The macro will affect ALL open workbooks. I also
> run the macro when I get bad data, to see if a fresh copy of the web page
> repeats the issue.
>
> Some people have so many functions that the smfForceRecalculati
> cause the EXCEL to go into calculation mode for 20-40 minutes. Even more.
>
> On Sat, Sep 21, 2013 at 10:42 AM, Douglas <jurisdoctor74@
>
> > Progress! I just tried "Ctl+Shift+
> > changed to -.63. However, I don't understand why.
> >
> > Is there some setting I need to change to keep the data constantly "fresh"
> > in order to avoid having to use the "Ctl+Shift+
> >
>
Sat Sep 21, 2013 12:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Oops. I always have EXCEL open with a new workbook with just Sheet1, to use
for whatever manipulations I might need. So I open other workbooks from
there, and then return to there.
So I do have more than one workbook open, but one will typically have
nothing in it.
For example, when you asked the question, I quickly went to that workbook
and tried that element number. After seeing good values for several ticker
symbols, I just deleted the columns those formula were in. Back to an empty
workbook. And when I was finished, I also hit my QAT button to run the
smfForceRecalculation macro. Back to an empty saved area in the add-in.
On Sat, Sep 21, 2013 at 11:03 AM, Douglas <jurisdoctor74@yahoo.com> wrote:
>
> But,in your reply, you said, "I typically run it whenever I close down a
> workbook or plan to open a new one". Doesn't the workbook have to be open
> at the time you run the macro?
>
for whatever manipulations I might need. So I open other workbooks from
there, and then return to there.
So I do have more than one workbook open, but one will typically have
nothing in it.
For example, when you asked the question, I quickly went to that workbook
and tried that element number. After seeing good values for several ticker
symbols, I just deleted the columns those formula were in. Back to an empty
workbook. And when I was finished, I also hit my QAT button to run the
smfForceRecalculati
On Sat, Sep 21, 2013 at 11:03 AM, Douglas <jurisdoctor74@
>
> But,in your reply, you said, "I typically run it whenever I close down a
> workbook or plan to open a new one". Doesn't the workbook have to be open
> at the time you run the macro?
>
Sat Sep 21, 2013 8:22 am (PDT) . Posted by:
manmohanbang
I tried the following but I am getting error as message
ableCell("http://financials.
egion=USA&culture=
<http://financials.
&culture=en-
Sat Sep 21, 2013 8:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's because there is no table within the source code of the web page
that contains such a table cell. The data you see on that page is placed
there dynamically, after the source code of the web page is delivered.
Since the add-in extracts data from the source code of the web page, it
can't extract that.
Instead, use the MorningStar CSV file mentioned in the LINKS area of the
group, and then pull your data from that array-entered range of data.
On Sat, Sep 21, 2013 at 8:00 AM, <manmohanbang@yahoo.in> wrote:
> I tried the following but I am getting error as message
>
> ableCell("
> http://financials.morningstar.com/ratios/r.html?t=IBM®ion=USA&culture=en-US",1,"OperatingIncome")
>
>
that contains such a table cell. The data you see on that page is placed
there dynamically, after the source code of the web page is delivered.
Since the add-in extracts data from the source code of the web page, it
can't extract that.
Instead, use the MorningStar CSV file mentioned in the LINKS area of the
group, and then pull your data from that array-entered range of data.
On Sat, Sep 21, 2013 at 8:00 AM, <manmohanbang@
> I tried the following but I am getting error as message
>
> ableCell("
> http://financials.
>
>
Sat Sep 21, 2013 8:46 am (PDT) . Posted by:
manmohanbang
Ok.
I realized lot of available data is on ADVFN so I tried
=RCHGetElementNumbe
Although =RCHGetElementNumbe
something wrong?
--- In smf_addin@yahoogrou
wrote:
That's because there is no table within the source code of the
web page that contains such a table cell. The data you see on
that page is placed there dynamically, after the source code of
the web page is delivered. Since the add-in extracts data from
the source code of the web page, it can't extract that.
Instead, use the MorningStar CSV file mentioned in the LINKS area
of the group, and then pull your data from that array-entered
range of data.
On Sat, Sep 21, 2013 at 8:00 AM, <manmohanbang@
<mailto:manmohan
I tried the following but I am getting error as message
ableCell("http://financials.
egion=USA&culture=
<http://financials.
&culture=en-
Sat Sep 21, 2013 8:59 am (PDT) . Posted by:
manmohanbang
Also, I tried RChgettablecell which is working fine the only
issue is how do I get annual reports staring 2003. The website
doesn't seem to be working if I change the start date of the
annual report
--- In smf_addin@yahoogrou
Ok.
I realized lot of available data is on ADVFN so I tried
=RCHGetElementNumbe
Although =RCHGetElementNumbe
something wrong?
--- In smf_addin@yahoogrou
wrote:
That's because there is no table within the source code of the
web page that contains such a table cell. The data you see on
that page is placed there dynamically, after the source code of
the web page is delivered. Since the add-in extracts data from
the source code of the web page, it can't extract that.
Instead, use the MorningStar CSV file mentioned in the LINKS area
of the group, and then pull your data from that array-entered
range of data.
On Sat, Sep 21, 2013 at 8:00 AM, <manmohanbang@
<mailto:manmohan
I tried the following but I am getting error as message
ableCell("http://financials.
egion=USA&culture=
<http://financials.
&culture=en-
Sat Sep 21, 2013 9:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you look back at messages over the past month, you'll see AdvFN has been
a hot topic of conversation. They've been in the midst of changing their
website, and I don't think they know what they are doing.
So, for now, AdvFN is probably not a good source of data.
Some have gone to GuruFocus and MorningStar for 10 annual periods of data.
On Sat, Sep 21, 2013 at 8:46 AM, <manmohanbang@yahoo.in> wrote:
>
> Ok.
>
> I realized lot of available data is on ADVFN so I tried
>
> =RCHGetElementNumber("IBM";,7689) and this is giving me an error. Although
> =RCHGetElementNumber("IBM";,941) is working. Am I doing something wrong?
>
>
a hot topic of conversation. They've been in the midst of changing their
website, and I don't think they know what they are doing.
So, for now, AdvFN is probably not a good source of data.
Some have gone to GuruFocus and MorningStar for 10 annual periods of data.
On Sat, Sep 21, 2013 at 8:46 AM, <manmohanbang@
>
> Ok.
>
> I realized lot of available data is on ADVFN so I tried
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
>
>
Sat Sep 21, 2013 9:03 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's just one of the things AdvFN broke on their web page...
On Sat, Sep 21, 2013 at 8:59 AM, <manmohanbang@yahoo.in> wrote:
> Also, I tried RChgettablecell which is working fine the only issue is how
> do I get annual reports staring 2003. The website doesn't seem to be
> working if I change the start date of the annual report
>
On Sat, Sep 21, 2013 at 8:59 AM, <manmohanbang@
> Also, I tried RChgettablecell which is working fine the only issue is how
> do I get annual reports staring 2003. The website doesn't seem to be
> working if I change the start date of the annual report
>
Sat Sep 21, 2013 7:20 pm (PDT) . Posted by:
"Deborah" dcharlotte99
First, my thanks to John Babcock for the new ADVFN 10-yr financial spreadsheet that works with the changes to the ADVFN website. It will be a lifesaver once I get it to update.
That's my problem, the spreadsheet won't recalculate when I enter a new ticker.
F9 changes the company and exchange info cells as well as the URL cells John includes. But all the data is $0.00. There are no error codes.
I noticed the spreadsheet uses C:/SMF for the Add-in location, I created that. I've had the add-in installed at C:/Program Files/SMF Add-in for several years. I made sure the Add-in is active in the Excel Options.
Any clues why the data doesn't update?
That's my problem, the spreadsheet won't recalculate when I enter a new ticker.
F9 changes the company and exchange info cells as well as the URL cells John includes. But all the data is $0.00. There are no error codes.
I noticed the spreadsheet uses C:/SMF for the Add-in location, I created that. I've had the add-in installed at C:/Program Files/SMF Add-in for several years. I made sure the Add-in is active in the Excel Options.
Any clues why the data doesn't update?
Tidak ada komentar:
Posting Komentar