4 Messages
Digest #3599
Messages
Tue Jan 5, 2016 10:03 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I tried to change the formula to change MMM to ticker which I had named cell A1.
I tried several different but it always retrieved the URL for MMM not whatever symbol I put in A!.
I, also, tried this where symbols were in column A .
IT produced this URL page to retrieve http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
And http://quotes.morningstar.com/stock/c-company-profile?t=kermit
Ticker was defined as cell A2 and kermit was A3
What am I doing wrong? I know this is not using the SMFaddin. Just excel
symbol
link
agnc
kermit
<http://quotes.morningstar.com/stock/c-header?&t=ticker> http://quotes.morningstar.com/stock/c-header?&t=ticker
<http://quotes.morningstar.com/stock/c-company-profile?t=kermit> http://quotes.morningstar.com/stock/c-company-profile?t=kermit
<http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker> http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker
<http://quotes.morningstar.com/stock/c-headlines?&t=kermit> http://quotes.morningstar.com/stock/c-headlines?&t=kermit
http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, January 04, 2016 10:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar data
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? <http://quotes.morningstar.com/stock/c-header?&t=MMM> &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? <http://quotes.morningstar.com/stock/c-headlines?&t=MMM> &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? <http://financials.morningstar.com/valuation/forward-valuation-list.action?&t=MMM> &t=MMM
Valuation History:
http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings <http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/trailing-total-returns.action?s=0P00001MK8&align=d&t=MMM> &align=d&t=MMM
Performance (Quote):
http://performance.morningstar.com/Performance/stock/quote-data-strip.action? <http://performance.morningstar.com/Performance/stock/quote-data-strip.action?&t=MMM> &t=MMM
Performance (Annual):
http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8 <http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8&ndec=2&align=d&t=MMM> &ndec=2&align=d&t=MMM
Operation Details:
http://financials.morningstar.com/company-profile/component.action?component=OperationDetails <http://financials.morningstar.com/company-profile/component.action?component=OperationDetails&t=MMM> &t=MMM
Raw Data - Financials:
http://financials.morningstar.com/financials/getFinancePart.html? <http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t=MMM> &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 <http://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?reportType=is&period=12&dataType=A&order=asc&columnYear=5&rounding=3&view=raw&t=MMM> &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 <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=m&t=MMM> &y=15&freq=m&t=MMM
Quarterly Performance
http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=q&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM> &t=MMM
Dividend History
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50 <http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM> &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", "Financial" or "Valuation" tab with =smfConvertData(smfstrExtr(RCHGetWebData....)))?
I tried several different but it always retrieved the URL for MMM not whatever symbol I put in A!.
I, also, tried this where symbols were in column A .
IT produced this URL page to retrieve http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
And http://quotes.morningstar.com/stock/c-company-profile?t=kermit
Ticker was defined as cell A2 and kermit was A3
What am I doing wrong? I know this is not using the SMFaddin. Just excel
symbol
link
agnc
kermit
<http://quotes.morningstar.com/stock/c-header?&t=ticker> http://quotes.morningstar.com/stock/c-header?&t=ticker
<http://quotes.morningstar.com/stock/c-company-profile?t=kermit> http://quotes.morningstar.com/stock/c-company-profile?t=kermit
<http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker> http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker
<http://quotes.morningstar.com/stock/c-headlines?&t=kermit> http://quotes.morningstar.com/stock/c-headlines?&t=kermit
http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, January 04, 2016 10:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar data
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? <http://quotes.morningstar.com/stock/c-header?&t=MMM> &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? <http://quotes.morningstar.com/stock/c-headlines?&t=MMM> &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? <http://financials.morningstar.com/valuation/forward-valuation-list.action?&t=MMM> &t=MMM
Valuation History:
http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings <http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/trailing-total-returns.action?s=0P00001MK8&align=d&t=MMM> &align=d&t=MMM
Performance (Quote):
http://performance.morningstar.com/Performance/stock/quote-data-strip.action? <http://performance.morningstar.com/Performance/stock/quote-data-strip.action?&t=MMM> &t=MMM
Performance (Annual):
http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8 <http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8&ndec=2&align=d&t=MMM> &ndec=2&align=d&t=MMM
Operation Details:
http://financials.morningstar.com/company-profile/component.action?component=OperationDetails <http://financials.morningstar.com/company-profile/component.action?component=OperationDetails&t=MMM> &t=MMM
Raw Data - Financials:
http://financials.morningstar.com/financials/getFinancePart.html? <http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t=MMM> &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 <http://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?reportType=is&period=12&dataType=A&order=asc&columnYear=5&rounding=3&view=raw&t=MMM> &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 <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=m&t=MMM> &y=15&freq=m&t=MMM
Quarterly Performance
http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=q&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM> &t=MMM
Dividend History
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50 <http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM> &t=MMM
On Mon, Jan 4, 2016 at 8:02 PM, Daniel Beausejour djbeausejour@
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&q
Tue Jan 5, 2016 10:10 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I forgot to mention that I was only trying to get it to open the webpage not pull it into excel.
It open the browser but showed a blank page because the ticker never resolved to cell A2 content
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, January 05, 2016 1:04 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Morningstar data
Randy, I tried to change the formula to change MMM to ticker which I had named cell A1.
I tried several different but it always retrieved the URL for MMM not whatever symbol I put in A!.
I, also, tried this where symbols were in column A .
IT produced this URL page to retrieve http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
And http://quotes.morningstar.com/stock/c-company-profile?t=kermit
Ticker was defined as cell A2 and kermit was A3
What am I doing wrong? I know this is not using the SMFaddin. Just excel
symbol
link
agnc
kermit
<http://quotes.morningstar.com/stock/c-header?&t=ticker> http://quotes.morningstar.com/stock/c-header?&t=ticker
<http://quotes.morningstar.com/stock/c-company-profile?t=kermit> http://quotes.morningstar.com/stock/c-company-profile?t=kermit
<http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker> http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker
<http://quotes.morningstar.com/stock/c-headlines?&t=kermit> http://quotes.morningstar.com/stock/c-headlines?&t=kermit
http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, January 04, 2016 10:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar data
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? <http://quotes.morningstar.com/stock/c-header?&t=MMM> &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? <http://quotes.morningstar.com/stock/c-headlines?&t=MMM> &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? <http://financials.morningstar.com/valuation/forward-valuation-list.action?&t=MMM> &t=MMM
Valuation History:
http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings <http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/trailing-total-returns.action?s=0P00001MK8&align=d&t=MMM> &align=d&t=MMM
Performance (Quote):
http://performance.morningstar.com/Performance/stock/quote-data-strip.action? <http://performance.morningstar.com/Performance/stock/quote-data-strip.action?&t=MMM> &t=MMM
Performance (Annual):
http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8 <http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8&ndec=2&align=d&t=MMM> &ndec=2&align=d&t=MMM
Operation Details:
http://financials.morningstar.com/company-profile/component.action?component=OperationDetails <http://financials.morningstar.com/company-profile/component.action?component=OperationDetails&t=MMM> &t=MMM
Raw Data - Financials:
http://financials.morningstar.com/financials/getFinancePart.html? <http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t=MMM> &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 <http://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?reportType=is&period=12&dataType=A&order=asc&columnYear=5&rounding=3&view=raw&t=MMM> &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 <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=m&t=MMM> &y=15&freq=m&t=MMM
Quarterly Performance
http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=q&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM> &t=MMM
Dividend History
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50 <http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM> &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", "Financial" or "Valuation" tab with =smfConvertData(smfstrExtr(RCHGetWebData....)))?
It open the browser but showed a blank page because the ticker never resolved to cell A2 content
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, January 05, 2016 1:04 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Morningstar data
Randy, I tried to change the formula to change MMM to ticker which I had named cell A1.
I tried several different but it always retrieved the URL for MMM not whatever symbol I put in A!.
I, also, tried this where symbols were in column A .
IT produced this URL page to retrieve http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
And http://quotes.morningstar.com/stock/c-company-profile?t=kermit
Ticker was defined as cell A2 and kermit was A3
What am I doing wrong? I know this is not using the SMFaddin. Just excel
symbol
link
agnc
kermit
<http://quotes.morningstar.com/stock/c-header?&t=ticker> http://quotes.morningstar.com/stock/c-header?&t=ticker
<http://quotes.morningstar.com/stock/c-company-profile?t=kermit> http://quotes.morningstar.com/stock/c-company-profile?t=kermit
<http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker> http://financials.morningstar.com/valuation/current-valuation-list.action?t=ticker
<http://quotes.morningstar.com/stock/c-headlines?&t=kermit> http://quotes.morningstar.com/stock/c-headlines?&t=kermit
http://quotes.morningstar.com/stock/c-header? <http://quotes.morningstar.com/stock/c-header?&t=ticker> &t=ticker
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, January 04, 2016 10:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Morningstar data
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? <http://quotes.morningstar.com/stock/c-header?&t=MMM> &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? <http://quotes.morningstar.com/stock/c-headlines?&t=MMM> &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? <http://financials.morningstar.com/valuation/forward-valuation-list.action?&t=MMM> &t=MMM
Valuation History:
http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings <http://financials.morningstar.com/valuation/valuation-history.action?type=price-earnings&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/trailing-total-returns.action?s=0P00001MK8&align=d&t=MMM> &align=d&t=MMM
Performance (Quote):
http://performance.morningstar.com/Performance/stock/quote-data-strip.action? <http://performance.morningstar.com/Performance/stock/quote-data-strip.action?&t=MMM> &t=MMM
Performance (Annual):
http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8 <http://performance.morningstar.com/Performance/stock/performance-history-1.action?s=0P00001MK8&ndec=2&align=d&t=MMM> &ndec=2&align=d&t=MMM
Operation Details:
http://financials.morningstar.com/company-profile/component.action?component=OperationDetails <http://financials.morningstar.com/company-profile/component.action?component=OperationDetails&t=MMM> &t=MMM
Raw Data - Financials:
http://financials.morningstar.com/financials/getFinancePart.html? <http://financials.morningstar.com/financials/getFinancePart.html?&callback=?&t=MMM> &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 <http://financials.morningstar.com/ajax/ReportProcess4HtmlAjax.html?reportType=is&period=12&dataType=A&order=asc&columnYear=5&rounding=3&view=raw&t=MMM> &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 <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=m&t=MMM> &y=15&freq=m&t=MMM
Quarterly Performance
http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m <http://performance.morningstar.com/Performance/fund/historical-returns.action?align=m&y=15&freq=q&t=MMM> &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 <http://performance.morningstar.com/Performance/stock/annual-dividends.action?y=25&t=MMM> &t=MMM
Dividend History
http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50 <http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=MMM> &t=MMM
On Mon, Jan 4, 2016 at 8:02 PM, Daniel Beausejour djbeausejour@
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&q
Tue Jan 5, 2016 10:59 am (PST) . Posted by:
"Peter James" pmjzz
You have to replace the t=xxx with a parameter, eg, t=["ticker"], then Excel will ask for input, or you can supply a cell.Explained here:http://web.archive.org/web/20130914030240/http://dancingpenguinsoflight.com/2010/07/excel-web-query-urls-with-dynamic-parameters/And here:http://www.jkp-ads.com/articles/webquery.asp
--Peter JamesPatrick Hutber: Improvement means deterioration
From: "'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, January 5, 2016 1:09 PM
Subject: RE: [smf_addin] Morningstar data
I forgot to mention that I was only trying to get it to open the webpage not pull it into excel. It open the browser but showed a blank page because the ticker never resolved to cell A2 content From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, January 05, 2016 1:04 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Morningstar data
Randy, I tried to change the formula to change MMM to ticker which I had named cell A1.I tried several different but it always retrieved the URL for MMM not whatever symbol I put in A!. I, also, tried this where symbols were in column A . IT produced this URL page to retrieve http://quotes.morningstar.com/stock/c-header?&t=tickerAnd http://quotes.morningstar.com/stock/c-company-profile?t=kermit Ticker was defined as cell A2 and kermit was A3 What am I doing wrong? I know this is not using the SMFaddin. Just excel
#yiv3549158962 #yiv3549158962 -- #yiv3549158962ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3549158962 #yiv3549158962ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3549158962 #yiv3549158962ygrp-mkp #yiv3549158962hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3549158962 #yiv3549158962ygrp-mkp #yiv3549158962ads {margin-bottom:10px;}#yiv3549158962 #yiv3549158962ygrp-mkp .yiv3549158962ad {padding:0 0;}#yiv3549158962 #yiv3549158962ygrp-mkp .yiv3549158962ad p {margin:0;}#yiv3549158962 #yiv3549158962ygrp-mkp .yiv3549158962ad a {color:#0000ff;text-decoration:none;}#yiv3549158962 #yiv3549158962ygrp-sponsor #yiv3549158962ygrp-lc {font-family:Arial;}#yiv3549158962 #yiv3549158962ygrp-sponsor #yiv3549158962ygrp-lc #yiv3549158962hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3549158962 #yiv3549158962ygrp-sponsor #yiv3549158962ygrp-lc .yiv3549158962ad {margin-bottom:10px;padding:0 0;}#yiv3549158962 #yiv3549158962actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3549158962 #yiv3549158962activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3549158962 #yiv3549158962activity span {font-weight:700;}#yiv3549158962 #yiv3549158962activity span:first-child {text-transform:uppercase;}#yiv3549158962 #yiv3549158962activity span a {color:#5085b6;text-decoration:none;}#yiv3549158962 #yiv3549158962activity span span {color:#ff7900;}#yiv3549158962 #yiv3549158962activity span .yiv3549158962underline {text-decoration:underline;}#yiv3549158962 .yiv3549158962attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3549158962 .yiv3549158962attach div a {text-decoration:none;}#yiv3549158962 .yiv3549158962attach img {border:none;padding-right:5px;}#yiv3549158962 .yiv3549158962attach label {display:block;margin-bottom:5px;}#yiv3549158962 .yiv3549158962attach label a {text-decoration:none;}#yiv3549158962 blockquote {margin:0 0 0 4px;}#yiv3549158962 .yiv3549158962bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3549158962 .yiv3549158962bold a {text-decoration:none;}#yiv3549158962 dd.yiv3549158962last p a {font-family:Verdana;font-weight:700;}#yiv3549158962 dd.yiv3549158962last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3549158962 dd.yiv3549158962last p span.yiv3549158962yshortcuts {margin-right:0;}#yiv3549158962 div.yiv3549158962attach-table div div a {text-decoration:none;}#yiv3549158962 div.yiv3549158962attach-table {width:400px;}#yiv3549158962 div.yiv3549158962file-title a, #yiv3549158962 div.yiv3549158962file-title a:active, #yiv3549158962 div.yiv3549158962file-title a:hover, #yiv3549158962 div.yiv3549158962file-title a:visited {text-decoration:none;}#yiv3549158962 div.yiv3549158962photo-title a, #yiv3549158962 div.yiv3549158962photo-title a:active, #yiv3549158962 div.yiv3549158962photo-title a:hover, #yiv3549158962 div.yiv3549158962photo-title a:visited {text-decoration:none;}#yiv3549158962 div#yiv3549158962ygrp-mlmsg #yiv3549158962ygrp-msg p a span.yiv3549158962yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3549158962 .yiv3549158962green {color:#628c2a;}#yiv3549158962 .yiv3549158962MsoNormal {margin:0 0 0 0;}#yiv3549158962 o {font-size:0;}#yiv3549158962 #yiv3549158962photos div {float:left;width:72px;}#yiv3549158962 #yiv3549158962photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv3549158962 #yiv3549158962photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3549158962 #yiv3549158962reco-category {font-size:77%;}#yiv3549158962 #yiv3549158962reco-desc {font-size:77%;}#yiv3549158962 .yiv3549158962replbq {margin:4px;}#yiv3549158962 #yiv3549158962ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3549158962 #yiv3549158962ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3549158962 #yiv3549158962ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3549158962 #yiv3549158962ygrp-mlmsg select, #yiv3549158962 input, #yiv3549158962 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3549158962 #yiv3549158962ygrp-mlmsg pre, #yiv3549158962 code {font:115% monospace;}#yiv3549158962 #yiv3549158962ygrp-mlmsg * {line-height:1.22em;}#yiv3549158962 #yiv3549158962ygrp-mlmsg #yiv3549158962logo {padding-bottom:10px;}#yiv3549158962 #yiv3549158962ygrp-msg p a {font-family:Verdana;}#yiv3549158962 #yiv3549158962ygrp-msg p#yiv3549158962attach-count span {color:#1E66AE;font-weight:700;}#yiv3549158962 #yiv3549158962ygrp-reco #yiv3549158962reco-head {color:#ff7900;font-weight:700;}#yiv3549158962 #yiv3549158962ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3549158962 #yiv3549158962ygrp-sponsor #yiv3549158962ov li a {font-size:130%;text-decoration:none;}#yiv3549158962 #yiv3549158962ygrp-sponsor #yiv3549158962ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3549158962 #yiv3549158962ygrp-sponsor #yiv3549158962ov ul {margin:0;padding:0 0 0 8px;}#yiv3549158962 #yiv3549158962ygrp-text {font-family:Georgia;}#yiv3549158962 #yiv3549158962ygrp-text p {margin:0 0 1em 0;}#yiv3549158962 #yiv3549158962ygrp-text tt {font-size:120%;}#yiv3549158962 #yiv3549158962ygrp-vital ul li:last-child {border-right:none !important;}#yiv3549158962
--Peter JamesPatrick Hutber: Improvement means deterioration
From: "'Kermit W. Prather' kermitp@tampabay.rr.com [smf_addin]" <smf_addin@yahoogroups.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, January 5, 2016 1:09 PM
Subject: RE: [smf_addin] Morningstar data
I forgot to mention that I was only trying to get it to open the webpage not pull it into excel. It open the browser but showed a blank page because the ticker never resolved to cell A2 content From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, January 05, 2016 1:04 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Morningstar data
Randy, I tried to change the formula to change MMM to ticker which I had named cell A1.I tried several different but it always retrieved the URL for MMM not whatever symbol I put in A!. I, also, tried this where symbols were in column A . IT produced this URL page to retrieve http://quotes.morningstar.com/stock/c-header?&t=tickerAnd http://quotes.morningstar.com/stock/c-company-profile?t=kermit Ticker was defined as cell A2 and kermit was A3 What am I doing wrong? I know this is not using the SMFaddin. Just excel
#yiv3549158962 #yiv3549158962 -- #yiv3549158962ygrp-
Tue Jan 5, 2016 11:26 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Think of it this way -- you're concatenating two string values:
"http://quotes.morningstar.com/stock/c-header?&t="
Ticker
So you'd just put the ampersand in between them:
="http://quotes.morningstar.com/stock/c-header?&t=" & Ticker
On Tue, Jan 5, 2016 at 11:03 AM, 'Kermit W. Prather' kermitp@... wrote:
>
> Randy, I tried to change the formula to change MMM to ticker which I had named
> cell A1.
>
> I tried several different but it always retrieved the URL for MMM not
> whatever symbol I put in A!.
>
>
>
> I, also, tried this where symbols were in column A .
>
> IT produced this URL page to retrieve
> http://quotes.morningstar.com/stock/c-header?&t=ticker
>
> And http://quotes.morningstar.com/stock/c-company-profile?t=kermit
>
> Ticker was defined as cell A2 and kermit was A3
>
>
>
> What am I doing wrong? I know this is not using the SMFaddin. Just excel
>
"http://quotes.morningstar.com/stock/c-header?&t="
Ticker
So you'd just put the ampersand in between them:
="http://quotes.morningstar.com/stock/c-header?&t=" & Ticker
On Tue, Jan 5, 2016 at 11:03 AM, 'Kermit W. Prather' kermitp@... wrote:
>
> Randy, I tried to change the formula to change MMM to ticker which I had named
> cell A1.
>
> I tried several different but it always retrieved the URL for MMM not
> whatever symbol I put in A!.
>
>
>
> I, also, tried this where symbols were in column A .
>
> IT produced this URL page to retrieve
> http://quotes.morningstar.com/stock/c-header?&t=ticker
>
> And http://quotes.morningstar.com/stock/c-company-profile?t=kermit
>
> Ticker was defined as cell A2 and kermit was A3
>
>
>
> What am I doing wrong? I know this is not using the SMFaddin. Just excel
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar