Rabu, 10 Februari 2016

[smf_addin] Digest Number 3632

7 Messages

Digest #3632
1a
1b
Re: Fw: Error message in worksheet by "Randy Harmelink" rharmelink
1c
1d
Re: Fw: Error message in worksheet by "Randy Harmelink" rharmelink
1e
1f
1g
Re: Fw: Error message in worksheet by "Randy Harmelink" rharmelink

Messages

Tue Feb 9, 2016 7:40 am (PST) . Posted by:

"Charlie" ocormican

Randy,

I really appreciate your feedback.

For testing, I limited the workbook to retrieve the next earnings date for four companies. The formulas are below:

Only the F next earnings date was retrieved:

I closed Excel and so forth. What do you think?

Charlie

From: mailto:smf_addin@yahoogroups.com
Sent: Monday, February 08, 2016 3:41 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Fw: Error message in worksheet

I tired all of the IRDM items, and they worked fine.

One thought -- how much data are you retrieving? The add-in is designed for ad hoc data retrieval, not wholesale database building, so any requests that go beyond 1000 web pages will return "Error".

That's because the add-in retrieves and stores a saved copy of a web page first, then extracts the data from that saved copy of the web page -- so that it only needs to get the web page once if 10 extractions come from the same web page. However, there are ONLY 1000 slots for saving web pages. So, anything above that will fail to retrieve a web page, and any extractions based on it will result in "Error".

BTW, the browser you use is irrelevant. It's just that the add-in uses the MicroSoft Internet engines, so shares all of the same libraries and settings as IE -- another MicroSoft product.

On Mon, Feb 8, 2016 at 11:31 AM, 'Charlie' cburton@ipa.net [smf_addin] <smf_addin@yahoogroups.com> wrote:

First, let me thank you for all your hard work building this wonderful add in.

I am having trouble, however, with the RCHGetElementNumber (Yahoo Finance) function. It is inconsistent in that it brings back the data for some stocks, but others it does not, even though I have verified on Yahoo Finance that the stock is listed. Please see the attachment. I have tried everything I can find to fix the problem, including settings in Internet Explorer, etc. I am using Windows 7 64 bit with Excel 2010. I would appreciate any feedback you might be able to provide. It behaves identically regardless of browser used (Chrome or IE).

Tue Feb 9, 2016 9:31 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Actually, both F and GOOGL were retrieved -- Yahoo has N/A posted for GOOGL.

What do you get for:

=RCHGetElementNumber("Version")
=RCHGetElementNumber("MMM",1285)
=RCHGetElementNumber("Definition",1285)
=smfGetAParms(1285)

On Tue, Feb 9, 2016 at 8:38 AM, 'Charlie' cburton@ipa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Randy,
>
> I really appreciate your feedback.
>
> For testing, I limited the workbook to retrieve the next earnings date for
> four companies. The formulas are below:
>
> [image: image]
>
> Only the F next earnings date was retrieved:
>
> [image: image]
>
> I closed Excel and so forth. What do you think?
>
>
>

Tue Feb 9, 2016 9:50 am (PST) . Posted by:

"Charlie" ocormican

Thanks again!

Here's what I get:

Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ; Local; 1)
Error
YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")
YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")

From: mailto:smf_addin@yahoogroups.com
Sent: Tuesday, February 09, 2016 11:31 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Fw: Error message in worksheet

Actually, both F and GOOGL were retrieved -- Yahoo has N/A posted for GOOGL.

What do you get for:

=RCHGetElementNumber("Version")

=RCHGetElementNumber("MMM",1285)

=RCHGetElementNumber("Definition",1285)
=smfGetAParms(1285)

On Tue, Feb 9, 2016 at 8:38 AM, 'Charlie' cburton@ipa.net [smf_addin] <smf_addin@yahoogroups.com> wrote:

Randy,

I really appreciate your feedback.

For testing, I limited the workbook to retrieve the next earnings date for four companies. The formulas are below:

Only the F next earnings date was retrieved:

I closed Excel and so forth. What do you think?


Tue Feb 9, 2016 10:32 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Aha! You have the old definition of the element. I had to change it last
month because Yahoo changed their web page for companies where they posted
an estimated next earnings date.

You can grab the new file from the "Elements" web page. Best practice is to
update add-in files while EXCEL is closed.

The new definition is:

YahooAE;Next Earnings Date;=RCHGetTableCell("
http://finance.yahoo.com/q?s=~~~~~",1,"Earnings Date:")

On Tue, Feb 9, 2016 at 10:49 AM, 'Charlie' cburton@ipa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Here's what I get:
>
> Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ;
> Local; 1)
> Error
> YahooAE;Next Earnings Date;=RCHGetTableCell("
> http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")
> YahooAE;Next Earnings Date;=RCHGetTableCell("
> http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")
>
>
>

Tue Feb 9, 2016 12:53 pm (PST) . Posted by:

"Charlie" ocormican

Thank you so much! I really appreciate it

From: mailto:smf_addin@yahoogroups.com
Sent: Tuesday, February 09, 2016 12:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Fw: Error message in worksheet

Aha! You have the old definition of the element. I had to change it last month because Yahoo changed their web page for companies where they posted an estimated next earnings date.

You can grab the new file from the "Elements" web page. Best practice is to update add-in files while EXCEL is closed.

The new definition is:

YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Earnings Date:")

On Tue, Feb 9, 2016 at 10:49 AM, 'Charlie' cburton@ipa.net [smf_addin] <smf_addin@yahoogroups.com> wrote:

Here's what I get:

Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ; Local; 1)
Error
YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")
YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")

Tue Feb 9, 2016 2:12 pm (PST) . Posted by:

"Charlie" ocormican

Works perfectly.

From: mailto:smf_addin@yahoogroups.com
Sent: Tuesday, February 09, 2016 12:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Fw: Error message in worksheet

Aha! You have the old definition of the element. I had to change it last month because Yahoo changed their web page for companies where they posted an estimated next earnings date.

You can grab the new file from the "Elements" web page. Best practice is to update add-in files while EXCEL is closed.

The new definition is:

YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Earnings Date:")

On Tue, Feb 9, 2016 at 10:49 AM, 'Charlie' cburton@ipa.net [smf_addin] <smf_addin@yahoogroups.com> wrote:

Here's what I get:

Stock Market Functions add-in, Version 2.1.2015.08.13 (C:\SMF Add-In; ; Local; 1)
Error
YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")
YahooAE;Next Earnings Date;=RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"Next Earnings Date:")

Tue Feb 9, 2016 2:46 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Love it when there's a simple explanation. :)

That is one advantage to having the element numbers -- just change the
definition in that one file, and the change is echoed to every worksheet
that uses the element. Otherwise, every worksheet that had a fully coded
formula would have to have been updated. If it's a function used in a lot
of workbooks, that can be a ton of updating to do.

On Tue, Feb 9, 2016 at 3:12 PM, 'Charlie' cburton@ipa.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

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

Tidak ada komentar:

Poskan Komentar