[smf_addin] Digest Number 2222

EXCEL Stock Market Functions Add-in

Messages In This Digest (25 Messages)

1a.

Using smf on a mac From: red_rackam

1b.

Re: Using smf on a mac From: Randy Harmelink

2a.

ADVFN Financial Statements From: rebalance85

2b.

Re: ADVFN Financial Statements From: Randy Harmelink

2c.

Re: ADVFN Financial Statements From: Rebalance

2d.

Re: ADVFN Financial Statements From: Randy Harmelink

2e.

Re: ADVFN Financial Statements From: Randy H

2f.

Re: ADVFN Financial Statements From: rebalance85

2g.

Re: ADVFN Financial Statements From: Randy Harmelink

2h.

Re: ADVFN Financial Statements From: rebalance85

2i.

Re: ADVFN Financial Statements From: Randy Harmelink

2j.

Re: ADVFN Financial Statements From: rebalance85

2k.

Re: ADVFN Financial Statements From: Randy Harmelink

2l.

Re: ADVFN Financial Statements From: rebalance85

3a.

Re: What does #value! response mean when using RCHGetElementNumber f From: MikeM

4a.

AdvFN Annual Reports From: rebalance85

4b.

Re: AdvFN Annual Reports From: Randy Harmelink

5a.

RCHGetYahooHistory() Dividend History From: confederate_yankee1965

5b.

Re: RCHGetYahooHistory() Dividend History From: Randy Harmelink

5c.

Re: RCHGetYahooHistory() Dividend History From: confederate_yankee1965

6a.

RCHGetElementNumber Errors From: curt.brandt@ymail.com

6b.

Re: RCHGetElementNumber Errors From: Randy Harmelink

7a.

Sorting data From: confederate_yankee1965

7b.

Re: Sorting data From: Randy Harmelink

8a.

Re: NASDAQ Financial Statements From: Randy H

View All Topics | Create New Topic

Messages

1a.

Using smf on a mac

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

Wed May 23, 2012 1:51 am (PDT)

Hi,

Has anyone ever tried this on a mac ? I am getting an error stating - can't find project or library

This is what the window looks like -

Microsoft Office 14.0 Object libray
MISSING: Microsoft Internet Controls
MISSING: Microsoft XML, v3.0
MISSING: Microsoft HTML Object Library

Back to top

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

1b.

Re: Using smf on a mac

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

Wed May 23, 2012 2:01 am (PDT)

As noted on the front page of the group, the add-in is not intended for
Macs. I know nothing about Macs.

It requires Windows DLL libraries, the ones you mention below.

Some Mac users have been able to run the add-in in a simulated Windows
environment.

On Wed, May 23, 2012 at 1:45 AM, red_rackam <red_rackam@yahoo.com> wrote:

>
> Has anyone ever tried this on a mac ? I am getting an error stating -
> can't find project or library
>
> This is what the window looks like -
>
> Microsoft Office 14.0 Object libray
> MISSING: Microsoft Internet Controls
> MISSING: Microsoft XML, v3.0
> MISSING: Microsoft HTML Object Library
>

Back to top

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

2a.

ADVFN Financial Statements

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

Wed May 23, 2012 1:51 am (PDT)

Hi, I am new to this group.
When I try to use the ADVFN functions, found out that the www.advfn.com change to cn.advfn.com, my location in China.
Please tell me how to make the correct it.

Thank you very much.

Back to top

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

2b.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 2:01 am (PDT)

You need to change this VBA code:

Const kAdvFNPrefix = "www"

On Wed, May 23, 2012 at 1:16 AM, rebalance85 <rebalance85@yahoo.com> wrote:

> Hi, I am new to this group.
> When I try to use the ADVFN functions, found out that the www.advfn.comchange to
> cn.advfn.com, my location in China.
> Please tell me how to make the correct it.
>
> Thank you very much.
>

Back to top

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

2c.

Re: ADVFN Financial Statements

Posted by: "Rebalance" rebalance85@yahoo.com   rebalance85

Wed May 23, 2012 4:19 am (PDT)

Thanks a lot.
Could you give me a link to download the file? I just try some, and could not find the VBA code.

在 2012-5-23，17:01，Randy Harmelink <rharmelink@gmail.com> 写道：

> You need to change this VBA code:
>
> Const kAdvFNPrefix = "www"
>
>
> On Wed, May 23, 2012 at 1:16 AM, rebalance85 <rebalance85@yahoo.com> wrote:
> Hi, I am new to this group.
> When I try to use the ADVFN functions, found out that the www.advfn.com change to cn.advfn.com, my location in China.
> Please tell me how to make the correct it.
>
> Thank you very much.
>
>
>
>
>
>
>

Back to top

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

2d.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 10:43 am (PDT)

You've already got it installed.

Alt+F11 to open up the VBA environment. Go to the add-in project and search
for the kAdvFNPrefix string.

On Wed, May 23, 2012 at 4:19 AM, Rebalance <rebalance85@yahoo.com> wrote:

> Could you give me a link to download the file? I just try some, and could
> not find the VBA code.
>
> 在 2012-5-23，17:01，Randy Harmelink <rharmelink@gmail.com> 写道：
>
> You need to change this VBA code:
>
> Const kAdvFNPrefix = "www"
>
>

Back to top

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

2e.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 11:02 am (PDT)

If you use the beta version of the add-in from the "Works in Progress"
folder, you don't need to mess with the VBA code. Instead, you can just
create a file in the same folder as add-in, called
"smf-AdvFN-Prefix.txt" -- all the file should contain is the two
letters "cn". You can create the file with notepad.

That's something I added to the beta version of the add-in, so people
that need a different AdvFN prefix won't need to change the VBA code
every time a new version of the add-in comes out.

--- In smf_addin@yahoogroups.com, Rebalance <rebalance85@...> wrote:
> Could you give me a link to download the file? I just try some, and
could not find the VBA code.
>

Back to top

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

2f.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 7:42 pm (PDT)

Many thanks Randy.
I creat the "smf-AdvFN-Prefix.txt", and the content is "cn ", is it correct? Or I should put "cn" into all the txt files in the folder?
I try the RCHGetElementNumber-Template-AdvFN-Financial-Statements, all the cell are errors. Where is the mistake?
I missed something, but I couldn't find by myself.

Thaks again for your patience.

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> If you use the beta version of the add-in from the "Works in Progress"
> folder, you don't need to mess with the VBA code. Instead, you can just
> create a file in the same folder as add-in, called
> "smf-AdvFN-Prefix.txt" -- all the file should contain is the two
> letters "cn". You can create the file with notepad.
>
> That's something I added to the beta version of the add-in, so people
> that need a different AdvFN prefix won't need to change the VBA code
> every time a new version of the add-in comes out.
>
> --- In smf_addin@yahoogroups.com, Rebalance <rebalance85@> wrote:
> > Could you give me a link to download the file? I just try some, and
> could not find the VBA code.
> >
>

Back to top

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

2g.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 7:50 pm (PDT)

On Wed, May 23, 2012 at 7:42 PM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> I creat the "smf-AdvFN-Prefix.txt", and the content is "cn ", is it
> correct? Or I should put "cn" into all the txt files in the folder?
>

Just that one file. No blank after "cn". Just two characters.

I try the RCHGetElementNumber-Template-AdvFN-Financial-Statements, all the
> cell are errors. Where is the mistake?
> I missed something, but I couldn't find by myself.
>

Did you exit and re-enter EXCEL? The prefix is only loaded once.

Back to top

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

2h.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 8:06 pm (PDT)

When I open the VBA,
The first line is:
Const kAdvFNPrefix = "www"
Than I find another kAdvFNPrefix , there are only two items.
I should use "cn" to replace the "www", am right?

Thak you very much.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You've already got it installed.
>
> Alt+F11 to open up the VBA environment. Go to the add-in project and search
> for the kAdvFNPrefix string.
>
> On Wed, May 23, 2012 at 4:19 AM, Rebalance <rebalance85@...> wrote:
>
> > Could you give me a link to download the file? I just try some, and could
> > not find the VBA code.
> >
> > åœ&#65533; 2012-5-23ï¼&#65533;17:01，Randy Harmelink <rharmelink@...> 写é"ï¼&#65533;
> >
> > You need to change this VBA code:
> >
> > Const kAdvFNPrefix = "www"
> >
> >
>

Back to top

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

2i.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 8:08 pm (PDT)

Yes

On Wed, May 23, 2012 at 8:06 PM, rebalance85 <rebalance85@yahoo.com> wrote:

> When I open the VBA,
> The first line is:
> Const kAdvFNPrefix = "www"
> Than I find another kAdvFNPrefix , there are only two items.
> I should use "cn" to replace the "www", am right?
>

Back to top

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

2j.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 8:12 pm (PDT)

1.cn or "cn"? Which one is correct?
2.I make the file first, then I open the excel and load the add-in.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> On Wed, May 23, 2012 at 7:42 PM, rebalance85 <rebalance85@...> wrote:
>
> >
> > I creat the "smf-AdvFN-Prefix.txt", and the content is "cn ", is it
> > correct? Or I should put "cn" into all the txt files in the folder?
> >
>
> Just that one file. No blank after "cn". Just two characters.
>
> I try the RCHGetElementNumber-Template-AdvFN-Financial-Statements, all the
> > cell are errors. Where is the mistake?
> > I missed something, but I couldn't find by myself.
> >
>
> Did you exit and re-enter EXCEL? The prefix is only loaded once.
>

Back to top

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

2k.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 8:15 pm (PDT)

Just TWO characters.

On Wed, May 23, 2012 at 8:12 PM, rebalance85 <rebalance85@yahoo.com> wrote:

> 1.cn or "cn"? Which one is correct?
> 2.I make the file first, then I open the excel and load the add-in.
>

Back to top

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

2l.

Re: ADVFN Financial Statements

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

Wed May 23, 2012 8:15 pm (PDT)

Just one thing, Excel Ver. 2007

--- In smf_addin@yahoogroups.com, "rebalance85" <rebalance85@...> wrote:
>
> 1.cn or "cn"? Which one is correct?
> 2.I make the file first, then I open the excel and load the add-in.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > On Wed, May 23, 2012 at 7:42 PM, rebalance85 <rebalance85@> wrote:
> >
> > >
> > > I creat the "smf-AdvFN-Prefix.txt", and the content is "cn ", is it
> > > correct? Or I should put "cn" into all the txt files in the folder?
> > >
> >
> > Just that one file. No blank after "cn". Just two characters.
> >
> > I try the RCHGetElementNumber-Template-AdvFN-Financial-Statements, all the
> > > cell are errors. Where is the mistake?
> > > I missed something, but I couldn't find by myself.
> > >
> >
> > Did you exit and re-enter EXCEL? The prefix is only loaded once.
> >
>

Back to top

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

3a.

Re: What does #value! response mean when using RCHGetElementNumber f

Posted by: "MikeM" mikemcq802@yahoo.com   mikemcq802

Wed May 23, 2012 6:08 am (PDT)

Exactly. Take the dividends and earnings per share numbers from the respective historical periods available on AdvFN. Divide one by the other and you have your historical value.

--- In smf_addin@yahoogroups.com, "investor952" <investor952@...> wrote:
>
> I am looking for the historical payout ratios going back 1 to 5 years
>

Back to top

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

4a.

AdvFN Annual Reports

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

Wed May 23, 2012 9:11 am (PDT)

Hello Randy

I couldn't use the "RCHGetElementNumber-Template-AdvFN-Financial-Statements", all the cell are error, and I also couldn't find the VBA.
So, I decide to use RCHGetTableCell get data.
For example: Ford
=RCHGetTableCell("http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AF",1,"Total Revenue"), then I can get 172455.
But I want to have 10 years data, each time I just can get 5 years, how to analysis the above URL?

Thank you very much!

Back to top

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

4b.

Re: AdvFN Annual Reports

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

Wed May 23, 2012 10:45 am (PDT)

There's no automatic way to change the URL. The necessary change can vary
by ticker symbol, but you can't tell without checking the content of the
web page itself.

On Wed, May 23, 2012 at 9:11 AM, rebalance85 <rebalance85@yahoo.com> wrote:

>
> I couldn't use the
> "RCHGetElementNumber-Template-AdvFN-Financial-Statements", all the cell are
> error, and I also couldn't find the VBA.
> So, I decide to use RCHGetTableCell get data.
> For example: Ford
> =RCHGetTableCell("
> http://cn.advfn.com/p.php?pid=financials&btn=annual_reports&mode=&symbol=NYSE%3AF",1,"Total
> Revenue"), then I can get 172455.
> But I want to have 10 years data, each time I just can get 5 years, how to
> analysis the above URL?
>

Back to top

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

5a.

RCHGetYahooHistory() Dividend History

Posted by: "confederate_yankee1965" cyankee65@gmail.com   confederate_yankee1965

Wed May 23, 2012 6:01 pm (PDT)

First, I just downloaded this add in and I find that it will make life easier for me when pulling stock information.

Is there a way to sort the information?

For example, if I pull up the dividend history, the most recent is first and the oldest is last. Without me having to rewrite my spreadsheet, is there a way to sort the data so that the oldest is first on the list and the most recent is last?

But, other then that, it has a learning curve, but I am able to make it work so far.

Thanks

Back to top

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

5b.

Re: RCHGetYahooHistory() Dividend History

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

Wed May 23, 2012 6:16 pm (PDT)

The sort parameter isn't active for dividend history, sorry.

On Wed, May 23, 2012 at 5:59 PM, confederate_yankee1965 <cyankee65@gmail.com
> wrote:

> First, I just downloaded this add in and I find that it will make life
> easier for me when pulling stock information.
>
> Is there a way to sort the information?
>
> For example, if I pull up the dividend history, the most recent is first
> and the oldest is last. Without me having to rewrite my spreadsheet, is
> there a way to sort the data so that the oldest is first on the list and
> the most recent is last?
>

Back to top

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

5c.

Re: RCHGetYahooHistory() Dividend History

Posted by: "confederate_yankee1965" cyankee65@gmail.com   confederate_yankee1965

Wed May 23, 2012 7:42 pm (PDT)

Ok, thanks. (Now that I found this message and posted another one just now) I have forgotten how to use yahoo groups. Thanks for your response

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The sort parameter isn't active for dividend history, sorry.
>
> On Wed, May 23, 2012 at 5:59 PM, confederate_yankee1965 <cyankee65@...
> > wrote:
>
> > First, I just downloaded this add in and I find that it will make life
> > easier for me when pulling stock information.
> >
> > Is there a way to sort the information?
> >
> > For example, if I pull up the dividend history, the most recent is first
> > and the oldest is last. Without me having to rewrite my spreadsheet, is
> > there a way to sort the data so that the oldest is first on the list and
> > the most recent is last?
> >
>

Back to top

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

6a.

RCHGetElementNumber Errors

Posted by: "curt.brandt@ymail.com" curt_brandt@verizon.net   curt.brandt@ymail.com

Wed May 23, 2012 6:55 pm (PDT)

I'm getting errors for MSN data where I never did before as well.

Back to top

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

6b.

Re: RCHGetElementNumber Errors

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

Wed May 23, 2012 8:13 pm (PDT)

See: http://finance.groups.yahoo.com/group/smf_addin/message/18529

On Wed, May 23, 2012 at 6:43 PM, curt.brandt@ymail.com <
curt_brandt@verizon.net> wrote:

> I'm getting errors for MSN data where I never did before as well.
>

Back to top

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

7a.

Sorting data

Posted by: "confederate_yankee1965" cyankee65@gmail.com   confederate_yankee1965

Wed May 23, 2012 7:40 pm (PDT)

Ok, I do not know if my previous message appeared, but, I have a problem with this great add in for Excel.

I can get the data to sort when I am showing the price and the date , but when I want JUST a list of dates and dividends, the data will not sort.

What do you need for me to provide for this problem.

Back to top

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

7b.

Re: Sorting data

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

Wed May 23, 2012 7:42 pm (PDT)

See:
http://finance.groups.yahoo.com/group/smf_addin/messages/18694?threaded=1&m=e&var=1&tidx=1

On Wed, May 23, 2012 at 7:39 PM, confederate_yankee1965 <cyankee65@gmail.com
> wrote:

> Ok, I do not know if my previous message appeared, but, I have a problem
> with this great add in for Excel.
>
> I can get the data to sort when I am showing the price and the date , but
> when I want JUST a list of dates and dividends, the data will not sort.
>
> What do you need for me to provide for this problem.
>

Back to top

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

8a.

Re: NASDAQ Financial Statements

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

Wed May 23, 2012 8:37 pm (PDT)

You need to review the source code on the web page to find out the
idiosyncrasies of extraction. They have changed the web page to add
charts on each line of the page using a bunch of HTML tables, which
makes table extraction a little more difficult. Try something like:

=RCHGetTableCell("http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp\
?documentType=2&Duration=1&NumPeriods=12&selected=AAPL",0,"Total
Current Assets","fundnum")

Replacing "AAPL" in the string is a simple EXCEL string concatenation,
such as:

"...string1..." & "...string2..." & "...string3..."

PS: Questions about the add-in should be sent to the Yahoo group, not to
me directly. Your message ended up in my SPAM folder and almost got
deleted without me seeing it.

On Tue, May 22, 2012 at 11:22 PM, rebalance85 <rebalance85@...
<mailto:rebalance85@yahoo.com> > wrote:
According to this link
http://finance.groups.yahoo.com/group/smf_addin/message/8315
<http://finance.groups.yahoo.com/group/smf_addin/message/8315>
I could not get the data from Nasdaq, blank or error, use your function:
=RCHGetTableCell("http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp\
?documentType=2&Duration=1&NumPeriods=12&selected=AAPL
<http://fundamentals.nasdaq.com/nasdaq_fundamentals.asp?documentType=2&D\
uration=1&NumPeriods=12&selected=AAPL> ",1,"Total Current Assets")
My excel version 2007.

Another issue is to replace the ticker number "AAPL", and some thing
like the documenttype, then I can get other company freely.

Back to top

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

Recent Activity

•  77
  New Members
•  1
  New Files

Visit Your Group

Yahoo! News

Odd News

You won't believe

it, but it's true

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

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

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