Messages In This Digest (2 Messages)

2a.: Re: able to get chart off website using the plugin? From: Hong Chong NG

Messages

1a.: Re: Please help!!

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

Wed Aug 17, 2011 3:16 am (PDT)

Apparantly in my version of Excel 2010 you have to put ; between the elements
=RCHGetElementNumber("IBM";941)

so far so good...

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I can't tell based on your description. What is it saying is wrong with the
> formula? The one you had before works fine here:
>
> =RCHGetElementNumber("IBM",941)
>
> Or, how about:
>
> =RCHGetYahooQuotes("IBM","l1")
>
> On Wed, Aug 17, 2011 at 12:35 AM, siamees <siamees@...> wrote:
>
> > OK, I installed the Add-In in the correct folder. Installed it using the
> > options. Closed Excel and reopend it. And when I put in the formula
> > =RCHGetElementNumber("Version") It says "Stock Market Functions add-in,
> > Version 2.1.2010.08.02". But every other formula it gives an error saying
> > the formula is wrong and when I press OK it highligts everything between the
> > ( ). What am I doing wrong?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

2a.: Re: able to get chart off website using the plugin?

Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg

Wed Aug 17, 2011 3:19 am (PDT)

how about the small bar chart here?
http://investing.businessweek.com/businessweek/research/stocks/financials/ratios.asp?ticker=NTES:US
how can we do it?

To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Wed, 17 Aug 2011 01:21:17 -0700
Subject: Re: [smf_addin] able to get chart off website using the plugin?

You can display some images in EXCEL by using the RCHCreateComment() function. However, EXCEL has a limitation of 99 bytes for the URL of an image to insert, so the charts from the Google page wouldn't be possible.

On Tue, Aug 16, 2011 at 2:58 PM, wu_ming_sg <nghongchong@hotmail.com> wrote:

Is it possible to display chart from the websites such as http://www.google.com/finance?q=NASDAQ:AAPL&fstype=ii though the plugin?

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