5 Messages
Digest #3313
Messages
Wed Feb 4, 2015 8:31 am (PST) . Posted by:
"David Nicholson" djsnicholson
Hi Randy,
In developing an excel app to assess portfolio diversification via an
X-ray look through to the underlying Morningstar diversification of each
mutual fund holding, I am trying to extract the numbers in the style box
in the via the RCHGetTableCell call. % of portfolio in Large Growth, %
small cap value, etc. etc.
eg.
http://portfolios.morningstar.com/fund/summary?t=FDSAX®ion=usa&culture=en-US
Even using httpFox, I am unable to identify any static page which holds
this information. Have you or anyone else previously extracted this
Morningstar information using the SMF_addin?
Thanks again for all that you do.
Regards,
David
On Sun, Jan 25, 2015 at 7:02 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The turnover ratio is on a different "static"/"feeder" page:
>
>
> http://performance.morningstar.com/Performance/fund/performance-history-1.action?&t=VFINX&s=0P00001MK8&ndec=2&ep=true&align=m&y=15
>
> I get these via a "URL sniffer". I use the httpFox extension with FireFox:
>
> https://addons.mozilla.org/en-US/firefox/addon/httpfox/
>
> On Sun, Jan 25, 2015 at 4:49 PM, David Nicholson djsn@...wrote:
>
>>
>> Sorry, I referred to the static pages as "feeder pages" to the dynamic
>> report layouts. (just my thought process) I did not test the process for
>> stocks as the URL mid-string referred to "cef" not stks or mf. I guessed at
>> the page URL but it didn't work. Hence my question.
>> For example, in trying to access the information for MF's, I used the
>> following
>> =RCHGetTableCell("
>> http://performance.morningstar.com/fund/performance-return.action?t="&$F43,3,"Turnover
>> Ratio")
>> where cell F43 has the mutual fund ticker.
>> I am sure that my error is something simple, but your notion of "static
>> pages" has prompted me to change all of my report retrieval methodologies
>> to refer to "static pages" to conform with a more timely consistent
>> updating Morningstar process.
>>
>>
>
>
In developing an excel app to assess portfolio diversification via an
X-ray look through to the underlying Morningstar diversification of each
mutual fund holding, I am trying to extract the numbers in the style box
in the via the RCHGetTableCell call. % of portfolio in Large Growth, %
small cap value, etc. etc.
eg.
http://portfolios.morningstar.com/fund/summary?t=FDSAX®ion=usa&culture=en-US
Even using httpFox, I am unable to identify any static page which holds
this information. Have you or anyone else previously extracted this
Morningstar information using the SMF_addin?
Thanks again for all that you do.
Regards,
David
On Sun, Jan 25, 2015 at 7:02 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>
> The turnover ratio is on a different "static"/"feeder" page:
>
>
> http://performance.morningstar.com/Performance/fund/performance-history-1.action?&t=VFINX&s=0P00001MK8&ndec=2&ep=true&align=m&y=15
>
> I get these via a "URL sniffer". I use the httpFox extension with FireFox:
>
> https://addons.mozilla.org/en-US/firefox/addon/httpfox/
>
> On Sun, Jan 25, 2015 at 4:49 PM, David Nicholson djsn@...wrote:
>
>>
>> Sorry, I referred to the static pages as "feeder pages" to the dynamic
>> report layouts. (just my thought process) I did not test the process for
>> stocks as the URL mid-string referred to "cef" not stks or mf. I guessed at
>> the page URL but it didn't work. Hence my question.
>> For example, in trying to access the information for MF's, I used the
>> following
>> =RCHGetTableCell("
>> http://performance.morningstar.com/fund/performance-return.action?t="&$F43,
>> Ratio")
>> where cell F43 has the mutual fund ticker.
>> I am sure that my error is something simple, but your notion of "static
>> pages" has prompted me to change all of my report retrieval methodologies
>> to refer to "static pages" to conform with a more timely consistent
>> updating Morningstar process.
>>
>>
>
>
Wed Feb 4, 2015 3:53 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/26221
Just checked. It still works. :)
httpFox wouldn't help, because the data is defined in an array within
Javascript on the original web page.
On Wed, Feb 4, 2015 at 9:30 AM, David Nicholson djsn@...wrote:
>
> In developing an excel app to assess portfolio diversification via an
> X-ray look through to the underlying Morningstar diversification of each
> mutual fund holding, I am trying to extract the numbers in the style box
> in the via the RCHGetTableCell call. % of portfolio in Large Growth, %
> small cap value, etc. etc.
>
> eg.
> http://portfolios.morningstar.com/fund/summary?t=FDSAX®ion=usa&culture=en-US
>
> Even using httpFox, I am unable to identify any static page which holds
> this information. Have you or anyone else previously extracted this
> Morningstar information using the SMF_addin?
>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/26221
Just checked. It still works. :)
httpFox wouldn't help, because the data is defined in an array within
Javascript on the original web page.
On Wed, Feb 4, 2015 at 9:30 AM, David Nicholson djsn@...wrote:
>
> In developing an excel app to assess portfolio diversification via an
> X-ray look through to the underlying Morningstar diversification of each
> mutual fund holding, I am trying to extract the numbers in the style box
> in the via the RCHGetTableCell call. % of portfolio in Large Growth, %
> small cap value, etc. etc.
>
> eg.
> http://portfolios.morningstar.com/fund/summary?t=FDSAX®ion=usa&culture=en-US
>
> Even using httpFox, I am unable to identify any static page which holds
> this information. Have you or anyone else previously extracted this
> Morningstar information using the SMF_addin?
>
>
Wed Feb 4, 2015 8:45 am (PST) . Posted by:
soemoe.theinwin
I managed to get it working thanks for your help.
I was wondering if you knew of a way to import the "Annual Rates (per share)" info which is at the top left of the 10 yr Financials tab. I am trying to create a spreadsheet where i have multiple tickers down the left hand side with say 5yr Revenue Growth and 5yr EBIT growth in the cells next to it..
Many thanks!
---In smf_addin@yahoogroups.com, <dan-carroll@...> wrote :
Thanks Randy. Updated the file and uploaded it. Works for US stocks but can't test it for overseas. LMK if it works...
I was wondering if you knew of a way to import the "Annual Rates (per share)" info which is at the top left of the 10 yr Financials tab. I am trying to create a spreadsheet where i have multiple tickers down the left hand side with say 5yr Revenue Growth and 5yr EBIT growth in the cells next to it..
Many thanks!
---In smf_addin@yahoogroups.com, <dan-carroll@
Thanks Randy. Updated the file and uploaded it. Works for US stocks but can't test it for overseas. LMK if it works...
Wed Feb 4, 2015 3:58 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Plain vanilla RCHGetTableCell() functions should do the trick:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"Revenue
Growth (%)")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"EBITDA
Growth (%)")
On Wed, Feb 4, 2015 at 9:45 AM, soemoe.theinwin@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I was wondering if you knew of a way to import the "Annual Rates (per
> share)" info which is at the top left of the 10 yr Financials tab. I am
> trying to create a spreadsheet where i have multiple tickers down the left
> hand side with say 5yr Revenue Growth and 5yr EBIT growth in the cells next
> to it..
>
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"Revenue
Growth (%)")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"EBITDA
Growth (%)")
On Wed, Feb 4, 2015 at 9:45 AM, soemoe.theinwin@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> I was wondering if you knew of a way to import the "Annual Rates (per
> share)" info which is at the top left of the 10 yr Financials tab. I am
> trying to create a spreadsheet where i have multiple tickers down the left
> hand side with say 5yr Revenue Growth and 5yr EBIT growth in the cells next
> to it..
>
Thu Feb 5, 2015 1:29 am (PST) . Posted by:
"Soemoe Win" soemoe.theinwin
That seems to be working great - thank you!!
On Thursday, February 5, 2015 12:58 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Plain vanilla RCHGetTableCell() functions should do the trick:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"Revenue Growth (%)")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"EBITDA Growth (%)")
On Wed, Feb 4, 2015 at 9:45 AM, soemoe.theinwin@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I was wondering if you knew of a way to import the "Annual Rates (per share)" info which is at the top left of the 10 yr Financials tab. I am trying to create a spreadsheet where i have multiple tickers down the left hand side with say 5yr Revenue Growth and 5yr EBIT growth in the cells next to it..
#yiv9658834135 #yiv9658834135 -- #yiv9658834135ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9658834135 #yiv9658834135ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9658834135 #yiv9658834135ygrp-mkp #yiv9658834135hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv9658834135 #yiv9658834135ygrp-mkp #yiv9658834135ads {margin-bottom:10px;}#yiv9658834135 #yiv9658834135ygrp-mkp .yiv9658834135ad {padding:0 0;}#yiv9658834135 #yiv9658834135ygrp-mkp .yiv9658834135ad p {margin:0;}#yiv9658834135 #yiv9658834135ygrp-mkp .yiv9658834135ad a {color:#0000ff;text-decoration:none;}#yiv9658834135 #yiv9658834135ygrp-sponsor #yiv9658834135ygrp-lc {font-family:Arial;}#yiv9658834135 #yiv9658834135ygrp-sponsor #yiv9658834135ygrp-lc #yiv9658834135hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9658834135 #yiv9658834135ygrp-sponsor #yiv9658834135ygrp-lc .yiv9658834135ad {margin-bottom:10px;padding:0 0;}#yiv9658834135 #yiv9658834135actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9658834135 #yiv9658834135activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9658834135 #yiv9658834135activity span {font-weight:700;}#yiv9658834135 #yiv9658834135activity span:first-child {text-transform:uppercase;}#yiv9658834135 #yiv9658834135activity span a {color:#5085b6;text-decoration:none;}#yiv9658834135 #yiv9658834135activity span span {color:#ff7900;}#yiv9658834135 #yiv9658834135activity span .yiv9658834135underline {text-decoration:underline;}#yiv9658834135 .yiv9658834135attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv9658834135 .yiv9658834135attach div a {text-decoration:none;}#yiv9658834135 .yiv9658834135attach img {border:none;padding-right:5px;}#yiv9658834135 .yiv9658834135attach label {display:block;margin-bottom:5px;}#yiv9658834135 .yiv9658834135attach label a {text-decoration:none;}#yiv9658834135 blockquote {margin:0 0 0 4px;}#yiv9658834135 .yiv9658834135bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv9658834135 .yiv9658834135bold a {text-decoration:none;}#yiv9658834135 dd.yiv9658834135last p a {font-family:Verdana;font-weight:700;}#yiv9658834135 dd.yiv9658834135last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9658834135 dd.yiv9658834135last p span.yiv9658834135yshortcuts {margin-right:0;}#yiv9658834135 div.yiv9658834135attach-table div div a {text-decoration:none;}#yiv9658834135 div.yiv9658834135attach-table {width:400px;}#yiv9658834135 div.yiv9658834135file-title a, #yiv9658834135 div.yiv9658834135file-title a:active, #yiv9658834135 div.yiv9658834135file-title a:hover, #yiv9658834135 div.yiv9658834135file-title a:visited {text-decoration:none;}#yiv9658834135 div.yiv9658834135photo-title a, #yiv9658834135 div.yiv9658834135photo-title a:active, #yiv9658834135 div.yiv9658834135photo-title a:hover, #yiv9658834135 div.yiv9658834135photo-title a:visited {text-decoration:none;}#yiv9658834135 div#yiv9658834135ygrp-mlmsg #yiv9658834135ygrp-msg p a span.yiv9658834135yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9658834135 .yiv9658834135green {color:#628c2a;}#yiv9658834135 .yiv9658834135MsoNormal {margin:0 0 0 0;}#yiv9658834135 o {font-size:0;}#yiv9658834135 #yiv9658834135photos div {float:left;width:72px;}#yiv9658834135 #yiv9658834135photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv9658834135 #yiv9658834135photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv9658834135 #yiv9658834135reco-category {font-size:77%;}#yiv9658834135 #yiv9658834135reco-desc {font-size:77%;}#yiv9658834135 .yiv9658834135replbq {margin:4px;}#yiv9658834135 #yiv9658834135ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv9658834135 #yiv9658834135ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv9658834135 #yiv9658834135ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv9658834135 #yiv9658834135ygrp-mlmsg select, #yiv9658834135 input, #yiv9658834135 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv9658834135 #yiv9658834135ygrp-mlmsg pre, #yiv9658834135 code {font:115% monospace;}#yiv9658834135 #yiv9658834135ygrp-mlmsg * {line-height:1.22em;}#yiv9658834135 #yiv9658834135ygrp-mlmsg #yiv9658834135logo {padding-bottom:10px;}#yiv9658834135 #yiv9658834135ygrp-msg p a {font-family:Verdana;}#yiv9658834135 #yiv9658834135ygrp-msg p#yiv9658834135attach-count span {color:#1E66AE;font-weight:700;}#yiv9658834135 #yiv9658834135ygrp-reco #yiv9658834135reco-head {color:#ff7900;font-weight:700;}#yiv9658834135 #yiv9658834135ygrp-reco {margin-bottom:20px;padding:0px;}#yiv9658834135 #yiv9658834135ygrp-sponsor #yiv9658834135ov li a {font-size:130%;text-decoration:none;}#yiv9658834135 #yiv9658834135ygrp-sponsor #yiv9658834135ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv9658834135 #yiv9658834135ygrp-sponsor #yiv9658834135ov ul {margin:0;padding:0 0 0 8px;}#yiv9658834135 #yiv9658834135ygrp-text {font-family:Georgia;}#yiv9658834135 #yiv9658834135ygrp-text p {margin:0 0 1em 0;}#yiv9658834135 #yiv9658834135ygrp-text tt {font-size:120%;}#yiv9658834135 #yiv9658834135ygrp-vital ul li:last-child {border-right:none !important;}#yiv9658834135
On Thursday, February 5, 2015 12:58 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:
Plain vanilla RCHGetTableCell() functions should do the trick:
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"Revenue Growth (%)")
=RCHGetTableCell("http://www.gurufocus.com/financials/"&$C3,2,"EBITDA Growth (%)")
On Wed, Feb 4, 2015 at 9:45 AM, soemoe.theinwin@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
I was wondering if you knew of a way to import the "Annual Rates (per share)" info which is at the top left of the 10 yr Financials tab. I am trying to create a spreadsheet where i have multiple tickers down the left hand side with say 5yr Revenue Growth and 5yr EBIT growth in the cells next to it..
#yiv9658834135 #yiv9658834135 -- #yiv9658834135ygrp-
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar