7 Messages
Digest #3632
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).
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?
>
>
>
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?
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:")
>
>
>
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,"
>
>
>
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:")
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,"
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:")
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,"
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.
>
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:
Posting Komentar