[smf_addin] Digest Number 3144

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3144

1a

Troubleshooting errors by racecar00

1b

Re: Troubleshooting errors by "Randy Harmelink" rharmelink

1c

Re: Troubleshooting errors by racecar00

1d

Re: Troubleshooting errors by "Randy Harmelink" rharmelink

2

why isn't there any MSN Stock Scouter rating data? by zbgb952

Messages

1a

Troubleshooting errors

Thu Aug 7, 2014 1:51 pm (PDT) . Posted by:

racecar00

Hi Randy,


A spreadsheet that I frequently use is displaying errors for the following elements:


- 944
- 691
- 692
- 595
-596


In addition, the following formula is no longer pulling in data (displays "Error"):

- =smfGetTagContent(" http://finance.yahoo.com/q/pr?s="&$C$5,"p",1,">Business Summary")


I'd like to know if these errors are global or specific to me. I tried several tickers with no lunch (i.e. MSFT, IBM, AMZN). If it is the latter, can you offer suggestions to diagnose and repair errors?



Thanks,

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: Troubleshooting errors

Thu Aug 7, 2014 2:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. All of those work fine for me right now using ticker symbol MMM.

Since all are Yahoo items, it may have been a temporary glitch on Yahoo's
part. Did you try running the smfForceRecalculation macro, to force the
add-in to try and retrieve the web pages again?

On Thu, Aug 7, 2014 at 1:51 PM, agelhausen@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> A spreadsheet that I frequently use is displaying errors for the
> following elements:
>
> - 944
>
> - 691
>
> - 692
>
> - 595
>
> -596
>
> In addition, the following formula is no longer pulling in data (displays
> "Error"):
>
> - =smfGetTagContent(" http://finance.yahoo.com/q/pr?s="&$C$5,"p",1,">Business
> Summary")
>
> I'd like to know if these errors are global or specific to me. I tried
> several tickers with no lunch (i.e. MSFT, IBM, AMZN). If it is the latter,
> can you offer suggestions to diagnose and repair errors?
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1c

Re: Troubleshooting errors

Thu Aug 7, 2014 2:24 pm (PDT) . Posted by:

racecar00

Interesting. I tried the following (in order of event):

1. smfforcerecalculation
2. Checked Yahoo pages directly to ensure data was populated
3. Restart spreadsheet/Excel, smfforcrecalcalculation
4. Restart machine, smff.....


No luck. Let me know if you have any other suggestions.


Thanks in advance.

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1d

Re: Troubleshooting errors

Thu Aug 7, 2014 4:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Hmmm. Try the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w), and
navigate to this web page:

http://finance.yahoo.com/q/ks?s=MMM

Does it look normal to you? If that works, try this in a new workbook and
tell me what it returns:

=smfGetTagContent("http://finance.yahoo.com/q/ks?s=MMM&x=1","table",-1,">Market
Cap")

Another possibility, but a long shot at this point -- do you have your
Internet Options set to get a new copy of the web page each time it's
accessed? It's possible, but unlikely after a reboot, that IE is caching a
bad web page...?

On Thu, Aug 7, 2014 at 2:24 PM, agelhausen@... wrote:

>
> Interesting. I tried the following (in order of event):
>
> 1. smfforcerecalculation
> 2. Checked Yahoo pages directly to ensure data was populated
> 3. Restart spreadsheet/Excel, smfforcrecalcalculation
> 4. Restart machine, smff.....
>
> No luck. Let me know if you have any other suggestions.
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2

why isn't there any MSN Stock Scouter rating data?

Fri Aug 8, 2014 12:38 am (PDT) . Posted by:

zbgb952

I notice that your RCHGetElementNumber for numbers 542 - 552 say none or obsolete. Why is this. Can't you get them at:


StockScouter Rating System - MSN Money http://investing.money.msn.com/investments/stock-ratings?symbol=t


as an example?










StockScouter Rating System - MSN Money http://investing.money.msn.com/investments/stock-ratings?symbol=t The StockScouter rating system can help you quickly analyze and assess a stock's potential for outperforming the broad market.



View on investing.money.msn.com http://investing.money.msn.com/investments/stock-ratings?symbol=t
Preview by Yahoo

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

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

Visit Your Group

• New Members 31

• Privacy • Unsubscribe • Terms of Use