Selasa, 05 Januari 2016

[smf_addin] Digest Number 3598[1 Attachment]

6 Messages

Digest #3598
1b
Re: RCHGetYahooQuotes returns 'Error' by "Randy Harmelink" rharmelink
1d
Re: RCHGetYahooQuotes returns 'Error' by "Randy Harmelink" rharmelink
2a
Morningstar data by "Daniel Beausejour" djbeausejour
2b
Re: Morningstar data [1 Attachment] by "Randy Harmelink" rharmelink

Messages

Mon Jan 4, 2016 7:13 am (PST) . Posted by:

another_investor

Hi Randy (et al),

The function RCHGetYahooQuotes seems to have started returning "Error" periodically when multiple quotes are being returned at the same time. For example, if A3-A25 has a list of tickers and the formula is RCHGetYahooQuotes(A3,"l1") -> RCHGetYahooQuotes(A25,"l1") sometimes the price is not returned. Clearing the tickers and repopulating them sometimes returns the prices for the stocks that returned "Error" and sometimes the tickers with the prices previously now return "Error".

Has anyone else been experiencing this issue please?
It is occurring on two different PC's and as far as I can tell, the internet browsers have not changed and no updates have occurred. In summary, it was working fine pre-Xmas and now is experiencing issues.

Thanks in advance and for all your excellent efforts/work

Steve

Mon Jan 4, 2016 7:27 am (PST) . Posted by:

"Randy Harmelink" rharmelink

An "Error" on RCHGetYahooQuotes() is most likely from some type of
communication problem. Maybe on the Yahoo end. For example, if one of their
servers is having a problem, a data request to that server might return the
"Error" result.

The best thing you can do is to make that one array-entered function, so
that you only have to grab data once instead of 23 times. It will speed up
your recalculation times as well.

On Mon, Jan 4, 2016 at 8:13 AM, steviejacobs@... wrote:

> The function RCHGetYahooQuotes seems to have started returning "Error"
> periodically when multiple quotes are being returned at the same time. For
> example, if A3-A25 has a list of tickers and the formula is
> RCHGetYahooQuotes(A3,"l1") -> RCHGetYahooQuotes(A25,"l1") sometimes the
> price is not returned. Clearing the tickers and repopulating them sometimes
> returns the prices for the stocks that returned "Error" and sometimes the
> tickers with the prices previously now return "Error".
>
> Has anyone else been experiencing this issue please?
>
> It is occurring on two different PC's and as far as I can tell, the
> internet browsers have not changed and no updates have occurred. In
> summary, it was working fine pre-Xmas and now is experiencing issues.
>
> Thanks in advance and for all your excellent efforts/work
>

Mon Jan 4, 2016 9:34 am (PST) . Posted by:

another_investor

Many, many thanks Randy,

Makes sense. Just thought I would check with you.
Is there a "best practice" guide with respect to design and retrieving data please?
I do try to use a single worksheet, source data from the same webpage where possible (to keep page retrievals to a minimum etc.) but in terms of performance, array and usages ... I am sure I have a lot to learn.

For example, can arrays be used on multiple stocks with RCHGetElementNumber?

Anyway, thanks for resolving this and all the best for 2016.

Steve


Mon Jan 4, 2016 10:34 am (PST) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooQuotes() is special -- it's a separate function because Yahoo
has a current quotes process where you can tell it the things you want and
it prepares a CSV file containing all that data. That's the reason it can
be array-entered to save time -- all of the data can be retrieved in on
shot from Yahoo. The closest function to this would be smfGetCSVFile(),
provided you can pass the file name parameters. FinViz used to allow that.
MorningStar has a few CSV files based on parameters.

Most of the other functions scrape web pages, so there would be no
advantage to array-entering them. They would still need to go to the same
number of web pages, retrieving each one as needed.

But, yes, anything you can do to reduce the number of web page accesses
will help, since that is typically the bottleneck in the data retrieval
process.

When I know what I want, and the data can be in a tabular format, I do
often go to smfUpdateDownloadTable. That's because it places values in a
cell and won't recalculate. Although you can have the add-in retrieve the
data again if desired.

On Mon, Jan 4, 2016 at 10:34 AM, steviejacobs@hotmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Many, many thanks Randy,
>
> Makes sense. Just thought I would check with you.
>
> Is there a "best practice" guide with respect to design and retrieving
> data please?
>
> I do try to use a single worksheet, source data from the same webpage
> where possible (to keep page retrievals to a minimum etc.) but in terms of
> performance, array and usages ... I am sure I have a lot to learn.
>
> For example, can arrays be used on multiple stocks with
> RCHGetElementNumber?
>
> Anyway, thanks for resolving this and all the best for 2016.
>
>

Mon Jan 4, 2016 7:30 pm (PST) . Posted by:

"Daniel Beausejour" djbeausejour

Hi Randy,
From the Morningstar webpage, I know how to extract data from the "Key Ratios" tab but not the other tabs.
How can I extract data from the "Performance&quot;, "Financial&quot; or "Valuation&quot; tab with =smfConvertData(smfstrExtr(RCHGetWebData....)))?

Thank you in advance,
Daniel
Attachment(s) from Daniel Beausejour
1 of 1 Photo(s)

Mon Jan 4, 2016 7:43 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Not a simple answer, since MorningStar uses dozens of "static" web pages to
build their dynamic web pages. The best way to find them is to use some
type of URL sniffer and see what web resources are used when a web page is
built. I use the HTTPFox extension with the FoxFire browser.

I did manage to find a "cheat sheet" I have saved, but I'm not sure how
current or complete it is:

Web page URL Quotes: http://quotes.morningstar.com/stock/c-header?&t=MMM
Profile: http://quotes.morningstar.com/stock/c-company-profile?t=MMM Current
Valuation:
http://financials.morningstar.com/valuation/current-valuation-list.action?t=MMM
Headlines: http://quotes.morningstar.com/stock/c-headlines?&t=MMM
Commentary: http://quotes.morningstar.com/stock/c-mstar?t=MMM Press
Releases: http://quotes.morningstar.com/stock/c-press?t=MMM Forward
Valuation:
http://financials.morningstar.com/valuation/forward-valuation-list.action?&t=MMM
Valuation
History:
http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings&t=MMM
Financials: http://quotes.morningstar.com/stock/c-financials?t=MMM
Competitors: http://quotes.morningstar.com/stock/c-competitors?t=MMM
Competitors
2:
http://financials.morningstar.com/competitors/industry-peer-data.action?t=MMM
Dividends: http://quotes.morningstar.com/stock/c-dividends?t=MMM
Recommendation: http://quotes.morningstar.com/stock/c-recommencation?t=MMM
Take: http://quotes.morningstar.com/stock/c-morningstar-take?t=MMM Market
Data: http://quotes.morningstar.com/stock/c-marketData?t=MMM Short Interest:
http://quotes.morningstar.com/stock/c-shortInterest?t=MMM Ownership:
http://quotes.morningstar.com/stock/c-fundowners?t=MMM Insiders:
http://quotes.morningstar.com/stock/c-insiders?t=MMM Key Stats:
http://quotes.morningstar.com/stock/c-keystats?t=MMM Performance:
http://performance.morningstar.com/Performance/stock/trailing-total-returns.action?s=0P00001MK8&align=d&t=MMM
Performance
(Quote):
http://performance.morningstar.com/Performance/stock/quote-data-strip.action?&t=MMM
Performance
(Annual):
http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8&ndec=2&align=d&t=MMM
Operation
Details:
http://financials.morningstar.com/company-profile/component.action?component=OperationDetails&t=MMM
Raw
Data - Financials:
http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t=MMM
Raw
Data - Key Stats:
http://financials.morningstar.com/financials/getKeyStatPart.html?t=MMM Raw
Data - Financials:
http://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?reportType=is&period=12&dataType=A&order=asc&columnYear=5&rounding=3&view=raw&t=MMM
Fund
Ownership:
http://investors.morningstar.com/ownership/equityOS-fund.html?t=MMM
Institutional
Ownership:
http://investors.morningstar.com/ownership/equityOS-inst.html?t=MMM Owner
Activity:
http://investors.morningstar.com/ownership/owner-activity.html?t=MMM Monthly
Performance
http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=m&t=MMM
Quarterly
Performance
http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=q&t=MMM
Annual
Estimates:
http://financials.morningstar.com/valuation/annual-estimate-list.action?t=MMM
Forward
Comparisons:
http://financials.morningstar.com/valuation/forward-comparisons-list.action?t=MMM
Analyst
Opinion:
http://financials.morningstar.com/valuation/analyst-opinion-list.action?t=MMM
Split
History
http://performance.morningstar.com/Performance/stock/split-history.action?t=MMM
Upcoming
Dividend
http://performance.morningstar.com/Performance/stock/upcoming-dividends.action?t=MMM
Annual
Dividends
http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM
Dividend
History
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM

On Mon, Jan 4, 2016 at 8:02 PM, Daniel Beausejour djbeausejour@... wrote:

>
> From the Morningstar webpage, I know how to extract data from the "Key
> Ratios" tab but not the other tabs.
>
> How can I extract data from the "Performance&quot;, "Financial&quot; or "Valuation&quot;
> tab with =smfConvertData(smfstrExtr(RCHGetWebData....)))?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar