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.....
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.....
>
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:"
>
> 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???
>
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?
Dear Randy,
Is there a data element or another way to grab an ETF and/or CEF EXPENSE RATIO?
Thanks
Armando
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?
>
>
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?
>
>
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?
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")
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
Here is an way to pull Expense Ratios for CEFs from cefconnect.com.
=RCHGetTableCell("http://www.cefconnect.com/Details/Summary.aspx?ticker="&$B6,1,
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
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")
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
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,
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?
>
=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?
>
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?
-----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
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?
>
>
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:
Posting Komentar