Sabtu, 01 Agustus 2015

[smf_addin] Digest Number 3474

12 Messages

Digest #3474

Messages

Fri Jul 31, 2015 8:20 am (PDT) . Posted by:

thadmalley

while using the rchgetyahooquotes function for "n" which gives the name of the security...some names have come back "n/a"...but some are fine...and the tickers are correct....anyone else experiencing this?


Thanks

Fri Jul 31, 2015 8:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Others mentioned it was happening to them two days ago:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/28878

On Fri, Jul 31, 2015 at 8:17 AM, cooler_king@... wrote:

> while using the rchgetyahooquotes function for "n" which gives the name of
> the security...some names have come back "n/a"...but some are fine...and
> the tickers are correct....anyone else experiencing this?
>
>

Fri Jul 31, 2015 2:11 pm (PDT) . Posted by:

ridgebacksexcel

Randy,


This formula is returning an error message now and I can not figure out the problem. Could you take a look at it for me please.


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


It should return 4.53 but I get Error.


Thanks.

Fri Jul 31, 2015 2:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't get an error, but it does look like they added another "span" tag
in there. I'm not sure how consistent their web page coding will be. This
change worked for me (i.e. changing 1 to 2):

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

On Fri, Jul 31, 2015 at 2:11 PM, tmallen2@... wrote:

>
> This formula is returning an error message now and I can not figure out
> the problem. Could you take a look at it for me please.
>
> =smfConvertData(smfGetTagContent("http://quotes.wsj.com/hpq/financials","span",1,">Valuation",">Enterprise
> Value to EBITDA"))
>
> It should return 4.53 but I get Error.
>

Fri Jul 31, 2015 4:12 pm (PDT) . Posted by:

ridgebacksexcel

It seems the WSJ site is causing me the problem. Market Watch, Yahoo, GuruFocus and Morningstar seems to work fine. I upgraded to Windows 10 yesterday. This might have something to do with the problem. Windows 10 uses the Microsoft Edge browser.


I put the formula in as described by you with the "2" instead of "1" and the same error message. If nothing on any site worked I would know there is a Windows 10 conflict, but it seems to be the WSJ site which is the primary site I need to pull data from.


Does the "1" pull the data in the formula for you or only when you put the "2" in? PS. No quotes of course.


Any other ideas?

Fri Jul 31, 2015 4:33 pm (PDT) . Posted by:

ridgebacksexcel

I went and looked at a bunch of different formulas. It might be a problem with the "span" tag. "strong" and "p" tags seem to work. Is there another tag I could use to get the data if we can't get the span tag to work?

Fri Jul 31, 2015 4:34 pm (PDT) . Posted by:

ridgebacksexcel

>>>Does the "1" pull the data in the formula for you or only when you put the "2" in? PS. No quotes of course.<<<


Actually ignore this statement. My formula actually has a "2" in it to pull the data. I used a "1" to test if the data was blank to look at another site.


My problem stills stands with the formula not working.


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

Fri Jul 31, 2015 4:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you, since that formula works fine for me...I did a
direct copy and paste as text into EXCEL.

Have you tried running the smfForceRecalculation macro, to get a fresh copy
of the web page? Possibly you got a glitched copy of the page? Also be sure
that your Internet Options are set to always get a new copy of the web page
when visiting a web site.

On Fri, Jul 31, 2015 at 4:34 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> >>>Does the "1" pull the data in the formula for you or only when you put
> the "2" in? PS. No quotes of course.<<<
>
> Actually ignore this statement. My formula actually has a "2" in it to
> pull the data. I used a "1" to test if the data was blank to look at
> another site.
>
> My problem stills stands with the formula not working.
>
> =smfConvertData(smfGetTagContent("http://quotes.wsj.com/hpq/financials","span",2,">Valuation&quot;,">Enterprise
> Value to EBITDA"))
>

Fri Jul 31, 2015 5:48 pm (PDT) . Posted by:

ridgebacksexcel

Ok this is getting interesting now. Microsoft Edge as best I can tell does not have a setting to reload a new web page every time you visit it. So not sure how to fix that.


I try to run the macro as you suggested but it will not run. It says it is disabled. I enabled all macros to run in the trust center but it still does not work.


I had saved the macro before as a quick menu key. It always worked before.


Lastly I re-read the instructions you have to set up the macro. Alt-F8 only brings up the settings page in Windows 10. It does not bring up the macro page for Excel ny more. Great.


Not sure what to do now.


I think this is all Windows 10 related.


Hopefully a solution or work around can be found as going back to an earlier Windows is not really an option.

Fri Jul 31, 2015 5:58 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't use either Windows 10 or Microsoft Edge, so can't offer any
solutions.

Do you know what EXCEL uses for web queries? Is it Microsoft Edge or IE? I
wouldn't think Windows 10 would change how EXCEL would operate. Although I
can see how it could hijack keyboard shortcuts. But pretty bad design on
Microsoft's part to hijack standard keyboard shortcuts of their own
application software.

On Fri, Jul 31, 2015 at 5:46 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Ok this is getting interesting now. Microsoft Edge as best I can tell does
> not have a setting to reload a new web page every time you visit it. So not
> sure how to fix that.
>
> I try to run the macro as you suggested but it will not run. It says it is
> disabled. I enabled all macros to run in the trust center but it still does
> not work.
>
> I had saved the macro before as a quick menu key. It always worked before.
>
> Lastly I re-read the instructions you have to set up the macro. Alt-F8
> only brings up the settings page in Windows 10. It does not bring up the
> macro page for Excel ny more. Great.
>
> Not sure what to do now.
>
>

Fri Jul 31, 2015 7:26 pm (PDT) . Posted by:

ridgebacksexcel

I was not able too figure out how to check the web query browser it uses. Do you know the steps to check?


I was able to activate the developer tab and get to the macro page. Then I typed in your macro name to run it.
Still did not fix the problem. I was hopeful it would.


Will keep digging.

Fri Jul 31, 2015 9:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't know which version of EXCEL you're using. You could use Google to
find out where it is. Here's what it looks like under EXCEL 2013:

http://www.smartfantasybaseball.com/2013/10/how-to-make-your-first-excel-web-query/

Usually, the keyboard shortcut alt+d+d+w bring up the web query dialog. If
you go to this web page:

http://www.pinlady.net/PluginDetect/IE/

...it should tell you which version of IE the EXCEL Web Query dialog is
using. For example, I get:

------------------------------
*Internet Explorer Browser Detector*

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

On Fri, Jul 31, 2015 at 7:26 PM, tmallen2@bellsouth.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I was not able too figure out how to check the web query browser it uses.
> Do you know the steps to check?
>
> I was able to activate the developer tab and get to the macro page. Then I
> typed in your macro name to run it.
> Still did not fix the problem. I was hopeful it would.
>
> Will keep digging.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar