Minggu, 02 Agustus 2015

[smf_addin] Digest Number 3475[2 Attachments]

8 Messages

Digest #3475

Messages

Sat Aug 1, 2015 7:17 am (PDT) . Posted by:

ehrlichk

Internet Explorer is still there in Windows 10. At least it is on my computer. Just type in Internet Explorer in the search box.

Sat Aug 1, 2015 12:22 pm (PDT) . Posted by:

ridgebacksexcel

Here is the result of my web query from Excel 13.
Looks like it is using IE 11. So ok there.


Internet Explorer Browser Detector

Your browser is IE: true
Your IE browser version: 11
----------------------------------------------------------
True IE browser version (independent of userAgent, document mode, or browser mode): 11.0.10240.16384
IE browser version (derived from navigator.userAgent): 7
IE browser document mode: 7


I opened Internet Explorer 11 with the link I had and checked for Reload a new web page every time I visit.
I was not checked so I selected it.
I deleted all my browsing history and cached data.
Closed Explorer and restarted computer.
I was hopeful this would fix the problem,.


Unfortunately it did not.


So in the interest of elimination all the possible problems, here is the exact formula again that does not work.


=smfConvertData(smfGetTagContent("http://quotes.wsj.com/hpq/financials","span",2,">Valuation",">Enterprise Value to EBITDA"))


I have even tried running the smfforcerecalculation macro manually but it does not fix the error message.


This is starting to get frustrating. Most other formulas work.


RCHGetTableCell works.
The smfConvertData(smfGetTagContent( formula works with ptags "p" and "strong".


I have not looked at other formulas yet but it must have something to do with the span ptag. Weird.





Sat Aug 1, 2015 1:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Let's try something different. What do you get with:

=RCHGetWebData("http://quotes.wsj.com/hpq/financials",">Enterprise Value to
EBITDA",200)

I get:

>Enterprise Value to EBITDA</span> <span class="data_data"> <span
class="marketDelta noChange">4.53</span> </span> </td> </tr> <tr> <td>
<span class="data_lbl updated-daily">Enterprise Value to Sales<

This:

=RCHGetTableCell("http://quotes.wsj.com/hpq/financials",0,">Enterprise
Value to EBITDA")

....gets me:

Enterprise Value to EBITDA4.53

...and this:

=smfGetTagContent("http://quotes.wsj.com/hpq/financials","td",-1,">Enterprise
Value to EBITDA")

...gets me:

<span class="data_lbl updated-daily">Enterprise Value to EBITDA</span>
<span class="data_data"> <span class="marketDelta noChange">4.53</span>
</span>

On Sat, Aug 1, 2015 at 12:22 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Here is the result of my web query from Excel 13.
> Looks like it is using IE 11. So ok there.
>
> *Internet Explorer Browser Detector*
>
> Your browser is IE: true
> Your IE browser version: 11
>
> ----------------------------------------------------------
> True IE browser version (independent of userAgent, document mode, or
> browser mode): 11.0.10240.16384
> IE browser version (derived from navigator.userAgent): 7
> IE browser document mode: 7
>
> I opened Internet Explorer 11 with the link I had and checked for Reload a
> new web page every time I visit.
> I was not checked so I selected it.
> I deleted all my browsing history and cached data.
> Closed Explorer and restarted computer.
> I was hopeful this would fix the problem,.
>
> Unfortunately it did not.
>
> So in the interest of elimination all the possible problems, here is the
> exact formula again that does not work.
>
> =smfConvertData(smfGetTagContent("http://quotes.wsj.com/hpq/financials","span",2,">Valuation&quot;,">Enterprise
> Value to EBITDA"))
>
> I have even tried running the smfforcerecalculation macro manually but it
> does not fix the error message.
>
> This is starting to get frustrating. Most other formulas work.
>
> RCHGetTableCell works.
> The smfConvertData(smfGetTagContent( formula works with ptags "p" and
> "strong".
>
> I have not looked at other formulas yet but it must have something to do
> with the span ptag. Weird.
>
>

Sat Aug 1, 2015 1:48 pm (PDT) . Posted by:

ridgebacksexcel

Let's try something different. What do you get with:

=RCHGetWebData("http://quotes.wsj.com/hpq/financials http://quotes.wsj.com/hpq/financials",">Enterprise Value to EBITDA",200)


I get:

>Enterprise Value to EBITDA</span> <span class="data_data"> <span class="marketDelta noChange">4.53</span> </span> </td> </tr> <tr> <td> <span class="data_lbl updated-daily">Enterprise Value to Sales<


My result is: False



This:

=RCHGetTableCell("http://quotes.wsj.com/hpq/financials http://quotes.wsj.com/hpq/financials",0,">Enterprise Value to EBITDA")


....gets me:

Enterprise Value to EBITDA4.53


My Result is: True


...and this:

=smfGetTagContent("http://quotes.wsj.com/hpq/financials http://quotes.wsj.com/hpq/financials","td",-1,">Enterprise Value to EBITDA")


...gets me:

<span class="data_lbl updated-daily">Enterprise Value to EBITDA</span> <span class="data_data"> <span class="marketDelta noChange">4.53</span> </span>



My Result is: Error

Sat Aug 1, 2015 4:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you're getting "True" and "False" results, you're cutting and pasting
incorrectly.

On Sat, Aug 1, 2015 at 1:48 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Let's try something different. What do you get with:
>
> =RCHGetWebData("*http://quotes.wsj.com/hpq/financials*
> <http://quotes.wsj.com/hpq/financials>",">Enterprise Value to EBITDA",200)
>
> I get:
>
> >Enterprise Value to EBITDA</span> <span class="data_data"> <span
> class="marketDelta noChange">4.53</span> </span> </td> </tr> <tr> <td>
> <span class="data_lbl updated-daily">Enterprise Value to Sales<
>
>
> *My result is: False*
>
> This:
>
> =RCHGetTableCell("*http://quotes.wsj.com/hpq/financials*
> <http://quotes.wsj.com/hpq/financials>",0,">Enterprise Value to EBITDA")
>
> ....gets me:
>
> Enterprise Value to EBITDA4.53
>
> *My Result is: True*
>
> ...and this:
>
> =smfGetTagContent("*http://quotes.wsj.com/hpq/financials*
> <http://quotes.wsj.com/hpq/financials>","td",-1,">Enterprise Value to
> EBITDA")
>
> ...gets me:
>
> <span class="data_lbl updated-daily">Enterprise Value to EBITDA</span>
> <span class="data_data"> <span class="marketDelta noChange">4.53</span>
> </span>
>
> *My Result is: Error*
>

Sat Aug 1, 2015 6:37 pm (PDT) . Posted by:

ridgebacksexcel

No I typed it in again exactly as shown. The result shows error and the formula result shows False.


It is not able to look at the web site page for some reason. I can email you the file if you want to look at it.


I built a blank excel sheet with just a few of these formulas to test. If I can find the problem I can transfer the solution over to the spreadsheet I have built that is very extensive.


I attached a screenshot of the spreadsheet with the formula box open. Hopefully you can see it.






Attachment(s) from
1 of 1 Photo(s)

Sat Aug 1, 2015 7:28 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I've attached a workbook with just the three formulas I gave you. What
results do you see?

You may need to run the smfFixLinks macro to fix unresolved links. My
add-in may be in a different location than yours.

------------------------------

By the way, one thing does bother me about your screenshot -- it shows two
different results. Just below the area where it echoes your parameter
values, it says:

= "Error"

...which means that formula is returning a value of "Error". However,
towards the bottom, just above the HELP link, it says:

Formula Result = FALSE

That implies to me that you have more than just that one function in that
cell, because "Error" is the result of the single function you're
examining, but "FALSE" is the result of the total formula in the cell.

------------------------------

At this point, I'm expecting you to see "Error" on all three results of the
formulas in my attached workbook. Here's why:

That "Error" result for the function in your image implies to me that you
can't retrieve the EXPECTED source code of the web page. Typically, that
means there could be some type of verification or redirection going on at
the site that is controlled by a cookie. Until that cookie is turned off,
it will continue trying to go to that verification/redirection page. Only
browser processing can adjust that cookie -- the SMF add-in doesn't run any
JavaScript code, it just retrieves the raw source code of the web page.

So, try this:

1. Visit the web page in question in the EXCEL Web Query dialog that we
used earlier. See if you can actually get to the data using the IE object
used by EXCEL.
2. Cancel out of the Web Query.
3. Run the smfForceRecalculation macro, to force the add-in to get a new
copy of the web page from the Internet.

What I'm hoping is that step (1) will allow that cookie to be updated, so
that you're no longer forced to redirect to some other web page.

------------------------------

Hmmm. If that doesn't work, another possibility -- when I use this URL in
FireFox:

http://quotes.wsj.com/hpq/financials

...it redirects me to:

http://quotes.wsj.com/HPQ/financials

What happens if you change your formulas to use an upper-case ticker symbol?

------------------------------

If that doesn't work, the last resort would be to see if it can get ANY
source code at all. Try:

=RCHGetWebData("http://quotes.wsj.com/HPQ/financials",1)
=smfGetTagContent("http://quotes.wsj.com/HPQ/financials","title")
=smfGetTagContent("http://quotes.wsj.com/HPQ/financials","table")

The first formula shows whatever source code it gets back. The other two
would get the title of the web page and the first table found on the web
page. If you can't get any source code at all, all three would return
"Error".

What I've done in some situations like this is take the data returned by
that first formula, put it onto the Internet as a web page, and see what
the web page looks like. In a few cases, I've gotten some type of error
message that the web site is sending out, instead of the expected data
page. Such an error message would almost always result in "Error" results
for data extractions.

------------------------------

On Sat, Aug 1, 2015 at 6:37 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> [Attachment(s) <#14eec0e4d66cb643_TopText> from tmallen2@bellsouth.net
> [smf_addin] included below]
>
> No I typed it in again exactly as shown. The result shows error and the
> formula result shows False.
>
> It is not able to look at the web site page for some reason. I can email
> you the file if you want to look at it.
>
> I built a blank excel sheet with just a few of these formulas to test. If
> I can find the problem I can transfer the solution over to the spreadsheet
> I have built that is very extensive.
>
> I attached a screenshot of the spreadsheet with the formula box open.
> Hopefully you can see it.
>
> Attachment(s) from tmallen2@bellsouth.net [smf_addin] | View attachments
> on the web
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/1287483185;_ylc=X3oDMTJycXVybWM5BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDdmlld09uV2ViBHN0aW1lAzE0Mzg0Nzk0MzQ->
>
> 1 of 1 Photo(s)
> [image: Screenshot (1).png]
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/1287483185;_ylc=X3oDMTJubnJsNnV0BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTQzODQ3OTQzNA--?itemid=614490357>
> Screenshot (1).png
> <https://groups.yahoo.com/neo/groups/smf_addin/attachments/1287483185;_ylc=X3oDMTJubnJsNnV0BF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDYXR0YWNobWVudARzbGsDcGhvdG8Ec3RpbWUDMTQzODQ3OTQzNA--?itemid=614490357>
> ------------------------------
>
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)

Sat Aug 1, 2015 8:16 pm (PDT) . Posted by:

ridgebacksexcel

Ok Thanks Randy. I am going to be very busy the next two days so I don't think I can look at this till Tuesday. The problem is coming from my Microsoft Surface Pro tablet/laptop. It was the first computer I tried to open my spreadsheet on after the Windows 10 upgrade. My home desktop has the Windows 10 upgrade too but I have not tested the spreadsheet on it yet. I will be home Tuesday and can check the desktop out too to see if it works.


I always had broken links to the SMF add-in since the spreadsheet saves to the OneDrive cloud each time and then I switch computers. I mostly use my desktop for the spreadsheet.


When I use the Surface Pro I just edit the link location. Sometimes I reinstall the add in but it always worked.


In this case the add-in works but not all the formulas so it is running.


Thanks for your help so far. It is getting me closer to zeroing in on the problem,


I will report back Tuesday or Wednesday with my findings.

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar