4 New Messages
Digest #2349
| |
Messages
Wed Sep 19, 2012 11:28 am (PDT) . Posted by:
"analyst101010" analyst101010
I don't know if any of you have noted it already, but it seems rchgetyahooquotes is working again.
I was kind of upset there for a minute! :)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I haven't a clue...
>
> On Thu, Sep 13, 2012 at 8:07 AM, rr76012 <rr76012@...> wrote:
>
> >
> > Do you think Yahoo will fix this anytime soon? Many fields are returning
> > "N/A" or "0".
> >
>
I was kind of upset there for a minute! :)
--- In smf_addin@yahoogrou
>
> I haven't a clue...
>
> On Thu, Sep 13, 2012 at 8:07 AM, rr76012 <rr76012@...
>
> >
> > Do you think Yahoo will fix this anytime soon? Many fields are returning
> > "N/A" or "0".
> >
>
Wed Sep 19, 2012 12:22 pm (PDT) . Posted by:
"analyst101010" analyst101010
Whoops!! spoke too soon.
Here's an interesting one = I have a workbook with 4 tabs, each with a GetYahooQuotes array on it, each covering approximately ~150 or so individual stocks...
For the last week or so, its refused to deliver a few important stats, returning "0" or "N/A" for things like =
- PEG
- 12month Price Target
- 2012-2013 EPS estimates, etc.
Did not return these #s at all. Probably also missing others I'm not requesting.
Today - to my surprise - I opened it up and page 1 was fully-populated. So it works again~!
Then I check pages 2-4 = hmmm. Not so much. Even on page 1, after about the first 150 names, you can see it stopped delivering those data points.
It looks almost like there is a fixed limit to these particular data points, whereas things like 'previous close', 52wk High, etc. all seem to populate fine, despite there being 4 pages, adding up to hundreds and hundreds of queries.
Even a little more odd... even though pages 2-4 are largely missing these pieces of data, it seems to randomly deliver them for some names.
I organized the tickers alphabetically, and the things like Price Target cease around "H".... but then will randomly deliver data like every 30 or so tickers... weird.
Any thoughts? I know the Yahoo CSV has a limit to the # of tickers they'll deliver data for (200?) in any single request... is my idea of doing a sheet with 4 separate arrays of ~100-200 a particularly bad move? any thoughts, suggestions appreciated.
I can upload an example if anyone wants, but its not anything particularly ingenious. Basically, its the standard GetYahooQuotes template with some additional RCHGetElementNumber functions added (e.g. Analyst consensus rating, etc). Because of the GetElement components, it takes like 5 minutes for the sheet to open properly while it calculates all the cells... kind of a pain.
Anyway, thanks for any thoughts, comments.
Yours,
John
--- In smf_addin@yahoogroups.com , "analyst101010" <jfgilmore@...> wrote:
>
> I don't know if any of you have noted it already, but it seems rchgetyahooquotes is working again.
>
> I was kind of upset there for a minute! :)
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > I haven't a clue...
> >
> > On Thu, Sep 13, 2012 at 8:07 AM, rr76012 <rr76012@> wrote:
> >
> > >
> > > Do you think Yahoo will fix this anytime soon? Many fields are returning
> > > "N/A" or "0".
> > >
> >
>
Here's an interesting one = I have a workbook with 4 tabs, each with a GetYahooQuotes array on it, each covering approximately ~150 or so individual stocks...
For the last week or so, its refused to deliver a few important stats, returning "0" or "N/A" for things like =
- PEG
- 12month Price Target
- 2012-2013 EPS estimates, etc.
Did not return these #s at all. Probably also missing others I'm not requesting.
Today - to my surprise - I opened it up and page 1 was fully-populated. So it works again~!
Then I check pages 2-4 = hmmm. Not so much. Even on page 1, after about the first 150 names, you can see it stopped delivering those data points.
It looks almost like there is a fixed limit to these particular data points, whereas things like 'previous close', 52wk High, etc. all seem to populate fine, despite there being 4 pages, adding up to hundreds and hundreds of queries.
Even a little more odd... even though pages 2-4 are largely missing these pieces of data, it seems to randomly deliver them for some names.
I organized the tickers alphabetically, and the things like Price Target cease around "H".... but then will randomly deliver data like every 30 or so tickers... weird.
Any thoughts? I know the Yahoo CSV has a limit to the # of tickers they'll deliver data for (200?) in any single request... is my idea of doing a sheet with 4 separate arrays of ~100-200 a particularly bad move? any thoughts, suggestions appreciated.
I can upload an example if anyone wants, but its not anything particularly ingenious. Basically, its the standard GetYahooQuotes template with some additional RCHGetElementNumber functions added (e.g. Analyst consensus rating, etc). Because of the GetElement components, it takes like 5 minutes for the sheet to open properly while it calculates all the cells... kind of a pain.
Anyway, thanks for any thoughts, comments.
Yours,
John
--- In smf_addin@yahoogrou
>
> I don't know if any of you have noted it already, but it seems rchgetyahooquotes is working again.
>
> I was kind of upset there for a minute! :)
>
>
> --- In smf_addin@yahoogrou
> >
> > I haven't a clue...
> >
> > On Thu, Sep 13, 2012 at 8:07 AM, rr76012 <rr76012@> wrote:
> >
> > >
> > > Do you think Yahoo will fix this anytime soon? Many fields are returning
> > > "N/A" or "0".
> > >
> >
>
Wed Sep 19, 2012 12:16 pm (PDT) . Posted by:
"antonvanas1989" antonvanas1989
Hi Randy,
Im looking at my sheet at the moment and i found a problem.
The problem is i'm retrieving data from Yahoo and ADVFN. (I'm using those data together) Now is the problem Yahoo Historical Prices give me a close with's not adjusted by stocksplits.
Example:
Tick = KO
Stocksplit = 13 august 2012 (2:1 split)
Following data from Annual 2011
before sp. after split
Outstanding shares 2284 4568
EPS 3.75 1.88
Share Price 69.97 69.97
P/E Ratio 18.66 37.32
So my P/E ratio is doubling because of the 2:1 Split. Same for all other ratio's using Yahoo Historical Close price.
Possible Fix 1: Fixing my sheet so Yahoo price close gets adjusted by splits
Possible Fix 2: I think i'm not the only one with this, (Yahoo is showing the "Before adjustment at end of year price") But maybe it's better for Add-In to adjust these data by splits?
How do you think about this bug?
Greets Anton
Im looking at my sheet at the moment and i found a problem.
The problem is i'm retrieving data from Yahoo and ADVFN. (I'm using those data together) Now is the problem Yahoo Historical Prices give me a close with's not adjusted by stocksplits.
Example:
Tick = KO
Stocksplit = 13 august 2012 (2:1 split)
Following data from Annual 2011
before sp. after split
Outstanding shares 2284 4568
EPS 3.75 1.88
Share Price 69.97 69.97
P/E Ratio 18.66 37.32
So my P/E ratio is doubling because of the 2:1 Split. Same for all other ratio's using Yahoo Historical Close price.
Possible Fix 1: Fixing my sheet so Yahoo price close gets adjusted by splits
Possible Fix 2: I think i'm not the only one with this, (Yahoo is showing the "Before adjustment at end of year price") But maybe it's better for Add-In to adjust these data by splits?
How do you think about this bug?
Greets Anton
Wed Sep 19, 2012 6:48 pm (PDT) . Posted by:
"jhyde.oregon" jhyde.oregon
Hi Randy,
Thank you for creating a really useful tool!
Do you have an smf_addin template that can access the Morningstar free "Market Fair Value" data located at this URL?
http://www.morningstar.com/market-valuation/market-fair-value-graph.aspx
This data is only for the overall market and subsectors, not individual stocks or funds, but it doesn't require premium access.
Regards,
John
Thank you for creating a really useful tool!
Do you have an smf_addin template that can access the Morningstar free "Market Fair Value" data located at this URL?
http://www.mornings
This data is only for the overall market and subsectors, not individual stocks or funds, but it doesn't require premium access.
Regards,
John
Tidak ada komentar:
Posting Komentar