14 New Messages
Digest #2766
Messages
Mon Sep 9, 2013 9:44 am (PDT) . Posted by:
sleellano
Randy, I have found my mistake in my spread sheet and corrected
it (problem was misspelled word)
Still can not enter the Links area though.
--- In smf_addin@yahoogrou
Yahoo Groups says I am signed in as sleellano to SMF. Is there
somewhere else I need to go. I was able to down load
smf_addin
--- In smf_addin@yahoogrou
Ah, OK.
You do have to join the group to access that area.
On Mon, Sep 9, 2013 at 7:31 AM, <sleellano@
It seems I am not being clear. The area I am referring to is in
the Yahoo Groups SMF_addin.
Links is where others have been refereed too for answers to
questions.
Mon Sep 9, 2013 10:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I go to the Yahoo group, I don't see a drop-down menu. So I'm not sure
what you're referring to there.
In any case, the URL for the LINKS area is:
http://finance.groups.yahoo.com/group/smf_addin/links
On Mon, Sep 9, 2013 at 6:47 AM, <sleellano@gmail.com> wrote:
> The answer to my question apparently is in "Links" which in the the
> "More drop down menu along with "Files, Database and Attachments, Both
> Links and Database are grayed out, there for none click able. If I can find
> out how to access Links I believe I can figure the rest out.
>
>
what you're referring to there.
In any case, the URL for the LINKS area is:
http://finance.
On Mon, Sep 9, 2013 at 6:47 AM, <sleellano@gmail.
> The answer to my question apparently is in "Links" which in the the
> "More drop down menu along with "Files, Database and Attachments, Both
> Links and Database are grayed out, there for none click able. If I can find
> out how to access Links I believe I can figure the rest out.
>
>
Mon Sep 9, 2013 10:40 am (PDT) . Posted by:
"Steve Lee" sleellano
Thank you for the URL and your time. Much appreciated
The menu is called "More"
Thanks again
Steve
On Mon, Sep 9, 2013 at 10:34 AM, Randy Harmelink <rharmelink@gmail.com>wrote:
> **
>
>
> When I go to the Yahoo group, I don't see a drop-down menu. So I'm not
> sure what you're referring to there.
>
> In any case, the URL for the LINKS area is:
>
> http://finance.groups.yahoo.com/group/smf_addin/links
>
> On Mon, Sep 9, 2013 at 6:47 AM, <sleellano@gmail.com> wrote:
>
>> The answer to my question apparently is in "Links" which in the the
>> "More drop down menu along with "Files, Database and Attachments, Both
>> Links and Database are grayed out, there for none click able. If I can find
>> out how to access Links I believe I can figure the rest out.
>>
>>
>
>
The menu is called "More"
Thanks again
Steve
On Mon, Sep 9, 2013 at 10:34 AM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> When I go to the Yahoo group, I don't see a drop-down menu. So I'm not
> sure what you're referring to there.
>
> In any case, the URL for the LINKS area is:
>
> http://finance.
>
> On Mon, Sep 9, 2013 at 6:47 AM, <sleellano@gmail.
>
>> The answer to my question apparently is in "Links" which in the the
>> "More drop down menu along with "Files, Database and Attachments, Both
>> Links and Database are grayed out, there for none click able. If I can find
>> out how to access Links I believe I can figure the rest out.
>>
>>
>
>
Mon Sep 9, 2013 10:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Normally, I would say, "Yes, you're screwed."
HOWEVER...in examining the source code and the JavaScript of the web page,
it appears the data is here:
http://www.cefconnect.com/Resources/TableData/?Type=DistributionHistory¶m0=1/1/1980¶m1=12/31/2020&Cusip=27828S101
So, you would need the CUSIP, but I gave it a bogus beginning date and
ending date that don't need to be changed. On that page, each distribution
looks something like:
{"TotDiv":0.1025,"Income":0.1025,"CapitalReturn":0.0,"CapitalLT":0.0,"CapitalST":0.0,"PayDateDisplay":"8/30/2013","ExDivDateDisplay":"8/21/2013","DeclaredDateDisplay":"8/13/2013"}
...so you could extract each one from that file. For example, if this is in
cell B2:
=RCHGetWebData("
http://www.cefconnect.com/Resources/TableData/?Type=DistributionHistory¶m0=1/1/1980¶m1=12/31/2020&Cusip=27828S101
")
...then extracting the 13th distribution amount from the file would be:
=smfstrExtr(smfWord($B$2,13,"}"),"TotDiv"":",",")
On Mon, Sep 9, 2013 at 8:36 AM, <petekoch@yahoo.com> wrote:
>
> I attempted to extract the distribution breakdown for ETG using the
> following URL with the Distributions tab:
>
> http://www.cefconnect.com/Details/Summary.aspx?ticker=ETG
>
> using the following formula:
>
> =RCHGetTableCell("http://www.cefconnect.com/Details/Summary.aspx?ticker-"&Ticker,3,"Distribution
> History","Declared Date",,,,2)
>
> What is returned is "Distribution Amount", the header for the value I
> want. I don't find the amount values in the page source, leading me to
> believe that the values are dynamically generated and not available in the
> source, similar to what Morningstar did with their financials a while
> back.
>
> I be thinkin' I be screwed. Am I right ?
>
HOWEVER...in examining the source code and the JavaScript of the web page,
it appears the data is here:
http://www.cefconne
So, you would need the CUSIP, but I gave it a bogus beginning date and
ending date that don't need to be changed. On that page, each distribution
looks something like:
{"TotDiv"
...so you could extract each one from that file. For example, if this is in
cell B2:
=RCHGetWebData(
http://www.cefconne
")
...then extracting the 13th distribution amount from the file would be:
=smfstrExtr(
On Mon, Sep 9, 2013 at 8:36 AM, <petekoch@yahoo.
>
> I attempted to extract the distribution breakdown for ETG using the
> following URL with the Distributions tab:
>
> http://www.cefconne
>
> using the following formula:
>
> =RCHGetTableCell(
> History"
>
> What is returned is "Distribution Amount"
> want. I don't find the amount values in the page source, leading me to
> believe that the values are dynamically generated and not available in the
> source, similar to what Morningstar did with their financials a while
> back.
>
> I be thinkin' I be screwed. Am I right ?
>
Mon Sep 9, 2013 11:45 am (PDT) . Posted by:
petekoch
Thanks, Randy, I appreciate it.
I have a command button in the workbook which opens a browser tab
for the Fund on the CEF Connect site where the breakdown of the
distribution is laid out. That will do for now.
What you have uncovered looks like a task for another day.
I would like to save the message number so I can easily find your
solution when I want it, but after the changes to Yahoo! Groups,
I no longer see a message number. Is there an option to make the
message number visible ?
--- In smf_addin@yahoogrou
Normally, I would say, "Yes, you're screwed."Â
HOWEVER...in examining the source code and the JavaScript of the
web page, it appears the data is here:
http://www.cefconne
istory¶m0=
<http://www.cefconne
History¶m0=
So, you would need the CUSIP, but I gave it a bogus beginning
date and ending date that don't need to be changed. On that page,
each distribution looks something like:
{"TotDiv"
0.0,"CapitalST
y":"
...so you could extract each one from that file. For example, if
this is in cell B2:
=RCHGetWebData(
pe=DistributionHist
828S101
<http://www.cefconne
History¶m0=
...then extracting the 13th distribution amount from the file
would be:
=smfstrExtr(
On Mon, Sep 9, 2013 at 8:36 AM, <petekoch@
I attempted to extract the distribution breakdown for ETG using
the following URL with the Distributions tab:
http://www.cefconne
<http://www.cefconne
using the following formula:
=RCHGetTableCell(
ticker- <http://www.cefconne
"&Ticker,
What is returned is "Distribution Amount"
value I want. I don't find the amount values in the page
source, leading me to believe that the values are dynamically
generated and not available in the source, similar to what
Morningstar did with their financials a while back.Â
I be thinkin' I be screwed. Am I right ?
Mon Sep 9, 2013 12:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I have no idea. Groups looks the same to me as they always have. In any
case, it's:
http://finance.groups.yahoo.com/group/smf_addin/message/23587
On Mon, Sep 9, 2013 at 11:45 AM, <petekoch@yahoo.com> wrote:
> I would like to save the message number so I can easily find your
> solution when I want it, but after the changes to Yahoo! Groups, I no
> longer see a message number. Is there an option to make the message number
> visible ?
>
case, it's:
http://finance.
On Mon, Sep 9, 2013 at 11:45 AM, <petekoch@yahoo.
> I would like to save the message number so I can easily find your
> solution when I want it, but after the changes to Yahoo! Groups, I no
> longer see a message number. Is there an option to make the message number
> visible ?
>
Mon Sep 9, 2013 1:21 pm (PDT) . Posted by:
"Martin Topper" mtopper
there appea4s to be an option to show messages "Summarized" or "Expanded";. Summarized does not appear to include the message number.
________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Monday, September 9, 2013 3:54 PM
Subject: Re: [smf_addin] RE: GetTableCell Question
I have no idea. Groups looks the same to me as they always have. In any case, it's:
http://finance.groups.yahoo.com/group/smf_addin/message/23587
On Mon, Sep 9, 2013 at 11:45 AM, <petekoch@yahoo.com> wrote:
I would like to save the message number so I can easily find your solution when I want it, but after the changes to Yahoo! Groups, I no longer see a message number. Is there an option to make the message number visible ?
>
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Monday, September 9, 2013 3:54 PM
Subject: Re: [smf_addin] RE: GetTableCell Question
I have no idea. Groups looks the same to me as they always have. In any case, it's:
http://finance.
On Mon, Sep 9, 2013 at 11:45 AM, <petekoch@yahoo.
I would like to save the message number so I can easily find your solution when I want it, but after the changes to Yahoo! Groups, I no longer see a message number. Is there an option to make the message number visible ?
>
Mon Sep 9, 2013 1:10 pm (PDT) . Posted by:
"bs2167" bs2167
I tried posting this a few hours ago but the message doesn't appear to be showing up - apologies if this is a duplicate.
As of this morning, the fulldisclosure.com website appears to be down. Are others experiencing the same issue? If so, has anyone been able to identify a new url that it's operating under? (last time the site migrated from earnings.com to fulldisclosure.com)
As of this morning, the fulldisclosure.
Mon Sep 9, 2013 1:28 pm (PDT) . Posted by:
"bs2167" bs2167
Hello,
As of this morning, I haven't been able to access the fulldisclosure.com website. I wanted to 1) check that I'm not the only having problems and 2) see if anyone has found an alternate web address that works (similar to last time when earnings.com became fulldisclosure.com).
Appreciate any input. Thanks
As of this morning, I haven't been able to access the fulldisclosure.
Appreciate any input. Thanks
Mon Sep 9, 2013 4:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not seeing it right now. But it's disappeared and returned several
times now...
But I've not had long-term expectations of the site.
On Mon, Sep 9, 2013 at 8:01 AM, bs2167 <bs2167@yahoo.com> wrote:
>
> As of this morning, I haven't been able to access the fulldisclosure.comwebsite. I wanted to 1) check that I'm not the only having problems and 2)
> see if anyone has found an alternate web address that works (similar to
> last time when earnings.com became fulldisclosure.com).
>
> Appreciate any input. Thanks
>
times now...
But I've not had long-term expectations of the site.
On Mon, Sep 9, 2013 at 8:01 AM, bs2167 <bs2167@yahoo.
>
> As of this morning, I haven't been able to access the fulldisclosure.
> see if anyone has found an alternate web address that works (similar to
> last time when earnings.com became fulldisclosure.
>
> Appreciate any input. Thanks
>
Mon Sep 9, 2013 6:51 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Thanks Randy.
Little by little, making more sense of this.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Monday, September 09, 2013 10:51 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] basic quote
Don't do that unless you want a volatile formula. It will recalculate anytime something changes in the workbook, and be VERY slow if you have a number of them.
Instead:
=RCHGetYahooQuotes(A2, "l1")
Check the documentation of that function for available Yahoo codes for various data items.
Note that a large number of the above formulas will also makes your worksheet slow. That's when you want to array-enter the formula as a table -- so everything in the table is retrieved with a single Internet access, instead of each individual formula needing an Internet access.
On Mon, Sep 9, 2013 at 7:08 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
=smfPricesByDates(B2, TODAY()) where ticker symbol is in cell B2
Little by little, making more sense of this.
Jim
From: smf_addin@yahoogrou
Sent: Monday, September 09, 2013 10:51 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] basic quote
Don't do that unless you want a volatile formula. It will recalculate anytime something changes in the workbook, and be VERY slow if you have a number of them.
Instead:
=RCHGetYahooQuotes(
Check the documentation of that function for available Yahoo codes for various data items.
Note that a large number of the above formulas will also makes your worksheet slow. That's when you want to array-enter the formula as a table -- so everything in the table is retrieved with a single Internet access, instead of each individual formula needing an Internet access.
On Mon, Sep 9, 2013 at 7:08 AM, Kermit W. Prather <kermitp@tampabay.
=smfPricesByDates(
Mon Sep 9, 2013 7:32 pm (PDT) . Posted by:
"Jim Ranum" amt2100
Well, I spoke too soon.
I'm trying to follow the guidance in your "little template" message on 7/28/2006 and for some reason, the first 2 columns repeat the ticker twice. The way I see it, the A column are my inputs and the RCHGetYahooQuotes should start in column B with numbers, no ticker at all.
And the numbers are shifted over 1 column, not under the coded column. The Price (code 11) isn't showing up at all.
Screenshot here:
What did I do wrong?
Thanks,
Jim
From: Jim Ranum [mailto:amt2100@gmail.com]
Sent: Monday, September 09, 2013 9:51 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [smf_addin] basic quote
Thanks Randy.
Little by little, making more sense of this.
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Monday, September 09, 2013 10:51 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] basic quote
Don't do that unless you want a volatile formula. It will recalculate anytime something changes in the workbook, and be VERY slow if you have a number of them.
Instead:
=RCHGetYahooQuotes(A2, "l1")
Check the documentation of that function for available Yahoo codes for various data items.
Note that a large number of the above formulas will also makes your worksheet slow. That's when you want to array-enter the formula as a table -- so everything in the table is retrieved with a single Internet access, instead of each individual formula needing an Internet access.
On Mon, Sep 9, 2013 at 7:08 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
=smfPricesByDates(B2, TODAY()) where ticker symbol is in cell B2
I'm trying to follow the guidance in your "little template" message on 7/28/2006 and for some reason, the first 2 columns repeat the ticker twice. The way I see it, the A column are my inputs and the RCHGetYahooQuotes should start in column B with numbers, no ticker at all.
And the numbers are shifted over 1 column, not under the coded column. The Price (code 11) isn't showing up at all.
Screenshot here:
What did I do wrong?
Thanks,
Jim
From: Jim Ranum [mailto:amt2100@gmail.
Sent: Monday, September 09, 2013 9:51 PM
To: 'smf_addin@
Subject: RE: [smf_addin] basic quote
Thanks Randy.
Little by little, making more sense of this.
Jim
From: smf_addin@yahoogrou
Sent: Monday, September 09, 2013 10:51 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] basic quote
Don't do that unless you want a volatile formula. It will recalculate anytime something changes in the workbook, and be VERY slow if you have a number of them.
Instead:
=RCHGetYahooQuotes(
Check the documentation of that function for available Yahoo codes for various data items.
Note that a large number of the above formulas will also makes your worksheet slow. That's when you want to array-enter the formula as a table -- so everything in the table is retrieved with a single Internet access, instead of each individual formula needing an Internet access.
On Mon, Sep 9, 2013 at 7:08 AM, Kermit W. Prather <kermitp@tampabay.
=smfPricesByDates(
Mon Sep 9, 2013 8:15 pm (PDT) . Posted by:
"Deborah" dcharlotte99
Randy - now that it's looking like AdvFN will not be a good long-term solution to pull in 10 years of financial data, do you know of an alternative?
I saw the post Jae Jun made about his monthly subscription offer, wonder what you think of that or do you know of a free (or less expensive) alternative. I'm still a small-time investor.
Is Morningstar an alternative? I need 10 years of financial statement data to do my analysis, and believe they have it.
Thanks much for creating and supporting SMF Add-in, I've really enjoyed using it over the last few years.
I saw the post Jae Jun made about his monthly subscription offer, wonder what you think of that or do you know of a free (or less expensive) alternative. I'm still a small-time investor.
Is Morningstar an alternative? I need 10 years of financial statement data to do my analysis, and believe they have it.
Thanks much for creating and supporting SMF Add-in, I've really enjoyed using it over the last few years.
Mon Sep 9, 2013 11:30 pm (PDT) . Posted by:
g_oudreva
Deborah,
Theres a great source for 10 years of financial data and it's
free.
It's the 10 year model-GuruFocus.
by dancarroll
It's located in the files\all files\uploads by forum members
(it's really nice to have members like dancarroll whom give back
to the smf-addin community. After all, Randy has set a great
example by helping all of us with his SMF creation.! Thanks again
Randy and Dan!)
--- In smf_addin@yahoogrou
Randy - now that it's looking like AdvFN will not be a good
long-term solution to pull in 10 years of financial data, do you
know of an alternative?
I saw the post Jae Jun made about his monthly subscription offer,
wonder what you think of that or do you know of a free (or less
expensive) alternative. I'm still a small-time investor.
Is Morningstar an alternative? I need 10 years of financial
statement data to do my analysis, and believe they have it.
Thanks much for creating and supporting SMF Add-in, I've really
enjoyed using it over the last few years.
Tidak ada komentar:
Posting Komentar