9 Messages
Digest #4136
Messages
Thu Aug 31, 2017 9:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They may be another website that has moved to JSON data, and they build the
web page dynamically after retrieving the data from elsewhere. If so, you
need to see if the add-in can extract data from the "elsewhere"...
That last "1" parameter means that you're perusing the IE object, which
means the web page has completed all of its scripting. But I've not found
it to be reliable between different versions of IE and EXCEL and O/S.
On Thu, Aug 31, 2017 at 3:17 PM, buckleca@
...
wrote:
>
> In the Quick-webpage-examination spreadsheet:
>
> smfGetTagContent($C$7,$C$8,B12,$C$9) - always returns error
>
> smfGetTagContent($C$7,$C$8,B12,$C$9,,,,,,1) - sometimes returns the
> correct results - but mostly returns error.
>
> Maybe I'll try debugging the code and see what might be happening.
>
>
web page dynamically after retrieving the data from elsewhere. If so, you
need to see if the add-in can extract data from the "elsewhere&quo
That last "1" parameter means that you're perusing the IE object, which
means the web page has completed all of its scripting. But I've not found
it to be reliable between different versions of IE and EXCEL and O/S.
On Thu, Aug 31, 2017 at 3:17 PM, buckleca@
...
wrote:
>
> In the Quick-webpage-
>
> smfGetTagContent(
>
> smfGetTagContent(
> correct results - but mostly returns error.
>
> Maybe I'll try debugging the code and see what might be happening.
>
>
Thu Aug 31, 2017 11:37 pm (PDT) . Posted by:
buckleca
I discovered something.
When I first open the spreadsheet and the functions all return error, while the same spreadsheet is open I select Data - From Web - paste the link into the Excel i/e browser - Go, it loads correctly except for a script error.
I then click on Yes to continue running the scripts.... Close without running Import - Force Calculation - and the functions work correctly.
Without doing this step, it's all errors!
Maybe the functions can't process the script error on the first run? Strange.
Thanks for your help.
When I first open the spreadsheet and the functions all return error, while the same spreadsheet is open I select Data - From Web - paste the link into the Excel i/e browser - Go, it loads correctly except for a script error.
I then click on Yes to continue running the scripts.... Close without running Import - Force Calculation - and the functions work correctly.
Without doing this step, it's all errors!
Maybe the functions can't process the script error on the first run? Strange.
Thanks for your help.
Fri Sep 1, 2017 1:50 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is sometimes an issue with Morningstar, where I need to visit the
site before I can get data. It's generally when they have a redirection to
some type of advertising or special notice. It then sets a cookie that
indicates it no longer needs to do that. Since the add-in just grabs source
code, it can't run the script that updates the cookie.
It could be your site has something like that...?
On Thu, Aug 31, 2017 at 11:37 PM, buckleca@
...
wrote:
>
> I discovered something.
>
> When I first open the spreadsheet and the functions all return error,
> while the same spreadsheet is open I select Data - From Web - paste the
> link into the Excel i/e browser - Go, it loads correctly except for a
> script error.
>
> I then click on Yes to continue running the scripts.... Close without
> running Import - Force Calculation - and the functions work correctly.
>
> Without doing this step, it's all errors!
>
> Maybe the functions can't process the script error on the first run?
> Strange.
>
> Thanks for your help.
>
site before I can get data. It's generally when they have a redirection to
some type of advertising or special notice. It then sets a cookie that
indicates it no longer needs to do that. Since the add-in just grabs source
code, it can't run the script that updates the cookie.
It could be your site has something like that...?
On Thu, Aug 31, 2017 at 11:37 PM, buckleca@
...
wrote:
>
> I discovered something.
>
> When I first open the spreadsheet and the functions all return error,
> while the same spreadsheet is open I select Data - From Web - paste the
> link into the Excel i/e browser - Go, it loads correctly except for a
> script error.
>
> I then click on Yes to continue running the scripts.... Close without
> running Import - Force Calculation - and the functions work correctly.
>
> Without doing this step, it's all errors!
>
> Maybe the functions can't process the script error on the first run?
> Strange.
>
> Thanks for your help.
>
Fri Sep 1, 2017 9:07 am (PDT) . Posted by:
buckleca
Thanks Randy
This might be a temporary problem with the website and it looks like the script error is happening on an ad link.
At least in the meantime I can run the internal i/e once and the SMF functions work like a charm.
I'll carry on as if I'm in my right mind
This might be a temporary problem with the website and it looks like the script error is happening on an ad link.
At least in the meantime I can run the internal i/e once and the SMF functions work like a charm.
I'll carry on as if I'm in my right mind
Thu Aug 31, 2017 10:26 pm (PDT) . Posted by:
zbgb952
High Randy,
I just updated one of my Excel spreadsheets that use your functions and for some reason, the 5 year
dividend growth function I used: RCHGetElementNumber($D36,13674)/100, where $D36 is the stock ticker symbol, gave me a value of 0.00% for every stock ticker in my spreadsheet.
Has something changed with this?
Thankyou
Morey
I just updated one of my Excel spreadsheets that use your functions and for some reason, the 5 year
dividend growth function I used: RCHGetElementNumber
Has something changed with this?
Thankyou
Morey
Thu Aug 31, 2017 11:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's because Reuters has not been populating company data on the web page:
http://www.reuters.com/finance/stocks/financial-highlights/MMM
Another add-in user had a similar issue and contacted Reuters, getting this
response:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33045
On Thu, Aug 31, 2017 at 10:26 PM, mb0329@
...
wrote:
>
> I just updated one of my Excel spreadsheets that use your functions and
> for some reason, the 5 year
> dividend growth function I used: RCHGetElementNumber($D36,13674)/100,
> where $D36 is the stock ticker symbol, gave me a value of 0.00% for every
> stock ticker in my spreadsheet.
>
> Has something changed with this?
>
>
http://www.reuters.com/finance/stocks/financial-highlights/MMM
Another add-in user had a similar issue and contacted Reuters, getting this
response:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/33045
On Thu, Aug 31, 2017 at 10:26 PM, mb0329@
...
wrote:
>
> I just updated one of my Excel spreadsheets that use your functions and
> for some reason, the 5 year
> dividend growth function I used: RCHGetElementNumber
> where $D36 is the stock ticker symbol, gave me a value of 0.00% for every
> stock ticker in my spreadsheet.
>
> Has something changed with this?
>
>
Fri Sep 1, 2017 8:55 am (PDT) . Posted by:
joelfp2000
Randy,
I hope you've had a great week. Thanks for your help with my questions this week.
I'm on the M* Quicktake report and would like retrieve the "% Rank in Category" under the Tax Analysis section, not the Performance History section.
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=sambx http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=sambx
The formula that I am using is as follows:
=RCHGetTableCell("http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol="&$A2,1,"% Rank in Category")/100
I usually change the ,1, to a ,2, etc. if I want the next column's data, etc. However, I can't figure out how to move to the next section.
Any help would be wonderful as I'm totally stumped.
Thanks in advance and I hope you enjoy your Labor Day weekend!
Joel
I hope you've had a great week. Thanks for your help with my questions this week.
I'm on the M* Quicktake report and would like retrieve the "% Rank in Category" under the Tax Analysis section, not the Performance History section.
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=sambx http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=sambx
The formula that I am using is as follows:
=RCHGetTableCell("http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol="&$A2,1,
I usually change the ,1, to a ,2, etc. if I want the next column's data, etc. However, I can't figure out how to move to the next section.
Any help would be wonderful as I'm totally stumped.
Thanks in advance and I hope you enjoy your Labor Day weekend!
Joel
Fri Sep 1, 2017 10:36 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You can use up to four search terms, so you need to position yourself first
before looking for "% in Category". For example:
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol="&$A2,1,">Tax
Analysis","% Rank in Category")
On Fri, Sep 1, 2017 at 8:55 AM, joel.andrews@
...
wrote:
> I'm on the M* Quicktake report and would like retrieve the "% Rank in
> Category" under the Tax Analysis section, not the Performance History
> section.
>
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=sambx
>
> The formula that I am using is as follows:
>
> =RCHGetTableCell("http://quicktake.morningstar.com/
> fundnet/printreport.aspx?symbol="&$A2,1,"% Rank in Category")/100
>
> I usually change the ,1, to a ,2, etc. if I want the next column's data,
> etc. However, I can't figure out how to move to the next section.
>
> Any help would be wonderful as I'm totally stumped.
>
>
>
before looking for "% in Category". For example:
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol="&$A2,1,">Tax
Analysis","% Rank in Category")
On Fri, Sep 1, 2017 at 8:55 AM, joel.andrews@
...
wrote:
> I'm on the M* Quicktake report and would like retrieve the "% Rank in
> Category" under the Tax Analysis section, not the Performance History
> section.
>
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=sambx
>
> The formula that I am using is as follows:
>
> =RCHGetTableCell("http://quicktake.morningstar.com/
> fundnet/printreport
>
> I usually change the ,1, to a ,2, etc. if I want the next column's data,
> etc. However, I can't figure out how to move to the next section.
>
> Any help would be wonderful as I'm totally stumped.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
