Selasa, 24 Februari 2015

[smf_addin] Digest Number 3336[1 Attachment]

15 Messages

Digest #3336

Messages

Tue Feb 24, 2015 4:08 am (PST) . Posted by:

tzewei_79

I don't think I used an excel query. The warning message did not appear on my home desktop which is using excel 2010 but....I have problems displaying =RCHGetTableCell("http://dividata.com/stock/"&A2,1,"Dividend Increases:") where A2 is a ticker symbol. It keeps showing "Error" now. I have also tried using =RCHGetTableCell("http://dividata.com/stock/AEP,1,"Dividend Increases:") and the rsults is still the same.

I checked dividata and the link was ok on browser. Not sure what is happening.....



Attachment(s) from
1 of 1 File(s)

Tue Feb 24, 2015 4:32 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It looks like dividata.com has done something to their web pages to prevent
non-browsers from grabbing the data. No data is retrieved on an XMLHTTP
request.

On Tue, Feb 24, 2015 at 5:08 AM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I don't think I used an excel query. The warning message did not appear on
> my home desktop which is using excel 2010 but....I have problems
> displaying =RCHGetTableCell("http://dividata.com/stock/"&A2,1,"Dividend
> Increases:") where A2 is a ticker symbol. It keeps showing "Error" now. I
> have also tried using =RCHGetTableCell("http://dividata.com/stock/AEP,1,"Dividend
> Increases:") and the rsults is still the same.
>
> I checked dividata and the link was ok on browser. Not sure what is
> happening.....
>

Tue Feb 24, 2015 5:14 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You bet.

On Tue, Feb 24, 2015 at 6:01 AM, tzewei_79@yahoo.com.sg [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> ?? They can do that???
>

Tue Feb 24, 2015 8:03 am (PST) . Posted by:

tzewei_79

ok, next question may not be related to smf. Anyone has substitute for grabbing consecutive dividend increasing years and dividend years paid continuously?

Tue Feb 24, 2015 5:17 am (PST) . Posted by:

Dear Randy,


Is there a data element or another way to grab an ETF and/or CEF EXPENSE RATIO?


Thanks


Armando

Tue Feb 24, 2015 5:23 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not that I recall...there aren't a lot of elements defined for non-stock
items.

On Tue, Feb 24, 2015 at 6:17 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there a data element or another way to grab an ETF and/or CEF EXPENSE
> RATIO?
>
>

Tue Feb 24, 2015 6:05 am (PST) . Posted by:

Is there a way to grab that info from Morningstar or Reuters or
other site?

-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Feb 24, 2015 10:23 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ETF/CEF EXPENSE RATIO



Not that I recall...there aren't a lot of elements defined for
non-stock items.

On Tue, Feb 24, 2015 at 6:17 AM, armando@pipeline.com
<mailto:armando@pipeline.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:


Is there a data element or another way to grab an ETF and/or CEF
EXPENSE RATIO?







Tue Feb 24, 2015 6:28 am (PST) . Posted by:

hashky

Armando -

Here is an way to pull Expense Ratios for CEFs from cefconnect.com.

=RCHGetTableCell("http://www.cefconnect.com/Details/Summary.aspx?ticker="&$B6,1,"Annual Expense Ratios","Total&quot;)

B6 contains the ticker.

If you can't get it to work try:
Log into cefconnect.com with Internet Explorer.

You may need to be looking at the Daily Pricing and have the Ticker showing.

Ron

Tue Feb 24, 2015 6:56 am (PST) . Posted by:

Thanks Ron...
Anything for ETFs?

-----Original Message-----
From: "hashky@yahoo.com [smf_addin]"
Sent: Feb 24, 2015 11:28 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: ETF/CEF EXPENSE RATIO


Armando -

Here is an way to pull Expense Ratios for CEFs from
cefconnect.com.

=RCHGetTableCell("http://www.cefconnect.com/Details/Summary.aspx?\
ticker="&$B6,1,"Annual Expense Ratios","Total&quot;)

B6 contains the ticker.

If you can't get it to work try:
Log into cefconnect.com with Internet Explorer.

You may need to be looking at the Daily Pricing and have the
Ticker showing.

Ron



Tue Feb 24, 2015 7:10 am (PST) . Posted by:

"Randy Harmelink" rharmelink

You can try:

=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=SPY",1,"Expense Ratio")

But as I recall, some ETF's used different terminology for the expense
ratio, so it didn't always work.

On Tue, Feb 24, 2015 at 7:56 AM, armando@pipeline.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Anything for ETFs?
>

Tue Feb 24, 2015 7:21 am (PST) . Posted by:

Thanks...

-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Feb 24, 2015 12:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: ETF/CEF EXPENSE RATIO



You can try:

=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=SPY
<http://finance.yahoo.com/q/pr?s=SPY> ",1,"Expense Ratio")

But as I recall, some ETF's used different terminology for the
expense ratio, so it didn't always work.

On Tue, Feb 24, 2015 at 7:56 AM, armando@pipeline.com
<mailto:armando@pipeline.com> [smf_addin]
<smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> >
wrote:

Anything for ETFs?






Tue Feb 24, 2015 11:00 am (PST) . Posted by:

hedgefundit

Hello everyone and thank you for this plugin.


I have a list of roughly 200 stock symbols that I do a variety of analysis on. One of the things I am specifically looking for is an indication that a stock in currently trending up/down or even sideways(I trade options).


Beyond just getting a % change over X days I need to sort out the quality of the trend and ideally the start date of the trend. I realize that these things are extremely subjective, but any logically consistent methodology would be fine to start with.


Ideally I would love to see the following type of info; Start Date, Slope and Mean Squared error of the regression.


Does anyone know a site I can use this plug in to grab any data like this?


Thanks

Tue Feb 24, 2015 1:20 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

BarChart.com may have something of use to you. They cover a lot of
different possibilities:

http://www.barchart.com/cheatsheet.php?sym=MMM
http://www.barchart.com/technicals/stocks/MMM
http://www.barchart.com/opinions/stocks/MMM
http://www.barchart.com/opinions/stocks/MMM&view=detailed
http://www.barchart.com/snapopinion/stocks/MMM
http://www.barchart.com/performance/stocks/MMM

On Tue, Feb 24, 2015 at 12:00 PM, drobertson123@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Hello everyone and thank you for this plugin.
>
> I have a list of roughly 200 stock symbols that I do a variety of analysis
> on. One of the things I am specifically looking for is an indication that
> a stock in currently trending up/down or even sideways(I trade options).
>
> Beyond just getting a % change over X days I need to sort out the quality
> of the trend and ideally the start date of the trend. I realize that these
> things are extremely subjective, but any logically consistent methodology
> would be fine to start with.
>
> Ideally I would love to see the following type of info; Start Date, Slope
> and Mean Squared error of the regression.
>
> Does anyone know a site I can use this plug in to grab any data like this?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar