Kamis, 03 Mei 2012

[smf_addin] Digest Number 2197

Messages In This Digest (12 Messages)

1a.
Re: FT.COM From: Lawrence
1b.
Re: FT.COM From: MikeM
1c.
Re: FT.COM From: Lawrence
1d.
Re: FT.COM From: Mike McQuaid
1e.
Re: FT.COM From: Lawrence
1f.
Re: FT.COM From: Mike McQuaid
1g.
Re: FT.COM From: Lawrence
1h.
Re: FT.COM From: Mike McQuaid
1i.
Re: FT.COM From: Lawrence
1j.
Re: FT.COM From: Randy Harmelink
2a.
Re: MSN elements not working anymore From: FroZeNDowNloaD
3.1.
New file uploaded to smf_addin From: smf_addin@yahoogroups.com

Messages

1a.

Re: FT.COM

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Wed May 2, 2012 8:26 pm (PDT)



Hi Randy

This RCH formulae works on one machine running Excel 2010 but on another running Excel 2007 it does not work and shows "Error". Is it a requirement to use Excel 2010 or are there some updates I need?

thanks

LL

--- In smf_addin@yahoogroups.com, "Randy Harmelink" <rharmelink@...> wrote:
>
> This appears to work:
>
> =RCHGetTableCell("http://markets.ft.com/tearsheets/performance.asp?s=PTBA.JK",
> 1,"EPS (TTM)")
>
> To convert it to a number, you could do something like:
>
> =VALUE(SUBSTITUTE(formula,"IDR",""))
>
> But I highly doubt changing the URL from one domain to another would
> grab the data. The structure of the web page would need to be almost
> identical for that to work.
>
> On 6/16/08, imanbogor <iman.chandra@...> wrote:
> > Suddenly Reuters.com not provide our stock exchange dat anymore.
> > Now, our data move to http://markets.ft.com. Is it possible if I
> > want to change the source of your add-ins from reuters.com to
> > http://markets.ft.com?
> >
> > Here is one example:
> >
> > http://markets.ft.com/tearsheets/performance.asp?
> > s=PTBA.JK&vsc_appId=ts&ftsite=FTCOM&searchtype=equity&searchOption=eq
> > uity
> >
> > which is PTBA.JK is our stock quotes.
> >
> > Next, bsed on link above, is it possible if I only want to show EPS
> > (TTM) data in my spreadsheet?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1b.

Re: FT.COM

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

Wed May 2, 2012 8:34 pm (PDT)



That formula works for me in Excel 2003 - highly unlikely to have only 2007 be an inherent problem. Do any formulas work for you in your Excel 2007?

What about this one:
=RCHGetElementNumber("version")

If none work for 2007, see Links section for some tips:
http://finance.groups.yahoo.com/group/smf_addin/links

--- In smf_addin@yahoogroups.com, "Lawrence" <lawrence.leesh@...> wrote:
>
> Hi Randy
>
> This RCH formulae works on one machine running Excel 2010 but on another running Excel 2007 it does not work and shows "Error". Is it a requirement to use Excel 2010 or are there some updates I need?
>
> thanks
>
> LL
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1c.

Re: FT.COM

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Wed May 2, 2012 8:45 pm (PDT)



Yes, those that have a number attached to them works. The one that does not work are the ones that refer to a web page address directly in the formulae.

--- In smf_addin@yahoogroups.com, "MikeM" <mikemcq802@...> wrote:
>
> That formula works for me in Excel 2003 - highly unlikely to have only 2007 be an inherent problem. Do any formulas work for you in your Excel 2007?
>
> What about this one:
> =RCHGetElementNumber("version")
>
> If none work for 2007, see Links section for some tips:
> http://finance.groups.yahoo.com/group/smf_addin/links
>
> --- In smf_addin@yahoogroups.com, "Lawrence" <lawrence.leesh@> wrote:
> >
> > Hi Randy
> >
> > This RCH formulae works on one machine running Excel 2010 but on another running Excel 2007 it does not work and shows "Error". Is it a requirement to use Excel 2010 or are there some updates I need?
> >
> > thanks
> >
> > LL
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1d.

Re: FT.COM

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

Wed May 2, 2012 8:54 pm (PDT)



Do all of them with a webpage address directly in the formula fail? Or just
that one. What about this one:

=smfGetTagContent("http://quotes.wsj.com/VFC/company-people","p",1,"cr_compa
ny_desc <http://quotes.wsj.com/VFC/company-people> ")

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Lawrence
Sent: Wednesday, May 02, 2012 11:45 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: FT.COM

Yes, those that have a number attached to them works. The one that does not
work are the ones that refer to a web page address directly in the formulae.

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"MikeM" <mikemcq802@...> wrote:
>
> That formula works for me in Excel 2003 - highly unlikely to have only
2007 be an inherent problem. Do any formulas work for you in your Excel
2007?
>
> What about this one:
> =RCHGetElementNumber("version")
>
> If none work for 2007, see Links section for some tips:
> http://finance.groups.yahoo.com/group/smf_addin/links
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Lawrence" <lawrence.leesh@> wrote:
> >
> > Hi Randy
> >
> > This RCH formulae works on one machine running Excel 2010 but on another
running Excel 2007 it does not work and shows "Error". Is it a requirement
to use Excel 2010 or are there some updates I need?
> >
> > thanks
> >
> > LL
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1e.

Re: FT.COM

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Wed May 2, 2012 9:04 pm (PDT)



This one works.

Does it have anything to do with formulaes that start with RCHGetTableCell not working because I am missing something?

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Do all of them with a webpage address directly in the formula fail? Or just
> that one. What about this one:
>
> =smfGetTagContent("http://quotes.wsj.com/VFC/company-people","p",1,"cr_compa
> ny_desc <http://quotes.wsj.com/VFC/company-people> ")
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Lawrence
> Sent: Wednesday, May 02, 2012 11:45 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: FT.COM
>
>
>
>
> Yes, those that have a number attached to them works. The one that does not
> work are the ones that refer to a web page address directly in the formulae.
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> "MikeM" <mikemcq802@> wrote:
> >
> > That formula works for me in Excel 2003 - highly unlikely to have only
> 2007 be an inherent problem. Do any formulas work for you in your Excel
> 2007?
> >
> > What about this one:
> > =RCHGetElementNumber("version")
> >
> > If none work for 2007, see Links section for some tips:
> > http://finance.groups.yahoo.com/group/smf_addin/links
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> "Lawrence" <lawrence.leesh@> wrote:
> > >
> > > Hi Randy
> > >
> > > This RCH formulae works on one machine running Excel 2010 but on another
> running Excel 2007 it does not work and shows "Error". Is it a requirement
> to use Excel 2010 or are there some updates I need?
> > >
> > > thanks
> > >
> > > LL
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1f.

Re: FT.COM

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

Wed May 2, 2012 9:10 pm (PDT)



Very unlikely. Randy uses Excel 2007 - for what that's worth. So, his
machine is OK, yours with 2010 is OK and mine with 2003 is OK.

What is your exact formula that isn't working as it is on your 2007 machine
- are you sure you entered it exactly right?

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Lawrence
Sent: Thursday, May 03, 2012 12:05 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: FT.COM

This one works.

Does it have anything to do with formulaes that start with RCHGetTableCell
not working because I am missing something?

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Mike McQuaid" <mikemcq802@...> wrote:
>
> Do all of them with a webpage address directly in the formula fail? Or
just
> that one. What about this one:
>
>
=smfGetTagContent("http://quotes.wsj.com/VFC/company-people","p",1,"cr_compa
> ny_desc <http://quotes.wsj.com/VFC/company-people> ")
>
> _____
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
> Of Lawrence
> Sent: Wednesday, May 02, 2012 11:45 PM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: [smf_addin] Re: FT.COM
>
>
>
>
> Yes, those that have a number attached to them works. The one that does
not
> work are the ones that refer to a web page address directly in the
formulae.
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com> ,
> "MikeM" <mikemcq802@> wrote:
> >
> > That formula works for me in Excel 2003 - highly unlikely to have only
> 2007 be an inherent problem. Do any formulas work for you in your Excel
> 2007?
> >
> > What about this one:
> > =RCHGetElementNumber("version")
> >
> > If none work for 2007, see Links section for some tips:
> > http://finance.groups.yahoo.com/group/smf_addin/links
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com> ,
> "Lawrence" <lawrence.leesh@> wrote:
> > >
> > > Hi Randy
> > >
> > > This RCH formulae works on one machine running Excel 2010 but on
another
> running Excel 2007 it does not work and shows "Error". Is it a requirement
> to use Excel 2010 or are there some updates I need?
> > >
> > > thanks
> > >
> > > LL
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1g.

Re: FT.COM

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Wed May 2, 2012 9:16 pm (PDT)



This is the exact formula:

=RCHGetTableCell("http://markets.ft.com/tearsheets/performance.asp?s=PTBA.JK",1,"EPS (TTM)")

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Very unlikely. Randy uses Excel 2007 - for what that's worth. So, his
> machine is OK, yours with 2010 is OK and mine with 2003 is OK.
>
> What is your exact formula that isn't working as it is on your 2007 machine
> - are you sure you entered it exactly right?
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Lawrence
> Sent: Thursday, May 03, 2012 12:05 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: FT.COM
>
>
>
>
> This one works.
>
> Does it have anything to do with formulaes that start with RCHGetTableCell
> not working because I am missing something?
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> "Mike McQuaid" <mikemcq802@> wrote:
> >
> > Do all of them with a webpage address directly in the formula fail? Or
> just
> > that one. What about this one:
> >
> >
> =smfGetTagContent("http://quotes.wsj.com/VFC/company-people","p",1,"cr_compa
> > ny_desc <http://quotes.wsj.com/VFC/company-people> ")
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
> Behalf
> > Of Lawrence
> > Sent: Wednesday, May 02, 2012 11:45 PM
> > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> > Subject: [smf_addin] Re: FT.COM
> >
> >
> >
> >
> > Yes, those that have a number attached to them works. The one that does
> not
> > work are the ones that refer to a web page address directly in the
> formulae.
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> ,
> > "MikeM" <mikemcq802@> wrote:
> > >
> > > That formula works for me in Excel 2003 - highly unlikely to have only
> > 2007 be an inherent problem. Do any formulas work for you in your Excel
> > 2007?
> > >
> > > What about this one:
> > > =RCHGetElementNumber("version")
> > >
> > > If none work for 2007, see Links section for some tips:
> > > http://finance.groups.yahoo.com/group/smf_addin/links
> > >
> > > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> ,
> > "Lawrence" <lawrence.leesh@> wrote:
> > > >
> > > > Hi Randy
> > > >
> > > > This RCH formulae works on one machine running Excel 2010 but on
> another
> > running Excel 2007 it does not work and shows "Error". Is it a requirement
> > to use Excel 2010 or are there some updates I need?
> > > >
> > > > thanks
> > > >
> > > > LL
> > > >
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1h.

Re: FT.COM

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

Wed May 2, 2012 9:45 pm (PDT)



Sorry, I'm out of ideas. If you can access this page successfully using
Internet Explorer but SMF doesn't work then I don't know. SMF, through
Excel, uses the same internet access as IE.

http://markets.ft.com/Research/Markets/Tearsheets/Summary?s=PTBA:JKT

I know Randy has sometimes has people try using Excel's Import External Data
/ New Web Query for the url in question to make sure it is retrievable. SMF
essentially relies on Excel's ability to retrieve it - then SMF parses it.
Excel itself relies essentially on IE so that's why you should see if IE can
lookup the page OK. I have no idea why it wouldn't - but sometimes funny
things arise when you try that.

Oh, have you set your IE cache option properly? If you got a bad page one
time but your cache setting is wrong it could just be using that same bad
page.
This links item describes how to set it right:
http://finance.groups.yahoo.com/group/smf_addin/message/13523

If none of this helps you'll have to wait for the master in the morning.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Lawrence
Sent: Thursday, May 03, 2012 12:16 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: FT.COM

This is the exact formula:

=RCHGetTableCell("http://markets.ft.com/tearsheets/performance.asp?s=PTBA.JK
",1,"EPS (TTM)")

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Mike McQuaid" <mikemcq802@...> wrote:
>
> Very unlikely. Randy uses Excel 2007 - for what that's worth. So, his
> machine is OK, yours with 2010 is OK and mine with 2003 is OK.
>
> What is your exact formula that isn't working as it is on your 2007
machine
> - are you sure you entered it exactly right?
>
> _____
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
> Of Lawrence
> Sent: Thursday, May 03, 2012 12:05 AM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: [smf_addin] Re: FT.COM
>
>
>
>
> This one works.
>
> Does it have anything to do with formulaes that start with RCHGetTableCell
> not working because I am missing something?
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com> ,
> "Mike McQuaid" <mikemcq802@> wrote:
> >
> > Do all of them with a webpage address directly in the formula fail? Or
> just
> > that one. What about this one:
> >
> >
>
=smfGetTagContent("http://quotes.wsj.com/VFC/company-people","p",1,"cr_compa
> > ny_desc <http://quotes.wsj.com/VFC/company-people> ")
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com> ] On
> Behalf
> > Of Lawrence
> > Sent: Wednesday, May 02, 2012 11:45 PM
> > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com>
> > Subject: [smf_addin] Re: FT.COM
> >
> >
> >
> >
> > Yes, those that have a number attached to them works. The one that does
> not
> > work are the ones that refer to a web page address directly in the
> formulae.
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> ,
> > "MikeM" <mikemcq802@> wrote:
> > >
> > > That formula works for me in Excel 2003 - highly unlikely to have only
> > 2007 be an inherent problem. Do any formulas work for you in your Excel
> > 2007?
> > >
> > > What about this one:
> > > =RCHGetElementNumber("version")
> > >
> > > If none work for 2007, see Links section for some tips:
> > > http://finance.groups.yahoo.com/group/smf_addin/links
> > >
> > > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> ,
> > "Lawrence" <lawrence.leesh@> wrote:
> > > >
> > > > Hi Randy
> > > >
> > > > This RCH formulae works on one machine running Excel 2010 but on
> another
> > running Excel 2007 it does not work and shows "Error". Is it a
requirement
> > to use Excel 2010 or are there some updates I need?
> > > >
> > > > thanks
> > > >
> > > > LL
> > > >
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1i.

Re: FT.COM

Posted by: "Lawrence" lawrence.leesh@gmail.com   lawleesh

Wed May 2, 2012 9:57 pm (PDT)



Thanks. I realized that when I keyed in http://markets.ft.com/tearsheets/performance.asp?s=PTBA.JK into IE, it changes to http://markets.ft.com/Research/Markets/Tearsheets/Summary?s=PTBA:JKT
automatically.
When I keyed in this new url into the formula, it works.

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Sorry, I'm out of ideas. If you can access this page successfully using
> Internet Explorer but SMF doesn't work then I don't know. SMF, through
> Excel, uses the same internet access as IE.
>
> http://markets.ft.com/Research/Markets/Tearsheets/Summary?s=PTBA:JKT
>
> I know Randy has sometimes has people try using Excel's Import External Data
> / New Web Query for the url in question to make sure it is retrievable. SMF
> essentially relies on Excel's ability to retrieve it - then SMF parses it.
> Excel itself relies essentially on IE so that's why you should see if IE can
> lookup the page OK. I have no idea why it wouldn't - but sometimes funny
> things arise when you try that.
>
> Oh, have you set your IE cache option properly? If you got a bad page one
> time but your cache setting is wrong it could just be using that same bad
> page.
> This links item describes how to set it right:
> http://finance.groups.yahoo.com/group/smf_addin/message/13523
>
> If none of this helps you'll have to wait for the master in the morning.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of Lawrence
> Sent: Thursday, May 03, 2012 12:16 AM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: FT.COM
>
>
>
>
> This is the exact formula:
>
> =RCHGetTableCell("http://markets.ft.com/tearsheets/performance.asp?s=PTBA.JK
> ",1,"EPS (TTM)")
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> "Mike McQuaid" <mikemcq802@> wrote:
> >
> > Very unlikely. Randy uses Excel 2007 - for what that's worth. So, his
> > machine is OK, yours with 2010 is OK and mine with 2003 is OK.
> >
> > What is your exact formula that isn't working as it is on your 2007
> machine
> > - are you sure you entered it exactly right?
> >
> > _____
> >
> > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
> Behalf
> > Of Lawrence
> > Sent: Thursday, May 03, 2012 12:05 AM
> > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> > Subject: [smf_addin] Re: FT.COM
> >
> >
> >
> >
> > This one works.
> >
> > Does it have anything to do with formulaes that start with RCHGetTableCell
> > not working because I am missing something?
> >
> > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> ,
> > "Mike McQuaid" <mikemcq802@> wrote:
> > >
> > > Do all of them with a webpage address directly in the formula fail? Or
> > just
> > > that one. What about this one:
> > >
> > >
> >
> =smfGetTagContent("http://quotes.wsj.com/VFC/company-people","p",1,"cr_compa
> > > ny_desc <http://quotes.wsj.com/VFC/company-people> ")
> > >
> > > _____
> > >
> > > From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com>
> > [mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com> ] On
> > Behalf
> > > Of Lawrence
> > > Sent: Wednesday, May 02, 2012 11:45 PM
> > > To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com>
> > > Subject: [smf_addin] Re: FT.COM
> > >
> > >
> > >
> > >
> > > Yes, those that have a number attached to them works. The one that does
> > not
> > > work are the ones that refer to a web page address directly in the
> > formulae.
> > >
> > > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com>
> > <mailto:smf_addin%40yahoogroups.com> ,
> > > "MikeM" <mikemcq802@> wrote:
> > > >
> > > > That formula works for me in Excel 2003 - highly unlikely to have only
> > > 2007 be an inherent problem. Do any formulas work for you in your Excel
> > > 2007?
> > > >
> > > > What about this one:
> > > > =RCHGetElementNumber("version")
> > > >
> > > > If none work for 2007, see Links section for some tips:
> > > > http://finance.groups.yahoo.com/group/smf_addin/links
> > > >
> > > > --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> <mailto:smf_addin%40yahoogroups.com>
> > <mailto:smf_addin%40yahoogroups.com> ,
> > > "Lawrence" <lawrence.leesh@> wrote:
> > > > >
> > > > > Hi Randy
> > > > >
> > > > > This RCH formulae works on one machine running Excel 2010 but on
> > another
> > > running Excel 2007 it does not work and shows "Error". Is it a
> requirement
> > > to use Excel 2010 or are there some updates I need?
> > > > >
> > > > > thanks
> > > > >
> > > > > LL
> > > > >
> > > >
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
1j.

Re: FT.COM

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

Wed May 2, 2012 10:24 pm (PDT)



Maybe it's that particular URL your machine doesn't like. What happens if
you visit that web address in IE, or via the EXCEL Web Query dialog?

Does this one work?

=RCHGetTableCell("http://finance.yahoo.com/q?s=MMM",1,"Close:")

On Wed, May 2, 2012 at 9:16 PM, Lawrence <lawrence.leesh@gmail.com> wrote:

> This is the exact formula:
>
> =RCHGetTableCell("
> http://markets.ft.com/tearsheets/performance.asp?s=PTBA.JK",1,"EPS (TTM)")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)
2a.

Re: MSN elements not working anymore

Posted by: "FroZeNDowNloaD" moonglows@gmail.com   FroZeNDowNloaD

Wed May 2, 2012 9:43 pm (PDT)



1;MSN;Company Description;http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;COMPANY REPORT; ; ; ;0;0;0;0

Go change it in the element file. it is the first line.

--- In smf_addin@yahoogroups.com, "Matt" <mattschofield@...> wrote:
>
>
> I can get the company name definition to work with the new file, but the description (i.e. element 1), returns:
>
> Financial data in <span> USD</span> <br /> Values in Millions (Except for per share items)
>

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

New file uploaded to smf_addin

Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com

Wed May 2, 2012 11:58 pm (PDT)




Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/Money making worksheets/1000 input tickers with RCHGetYahooQuotes function-2.xlsm
Uploaded by : digsupply <picsound@gmail.com>
Description : Get 1000 input tickers with RCHGetYahooQuotes function

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/Money%20making%20worksheets/1000%20input%20tickers%20with%20RCHGetYahooQuotes%20function-2.xlsm

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

digsupply <picsound@gmail.com>


Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (263)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New web site?

Drive traffic now.

Get your business

on Yahoo! search.

Yahoo! News

Odd News

You won't believe

it, but it's true

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
Diposting oleh EXCEL FEED LEARNING di 01.27

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)