Rabu, 25 April 2012

[smf_addin] Digest Number 2187[1 Attachment]

Messages In This Digest (13 Messages)

1a.
Re: Ipad From: MikeM
1b.
Re: Ipad From: Martin Topper
2a.
Re: Strange Chart Output From: Kermit W. Prather
3a.
Re: RCHGetTableCell-Template-IBD-Stock-Checkup From: Kermit W. Prather
3b.
Re: RCHGetTableCell-Template-IBD-Stock-Checkup From: Randy Harmelink
3c.
Re: RCHGetTableCell-Template-IBD-Stock-Checkup From: Dave Charlaff
3d.
Re: RCHGetTableCell-Template-IBD-Stock-Checkup From: Kermit W. Prather
3e.
Re: RCHGetTableCell-Template-IBD-Stock-Checkup From: Kermit W. Prather
3f.
Re: RCHGetTableCell-Template-IBD-Stock-Checkup From: Randy Harmelink
4a.
Re: Latest user posting seems in error From: Ron Spruell
5a.
rchgettablecell Question From: zellabettic
5b.
Re: rchgettablecell Question From: Randy H
5c.
Re: rchgettablecell Question From: zellabettic

Messages

1a.

Re: Ipad

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

Tue Apr 24, 2012 5:48 am (PDT)



Marty, these hosting services use "Virtualization" technology. Their servers simulate running individual PCs and transmit only the screen interactions between the client and host. Each virtual PC at the host is identical. So, once it is setup every client gets the same thing. It's not that big of a deal to configure - the technical hurdle is not the problem.

And, yes, the licensing of software for these services is very different than "shrink wrap" licenses.

--- In smf_addin@yahoogroups.com, Martin Topper <mtopper@...> wrote:
>
> Bruce
>
> I have tried using CloudOn, a similar app that lets me use excel on my iPad.  I think Microsoft might have a problem (license violation?) if these apps were on servers.  SoI concluded that the iPad is only relaying a screen view of a standalone computer, located who knows where, that runs excel.  And the service would have to install the smf on EVERY computer so that whichever one you are directed to when you sign on, would work.  I think that might be a bit of a reach.
>
> Marty
>
>

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

Re: Ipad

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Tue Apr 24, 2012 7:21 am (PDT)



Mike

That's encouraging.  If you make progress, please post back.

thanks

Marty

________________________________
From: MikeM <mikemcq802@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Tuesday, April 24, 2012 8:48 AM
Subject: [smf_addin] Re: Ipad


 
Marty, these hosting services use "Virtualization" technology. Their servers simulate running individual PCs and transmit only the screen interactions between the client and host. Each virtual PC at the host is identical. So, once it is setup every client gets the same thing. It's not that big of a deal to configure - the technical hurdle is not the problem.

And, yes, the licensing of software for these services is very different than "shrink wrap" licenses.

--- In smf_addin@yahoogroups.com, Martin Topper <mtopper@...> wrote:
>
> Bruce
>
> I have tried using CloudOn, a similar app that lets me use excel on my iPad.  I think Microsoft might have a problem (license violation?) if these apps were on servers.  SoI concluded that the iPad is only relaying a screen view of a standalone computer, located who knows where, that runs excel.  And the service would have to install the smf on EVERY computer so that whichever one you are directed to when you sign on, would work.  I think that might be a bit of a reach.
>
> Marty
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
2a.

Re: Strange Chart Output

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Tue Apr 24, 2012 5:58 am (PDT)



Not to add to your confusion but I get a clear chart using the link in a
browser.
However when I put the
=RCHCreateComment("http://www.bondtools.com/nbbi.png",99)
into excel all I get is <http://www.bondtools.com/nbbi.png> Chart which
when I click on it gives me a browser window with the clear chart.

-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Philip S
Sent: Tuesday, April 24, 2012 4:14 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Strange Chart Output


Thanks for looking at this. Does sound like you are getting the reverse of
what I see i.e. clear image on website and dark/unreadable image in Excel
comment. I will have to see if I can find similar charts elsewhere. Some
obscure setting issue I guess.


--- In <mailto:smf_addin@yahoogroups.com> smf_addin@yahoogroups.com, Randy
Harmelink < <mailto:rharmelink@...> rharmelink@...> wrote:
>
> Hmmm. I get just the reverse. If I go to the site with my browser, I
> get a very poor image that is mostly dark and a type of reverse image
> from what I would normally expect. The one I get in EXCEL has a nice
> light green background. I find the website version unreadable.
>
> There may be some setting that causes it, but I'm unaware of what it
> would be.
>
> On Mon, Apr 23, 2012 at 8:52 AM, Philip S < <mailto:Philip_R_Small@...>
Philip_R_Small@...>wrote:
>
> >
> > I have been using RCHCreateComment to see a number of charts. I am
> > having problems with the following:
> >
> > =RCHCreateComment(" <http://www.bondtools.com/nbbi.png>
http://www.bondtools.com/nbbi.png",99)
> >
> > It seems to show a "negative" of the chart
> >
> > <http://www.bondtools.com/nbbi.png> http://www.bondtools.com/nbbi.png
is the website which displays the
> > chart normally and I can copy and paste from it fine. Is this a site
> > specific issue or is there a setting I can use to display it in readable
form.
> >
>




------------------------------------

Yahoo! Groups Links


(Yahoo! ID required)

<mailto:smf_addin-fullfeatured@yahoogroups.com>
smf_addin-fullfeatured@yahoogroups.com


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

Re: RCHGetTableCell-Template-IBD-Stock-Checkup

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Tue Apr 24, 2012 6:31 am (PDT)



I just downloaded the template RCHGetTableCell-Template-IBD-Stock-Checkup and after changing the smf addin location I get #NAME? in every cell

I’m not sure how to fix it since cells contain different values. I downloaded the file a few times saving as different names and still got the same errors

I’m going to try another machine just for the heck of it. I’ll post the results later.

Kermit


Cell C7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell(URLCheckup,1,"term=Composite Rating")

While

Cell D7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group"),">","<")

Cell E7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"span",-1,"_Composite")

Cell F7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group")&"|",": ","|")

Cell G7 contains blanks

Cell H7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"dt",-1,"Group Leaders","_rptComposite"),"Symbol=","""")


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 24, 2012 3:01 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell-Template-IBD-Stock-Checkup


Not a clue. I just opened the template from the group and tried all three of those -- they worked fine.

You didn't exceed your daily limit of stock check-ups, did you?
On Mon, Apr 23, 2012 at 9:16 PM, carmine288 <carmine.nicoletta@gmail.com> wrote:
Any idea why this template produces an "Error" for these: SNDK, EGY, and
VECO

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

Re: RCHGetTableCell-Template-IBD-Stock-Checkup

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

Tue Apr 24, 2012 6:50 am (PDT)



If you have a path preceding the function, such as:

'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!

...then that is an unresolved link that needs to be manually fixed. I
usually just run the smfFixLinks macro that is in the add-in. Otherwise, a
"Find and Replace All", changing them to nothing, works just as well --
it's what the macro does (or tries to do).

The unresolved links are an issue because of how EXCEL handles user-defined
functions from add-ins.

On Tue, Apr 24, 2012 at 6:31 AM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I just downloaded the template RCHGetTableCell-Template-IBD-Stock-Checkup
> and after changing the smf addin location I get #NAME? in every cell****
>
> ** **
>
> I’m not sure how to fix it since cells contain different values. I
> downloaded the file a few times saving as different names and still got the
> same errors****
>
> ** **
>
> I’m going to try another machine just for the heck of it. I’ll post the
> results later. ****
>
> ** **
>
> Kermit****
>
> ** **
>
> Cell C7 contains ='C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell(URLCheckup,1,"term=Composite
> Rating")****
>
> ** **
>
> While****
>
> ** **
>
> Cell D7 contains =0+'C:\SMF Add-in\
> RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank
> Within Group"),">","<")****
>
> ** **
>
> Cell E7 contains =0+'C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"span",-1,"_Composite")
> ****
>
> ** **
>
> Cell F7 contains ='C:\SMF Add-in\
> RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank
> Within Group")&"|",": ","|")****
>
> ** **
>
> Cell G7 contains blanks****
>
> ** **
>
> Cell H7 contains ='C:\SMF Add-in\
> RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"dt",-1,"Group
> Leaders","_rptComposite"),"Symbol=","""")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
3c.

Re: RCHGetTableCell-Template-IBD-Stock-Checkup

Posted by: "Dave Charlaff" davecharlaff@hotmail.com   copthornelabs

Tue Apr 24, 2012 7:45 am (PDT)



Kermit,

The problem is that Investors throws up a splash ad randomly that you have to close before you can get access to the ratings. (perhaps just to spite freeloaders)

Logging in to IBD ( better if you have a subscription) sets a cookie on your machine that avoids this issue.

I log in and stay logged in and everything works smoothly.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Kermit W. Prather
Sent: Tuesday, April 24, 2012 9:31 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RCHGetTableCell-Template-IBD-Stock-Checkup

I just downloaded the template RCHGetTableCell-Template-IBD-Stock-Checkup and after changing the smf addin location I get #NAME? in every cell

I’m not sure how to fix it since cells contain different values. I downloaded the file a few times saving as different names and still got the same errors

I’m going to try another machine just for the heck of it. I’ll post the results later.

Kermit

Cell C7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell(URLCheckup,1,"term=Composite Rating")

While

Cell D7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group"),">","<")

Cell E7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"span",-1,"_Composite")

Cell F7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group")&"|",": ","|")

Cell G7 contains blanks

Cell H7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"dt",-1,"Group Leaders","_rptComposite"),"Symbol=","""")

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 24, 2012 3:01 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell-Template-IBD-Stock-Checkup

Not a clue. I just opened the template from the group and tried all three of those -- they worked fine.

You didn't exceed your daily limit of stock check-ups, did you?

On Mon, Apr 23, 2012 at 9:16 PM, carmine288 <carmine.nicoletta@gmail.com> wrote:

Any idea why this template produces an "Error" for these: SNDK, EGY, and
VECO

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

Re: RCHGetTableCell-Template-IBD-Stock-Checkup

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Tue Apr 24, 2012 1:35 pm (PDT)



I have downloaded many templates and this one is only the second one that has failed like that.

Plus, some cell have such Cell D7 contains contain multiple prefixs - How is that possible? Something is wrong with this template.
=0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group"),">","<")


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 24, 2012 9:51 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell-Template-IBD-Stock-Checkup


If you have a path preceding the function, such as:

'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!

...then that is an unresolved link that needs to be manually fixed. I usually just run the smfFixLinks macro that is in the add-in. Otherwise, a "Find and Replace All", changing them to nothing, works just as well -- it's what the macro does (or tries to do).

The unresolved links are an issue because of how EXCEL handles user-defined functions from add-ins.
On Tue, Apr 24, 2012 at 6:31 AM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

I just downloaded the template RCHGetTableCell-Template-IBD-Stock-Checkup and after changing the smf addin location I get #NAME? in every cell

I’m not sure how to fix it since cells contain different values. I downloaded the file a few times saving as different names and still got the same errors

I’m going to try another machine just for the heck of it. I’ll post the results later.

Kermit

Cell C7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell(URLCheckup,1,"term=Composite Rating")

While

Cell D7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group"),">","<")

Cell E7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"span",-1,"_Composite")

Cell F7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group")&"|",": ","|")

Cell G7 contains blanks

Cell H7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"dt",-1,"Group Leaders","_rptComposite"),"Symbol=","""")

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

Re: RCHGetTableCell-Template-IBD-Stock-Checkup

Posted by: "Kermit W. Prather" kermitp@tampabay.rr.com   kermitpra

Tue Apr 24, 2012 1:36 pm (PDT)



Maybe that is the problem, I don’t subscribe to IBD.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Dave Charlaff
Sent: Tuesday, April 24, 2012 10:45 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RCHGetTableCell-Template-IBD-Stock-Checkup


Kermit,

The problem is that Investors throws up a splash ad randomly that you have to close before you can get access to the ratings. (perhaps just to spite freeloaders)

Logging in to IBD ( better if you have a subscription) sets a cookie on your machine that avoids this issue.

I log in and stay logged in and everything works smoothly.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Kermit W. Prather
Sent: Tuesday, April 24, 2012 9:31 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] RCHGetTableCell-Template-IBD-Stock-Checkup


I just downloaded the template RCHGetTableCell-Template-IBD-Stock-Checkup and after changing the smf addin location I get #NAME? in every cell

I’m not sure how to fix it since cells contain different values. I downloaded the file a few times saving as different names and still got the same errors

I’m going to try another machine just for the heck of it. I’ll post the results later.

Kermit


Cell C7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetTableCell(URLCheckup,1,"term=Composite Rating")

While

Cell D7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group"),">","<")

Cell E7 contains =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"span",-1,"_Composite")

Cell F7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank Within Group")&"|",": ","|")

Cell G7 contains blanks

Cell H7 contains ='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"dt",-1,"Group Leaders","_rptComposite"),"Symbol=","""")


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 24, 2012 3:01 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] RCHGetTableCell-Template-IBD-Stock-Checkup


Not a clue. I just opened the template from the group and tried all three of those -- they worked fine.

You didn't exceed your daily limit of stock check-ups, did you?
On Mon, Apr 23, 2012 at 9:16 PM, carmine288 <carmine.nicoletta@gmail.com> wrote:
Any idea why this template produces an "Error" for these: SNDK, EGY, and
VECO

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

Re: RCHGetTableCell-Template-IBD-Stock-Checkup

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

Tue Apr 24, 2012 1:58 pm (PDT)



There are two prefixes because there are two SMF functions. Both have
unresolved links.

On Tue, Apr 24, 2012 at 1:34 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> I have downloaded many templates and this one is only the second one that
> has failed like that. ****
>
> ** **
>
> Plus, some cell have such Cell D7 contains contain multiple prefixs - How
> is that possible? Something is wrong with this template.****
>
> =0+'C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!smfStrExtr('C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!smfGetTagContent(URLCheckup,"p",-1,"Rank
> Within Group"),">","<")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)
4a.

Re: Latest user posting seems in error

Posted by: "Ron Spruell" hashky@yahoo.com   hashky

Tue Apr 24, 2012 8:49 am (PDT)

[Attachment(s) from Ron Spruell included below]

I don't know what is going on.  I upload the file as I usually do.  I normally don't download and test.  I did download this one an it is not an Excel File.  I have the Excel file running on my computer.  But when I upload it turns out to be not an Excel file.

I don't know why it is not uploading to Yahoo.  I have attached a copy.  It seems to work here.

>________________________________
> From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Monday, April 23, 2012 9:43 AM
>Subject: Re: [smf_addin] Latest user posting seems in error
>
>
> 
>I agree. I got a hex display output page when I click on the link.
>
>
>On Mon, Apr 23, 2012 at 7:25 AM, Ryalmokas <ryalmokas@hotmail.com> wrote:
>
>I may be mistaken (won't be the first time), but Hashky's latest file posting ("Calls") seems not to be an xls file???
>>
>
>
>
>

Attachment(s) from Ron Spruell

1 of 1 File(s)

Calls-1.01e.xls
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
5a.

rchgettablecell Question

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

Tue Apr 24, 2012 12:52 pm (PDT)



Hello,

I am using this formula:

=rchgettablecell("http://performance.morningstar.com/PerformanceHtml/stock/trailing-total-returns.action?t="&A2&"&ndec=2&ep=true&annlz=true&ops=clear",5,"YTD",""&A2&"")

to return the ytd return of a stock I define in cell a2 of my spreadsheet from morningstar.com. However, on this same page, there is a row header that lists the category of the stock. I'm trying to tet the category and am unable to pull down this piece of data.

I've tried almost everything I can think of and could import the column headings, but unfortunately not the row headings.

Any help would be much appreciated. Thank you,

Clete

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

Re: rchgettablecell Question

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

Tue Apr 24, 2012 1:03 pm (PDT)



They have some very bizarre HTML table coding. I would just get it from
above the graph:

=smfGetTagContent("http://performance.morningstar.com/PerformanceHtml/st\
ock/trailing-total-returns.action?t="&A2,"span",1,"cdot2")

Otherwise:

=RCHGetTableCell("http://performance.morningstar.com/PerformanceHtml/sto\
ck/trailing-total-returns.action?t="&A2,1,">YTD",,,,3,"</table")

On Tue, Apr 24, 2012 at 10:14 AM, zellabettic <zellabettic@yahoo.com>
wrote:
I am using this formula:

=rchgettablecell("http://performance.morningstar.com/PerformanceHtml/sto\
ck/trailing-total-returns.action?t=
<http://performance.morningstar.com/PerformanceHtml/stock/trailing-total\
-returns.action?t=>
"&A2&"&ndec=2&ep=true&annlz=true&ops=clear",5,"YTD",""&A2&"")

to return the ytd return of a stock I define in cell a2 of my
spreadsheet from morningstar.com <http://morningstar.com/> . However,
on this same page, there is a row header that lists the category of the
stock. I'm trying to tet the category and am unable to pull down this
piece of data.

I've tried almost everything I can think of and could import the column
headings, but unfortunately not the row headings.

Any help would be much appreciated. Thank you,

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

Re: rchgettablecell Question

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

Tue Apr 24, 2012 2:55 pm (PDT)



Thank you - you are an amazing programmer - much appreciated and works perfectly.

Clete

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> They have some very bizarre HTML table coding. I would just get it from
> above the graph:
>
> =smfGetTagContent("http://performance.morningstar.com/PerformanceHtml/st\
> ock/trailing-total-returns.action?t="&A2,"span",1,"cdot2")
>
> Otherwise:
>
> =RCHGetTableCell("http://performance.morningstar.com/PerformanceHtml/sto\
> ck/trailing-total-returns.action?t="&A2,1,">YTD",,,,3,"</table")
>
> On Tue, Apr 24, 2012 at 10:14 AM, zellabettic <zellabettic@...>
> wrote:
> I am using this formula:
>
> =rchgettablecell("http://performance.morningstar.com/PerformanceHtml/sto\
> ck/trailing-total-returns.action?t=
> <http://performance.morningstar.com/PerformanceHtml/stock/trailing-total\
> -returns.action?t=>
> "&A2&"&ndec=2&ep=true&annlz=true&ops=clear",5,"YTD",""&A2&"")
>
> to return the ytd return of a stock I define in cell a2 of my
> spreadsheet from morningstar.com <http://morningstar.com/> . However,
> on this same page, there is a row header that lists the category of the
> stock. I'm trying to tet the category and am unable to pull down this
> piece of data.
>
> I've tried almost everything I can think of and could import the column
> headings, but unfortunately not the row headings.
>
> Any help would be much appreciated. Thank you,
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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.24

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)