10 New Messages
Digest #2829
Messages
Sun Oct 27, 2013 6:57 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I usually try any formulas you post. They almost always work and I learn a lot doing it.
I tried the 3 listed in the posting below and the Finbiz does not pick up the correct information.
I built a spreadsheet and have attached it. Maybe you can tell me where I went wrong.
It looks like Finbiz is returning the P/E value for any symbol
Yahoo
Finbiz
Zacks
IBM
<http://finance.yahoo.com/q?s=> 1/21/2014
<http://finviz.com/quote.ashx?t=> 12.27
<http://www.zacks.com/stock/quote/> 1/28/2014
I am ,also, amazed that Yahoo and Zacks does not agree on many stocks' earning dates.
Thanks,
Kermit
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of c1sander
Sent: Saturday, October 26, 2013 2:16 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Formula to get Earnings Announcement Date
Randy,
I'm glad I asked. Thanks for the reply.
Craig
--- In <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com, Randy Harmelink < <mailto:rharmelink@...> rharmelink@...> wrote:
>
> Yahoo posts it by ticker on their main quotes page. So try:
>
> =DATEVALUE(RCHGetTableCell(" <http://finance.yahoo.com/q?s=> http://finance.yahoo.com/q?s="&B3,1,"Next
> Earnings Date"))
>
> Also, FinViz (check the LINKS area of the group to see how you can get
> multiple tickers in one Internet access):
>
> =RCHGetTableCell(" <http://finviz.com/quote.ashx?t=> http://finviz.com/quote.ashx?t="&B4,1,">Earnings")
>
> Or from Zacks:
>
> =DATEVALUE(RCHGetTableCell(" <http://www.zacks.com/stock/quote/> http://www.zacks.com/stock/quote/"&B5,1,"N
> ext
> Earnings Report Date"))
>
> On Thu, Oct 24, 2013 at 8:11 PM, Craig < <mailto:craig.sander@...> craig.sander@...> wrote:
>
> >
> > There may be better ways to do this, but I found a way to look up
> > the date of earnings announcements for a given ticker. The ticker
> > should be entered in cell A1. The result is in text format, but
> > with a little more work can be converted to date format.****
> >
> > ** **
> >
> > As an example, for Starbucks, the URL is
> > <http://biz.yahoo.com/research/earncal/s/sbux.html> http://biz.yahoo.com/research/earncal/s/sbux.html (“s†is the first
> > letter of the ticker.) For IBM you would use
> > <http://biz.yahoo.com/research/earncal/i/ibm.html> http://biz.yahoo.com/research/earncal/i/ibm.html .****
> >
> > ** **
> >
> > I’d be interested in other ways or other sites that can be used to
> > get this data.****
> >
> > ** **
> >
> > Craig****
> >
> > -----------------****
> >
> > =IFERROR(RIGHT(RCHGetTableCell("http://biz.yahoo.com/research/earnca
> > l/"&LEFT(A1,1)&"/"&A1&";.html",1,"Week"),
> > LEN(RCHGetTableCell("http://biz.yahoo.com/research/earncal/
> > "&LEFT(A1,1)&"/"&A1&";.html",1,"Week"))-FIND(",",RCHGetTableCell("
> > <http://biz.yahoo.com/research/earncal/> http://biz.yahoo.com/research/earncal/
> > "&LEFT(A1,1)&"/"&A1&";.html",1,"Week"))-1),"--")
> >
>
------------------------------------
Yahoo! Groups Links
I tried the 3 listed in the posting below and the Finbiz does not pick up the correct information.
I built a spreadsheet and have attached it. Maybe you can tell me where I went wrong.
It looks like Finbiz is returning the P/E value for any symbol
Yahoo
Finbiz
Zacks
IBM
<http://finance.
<http://finviz.
<http://www.zacks.
I am ,also, amazed that Yahoo and Zacks does not agree on many stocks' earning dates.
Thanks,
Kermit
-----Original Message-----
From: smf_addin@yahoogrou
Sent: Saturday, October 26, 2013 2:16 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Formula to get Earnings Announcement Date
Randy,
I'm glad I asked. Thanks for the reply.
Craig
--- In <mailto:smf_addin@yahoogrou
>
> Yahoo posts it by ticker on their main quotes page. So try:
>
> =DATEVALUE(RCHGetTa
> Earnings Date"))
>
> Also, FinViz (check the LINKS area of the group to see how you can get
> multiple tickers in one Internet access):
>
> =RCHGetTableCell(
>
> Or from Zacks:
>
> =DATEVALUE(RCHGetTa
> ext
> Earnings Report Date"))
>
> On Thu, Oct 24, 2013 at 8:11 PM, Craig < <mailto:craig.
>
> >
> > There may be better ways to do this, but I found a way to look up
> > the date of earnings announcements for a given ticker. The ticker
> > should be entered in cell A1. The result is in text format, but
> > with a little more work can be converted to date format.****
> >
> > ** **
> >
> > As an example, for Starbucks, the URL is
> > <http://biz.yahoo.
> > letter of the ticker.) For IBM you would use
> > <http://biz.yahoo.
> >
> > ** **
> >
> > I’d be interested in other ways or other sites that can be used to
> > get this data.****
> >
> > ** **
> >
> > Craig****
> >
> > ------------
> >
> > =IFERROR(RIGHT(
> > l/"&LEFT(
> > LEN(RCHGetTableCell
> > "&LEFT(
> > <http://biz.yahoo.
> > "&LEFT(
> >
>
------------
Yahoo! Groups Links
Attachments with this message:
1 of 1 File(s)
Sun Oct 27, 2013 8:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
When I try the formula for FinViz, I get:
Oct 16 AMC
And that's what I see on the web page. So obviously quite out of date and
not useful. It does look like you are getting the P/E ratio, but I have no
idea why.
On Sun, Oct 27, 2013 at 6:56 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:
> Randy, I usually try any formulas you post. They almost always work and
> I learn a lot doing it.
>
> tried the 3 listed in the posting below and the Finbiz does not pick up
> the correct information.
>
> I built a spreadsheet and have attached it. Maybe you can tell me where I
> went wrong.
>
> It looks like Finbiz is returning the P/E value for any symbol
>
>
>
> Yahoo
>
> Finbiz
>
> Zacks
>
> IBM
>
> *1/21/2014 <http://finance.yahoo.com/q?s=>*
>
> *12.27 <http://finviz.com/quote.ashx?t=>*
>
> *1/28/2014 <http://www.zacks.com/stock/quote/>*
>
>
>
> I am ,also, amazed that Yahoo and Zacks does not agree on many stocks'
> earning dates.
>
Oct 16 AMC
And that's what I see on the web page. So obviously quite out of date and
not useful. It does look like you are getting the P/E ratio, but I have no
idea why.
On Sun, Oct 27, 2013 at 6:56 AM, Kermit W. Prather
<kermitp@tampabay.
> Randy, I usually try any formulas you post. They almost always work and
> I learn a lot doing it.
>
> tried the 3 listed in the posting below and the Finbiz does not pick up
> the correct information.
>
> I built a spreadsheet and have attached it. Maybe you can tell me where I
> went wrong.
>
> It looks like Finbiz is returning the P/E value for any symbol
>
>
>
> Yahoo
>
> Finbiz
>
> Zacks
>
> IBM
>
> *1/21/2014 <http://finance.
>
> *12.27 <http://finviz.
>
> *1/28/2014 <http://www.zacks.
>
>
>
> I am ,also, amazed that Yahoo and Zacks does not agree on many stocks'
> earning dates.
>
Sun Oct 27, 2013 8:02 am (PDT) . Posted by:
limolyte
Hello,
I'm looking for some advice regarding my charting using Yahoo domestic/international historical stock data. The issue for me is date uniformity with holiday schedules for the various exchanges.
For example the Toronto Exchange (.TO) is on holiday 8/5/13 and 10/14/13 vs. US exchanges.
Let's say I want to build a historical pricing chart (Excel) with data between 8/1/13 through 10/26/13 with two stocks. One traded on the Toronto Exchange and one Domestic US stock both in the same sector.
When I gather the Yahoo historical data for the Toronto exchange I have two less entries vs. the US exchange (for 8/5/13 and 10/14/13).
Has anyone automated (via VBA) a mechanism to add the dates back in with the previous Adj Close data?
Thank you
I'm looking for some advice regarding my charting using Yahoo domestic/internatio
For example the Toronto Exchange (.TO) is on holiday 8/5/13 and 10/14/13 vs. US exchanges.
Let's say I want to build a historical pricing chart (Excel) with data between 8/1/13 through 10/26/13 with two stocks. One traded on the Toronto Exchange and one Domestic US stock both in the same sector.
When I gather the Yahoo historical data for the Toronto exchange I have two less entries vs. the US exchange (for 8/5/13 and 10/14/13).
Has anyone automated (via VBA) a mechanism to add the dates back in with the previous Adj Close data?
Thank you
Sun Oct 27, 2013 8:30 am (PDT) . Posted by:
"Craig" c1sander
Does anyone have suggestions for a site that can provide current Implied
Volatility for a given ticker or list of tickers?
Thanks,
Craig
Volatility for a given ticker or list of tickers?
Thanks,
Craig
Sun Oct 27, 2013 8:43 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Is this what you want?
=smfGet888OptionQuote("IBM",,,,"ivicc")
Documentation for the function is in the "Works in Progress" folder. And
you do need to get a quote manually from the website first (
www.888options.com) using either the EXCEL Web Dialog or IE, so that the
proper security cookie is created.
On Sun, Oct 27, 2013 at 8:30 AM, Craig <craig.sander@comcast.net> wrote:
>
> Does anyone have suggestions for a site that can provide current Implied
> Volatility for a given ticker or list of tickers?
>
=smfGet888OptionQuo
Documentation for the function is in the "Works in Progress" folder. And
you do need to get a quote manually from the website first (
www.888options.
proper security cookie is created.
On Sun, Oct 27, 2013 at 8:30 AM, Craig <craig.sander@
>
> Does anyone have suggestions for a site that can provide current Implied
> Volatility for a given ticker or list of tickers?
>
Sun Oct 27, 2013 9:10 am (PDT) . Posted by:
"PeteA" option2z
RE: differently constructed tickers.
Maybe more.if you use ADR's for instance: RDS-A (from memory) Royal Dutch
Shell. I convert to RDSA for IB every time I run across it. Don't see a
really good way to do an algorithm as there is no standard way to handle
these oddballs.
Pete A
Maybe more.if you use ADR's for instance: RDS-A (from memory) Royal Dutch
Shell. I convert to RDSA for IB every time I run across it. Don't see a
really good way to do an algorithm as there is no standard way to handle
these oddballs.
Pete A
Sun Oct 27, 2013 10:25 am (PDT) . Posted by:
richardvankasteel
Dear Randy, I try the new (latest add-in, Version 2.1.2013.10.17 but get errors with Element 10726. It looks like AdvFN makes the trouble. IS there a reason why AdvFN does not work anymore
Tx.
Tx.
Sun Oct 27, 2013 10:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Element 10726 is working fine here. Do you use a different prefix? Did you
exit EXCEL before updating the add-in files?
AdvFN stopped working because they changed how their web pages work. And it
took them nearly 2 months to fix the errors they put in. So I had to modify
the code for the changes. And there are also a few people saying the data
doesn't look correct.
It looks like AdvFN will be changing again soon. When asked about late
updates, they point people to the new beta format web pages they have links
for on their pages.
On Sun, Oct 27, 2013 at 9:00 AM, <richardvankasteel@yahoo.com> wrote:
>
> Dear Randy, I try the new (latest add-in, Version 2.1.2013.10.17 but get
> errors with Element 10726. It looks like AdvFN makes the trouble. IS there
> a reason why AdvFN does not work anymore
>
exit EXCEL before updating the add-in files?
AdvFN stopped working because they changed how their web pages work. And it
took them nearly 2 months to fix the errors they put in. So I had to modify
the code for the changes. And there are also a few people saying the data
doesn't look correct.
It looks like AdvFN will be changing again soon. When asked about late
updates, they point people to the new beta format web pages they have links
for on their pages.
On Sun, Oct 27, 2013 at 9:00 AM, <richardvankasteel@
>
> Dear Randy, I try the new (latest add-in, Version 2.1.2013.10.
> errors with Element 10726. It looks like AdvFN makes the trouble. IS there
> a reason why AdvFN does not work anymore
>
Sun Oct 27, 2013 12:06 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
When I retrieve the elements from Stockscores.
811, 812, and 813 they return error on all symbols I tried.
The example below uses IBM as the symbol. All other Stockscores elements
work okay.
811
StockScores
Price Indicator -- 100 Day Trend
Error
812
StockScores
Price Indicator -- 15 Day Trend
Error
813
StockScores
Price Indicator -- 45 Day Trend
Error
* I Copied the 3 elements in question from the webpage they show
the bearish move
Moving Average Indictors
15 Day Trend
Bearishbearish
45 Day Trend
Bearishbearish
100 Day Trend
Bearishbearish
Mid Term Moving Average Crossover
NONE
Long Term Moving Average Crossover
NONE
Kermit
Sun Oct 27, 2013 12:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They work fine here. You reported this back in March. When we investigated,
it turned out your web pages contained different content than mine. I don't
know how to handle such a situation in an element definition.
See:
http://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/21724
On Sun, Oct 27, 2013 at 12:06 PM, Kermit W. Prather <kermitp@tampabay.rr.com
> wrote:
> ** **
>
> When I retrieve the elements from Stockscores.com all seem to work except
> 811, 812, and 813 they return error on all symbols I tried. ****
>
> ** **
>
> The example below uses IBM as the symbol. All other Stockscores elements
> work okay. ****
>
> ** **
>
> ** **
>
> 811****
>
> StockScores****
>
> Price Indicator -- 100 Day Trend****
>
> Error****
>
> 812****
>
> StockScores****
>
> Price Indicator -- 15 Day Trend****
>
> Error****
>
> 813****
>
> StockScores****
>
> Price Indicator -- 45 Day Trend****
>
> Error****
>
> ** **
>
> ** **
>
> **[image: *] ** I Copied the 3 elements in question from the
> webpage they show the bearish move****
>
> ** **
>
> *Moving Average Indictors *
>
> 15 Day Trend****
>
> [image: Bearish]bearish****
>
> 45 Day Trend ****
>
> [image: Bearish]bearish****
>
> 100 Day Trend****
>
> [image: Bearish]bearish****
>
> Mid Term Moving Average Crossover****
>
> NONE****
>
> Long Term Moving Average Crossover****
>
> NONE****
>
> ** **
>
> ** **
>
> Kermit
>
it turned out your web pages contained different content than mine. I don't
know how to handle such a situation in an element definition.
See:
http://groups.
On Sun, Oct 27, 2013 at 12:06 PM, Kermit W. Prather <kermitp@tampabay.
> wrote:
> ** **
>
> When I retrieve the elements from Stockscores.
> 811, 812, and 813 they return error on all symbols I tried. ****
>
> ** **
>
> The example below uses IBM as the symbol. All other Stockscores elements
> work okay. ****
>
> ** **
>
> ** **
>
> 811****
>
> StockScores*
>
> Price Indicator -- 100 Day Trend****
>
> Error****
>
> 812****
>
> StockScores*
>
> Price Indicator -- 15 Day Trend****
>
> Error****
>
> 813****
>
> StockScores*
>
> Price Indicator -- 45 Day Trend****
>
> Error****
>
> ** **
>
> ** **
>
> **[image: *] ** I Copied the 3 elements in question from the
> webpage they show the bearish move****
>
> ** **
>
> *Moving Average Indictors *
>
> 15 Day Trend****
>
> [image: Bearish]bearish*
>
> 45 Day Trend ****
>
> [image: Bearish]bearish*
>
> 100 Day Trend****
>
> [image: Bearish]bearish*
>
> Mid Term Moving Average Crossover***
>
> NONE****
>
> Long Term Moving Average Crossover***
>
> NONE****
>
> ** **
>
> ** **
>
> Kermit
>
Tidak ada komentar:
Posting Komentar