Rabu, 12 November 2014

[smf_addin] Digest Number 3237

12 Messages

Digest #3237
1.1
Re: Yahoo Key Statistics by "Randy Harmelink" rharmelink
3a
Re: Any updates on Stock Scouter? by "Randy Harmelink" rharmelink
4a
Re: MSN data by "Randy Harmelink" rharmelink
4b
Re: MSN data by antonvanas1989
4c
Re: MSN data by "Randy Harmelink" rharmelink
5a
Re: I'm back... by "Brad Reel" reeldeal9090
6b
Re: How to see contents of web page by "Randy Harmelink" rharmelink
7b
Re: Select Case oHTTP.Status by "Randy Harmelink" rharmelink

Messages

Tue Nov 11, 2014 2:42 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I don't know what to tell you. When I use the Key Statistics template,
everything seems to be coming through fine for V and BKE...

I can't fix a problem if it doesn't repeat here.

On Sun, Nov 9, 2014 at 12:47 PM, silverwaits32@... wrote:

>
> I am having trouble with about 90% of the symbols I try to input using any
> of the element numbers found on the yahoo Key Statistics page. The problem
> that I am having is with companies that I know Yahoo is tracking, like Visa
> (V) and Buckle (BKE). I have verified that they are actually there by
> going to the actual Yahoo Key Statistics page using those symbols. I
> simply get an "ERROR" message. I have tried this in my own Excel program
> as well as the "Yahoo Key Statistics" SMF Excel download sheet.
>
> Does anyone have an answer to why this happens and, more importantly, a
> solution to it? Sorry if this is a re-post but I did a search and couldn't
> find a post asking the same question.
>
> Any info would be great. Thanks.
>
>
>
>
>
>

Tue Nov 11, 2014 2:43 am (PST) . Posted by:

"Randy Harmelink" rharmelink

As long as your workbook is set up with more than 256 columns, you should
be able to.

On Mon, Nov 10, 2014 at 12:30 PM, k.tafolli@... wrote:

> Is it possible to download data more than 256 column?
>

Tue Nov 11, 2014 2:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

From what I've heard, StockScouter was an exclusive MSN field...not likely
to show up on MSN again. There are always the MorningStar proprietary data
items...

On Sat, Nov 8, 2014 at 8:33 AM, Keith keith.elaine@... wrote:

>
> Are the MSN values ever coming back?
>
> Visit Your Group
> <https://groups.yahoo.com/neo/groups/smf_addin/info;_ylc=X3oDMTJmOXFuY2hhBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2Z2hwBHN0aW1lAzE0MTU2NzUxMjQ->
>
> - New Members
> <https://groups.yahoo.com/neo/groups/smf_addin/members/all;_ylc=X3oDMTJnaTJhMnNxBF9TAzk3MzU5NzE0BGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDdnRsBHNsawN2bWJycwRzdGltZQMxNDE1Njc1MTI0>
> 19
>
> [image: Yahoo! Groups]
> <https://groups.yahoo.com/neo;_ylc=X3oDMTJlbjZ2NnE1BF9TAzk3NDc2NTkwBGdycElkAzE4MDk0NjIwBGdycHNwSWQDMTcwNTYzMjE5OARzZWMDZnRyBHNsawNnZnAEc3RpbWUDMTQxNTY3NTEyNA-->
> • Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> •
> Unsubscribe <smf_addin-unsubscribe@yahoogroups.com?subject=Unsubscribe> • Terms
> of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/>
>
>
>

Tue Nov 11, 2014 2:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

I have different "new layouts" in FireFox and IE (and thus the add-in). The
IE (and add-in) layout has almost no data in it at all.

On Tue, Nov 11, 2014 at 3:33 AM, antonvanas1989@...wrote:

> Is there any Data from the new MSN layout available?
>
> I used for Europe stocks almost all data from MSN as it was the only
> source who provides annual report details from Europe companies..
>
> I hope there is some way how I can fix my sheet with new data so I can
> again get information.
>
> Couldn't find it on the forum yet :(
>

Tue Nov 11, 2014 10:52 am (PST) . Posted by:

antonvanas1989

So at the moment I can do nothing to retrieve the data?


I see they still have the data, but in a new form and with new url..


the data on the html is build from Li and <p class functions now, is it still possible to get those tables?


BAMNB income statement | Koninklijke Bam Groep NV - MSN Money http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS


http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS

BAMNB income statement | Koninklijke Bam Groep NV ... http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS Get the annual and quarterly income statement for Koninklijke Bam Groep NV (BAMNB). Dive deeper with other data, such as the company's balance sheet a...



View on www.msn.com http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS
Preview by Yahoo




Tue Nov 11, 2014 11:10 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Something like this appears to work:

=smfGetTagContent("
http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS","p",1,">Financials",">Stmt
Source Date")

=smfGetTagContent("
http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS","p",2,">Financials",">Stmt
Source Date")

=smfGetTagContent("
http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS","p",3,">Financials",">Stmt
Source Date")

=smfGetTagContent("
http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS","p",4,">Financials",">Stmt
Source Date")

=smfGetTagContent("http://www.msn.com/en-us/money/stockdetails/financials
/fi-202.1.BAMNB.AMS","p",5,">Financials",">Stmt Source Date")

=smfGetTagContent("
http://www.msn.com/en-us/money/stockdetails/financials/fi-202.1.BAMNB.AMS","p",6,">Financials",">Stmt
Source Date")

On Tue, Nov 11, 2014 at 11:52 AM, antonvanas1989@...wrote:

> So at the moment I can do nothing to retrieve the data?
>
> I see they still have the data, but in a new form and with new url..
>
> the data on the html is build from Li and <p class functions now, is it
> still possible to get those tables?
>

Tue Nov 11, 2014 3:57 am (PST) . Posted by:

"Brad Reel" reeldeal9090

Same here, Randy. Hope all is well. Take care of yourself.

On Mon, Nov 10, 2014 at 10:26 PM, Jose Jacob pepecan47@yahoo.ca [smf_addin]
<smf_addin@yahoogroups.com> wrote:

>
>
> Hi Randy - I wish you the best, I hope your health is good.
>
> Regards,
> Jose L. Jacob
>
> --------------------------------------------
> On Mon, 11/10/14, rharmelink@gmail.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
> Subject: [smf_addin] I'm back...
> To: smf_addin@yahoogroups.com
> Received: Monday, November 10, 2014, 10:04 PM
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ...from about a week in the hospital,
> after a week or so of a flaky monitor that I had to
> replace...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>

Tue Nov 11, 2014 7:15 am (PST) . Posted by:

steve.bogart

I use Mozilla and Yahoo. How do I view the contents of my portfolio page?


Tue Nov 11, 2014 8:21 am (PST) . Posted by:

"Randy Harmelink" rharmelink

See: https://support.mozilla.org/en-US/questions/973832

On Tue, Nov 11, 2014 at 8:15 AM, stevebogart@nyc.rr.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I use Mozilla and Yahoo. How do I view the contents of my portfolio page?
>

Tue Nov 11, 2014 12:14 pm (PST) . Posted by:

flew_bert

When downloading stock data using GetYahooHistory I get this message:
Select Case oHTTP.Status



Is this a bug, or a corruption issue?


Regards,
FL


Tue Nov 11, 2014 3:30 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

No clue as to what might be going on.

You're saying if you try to use the RCHGetYahooHistory() function, it
returns a message in the cell in EXCEL, or brings up a VBA error message?

Which version of the add-in are you using:

=RCHGetElementNumber("Version&quot;)

On Tue, Nov 11, 2014 at 1:14 PM, fluebbert@... wrote:

> When downloading stock data using GetYahooHistory I get this message:
>
> Select Case oHTTP.Status
>
> Is this a bug, or a corruption issue?
>
>

Tue Nov 11, 2014 1:00 pm (PST) . Posted by:

xslim12

Thanks. I will reinstall and see if that fixes.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.46

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)