Senin, 06 Oktober 2014

[smf_addin] Digest Number 3200

9 Messages

Digest #3200
1a
SMF-Template-Morningstar-Stock-Data by "Jose Jacob" pepecan47
1b
Re: SMF-Template-Morningstar-Stock-Data by "Randy Harmelink" rharmelink
1c
2b
Re: Fubction 13862 causing error message by "Randy Harmelink" rharmelink
3a
MSN data error by yan_l_aung
3b
Re: MSN data error by "Randy Harmelink" rharmelink

Messages

Sun Oct 5, 2014 11:38 am (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - using the M* template in the working in progress folder. The currency that you use is hard coded as USD, but Canadian stocks have CAD as currency.

http://financials.morningstar.com/valuation/earnings-estimates.html?t=BCE

May I ask you to create an element for the currency value, and modify the template?

Thank you very much.

Regards,
Jose L. Jacob

Sun Oct 5, 2014 1:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Since it's just a label on the template, I'm more inclined to just change
the label to be "Amount".

On Sun, Oct 5, 2014 at 11:38 AM, Jose Jacob pepecan47@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hi Randy - using the M* template in the working in progress folder. The
> currency that you use is hard coded as USD, but Canadian stocks have CAD as
> currency.
>
> http://financials.morningstar.com/valuation/earnings-estimates.html?t=BCE
>
> May I ask you to create an element for the currency value, and modify the
> template?
>

Sun Oct 5, 2014 2:34 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

Hi Randy - what I am asking is to retrieve from the internet the value (USD or CAD) and write it in the template as a variable. Currently in the template the literal is a hard coded "USD".

To do that I am suggesting to define al element # for the currency to use, and stick that in the spreadsheet.

See the following page for an example of a Canadian stock:

http://financials.morningstar.com/valuation/earnings-estimates.html?t=BCE

Regards,
Jose L. Jacob

--------------------------------------------
On Sun, 10/5/14, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] SMF-Template-Morningstar-Stock-Data
To: smf_addin@yahoogroups.com
Received: Sunday, October 5, 2014, 4:54 PM


 









Since it's just a label on
the template, I'm more inclined to just change the label
to be "Amount".

On Sun, Oct 5, 2014 at
11:38 AM, Jose Jacob pepecan47@yahoo.ca
[smf_addin] <smf_addin@yahoogroups.com>
wrote:
Hi Randy - using the M* template in the working in
progress folder. The currency that you use is hard coded as
USD, but Canadian stocks have CAD as currency.



http://financials.morningstar.com/valuation/earnings-estimates.html?t=BCE



May I ask you to create an element for the currency value,
and modify the template?












#yiv5007751977 #yiv5007751977 --
#yiv5007751977ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px
0;padding:0 10px;}

#yiv5007751977 #yiv5007751977ygrp-mkp hr {
border:1px solid #d8d8d8;}

#yiv5007751977 #yiv5007751977ygrp-mkp #yiv5007751977hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}

#yiv5007751977 #yiv5007751977ygrp-mkp #yiv5007751977ads {
margin-bottom:10px;}

#yiv5007751977 #yiv5007751977ygrp-mkp .yiv5007751977ad {
padding:0 0;}

#yiv5007751977 #yiv5007751977ygrp-mkp .yiv5007751977ad p {
margin:0;}

#yiv5007751977 #yiv5007751977ygrp-mkp .yiv5007751977ad a {
color:#0000ff;text-decoration:none;}
#yiv5007751977 #yiv5007751977ygrp-sponsor
#yiv5007751977ygrp-lc {
font-family:Arial;}

#yiv5007751977 #yiv5007751977ygrp-sponsor
#yiv5007751977ygrp-lc #yiv5007751977hd {
margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}

#yiv5007751977 #yiv5007751977ygrp-sponsor
#yiv5007751977ygrp-lc .yiv5007751977ad {
margin-bottom:10px;padding:0 0;}

#yiv5007751977 #yiv5007751977actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#yiv5007751977 #yiv5007751977activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#yiv5007751977 #yiv5007751977activity span {
font-weight:700;}

#yiv5007751977 #yiv5007751977activity span:first-child {
text-transform:uppercase;}

#yiv5007751977 #yiv5007751977activity span a {
color:#5085b6;text-decoration:none;}

#yiv5007751977 #yiv5007751977activity span span {
color:#ff7900;}

#yiv5007751977 #yiv5007751977activity span
.yiv5007751977underline {
text-decoration:underline;}

#yiv5007751977 .yiv5007751977attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}

#yiv5007751977 .yiv5007751977attach div a {
text-decoration:none;}

#yiv5007751977 .yiv5007751977attach img {
border:none;padding-right:5px;}

#yiv5007751977 .yiv5007751977attach label {
display:block;margin-bottom:5px;}

#yiv5007751977 .yiv5007751977attach label a {
text-decoration:none;}

#yiv5007751977 blockquote {
margin:0 0 0 4px;}

#yiv5007751977 .yiv5007751977bold {
font-family:Arial;font-size:13px;font-weight:700;}

#yiv5007751977 .yiv5007751977bold a {
text-decoration:none;}

#yiv5007751977 dd.yiv5007751977last p a {
font-family:Verdana;font-weight:700;}

#yiv5007751977 dd.yiv5007751977last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#yiv5007751977 dd.yiv5007751977last p
span.yiv5007751977yshortcuts {
margin-right:0;}

#yiv5007751977 div.yiv5007751977attach-table div div a {
text-decoration:none;}

#yiv5007751977 div.yiv5007751977attach-table {
width:400px;}

#yiv5007751977 div.yiv5007751977file-title a, #yiv5007751977
div.yiv5007751977file-title a:active, #yiv5007751977
div.yiv5007751977file-title a:hover, #yiv5007751977
div.yiv5007751977file-title a:visited {
text-decoration:none;}

#yiv5007751977 div.yiv5007751977photo-title a,
#yiv5007751977 div.yiv5007751977photo-title a:active,
#yiv5007751977 div.yiv5007751977photo-title a:hover,
#yiv5007751977 div.yiv5007751977photo-title a:visited {
text-decoration:none;}

#yiv5007751977 div#yiv5007751977ygrp-mlmsg
#yiv5007751977ygrp-msg p a span.yiv5007751977yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#yiv5007751977 .yiv5007751977green {
color:#628c2a;}

#yiv5007751977 .yiv5007751977MsoNormal {
margin:0 0 0 0;}

#yiv5007751977 o {
font-size:0;}

#yiv5007751977 #yiv5007751977photos div {
float:left;width:72px;}

#yiv5007751977 #yiv5007751977photos div div {
border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}

#yiv5007751977 #yiv5007751977photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#yiv5007751977 #yiv5007751977reco-category {
font-size:77%;}

#yiv5007751977 #yiv5007751977reco-desc {
font-size:77%;}

#yiv5007751977 .yiv5007751977replbq {
margin:4px;}

#yiv5007751977 #yiv5007751977ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#yiv5007751977 #yiv5007751977ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean,
sans-serif;}

#yiv5007751977 #yiv5007751977ygrp-mlmsg table {
font-size:inherit;font:100%;}

#yiv5007751977 #yiv5007751977ygrp-mlmsg select,
#yiv5007751977 input, #yiv5007751977 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#yiv5007751977 #yiv5007751977ygrp-mlmsg pre, #yiv5007751977
code {
font:115% monospace;}

#yiv5007751977 #yiv5007751977ygrp-mlmsg * {
line-height:1.22em;}

#yiv5007751977 #yiv5007751977ygrp-mlmsg #yiv5007751977logo {
padding-bottom:10px;}


#yiv5007751977 #yiv5007751977ygrp-msg p a {
font-family:Verdana;}

#yiv5007751977 #yiv5007751977ygrp-msg
p#yiv5007751977attach-count span {
color:#1E66AE;font-weight:700;}

#yiv5007751977 #yiv5007751977ygrp-reco
#yiv5007751977reco-head {
color:#ff7900;font-weight:700;}

#yiv5007751977 #yiv5007751977ygrp-reco {
margin-bottom:20px;padding:0px;}

#yiv5007751977 #yiv5007751977ygrp-sponsor #yiv5007751977ov
li a {
font-size:130%;text-decoration:none;}

#yiv5007751977 #yiv5007751977ygrp-sponsor #yiv5007751977ov
li {
font-size:77%;list-style-type:square;padding:6px 0;}

#yiv5007751977 #yiv5007751977ygrp-sponsor #yiv5007751977ov
ul {
margin:0;padding:0 0 0 8px;}

#yiv5007751977 #yiv5007751977ygrp-text {
font-family:Georgia;}

#yiv5007751977 #yiv5007751977ygrp-text p {
margin:0 0 1em 0;}

#yiv5007751977 #yiv5007751977ygrp-text tt {
font-size:120%;}

#yiv5007751977 #yiv5007751977ygrp-vital ul li:last-child {
border-right:none !important;
}
#yiv5007751977


Sun Oct 5, 2014 1:06 pm (PDT) . Posted by:

hsadvisor1

function # 13862 is not producing mutual fund or investment name. Why?

Sun Oct 5, 2014 1:45 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031

On Sun, Oct 5, 2014 at 1:06 PM, hsadvisor1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> function # 13862 is not producing mutual fund or investment name. Why?
>

Sun Oct 5, 2014 1:42 pm (PDT) . Posted by:

yan_l_aung

All,
I think MSN data retrieval is now broken. I used =RCHGetElementNumber(Ticker,34) for 52 week high from MSN data and others. It is showing error in the past few days. I downloaded "SMF-Template-MSN-Key-Ratio-Comparisons.xls" from ogres-crypt.com/SMF template session to see if it is my spreadsheet issue but they are having the same issue with MSN data.


Please let me know where to send problem report.


Thank you,
Ryan

Sun Oct 5, 2014 1:46 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

See:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/27031

On Sun, Oct 5, 2014 at 10:51 AM, sub_z_0@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I think MSN data retrieval is now broken. I used
> =RCHGetElementNumber(Ticker,34) for 52 week high from MSN data and others.
> It is showing error in the past few days. I downloaded
> "SMF-Template-MSN-Key-Ratio-Comparisons.xls" from ogres-crypt.com/SMF
> template session to see if it is my spreadsheet issue but they are having
> the same issue with MSN data.
>
> Please let me know where to send problem report.
>

Sun Oct 5, 2014 7:57 pm (PDT) . Posted by:

ghart21

Randy
How could I access the net shares purchased (10,888,000) or the % Change for a stock (here VRX)
from the Yahoo Insider transactions page? I used to get this data from MSN It's not one of your standard elements.
Thanks
G Hart


Net Share Purchase Activity Insider Purchases - Last 6 Months Shares Trans Purchases 5,190 2 Sales 6,000 1 Net Shares Purchased
(Sold) (810) 3 Total Insider Shares Held 2.97M N/A % Net Shares Purchased
(Sold) 0% N/A Net Institutional Purchases - Prior Qtr to Latest Qtr Shares Net Shares Purchased
(Sold) (10,888,400) % Change in Institutional Shares Held (4.42%) Data provided by Thomson Financial http://www.thomson.com/financial/financial.jsp

Mon Oct 6, 2014 12:33 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Just use the RCHGetTableCell() function. For example:

=RCHGetTableCell("http://finance.yahoo.com/q/it?s=VRX",1,">Net
Institutional",">Net Shares Purchased")

=RCHGetTableCell("http://finance.yahoo.com/q/it?s=VRX",1,">Net
Institutional",">% Change")

On Sun, Oct 5, 2014 at 7:57 PM, ghart23@earthlink.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> How could I access the net shares purchased (10,888,000) or the % Change
> for a stock (here VRX)
>
> from the Yahoo Insider transactions page? I used to get this data from
> MSN It's not one of your standard elements.
>
> Thanks
>
> G Hart
>
> *Net Share Purchase Activity**Insider Purchases* - Last 6 Months Shares
> TransPurchases5,1902Sales6,0001Net Shares Purchased
> (Sold)(810)3Total Insider Shares Held2.97MN/A% Net Shares Purchased
> (Sold)0%N/A*Net Institutional Purchases* - Prior Qtr to Latest Qtr SharesNet
> Shares Purchased
> (Sold)(10,888,400)% Change in Institutional Shares Held(4.42%)Data
> provided by Thomson Financial
> <http://www.thomson.com/financial/financial.jsp>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 02.33

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)