Jumat, 25 Oktober 2013

[smf_addin] Digest Number 2826

13 New Messages

Digest #2826
3a
2016 LEAP options by joshi_mandar
3b
Re: 2016 LEAP options by "Randy Harmelink" rharmelink
4b
5a
Re: Mutual Fund Quotes by stumpy_chris
5b
Re: Mutual Fund Quotes by "Randy Harmelink" rharmelink
6b
Re: Formula to get Earnings Announcement Date by "Randy Harmelink" rharmelink

Messages

Thu Oct 24, 2013 6:51 am (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I am having a problem creating VBA code to parse out the number of splits or
enter a 0 if the message has "no" instead of a number.

Can anyone supply me the VBA code to parse these messages?

My VBA skills are limited to simple task.
The cell I need to parse contains this formula in cell C1 thru C3 referring
to the symbol in cells A1 thru A3
And returns the text shown below.

=smfGetTagContent("http://getsplithistory.com/"&A1,"div",0,"splits-text";)



PCAR

<b>PACCAR Inc</b> has had <b>6</b> splits.

IBM

<b>International Business Machines Corp.</b> has had <b>7</b> splits.

AGNC

<b>American Capital Agency Corp.</b> has had no splits since its stock began
trading publicly.


Thanks,

Kermit

Thu Oct 24, 2013 9:32 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I would just use this formula:

=IFERROR(smfstrExtr(smfGetTagContent("http://getsplithistory.com/"&A1,"div",0,"splits-text";),"had
<b>","<")/1,"no")

On Thu, Oct 24, 2013 at 6:51 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I am having a problem creating VBA code to parse out the number of splits
> or enter a 0 if the message has "no" instead of a number. ****
>
> ** **
>
> Can anyone supply me the VBA code to parse these messages?****
>
> ** **
>
> My VBA skills are limited to simple task. ****
>
> The cell I need to parse contains this formula in cell C1 thru C3 referring
> to the symbol in cells A1 thru A3****
>
> And returns the text shown below. ****
>
> ** **
>
> =smfGetTagContent("http://getsplithistory.com/"&A1,"div",0,"splits-text";)*
> ***
>
> ** **
>
> ** **
>
> PCAR****
>
> ****
>
> <b>PACCAR Inc</b> has had <b>6</b> splits.****
>
> IBM****
>
> ****
>
> <b>International Business Machines Corp.</b> has had <b>7</b> splits.****
>
> AGNC****
>
> ****
>
> <b>American Capital Agency Corp.</b> has had no splits since its stock
> began trading publicly.****
>
> ** **
>
>
>

Thu Oct 24, 2013 6:05 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Thanks, Randy that works. Anyway to return zero or 1 value if no splits?

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Thursday, October 24, 2013 12:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Parsing returned text to retrieve either number of splits or NO


I would just use this formula:

=IFERROR(smfstrExtr(smfGetTagContent("http://getsplithistory.com/"&A1,"div",0,"splits-text";),"had <b>","<")/1,"no")

On Thu, Oct 24, 2013 at 6:51 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

I am having a problem creating VBA code to parse out the number of splits or enter a 0 if the message has "no" instead of a number.

Can anyone supply me the VBA code to parse these messages?

My VBA skills are limited to simple task.
The cell I need to parse contains this formula in cell C1 thru C3 referring to the symbol in cells A1 thru A3
And returns the text shown below.

=smfGetTagContent("http://getsplithistory.com/"&A1,"div",0,"splits-text";)



PCAR

<b>PACCAR Inc</b> has had <b>6</b> splits.

IBM

<b>International Business Machines Corp.</b> has had <b>7</b> splits.

AGNC

<b>American Capital Agency Corp.</b> has had no splits since its stock began trading publicly.




Thu Oct 24, 2013 6:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Then just change the second parameter of the IFERROR() function. It can be
whatever value you want.

On Thu, Oct 24, 2013 at 6:05 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> Thanks, Randy that works. Anyway to return zero or 1 value if no splits?
> ****
>
> ** **
>
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] *On
> Behalf Of *Randy Harmelink
> *Sent:* Thursday, October 24, 2013 12:32 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* Re: [smf_addin] Parsing returned text to retrieve either
> number of splits or NO****
>
> **
> ******
>
> I would just use this formula:
>
> =IFERROR(smfstrExtr(smfGetTagContent("http://getsplithistory.com/"&A1,"div",0,"splits-text";),"had
> <b>","<")/1,"no")****
>
>
>

Thu Oct 24, 2013 7:49 am (PDT) . Posted by:

dmatu2000

Has anyone found any accuracy problems with the AdvFn data? I am questioning their historical financials when comparing to what is filed on Edgar. While I don't think it is the case, I suppose there could have been financial restatements but it seems highly unlikely. For example, I found some in-accuracies with JNJ.

Thu Oct 24, 2013 9:13 am (PDT) . Posted by:

joshi_mandar

Randy - I am trying to get quotes for 2016 LEAPs using the tool. For example: smfGetOptionQuotes("aapl Jan 16 330 call","l",0,"Y"). It's throwing an error. I tried multiple companies. Same error for 2016 LEAPs. Same formula works well for 2015 LEAP options. Any idea?

Thu Oct 24, 2013 9:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I ran into this earlier. For some reason, the Jan 2016 Leaps are not using
a standard monthly expiration date. So you need to specify the exact date.
For example, this does work:

=smfGetOptionQuotes("aapl 1/15 16 330 call","l",0,"Y")

Usually, the ticker symbol contains the Saturday date. These have the
Friday date. I don't know why.

On Thu, Oct 24, 2013 at 9:13 AM, <joshi_mandar@hotmail.com> wrote:

>
> Randy - I am trying to get quotes for 2016 LEAPs using the tool. For
> example: smfGetOptionQuotes("aapl Jan 16 330 call","l",0,"Y"). It's
> throwing an error. I tried multiple companies. Same error for 2016 LEAPs.
> Same formula works well for 2015 LEAP options. Any idea?
>

Thu Oct 24, 2013 9:24 am (PDT) . Posted by:

lezm001

I've come across a situation where I have a large list of ticker symbols that I would like to pull data using the RCHgetElementNumber function. Some ticker symbols work great and others just get errors. An example is SBFAX. I can go to morningstar and see data on this mutual fund. If I try to pull data from morningstar using the 4811 - 4923 elements, I only get errors for this ticker symbol. Any ideas why some ticker symbols work and others do not?

Thu Oct 24, 2013 9:46 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

SBFAX is working fine here. The problem may be your "large list". The
add-in is intended for ad hoc usage, not for pulling data for databases. I
don't want people to overburden the free data sources and give them an
incentive to make the data unavailable to the add-in.

But, as written, the add-in can only pull in data from 1000 web pages per
"session". That's because it saves each web page before extracting data,
and I only set up 1000 slots for storing web pages.

On Thu, Oct 24, 2013 at 9:24 AM, <dlezman@steelcase.com> wrote:

>
> I've come across a situation where I have a large list of ticker symbols
> that I would like to pull data using the RCHgetElementNumber function.
> Some ticker symbols work great and others just get errors. An example is
> SBFAX. I can go to morningstar and see data on this mutual fund. If I try
> to pull data from morningstar using the 4811 - 4923 elements, I only get
> errors for this ticker symbol. Any ideas why some ticker symbols work and
> others do not?
>

Thu Oct 24, 2013 4:43 pm (PDT) . Posted by:

stumpy_chris


Here you go. This is the URL for Fidelity Cdn Asset Allocation from Globe Investor. Thanks.


http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=60075&companyName=Fidelity http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=60075&companyName=Fidelity




---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:

Sample URLs please.


On Wed, Oct 23, 2013 at 5:48 AM, <cschwartz@... mailto:cschwartz@...> wrote: Wondering of there was anyway to pull Mutual Fund Day end quotes from Globe Investor.





On Wed, Oct 23, 2013 at 5:57 AM, <cschwartz@... mailto:cschwartz@...> wrote:
Sorry and better yet - can you pull fund prices from Morningstar.









Thu Oct 24, 2013 4:57 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can get the fund price from the URL with:

=smfConvertData(smfstrExtr(smfGetTagContent("
http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=60075","p",-1,"Fund
price:"),":","("))

On Thu, Oct 24, 2013 at 4:43 PM, <cschwartz@nf.sympatico.ca> wrote:

> Here you go. This is the URL for Fidelity Cdn Asset Allocation from
> Globe Investor. Thanks.
>
>
> http://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=60075&companyName=Fidelity
>

Thu Oct 24, 2013 8:12 pm (PDT) . Posted by:

"Craig" c1sander

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 ("s" is the first letter
of the ticker.) For IBM you would use
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/earncal/"&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/researc
h/earncal/"&LEFT(A1,1)&"/"&A1&";.html",1,"Week"))-1),"--")

Thu Oct 24, 2013 9:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo posts it by ticker on their main quotes page. So try:

=DATEVALUE(RCHGetTableCell("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="&B4,1,">Earnings")

Or from Zacks:

=DATEVALUE(RCHGetTableCell("http://www.zacks.com/stock/quote/"&B5,1,"Next
Earnings Report Date"))

On Thu, Oct 24, 2013 at 8:11 PM, Craig <craig.sander@comcast.net> 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 ("s" is the first
> letter of the ticker.) For IBM you would use
> 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/earncal/"&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/
> "&LEFT(A1,1)&"/"&A1&";.html",1,"Week"))-1),"--")
>
Diposting oleh EXCEL FEED LEARNING di 00.47

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)