[smf_addin] Digest Number 2110

EXCEL Stock Market Functions Add-in

Messages In This Digest (10 Messages)

1a.

Re: New official release of the add-in -- version 2.1.2012.02.02 From: msimmsx

1b.

Re: New official release of the add-in -- version 2.1.2012.02.02 From: Randy Harmelink

2a.

Using RCHGetTableCell From: jothiramselvam

2b.

Re: Using RCHGetTableCell From: Randy Harmelink

2c.

Re: Using RCHGetTableCell From: jothiramselvam

3a.

RCHGetYahooQuotes Array From: maxxwell2

3b.

Re: RCHGetYahooQuotes Array From: Randy Harmelink

4a.

RCHGetTableCell Error From: kamran.deloitte

4b.

Re: RCHGetTableCell Error From: Randy Harmelink

4c.

Re: RCHGetTableCell Error From: Steven Sun

View All Topics | Create New Topic

Messages

1a.

Re: New official release of the add-in -- version 2.1.2012.02.02

Posted by: "msimmsx" marksimms@verizon.net   msimmsx

Thu Feb 9, 2012 10:07 am (PST)

Is there any documentation about any new features or major fixes for this new release ?

Back to top

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

1b.

Re: New official release of the add-in -- version 2.1.2012.02.02

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

Thu Feb 9, 2012 12:58 pm (PST)

Just what was mentioned in the original message...the primary item was the
AdvFN fix for their domain name flip-flop.

On Thu, Feb 9, 2012 at 11:07 AM, msimmsx <marksimms@verizon.net> wrote:

> Is there any documentation about any new features or major fixes for this
> new release ?
>

Back to top

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

2a.

Using RCHGetTableCell

Posted by: "jothiramselvam" jothiram.s@gmail.com   jothiramselvam

Thu Feb 9, 2012 1:25 pm (PST)

Hello,

Im trying to get the stock value from the link

http://in.finance.yahoo.com/q?s=BRITANNIA.BO

using RCHGetTableCell. Im able to get all the cells like "Prev Close", "Open" etc, but Im not able to get the stock value. Can any one guide me on this? Or should I use a different function to get the same.

Thanks
Joe

Back to top

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

2b.

Re: Using RCHGetTableCell

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

Thu Feb 9, 2012 1:28 pm (PST)

See the message archives -- there have been a number of recent message
threads on the topic of the "Last Close:" table entry going away...

I would suggest just using the RCHGetYahooQuotes() function.

On Thu, Feb 9, 2012 at 2:25 PM, jothiramselvam <jothiram.s@gmail.com> wrote:

> Hello,
>
> Im trying to get the stock value from the link
>
> http://in.finance.yahoo.com/q?s=BRITANNIA.BO
>
> using RCHGetTableCell. Im able to get all the cells like "Prev Close",
> "Open" etc, but Im not able to get the stock value. Can any one guide me on
> this? Or should I use a different function to get the same.
>

Back to top

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

2c.

Re: Using RCHGetTableCell

Posted by: "jothiramselvam" jothiram.s@gmail.com   jothiramselvam

Thu Feb 9, 2012 1:50 pm (PST)

Thanks, This works

=RCHGetYahooQuotes("20MICRONS.NS","l1")

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> See the message archives -- there have been a number of recent message
> threads on the topic of the "Last Close:" table entry going away...
>
> I would suggest just using the RCHGetYahooQuotes() function.
>
> On Thu, Feb 9, 2012 at 2:25 PM, jothiramselvam <jothiram.s@...> wrote:
>
> > Hello,
> >
> > Im trying to get the stock value from the link
> >
> > http://in.finance.yahoo.com/q?s=BRITANNIA.BO
> >
> > using RCHGetTableCell. Im able to get all the cells like "Prev Close",
> > "Open" etc, but Im not able to get the stock value. Can any one guide me on
> > this? Or should I use a different function to get the same.
> >
>

Back to top

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

3a.

RCHGetYahooQuotes Array

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

Thu Feb 9, 2012 5:10 pm (PST)

When I use the RCHGetYahooQuotes function in an array with several perameters the result is the right information but every other column is the ticker symbol. It didn't use to do that.

Back to top

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

3b.

Re: RCHGetYahooQuotes Array

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

Thu Feb 9, 2012 5:11 pm (PST)

I just tried the template from the files area and It's working fine.

I'll need more details on what you're doing...

On Thu, Feb 9, 2012 at 5:37 PM, maxxwell2 <maxxwell2@yahoo.com> wrote:

> When I use the RCHGetYahooQuotes function in an array with several
> perameters the result is the right information but every other column is
> the ticker symbol. It didn't use to do that.
>

Back to top

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

4a.

RCHGetTableCell Error

Posted by: "kamran.deloitte" mmkamipk@yahoo.com   kamran.deloitte

Thu Feb 9, 2012 7:32 pm (PST)

The following function is resulting in Error. Can someone help me how to fix this.

=RCHGetTableCell("http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol="&Ticker&"&lstStatement=Income&stmtView=Ann",5,,"Period End Date")

Thanks in advance.

Back to top

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

4b.

Re: RCHGetTableCell Error

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

Thu Feb 9, 2012 7:35 pm (PST)

That's no longer a valid URL for an MSN financial statements page. The
annual income statement is now at:

http://investing.money.msn.com/investments/stock-income-statement?stmtView=Ann&symbol=MMM

On Thu, Feb 9, 2012 at 8:10 PM, kamran.deloitte <mmkamipk@yahoo.com> wrote:

> The following function is resulting in Error. Can someone help me how to
> fix this.
>
> =RCHGetTableCell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol="&Ticker&"&lstStatement=Income&stmtView=Ann",5,,"Period
> End Date")
>

Back to top

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

4c.

Re: RCHGetTableCell Error

Posted by: "Steven Sun" ssun24cd@gmail.com   ssun_tdam

Thu Feb 9, 2012 7:38 pm (PST)

The url has been changed. Use the following address:

http://investing.money.msn.com/investments/stock-income-statement/?symbol=us%3aperf&stmtView=ann

Stevo

On Thu, Feb 9, 2012 at 10:10 PM, kamran.deloitte <mmkamipk@yahoo.com> wrote:

> **
>
>
> The following function is resulting in Error. Can someone help me how to
> fix this.
>
> =RCHGetTableCell("
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?Symbol="&Ticker&"&lstStatement=Income&stmtView=Ann",5,,"Period
> End Date")
>
> Thanks in advance.
>
>
>

Back to top

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

Recent Activity

•  133
  New Members
•  1
  New Files

Visit Your Group

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

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

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