[smf_addin] Digest Number 2049[2 Attachments]

EXCEL Stock Market Functions Add-in

Messages In This Digest (9 Messages)

1a.

Excel 2000 Name? Error From: flood87eaglecross2005

1b.

Re: Excel 2000 Name? Error From: Randy Harmelink

2.

Name? Error From: Steve Flood

3a.

Extracting Data From Yahoo From: bushpilote@yahoo.ca

3b.

Re: Extracting Data From Yahoo From: Mike McQuaid

3c.

Re: Extracting Data From Yahoo From: Mike McQuaid

3d.

Re: Extracting Data From Yahoo From: Mike McQuaid

3e.

Re: Extracting Data From Yahoo From: Randy Harmelink

4.

FCFE Free Cash Flow to Equity...where can I find this? From: investor952

View All Topics | Create New Topic

Messages

1a.

Excel 2000 Name? Error

Posted by: "flood87eaglecross2005" flood87eaglecross2005@yahoo.com   flood87eaglecross2005

Fri Dec 16, 2011 2:39 am (PST)

Hello,

I haven't had much luck getting a template to work. I'm using Excel 2000. Is that the problem?

I'll post some screen shots of the problem in the attachments page.

Thanks,
Steve.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

1b.

Re: Excel 2000 Name? Error

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 16, 2011 2:43 am (PST)

See the "Location Error" entry in the "Links" area of the group.

However, based on your attachments in the other message, you'll NEVER have
the links resolve automatically when you download workbooks from the files
area -- you pluralized the "SMF Add-in" part of the folder name.

On Fri, Dec 16, 2011 at 2:43 AM, flood87eaglecross2005 <
flood87eaglecross2005@yahoo.com> wrote:

>
> I haven't had much luck getting a template to work. I'm using Excel
> 2000. Is that the problem?
>
> I'll post some screen shots of the problem in the attachments page.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

2.

Name? Error

Posted by: "Steve Flood" flood87eaglecross2005@yahoo.com   flood87eaglecross2005

Fri Dec 16, 2011 2:41 am (PST)

[Attachment(s) from Steve Flood included below]

Hi,
 
  Final 2 Screen Shots.
 
Thanks,
Steve.

Attachment(s) from Steve Flood

2 of 2 File(s)

SMF Problems 3.rtf

SMF Problems 4.rtf

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

3a.

Extracting Data From Yahoo

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca   bushpilote

Fri Dec 16, 2011 5:00 am (PST)

Good morning Randy,
I'd appreciate your help on the following two issues:

1. Extracting Insider Transactions From Yahoo
I've been able to extract all of the information on the page except the net for institutional investors. I've tried all variarions of the this formula : =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&ticker,1,"Net Institutional Purchases",">Net Shares Purchased<br>(Sold)<",,,,,,,"--")with no success.

2. Company Name
I've been extracting a company's full name with =smfGetTagContent("http://finance.yahoo.com/q?s="&$B1,"h2",4,"class=","title")where B1 is the ticker symbol.However of late I need to keep changing the number 4 in the formula daily to get it to work. The number ranges from 1 to 4.

Thanks

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3b.

Re: Extracting Data From Yahoo

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri Dec 16, 2011 7:00 am (PST)

Randy can help on the Insiders info but for company name you can use:

=RCHGetElementNumber(Ticker,13862) (gets from MSN)
=RCHGetElementNumber(Ticker,13863) (gets from YahooKS)

There are probably other choices if you look through all the element
definitions - see your SMF add in folder.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of bushpilote@yahoo.ca
Sent: Friday, December 16, 2011 8:00 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Extracting Data From Yahoo

Good morning Randy,
I'd appreciate your help on the following two issues:

1. Extracting Insider Transactions From Yahoo
I've been able to extract all of the information on the page except the net
for institutional investors. I've tried all variarions of the this formula :
=RCHGetTableCell("http://finance.yahoo.com/q/it?s="&ticker,1,"Net
Institutional Purchases",">Net Shares Purchased<br>(Sold)<",,,,,,,"--")with
no success.

2. Company Name
I've been extracting a company's full name with
=smfGetTagContent("http://finance.yahoo.com/q?s="&$B1,"h2",4,"class=","title
")where B1 is the ticker symbol.However of late I need to keep changing the
number 4 in the formula daily to get it to work. The number ranges from 1 to
4.

Thanks

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3c.

Re: Extracting Data From Yahoo

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri Dec 16, 2011 7:08 am (PST)

Oh, I see in Yahoo's source there is an extra slash after <br - maybe that's
the problem?

Yahoo:

Net Shares Purchased<br/>(Sold)

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of bushpilote@yahoo.ca
Sent: Friday, December 16, 2011 8:00 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Extracting Data From Yahoo

Good morning Randy,
I'd appreciate your help on the following two issues:

1. Extracting Insider Transactions From Yahoo
I've been able to extract all of the information on the page except the net
for institutional investors. I've tried all variarions of the this formula :
=RCHGetTableCell("http://finance.yahoo.com/q/it?s="&ticker,1,"Net
Institutional Purchases",">Net Shares Purchased<br>(Sold)<",,,,,,,"--")with
no success.

2. Company Name
I've been extracting a company's full name with
=smfGetTagContent("http://finance.yahoo.com/q?s="&$B1,"h2",4,"class=","title
")where B1 is the ticker symbol.However of late I need to keep changing the
number 4 in the formula daily to get it to work. The number ranges from 1 to
4.

Thanks

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3d.

Re: Extracting Data From Yahoo

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Fri Dec 16, 2011 7:48 am (PST)

This works for me:

RCHGetTableCell("http://finance.yahoo.com/q/it?s=IBM",1,"Net
<http://finance.yahoo.com/q/it?s=IBM> Institutional Purchases","Net Shares
Purchased",)

I'm not sure what the trailing "--" is for either in your original, I don't
see that on the docs for that function.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of bushpilote@yahoo.ca
Sent: Friday, December 16, 2011 8:00 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Extracting Data From Yahoo

Good morning Randy,
I'd appreciate your help on the following two issues:

1. Extracting Insider Transactions From Yahoo
I've been able to extract all of the information on the page except the net
for institutional investors. I've tried all variarions of the this formula :
=RCHGetTableCell("http://finance.yahoo.com/q/it?s="&ticker,1,"Net
Institutional Purchases",">Net Shares Purchased<br>(Sold)<",,,,,,,"--")with
no success.

2. Company Name
I've been extracting a company's full name with
=smfGetTagContent("http://finance.yahoo.com/q?s="&$B1,"h2",4,"class=","title
")where B1 is the ticker symbol.However of late I need to keep changing the
number 4 in the formula daily to get it to work. The number ranges from 1 to
4.

Thanks

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3e.

Re: Extracting Data From Yahoo

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Dec 16, 2011 7:49 am (PST)

Try something like:

=RCHGetTableCell("http://finance.yahoo.com/q/it?s="&Ticker,1,">Net Shares
Purchased",">Net Shares Purchased",,,,,,"--")
=smfGetTagContent("http://finance.yahoo.com/q?s=
"&Ticker,"h2",1,"class=""title""")

On Fri, Dec 16, 2011 at 6:00 AM, <bushpilote@yahoo.ca> wrote:

> Good morning Randy,
> I'd appreciate your help on the following two issues:
>
> 1. Extracting Insider Transactions From Yahoo
> I've been able to extract all of the information on the page except the
> net for institutional investors. I've tried all variarions of the this
> formula : =RCHGetTableCell("http://finance.yahoo.com/q/it?s="&ticker,1,"Net
> Institutional Purchases",">Net Shares Purchased<br>(Sold)<",,,,,,,"--")with
> no success.
>
> 2. Company Name
> I've been extracting a company's full name with =smfGetTagContent("
> http://finance.yahoo.com/q?s="&$B1,"h2",4,"class=","title")where B1 is
> the ticker symbol.However of late I need to keep changing the number 4 in
> the formula daily to get it to work. The number ranges from 1 to 4.
>
> Thanks
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

4.

FCFE Free Cash Flow to Equity...where can I find this?

Posted by: "investor952" investor952@yahoo.com   investor952

Fri Dec 16, 2011 11:58 pm (PST)

Can someone point me to where I may retrieve this statistic for a stock?...and/or how I may pull down the data necessary to calculate it (Cash flow from operations - capital expenditures + Net borrowings ) ?
I recently read in a newsletter that I get that this a very useful statistic to use when evaluation dividend paying stocks. Thanks.

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)

Recent Activity

•  74
  New Members

Visit Your Group

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe