Kamis, 17 September 2015

[smf_addin] Digest Number 3514

12 Messages

Digest #3514
1a
Fund summary by thomas777crown
1b
Re: Fund summary by "Randy Harmelink" rharmelink
1c
Re: Fund summary by thomas777crown
1d
Re: Fund summary by "Randy Harmelink" rharmelink
2a
2b
Re: Ex-Date and Date of Payment by "Randy Harmelink" rharmelink
2e
Re: Ex-Date and Date of Payment by "Randy Harmelink" rharmelink
3a
Conference Event Dates by friedman_steve
3b
Re: Conference Event Dates by "Randy Harmelink" rharmelink
3c
Re: Conference Event Dates by "P Dunbar" pdunbar1942

Messages

Wed Sep 16, 2015 6:02 am (PDT) . Posted by:

thomas777crown

Hi Randy,


I'm trying to pull the fund summary from this etf or any other etf's


http://finance.yahoo.com/q/pr?s=ALTS+Profile http://finance.yahoo.com/q/pr?s=ALTS+Profile



Thanks in advance. You have helped me out a lot on here.


Cheers
Thomas


Wed Sep 16, 2015 6:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=RCHGetTableCell(" http://finance.yahoo.com/q/pr?s="&C4,1,">Fund
Summary","<tr")

On Wed, Sep 16, 2015 at 6:02 AM, thomas777crown@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I'm trying to pull the fund summary from this etf or any other etf's
>
> http://finance.yahoo.com/q/pr?s=ALTS+Profile
>
>
>
>

Wed Sep 16, 2015 7:14 pm (PDT) . Posted by:

thomas777crown

Thanks again Randy. I know you don't take money but maybe you could recommend a cause your interested in so we can donate money to that cause.

Cheers
Thomas

Wed Sep 16, 2015 7:28 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Two things have really affected family members -- Cancer and Parkinson's.

On Wed, Sep 16, 2015 at 7:14 PM, thomas777crown@... wrote:

>
> Thanks again Randy. I know you don't take money but maybe you could
> recommend a cause your interested in so we can donate money to that cause.
>
>
>

Wed Sep 16, 2015 10:23 am (PDT) . Posted by:

alanmoore1966

Anyone know if or how the next Ex-Date and Date of Payment can be pulled?

Regards
Ronnie Moore



Wed Sep 16, 2015 10:31 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can pull them from Yahoo's Key Statistics web page (stocks only), with:

=RCHGetElementNumber("MMM",992)
=RCHGetElementNumber("MMM",991)

On Wed, Sep 16, 2015 at 10:22 AM, alanmoore1966@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Anyone know if or how the next Ex-Date and Date of Payment can be pulled?
>
>

Wed Sep 16, 2015 12:35 pm (PDT) . Posted by:

alanmoore1966

Thanks Randy, looks like this is historic data. Is there any data that shows next quarters exact dates? What I have setup now is just adding 90 days to the historic data which will be close but not always exact.

Regards
Ronnie Moore

Wed Sep 16, 2015 2:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

They won't show "next" until after the dividend has actually been declared
by the company. So most of the time, it will point to the last paid
dividend. For some companies, it will even go ex-dividend before Yahoo
updates the dates because the company declares the dividend and the
ex-dividend date is only a day or two later.

You'd be better off adding 365 days to the previous year equivalent than 90
days since the last, because the declarations usually coincide with when
financials are released, and there can be different delays between the
quarterly and annual earnings results announcements.

On Wed, Sep 16, 2015 at 12:35 PM, alanmoore1966@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thanks Randy, looks like this is historic data. Is there any data that
> shows next quarters exact dates? What I have setup now is just adding 90
> days to the historic data which will be close but not always exact.
>
>

Wed Sep 16, 2015 1:33 pm (PDT) . Posted by:

friedman_steve

I'm trying to find a source that shows upcoming conference/event dates (not quarterly earnings calls, but things like presenting at JP Morgan conference, or an Investor Analyst Day).


The only source I'm aware of for this is briefing.com (which I do have a subscription for).
1. Is there another source you'd suggest (briefing isn't that complete)
2. I'm not sure how to create code to grab the info for Briefing.




for example:
http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn



want to be able to grab data for the upcoming CONFERENCES. Specifically the DATE and EVENT NAME.


Thanks for all the help!
Steve

Wed Sep 16, 2015 2:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, but I don't follow such items, no I'm not aware of the various data
sources that might be available.

I can't use the URL you gave me as it wants me to log in.

On Wed, Sep 16, 2015 at 1:33 PM, friedman_steve@... wrote:

> I'm trying to find a source that shows upcoming conference/event dates
> (not quarterly earnings calls, but things like presenting at JP Morgan
> conference, or an Investor Analyst Day).
>
> The only source I'm aware of for this is briefing.com (which I do have a
> subscription for).
>
> 1. Is there another source you'd suggest (briefing isn't that complete)
>
> 2. I'm not sure how to create code to grab the info for Briefing.
>
> for example:
>
> http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn
>
> want to be able to grab data for the upcoming CONFERENCES. Specifically
> the DATE and EVENT NAME.
>
>

Wed Sep 16, 2015 3:02 pm (PDT) . Posted by:

"P Dunbar" pdunbar1942

I was looking recently for similar data re shareholder meetings.  Bloomberg had such info and ceased compiling it a few years ago. Though it's out of the scope of SMF and likely expensive, if you're interested in consolidated brokerage conferences and analysts day calendars, your best bet is likely Bloomberg.
If you find another source, please kindly inform.


On Wednesday, September 16, 2015 9:37 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  Sorry, but I don't follow such items, no I'm not aware of the various data sources that might be available.

I can't use the URL you gave me as it wants me to log in.

On Wed, Sep 16, 2015 at 1:33 PM, friedman_steve@... wrote:

I'm trying to find a source that shows upcoming conference/event dates  (not quarterly earnings calls, but things like presenting at JP Morgan conference, or an Investor Analyst Day). The only source I'm aware of for this is briefing.com  (which I do have a subscription for).1.  Is there another source you'd suggest  (briefing isn't that complete)2.  I'm not sure how to create code to grab the info for Briefing.for example:http://www.briefing.com/InPlayEq/Search/Ticker.htm?ticker=lpsn
want to be able to grab data for the upcoming CONFERENCES.   Specifically the DATE and EVENT NAME.  

#yiv8035957747 #yiv8035957747 -- #yiv8035957747ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8035957747 #yiv8035957747ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8035957747 #yiv8035957747ygrp-mkp #yiv8035957747hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8035957747 #yiv8035957747ygrp-mkp #yiv8035957747ads {margin-bottom:10px;}#yiv8035957747 #yiv8035957747ygrp-mkp .yiv8035957747ad {padding:0 0;}#yiv8035957747 #yiv8035957747ygrp-mkp .yiv8035957747ad p {margin:0;}#yiv8035957747 #yiv8035957747ygrp-mkp .yiv8035957747ad a {color:#0000ff;text-decoration:none;}#yiv8035957747 #yiv8035957747ygrp-sponsor #yiv8035957747ygrp-lc {font-family:Arial;}#yiv8035957747 #yiv8035957747ygrp-sponsor #yiv8035957747ygrp-lc #yiv8035957747hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8035957747 #yiv8035957747ygrp-sponsor #yiv8035957747ygrp-lc .yiv8035957747ad {margin-bottom:10px;padding:0 0;}#yiv8035957747 #yiv8035957747actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8035957747 #yiv8035957747activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8035957747 #yiv8035957747activity span {font-weight:700;}#yiv8035957747 #yiv8035957747activity span:first-child {text-transform:uppercase;}#yiv8035957747 #yiv8035957747activity span a {color:#5085b6;text-decoration:none;}#yiv8035957747 #yiv8035957747activity span span {color:#ff7900;}#yiv8035957747 #yiv8035957747activity span .yiv8035957747underline {text-decoration:underline;}#yiv8035957747 .yiv8035957747attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8035957747 .yiv8035957747attach div a {text-decoration:none;}#yiv8035957747 .yiv8035957747attach img {border:none;padding-right:5px;}#yiv8035957747 .yiv8035957747attach label {display:block;margin-bottom:5px;}#yiv8035957747 .yiv8035957747attach label a {text-decoration:none;}#yiv8035957747 blockquote {margin:0 0 0 4px;}#yiv8035957747 .yiv8035957747bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8035957747 .yiv8035957747bold a {text-decoration:none;}#yiv8035957747 dd.yiv8035957747last p a {font-family:Verdana;font-weight:700;}#yiv8035957747 dd.yiv8035957747last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8035957747 dd.yiv8035957747last p span.yiv8035957747yshortcuts {margin-right:0;}#yiv8035957747 div.yiv8035957747attach-table div div a {text-decoration:none;}#yiv8035957747 div.yiv8035957747attach-table {width:400px;}#yiv8035957747 div.yiv8035957747file-title a, #yiv8035957747 div.yiv8035957747file-title a:active, #yiv8035957747 div.yiv8035957747file-title a:hover, #yiv8035957747 div.yiv8035957747file-title a:visited {text-decoration:none;}#yiv8035957747 div.yiv8035957747photo-title a, #yiv8035957747 div.yiv8035957747photo-title a:active, #yiv8035957747 div.yiv8035957747photo-title a:hover, #yiv8035957747 div.yiv8035957747photo-title a:visited {text-decoration:none;}#yiv8035957747 div#yiv8035957747ygrp-mlmsg #yiv8035957747ygrp-msg p a span.yiv8035957747yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8035957747 .yiv8035957747green {color:#628c2a;}#yiv8035957747 .yiv8035957747MsoNormal {margin:0 0 0 0;}#yiv8035957747 o {font-size:0;}#yiv8035957747 #yiv8035957747photos div {float:left;width:72px;}#yiv8035957747 #yiv8035957747photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8035957747 #yiv8035957747photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8035957747 #yiv8035957747reco-category {font-size:77%;}#yiv8035957747 #yiv8035957747reco-desc {font-size:77%;}#yiv8035957747 .yiv8035957747replbq {margin:4px;}#yiv8035957747 #yiv8035957747ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8035957747 #yiv8035957747ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8035957747 #yiv8035957747ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8035957747 #yiv8035957747ygrp-mlmsg select, #yiv8035957747 input, #yiv8035957747 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8035957747 #yiv8035957747ygrp-mlmsg pre, #yiv8035957747 code {font:115% monospace;}#yiv8035957747 #yiv8035957747ygrp-mlmsg * {line-height:1.22em;}#yiv8035957747 #yiv8035957747ygrp-mlmsg #yiv8035957747logo {padding-bottom:10px;}#yiv8035957747 #yiv8035957747ygrp-msg p a {font-family:Verdana;}#yiv8035957747 #yiv8035957747ygrp-msg p#yiv8035957747attach-count span {color:#1E66AE;font-weight:700;}#yiv8035957747 #yiv8035957747ygrp-reco #yiv8035957747reco-head {color:#ff7900;font-weight:700;}#yiv8035957747 #yiv8035957747ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8035957747 #yiv8035957747ygrp-sponsor #yiv8035957747ov li a {font-size:130%;text-decoration:none;}#yiv8035957747 #yiv8035957747ygrp-sponsor #yiv8035957747ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8035957747 #yiv8035957747ygrp-sponsor #yiv8035957747ov ul {margin:0;padding:0 0 0 8px;}#yiv8035957747 #yiv8035957747ygrp-text {font-family:Georgia;}#yiv8035957747 #yiv8035957747ygrp-text p {margin:0 0 1em 0;}#yiv8035957747 #yiv8035957747ygrp-text tt {font-size:120%;}#yiv8035957747 #yiv8035957747ygrp-vital ul li:last-child {border-right:none !important;}#yiv8035957747

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar