Sabtu, 14 November 2015

[smf_addin] Digest Number 3557

7 Messages

Digest #3557
1a
SMF hanging by jimmymc00
1b
Re: SMF hanging by "Randy Harmelink" rharmelink
1c
Re: SMF hanging by john_hoel
3b
Re: Help with GetElement / Yahoo by "Randy Harmelink" rharmelink
3c
Re: Help with GetElement / Yahoo by "Randy Harmelink" rharmelink

Messages

Fri Nov 13, 2015 12:21 pm (PST) . Posted by:

jimmymc00



I'm experiencing a long processing time for about 10 minutes, on what used to be less than a minute, for the RCHGetYahooQuotes array to process. At the end of the processing the array sheet is blank except for the first cell which shows ERROR. I've tried the Regenerate and Fix Links functions with no help. I've rebooted (Windows 10) a couple of times and restarted (Excel 13) as well but nothing changes. Excel will actually go into "not responding" mode a few times and then come back to active. What do you think? Jim

.



Fri Nov 13, 2015 12:33 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I ran into that myself earlier today. The problem is on the Yahoo side --
the CSV file requests are taking a long time. When I looked at my log file,
those requests were taking anywhere from 20 to 50 seconds each, instead of
the usual half-second.

On Fri, Nov 13, 2015 at 1:21 PM, jmcatee133@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm experiencing a long processing time for about 10 minutes, on what
> used to be less than a minute, for the RCHGetYahooQuotes array to process.
> At the end of the processing the array sheet is blank except for the first
> cell which shows ERROR. I've tried the Regenerate and Fix Links functions
> with no help. I've rebooted (Windows 10) a couple of times and restarted
> (Excel 13) as well but nothing changes. Excel will actually go into "not
> responding" mode a few times and then come back to active. What do you
> think? Jim
>

Fri Nov 13, 2015 12:34 pm (PST) . Posted by:

john_hoel

I am having similar problems.

Fri Nov 13, 2015 12:34 pm (PST) . Posted by:

victorklai

Hi All,


I'm trying to retrieve the "Average Price/Earnings" ratio for an ETF from Yahoo with the RCHGetElementNumber() function.


I looked up the Element number as either 5184 or 5190 from Yahoo data elements (http://ogres-crypt.com/SMF/Elements/smf-elements-2.txt http://ogres-crypt.com/SMF/Elements/smf-elements-2.txt), and I entered the function as =RCHGetElementNumber("VTI";,5184).


I tried both Element numbers with different ETFs and always get "Error." I also tried other Element numbers and it seems like anything after "5182" for the Yahoo Holdings page returns an error. Element numbers before 5183 return values correctly.


Am I doing this incorrectly, or is there another way to return the Average P/E for an ETF?


Thanks in advance for your help!


Victor



Fri Nov 13, 2015 12:39 pm (PST) . Posted by:

victorklai

Hi All,


I'm having trouble retrieving "Average Price/Earnings" for an ETF off the Yahoo Holdings page using the RCHGetElementNumber function.


I looked up the Element number for Average Price/Earnings as either 5184 or 5190 from Yahoo data elements (http://ogres-crypt.com/SMF/Elements/smf-elements-2.txt), and entered the function as =RCHGetElementNumber("SPY";,5184).


I tried both Element numbers and different ETFs, but only get "Error" returned. Also, it seems like all element numbers past 5183 on the Holdings page return errors.


Am I doing something incorrectly, or is there another way to retrieve the Average Price/Earnings value for ETFs?


Thanks in advance for your help.


Victor





Fri Nov 13, 2015 12:51 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Looks like they've changed some tags on the web page. For now, the
work-around:

=RCHGetTableCell("http://finance.yahoo.com/q/hl?s="&D4,1,">Equity
Holdings","Price/Earnings")

On Fri, Nov 13, 2015 at 1:39 PM, victorklai@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm having trouble retrieving "Average Price/Earnings" for an ETF off the
> Yahoo Holdings page using the RCHGetElementNumber function.
>
> I looked up the Element number for Average Price/Earnings as either 5184
> or 5190 from Yahoo data elements (
> http://ogres-crypt.com/SMF/Elements/smf-elements-2.txt), and entered the
> function as =RCHGetElementNumber("SPY";,5184).
>
> I tried both Element numbers and different ETFs, but only get "Error"
> returned. Also, it seems like all element numbers past 5183 on the
> Holdings page return errors.
>
> Am I doing something incorrectly, or is there another way to retrieve the
> Average Price/Earnings value for ETFs?
>
>

Fri Nov 13, 2015 1:02 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Oops. Wrong answer. It appears those items are presented differently for
ETFs, so the elements numbers will only work for mutual funds.

On Fri, Nov 13, 2015 at 1:39 PM, victorklai@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I'm having trouble retrieving "Average Price/Earnings" for an ETF off the
> Yahoo Holdings page using the RCHGetElementNumber function.
>
> I looked up the Element number for Average Price/Earnings as either 5184
> or 5190 from Yahoo data elements (
> http://ogres-crypt.com/SMF/Elements/smf-elements-2.txt), and entered the
> function as =RCHGetElementNumber("SPY";,5184).
>
> I tried both Element numbers and different ETFs, but only get "Error"
> returned. Also, it seems like all element numbers past 5183 on the
> Holdings page return errors.
>
> Am I doing something incorrectly, or is there another way to retrieve the
> Average Price/Earnings value for ETFs?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)