Rabu, 06 Januari 2016

[smf_addin] Digest Number 3599

4 Messages

Digest #3599
1a
Re: Morningstar data by "Kermit W. Prather" kermitpra
1b
Re: Morningstar data by "Kermit W. Prather" kermitpra
1c
Re: Morningstar data by "Peter James" pmjzz
1d
Re: Morningstar data by "Randy Harmelink" rharmelink

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&quot;, "Financial&quot; or "Valuation&quot; tab with =smfConvertData(smfstrExtr(RCHGetWebData....)))?



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&quot;, "Financial&quot; or "Valuation&quot; tab with =smfConvertData(smfstrExtr(RCHGetWebData....)))?



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

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
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar