Messages In This Digest (15 Messages)
- 1a.
- Re: Extract text? From: Randy Harmelink
- 1b.
- Re: Extract text? From: dguillett1
- 1c.
- Re: Extract text? From: Randy Harmelink
- 1d.
- Re: Extract text? From: dguillett1
- 2a.
- Populate the spreadsheet when open it From: Jacob Jose
- 2b.
- Re: Populate the spreadsheet when open it From: Randy Harmelink
- 3a.
- extract from reuters From: wu_ming_sg
- 3b.
- Re: extract from reuters From: Randy Harmelink
- 3c.
- Re: extract from reuters From: Hong Chong NG
- 3d.
- Re: extract from reuters From: Randy Harmelink
- 4a.
- how to make chart hold when link is being clicked on? From: wu_ming_sg
- 4b.
- Re: how to make chart hold when link is being clicked on? From: Randy Harmelink
- 5a.
- Barcharts TrendSpotter From: David Weller
- 5b.
- Re: Barcharts TrendSpotter From: Randy Harmelink
- 5c.
- Re: Barcharts TrendSpotter From: David Weller
Messages
- 1a.
-
Re: Extract text?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Sep 5, 2011 6:55 am (PDT)
There isn't an add-in formula that will do it all automatically. You'll need
to do that manually.
On Mon, Sep 5, 2011 at 3:18 AM, Hong Chong NG <nghongchong@hotmail.com >wrote:
>
> How do I get it to extract the text nicely?
>
> Example:
> OWNERSHIP
> Grade: C
>
> Insider trading information is unavailable or inconsistent.
>
> Shares are neither being accumulated heavily nor sold heavily by financial
> institutions. *Neutral* for a large company like NTES
>
>
> I used =smfGetTagContent("
> http://investing.money.msn. ", "div",2,">Quickcom/investments/ stock-ratings/ ?symbol=ntes
> Summary",">Ownership")
> but got the below text with tags.
>
> "<p>Insider trading information is unavailable or inconsistent.</p>
> <p>Shares are neither being accumulated heavily nor sold heavily by
> financial institutions. <B>Neutral</B> for a large company like NTES</p>"
>
- 1b.
-
Re: Extract text?
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Mon Sep 5, 2011 7:26 am (PDT)
Or use an external query macro
From: Randy Harmelink
Sent: Monday, September 05, 2011 8:55 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Extract text?
There isn't an add-in formula that will do it all automatically. You'll need to do that manually.
On Mon, Sep 5, 2011 at 3:18 AM, Hong Chong NG <nghongchong@hotmail.com > wrote:
How do I get it to extract the text nicely?
Example:
OWNERSHIP
Grade: C
Insider trading information is unavailable or inconsistent.
Shares are neither being accumulated heavily nor sold heavily by financial institutions. Neutral for a large company like NTES
I used =smfGetTagContent("http://investing. money.msn. ", "div",2,">Quick Summary",">Ownershicom/investments/ stock-ratings/ ?symbol=ntes p")
but got the below text with tags.
"<p>Insider trading information is unavailable or inconsistent.</p> <p>Shares are neither being accumulated heavily nor sold heavily by financial institutions. <B>Neutral</ B> for a large company like NTES</p>"
- 1c.
-
Re: Extract text?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Sep 5, 2011 7:57 am (PDT)
Then you still need to extract it. The data isn't in a table, so you'd need
to query the whole page, and extract the data from that.
On Mon, Sep 5, 2011 at 7:26 AM, dguillett1 <dguillett1@gmail.com > wrote:
>
> Or use an external query macro
>
- 1d.
-
Re: Extract text?
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Mon Sep 5, 2011 8:26 am (PDT)
Or just hide the undesired rows/columns or a macro to copy to another sheet
From: Randy Harmelink
Sent: Monday, September 05, 2011 9:57 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Extract text?
Then you still need to extract it. The data isn't in a table, so you'd need to query the whole page, and extract the data from that.
On Mon, Sep 5, 2011 at 7:26 AM, dguillett1 <dguillett1@gmail.com > wrote:
Or use an external query macro
- 2a.
-
Populate the spreadsheet when open it
Posted by: "Jacob Jose" pepecan47@yahoo.ca pepecan47
Mon Sep 5, 2011 9:58 am (PDT)
I am using the SMF Add-In for some time now, and only have praise for the product.
I am working on a new workbook, and all of a sudden, when opening the workbook, the SMF is not populating the values from the different web sites. It is opening with the values when I saved the workbook the last time this thing worked. As far as I can see, the other workbooks are fine except this one.
Do you thing is it a setting in Excel for this particular spreadsheet?
Regards,
Jose L. Jacob - 2b.
-
Re: Populate the spreadsheet when open it
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Sep 5, 2011 12:26 pm (PDT)
Possibly manual calculation?
On Mon, Sep 5, 2011 at 9:58 AM, Jacob Jose <pepecan47@yahoo.ca > wrote:
>
> I am using the SMF Add-In for some time now, and only have praise for the
> product.
>
> I am working on a new workbook, and all of a sudden, when opening the
> workbook, the SMF is not populating the values from the different web sites.
> It is opening with the values when I saved the workbook the last time this
> thing worked. As far as I can see, the other workbooks are fine except this
> one.
>
> Do you thing is it a setting in Excel for this particular spreadsheet?
>
- 3a.
-
extract from reuters
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Sep 5, 2011 11:40 am (PDT)
hi,
How do I write the formula to extract from here
<http://www.reuters.com/finance/ > ?stocks/overview? symbol=NTES. O
I am interested in the Shares Outstanding (Mil.): data.
thanks!
- 3b.
-
Re: extract from reuters
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Sep 5, 2011 12:27 pm (PDT)
Did you try at all? It's about as straight-forward as it gets:
=RCHGetTableCell("
http://www.reuters.com/finance/ ",1,">Sharesstocks/overview? symbol=NTES. O
Outstanding")
On Mon, Sep 5, 2011 at 11:40 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
>
> How do I write the formula to extract from here<http://www.reuters.com/finance/ >stocks/overview? symbol=NTES. O
> ?
>
> I am interested in the *Shares Outstanding (Mil.):* data.
>
>
- 3c.
-
Re: extract from reuters
Posted by: "Hong Chong NG" nghongchong@hotmail.com wu_ming_sg
Mon Sep 5, 2011 12:31 pm (PDT)
Thanks! I tried the below with error message. I modelled it after my other cells but couldn't get it right, sorry to trouble you.
=RCHGetTableCell("http://www.reuters. com/finance/ "&Ticker,1,"stocks/overview? symbol= >Overall ",">Shares Outstanding" ,,,3)
To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Mon, 5 Sep 2011 12:27:54 -0700
Subject: Re: [smf_addin] extract from reuters
Did you try at all? It's about as straight-forward as it gets:
=RCHGetTableCell("http://www.reuters. com/finance/ ",1,">Shares Outstanding"stocks/overview? symbol=NTES. O )
On Mon, Sep 5, 2011 at 11:40 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
How do I write the formula to extract from here ?
I am interested in the Shares Outstanding (Mil.): data.
- 3d.
-
Re: extract from reuters
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Sep 5, 2011 12:57 pm (PDT)
There should be no reason to skip 3 table rows after finding ">Shares
Outstanding" -- the data is in the same row. Also, there is no ">Overall"
string in the source code of the web page. You do need to look at the source
code instead of making assumptions about how they have the web page coded.
On Mon, Sep 5, 2011 at 12:31 PM, Hong Chong NG <nghongchong@hotmail.com >wrote:
>
> Thanks! I tried the below with error message. I modelled it after my
> other cells but couldn't get it right, sorry to trouble you.
>
> =RCHGetTableCell("http://www.reuters. com/finance/ <http://www.reuters.stocks/overview? symbol com/finance/ >stocks/overview? symbol=NTES. O
> ="&Ticker,1,">Overall ",">Shares Outstanding" ,,,3)
>
- 4a.
-
how to make chart hold when link is being clicked on?
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Sep 5, 2011 3:15 pm (PDT)
Hi,
In this sample file "RCHCreateComments-Quick-Chart- Review.xls" , one can
click on the chart link and the chart will appear and hold till the next
click..
How was it achieved please?
Regards,
- 4b.
-
Re: how to make chart hold when link is being clicked on?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Sep 5, 2011 3:44 pm (PDT)
One of the parameters for the function is whether the comment should be
visible or not. Note that there is a collapsed column that typically has a
zeroes in it (i.e. comment not visible). There is a little macro attached to
the sheet:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("Charts").Offset( 0, -1) = 0
If Not Intersect(Target, ActiveSheet.Range("Charts" )) Is Nothing Then
Target.Offset(0, -1) = 1
End If
End Sub
...that toggles the "0" value to "1" for the selected chart, telling the
function to make the comment visible. If you select anything other than
something in the chart range, it sets all of those values back to zero. It's
not all that efficient, but it was just a "quick and dirty" example to show
how it could be done. You'll note the file is in the "Requests" folder.
On Mon, Sep 5, 2011 at 3:15 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> In this sample file "RCHCreateComments-Quick-Chart- Review.xls" , one can
> click on the chart link and the chart will appear and hold till the next
> click..
>
> How was it achieved please?
>
>
- 5a.
-
Barcharts TrendSpotter
Posted by: "David Weller" wellerdr@cox.net wellerdr
Mon Sep 5, 2011 3:40 pm (PDT)
Does Barcharts = RCHGetElementNumber(Q16,701) ) still work? Thanks
Q16 is symbol
=IF(LEN(Q16)=0,"--",RCHGetEl ementNumber( Q16,701))
dave
- 5b.
-
Re: Barcharts TrendSpotter
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Sep 5, 2011 4:23 pm (PDT)
I just updated the definition in the smf-elements-9.txt file, which can be
found in the "Works in Progress" folder of the files area of the group.
BarChart changed the verbiage from "Trend Spotter" to "TrendSpotter". Just
replace that file in your SMF folder and run the smfForceRecalculation macro
to reload the element definitions.
On Mon, Sep 5, 2011 at 3:40 PM, David Weller <wellerdr@cox.net > wrote:
>
> Does Barcharts = RCHGetElementNumber(Q16,701) ) still work? Thanks****
>
> ** **
>
> Q16 is symbol
>
> =IF(LEN(Q16)=0,"--",RCHGetEl ementNumber( Q16,701)) ****
>
- 5c.
-
Re: Barcharts TrendSpotter
Posted by: "David Weller" wellerdr@cox.net wellerdr
Mon Sep 5, 2011 4:31 pm (PDT)
Thanks so much!!!
Dave
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Randy Harmelink
Sent: Monday, September 05, 2011 7:24 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Barcharts TrendSpotter
I just updated the definition in the smf-elements-9.txt file, which can be
found in the "Works in Progress" folder of the files area of the group.
BarChart changed the verbiage from "Trend Spotter" to "TrendSpotter". Just
replace that file in your SMF folder and run the smfForceRecalculation macro
to reload the element definitions.
On Mon, Sep 5, 2011 at 3:40 PM, David Weller <wellerdr@cox.net > wrote:
Does Barcharts = RCHGetElementNumber(Q16,701) ) still work? Thanks
Q16 is symbol
=IF(LEN(Q16)=0,"--",RCHGetEl ementNumber( Q16,701))
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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
Tidak ada komentar:
Posting Komentar