Messages In This Digest (25 Messages)
- 1a.
- extract overview from Reuters From: wu_ming_sg
- 1b.
- Re: extract overview from Reuters From: Randy Harmelink
- 1c.
- Re: extract overview from Reuters From: wu_ming_sg
- 1d.
- Re: extract overview from Reuters From: Randy Harmelink
- 1e.
- Re: extract overview from Reuters From: wu_ming_sg
- 1f.
- Re: extract overview from Reuters From: Randy Harmelink
- 2a.
- Re: Use the plug-in for Commitments of Traders data on futures from From: Gary Funck
- 3a.
- Google capital expenditures? From: smfaddin
- 3b.
- Re: Google capital expenditures? From: Randy Harmelink
- 4.1.
- RCHGetElementNumber From: charles
- 4.2.
- Re: RCHGetElementNumber From: Randy Harmelink
- 4.3.
- Re: RCHGetElementNumber From: investor952
- 4.4.
- Re: RCHGetElementNumber From: Randy Harmelink
- 4.5.
- Re: RCHGetElementNumber From: investor952
- 4.6.
- Re: RCHGetElementNumber From: Randy Harmelink
- 5a.
- Re: Spreadsheet Auto-Update From: Troy
- 5b.
- Re: Spreadsheet Auto-Update From: Randy Harmelink
- 6a.
- Is SMF using IE proxy? From: gz_cp
- 6b.
- Re: Is SMF using IE proxy? From: Randy Harmelink
- 6c.
- Re: Is SMF using IE proxy? From: gz_cp
- 7a.
- Re: RCHGetElementNumber problem with ADVFN template From: mutantcar
- 7b.
- Re: RCHGetElementNumber problem with ADVFN template From: Randy Harmelink
- 8a.
- Re: Pulling Competitors off of Yahoo! Finance From: scott jackson
- 8b.
- Re: Pulling Competitors off of Yahoo! Finance From: Randy Harmelink
- 9.
- Elements 4951-4958 and 5052-5058 From: Joel
Messages
- 1a.
-
extract overview from Reuters
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Sep 10, 2011 8:36 am (PDT)
Hi,
What is the best way to extract the below overview from reuters?
http://www.reuters.com/finance/ stocks/overview? symbol=NTES. O
<http://www.reuters.com/finance/ >stocks/overview? symbol=NTES. O
NTES.O on Nasdaq
47.94USD
9 Sep 2011Price Change (% chg)
$-0.95 (-1.94%)Prev Close
$48.89Open
$48.60Day's High
$49.39Day's Low
$47.55Volume
1,077,683Avg. Vol
869,27352-wk High
$55.0052-wk Low
$35.20
Regards,
- 1b.
-
Re: extract overview from Reuters
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 8:38 am (PDT)
You'll need to use the smfGetTagContent() on each item, since they don't put
it into a table.
On Sat, Sep 10, 2011 at 8:36 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> What is the best way to extract the below overview from reuters?
>
> http://www.reuters.com/finance/ stocks/overview? symbol=NTES. O
>
> NTES.O on Nasdaq
>
> 47.94USD
> 9 Sep 2011
> Price Change (% chg)
>
> $-0.95 (-1.94%)
> Prev Close
> $48.89
> Open
> $48.60
> Day's High
> $49.39
> Day's Low
> $47.55
> Volume
> 1,077,683
> Avg. Vol
> 869,273
> 52-wk High
> $55.00
> 52-wk Low
> $35.20
>
- 1c.
-
Re: extract overview from Reuters
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Sep 10, 2011 8:43 am (PDT)
Hi,
I like to extract the exchange and date at least, can you show me how to
write the formula please?
Below is the source code.
"<div class="moduleBody"> <div id="headerQuoteCont ainer"> <div
class="sectionQuote nasdaqChange"> <div class="sectionQuote Detail">
<span class="nasdaqChangeHeader">NTES. O on Nasdaq</span> <br
class="clear"><br class="clear" > <span style="font- size: 23px;">
47.94</span><span>USD< /span><br /> <span class="nasdaqChange Time">9
Sep 2011</span> </div> </div>"
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> You'll need to use the smfGetTagContent() on each item, since they
don't put
> it into a table.
>
> On Sat, Sep 10, 2011 at 8:36 AM, wu_ming_sg nghongchong@... wrote:
>
> >
> > What is the best way to extract the below overview from reuters?
> >
> > http://www.reuters.com/finance/ stocks/overview? symbol=NTES. O
> >
> > NTES.O on Nasdaq
> >
> > 47.94USD
> > 9 Sep 2011
> > Price Change (% chg)
> >
> > $-0.95 (-1.94%)
> > Prev Close
> > $48.89
> > Open
> > $48.60
> > Day's High
> > $49.39
> > Day's Low
> > $47.55
> > Volume
> > 1,077,683
> > Avg. Vol
> > 869,273
> > 52-wk High
> > $55.00
> > 52-wk Low
> > $35.20
> >
>
- 1d.
-
Re: extract overview from Reuters
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 8:48 am (PDT)
Try:
=smfStrExtr(smfGetTagContent ("
http://www.reuters.com/finance/ ",stocks/overview? symbol=NTES. O
"span",-1,"id=""headerQuoteCon tainer""" ,"ChangeHeader" )&"|"," on ","|")
=smfGetTagContent("
http://www.reuters.com/finance/ ",stocks/overview? symbol=NTES. O
"span",-1,"id=""headerQuoteCon tainer""" ,"ChangeTime" )
On Sat, Sep 10, 2011 at 8:43 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> I like to extract the *exchange *and *date *at least, can you show me how
> to write the formula please?
>
> Below is the source code.
>
> "<div class="moduleBody"> <div id="headerQuoteCont ainer"> <div class="sectionQuote
> nasdaqChange"> <div class="sectionQuote Detail"> <span class="
> nasdaqChangeHeader">*NTES.O on Nasdaq*</span> <br class="clear" ><br class
> ="clear"> <span style="font-size: 23px;"> 47.94</span> <span>USD< /span><br
> /> <span class="nasdaqChangeTime">*9 Sep 2011*</span> </div> </div>"
>
- 1e.
-
Re: extract overview from Reuters
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Sat Sep 10, 2011 8:59 am (PDT)
you are a real genius!
Do you have any documentation on smfStrExt()?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> Try:
>
> =smfStrExtr(smfGetTagContent ("
> http://www.reuters.com/finance/ ",stocks/overview? symbol=NTES. O
> "span",-1,"id=""headerQuoteCon tainer""" ,"ChangeHeader" )&"|"," on
","|")
>
> =smfGetTagContent("
> http://www.reuters.com/finance/ ",stocks/overview? symbol=NTES. O
> "span",-1,"id=""headerQuoteCon tainer""" ,"ChangeTime" )
>
> On Sat, Sep 10, 2011 at 8:43 AM, wu_ming_sg nghongchong@... wrote:
>
> >
> > I like to extract the *exchange *and *date *at least, can you show
me how
> > to write the formula please?
> >
> > Below is the source code.
> >
> > "<div class="moduleBody"> <div id="headerQuoteCont ainer"> <div
class="sectionQuote
> > nasdaqChange"> <div class="sectionQuote Detail"> <span class="
> > nasdaqChangeHeader">*NTES.O on Nasdaq*</span> <br class="clear" ><br
class
> > ="clear"> <span style="font-size: 23px;">
47.94</span><span>USD< /span><br
> > /> <span class="nasdaqChangeTime">*9 Sep 2011*</span> </div> </div>"
> >
>
- 1f.
-
Re: extract overview from Reuters
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 9:04 am (PDT)
The only documentation so far:
http://finance.groups.yahoo. com/group/ smf_addin/ message/13843
On Sat, Sep 10, 2011 at 8:58 AM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Do you have any documentation on smfStrExt()?
>
- 2a.
-
Re: Use the plug-in for Commitments of Traders data on futures from
Posted by: "Gary Funck" gary@intrepid.com garyfunck
Sat Sep 10, 2011 9:25 am (PDT)
On 08/29/11 06:22:26, gz_cp wrote:
> Hi,
>
> Has anyone found a resource where we can use the plug-in to download
> the historical data series of Commitments of Traders (COT) data on
> futures from CFTC?
The CFTC provides historical data here (in zip'ed CSV and XLS formats):
http://www.cftc.gov/MarketReport s/CommitmentsofT raders/Historica lCompressed/ index.htm
> We have been looking for it for a while and couldn't find it.
> The Excel file downloaded from the CFTC website is not easy to extract
> into time series.
How so?
- 3a.
-
Google capital expenditures?
Posted by: "smfaddin" smfaddin@yahoo.com smfaddin
Sat Sep 10, 2011 9:41 am (PDT)
Is anyone having trouble with Google Capital Expenditures?
Mine is reading ERROR. All of my other data requests are working.
- 3b.
-
Re: Google capital expenditures?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 9:42 am (PDT)
More details please.
On Sat, Sep 10, 2011 at 9:37 AM, smfaddin <smfaddin@yahoo.com > wrote:
> Is anyone having trouble with Google Capital Expenditures?
>
> Mine is reading ERROR. All of my other data requests are working.
>
- 4.1.
-
RCHGetElementNumber
Posted by: "charles" chasjohn02@yahoo.com chasjohn02
Sat Sep 10, 2011 10:00 am (PDT)
Today (9-10-2011): RCHGetElementNumber yieldsERROR for all MSN element numbers. Any suggestions?
- 4.2.
-
Re: RCHGetElementNumber
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 11:26 am (PDT)
Wait until MSN fixes the problem?
If I go to MSN and try to generate a print report, I'm getting "Ticker not
found" for all tickers I've tried.
On Sat, Sep 10, 2011 at 10:00 AM, charles <chasjohn02@yahoo.com > wrote:
> Today (9-10-2011): RCHGetElementNumber yieldsERROR for all MSN element
> numbers. Any suggestions?
>
- 4.3.
-
Re: RCHGetElementNumber
Posted by: "investor952" investor952@yahoo.com investor952
Sat Sep 10, 2011 1:30 pm (PDT)
I just got the same problem. When I go to the MSN Stock Scouter website..that seems to be working, however, I get the same error as you describe below when using the Excel formula.
--- In smf_addin@yahoogroups.com , "charles" <chasjohn02@...> wrote:
>
> Today (9-10-2011): RCHGetElementNumber yieldsERROR for all MSN element numbers. Any suggestions?
>
- 4.4.
-
Re: RCHGetElementNumber
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 1:42 pm (PDT)
The MSN website is *NOT* working.
http://moneycentral.msn.com/ investor/ research/ sreport.asp? symbol=MMM& QD=1&OP=1& Y1=1&CR=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
...gives me "Ticker not found". The add-in gets the data from the "Print
Report" page.
On Sat, Sep 10, 2011 at 1:30 PM, investor952 <investor952@yahoo.com > wrote:
> I just got the same problem. When I go to the MSN Stock Scouter
> website..that seems to be working, however, I get the same error as you
> describe below when using the Excel formula.
>
- 4.5.
-
Re: RCHGetElementNumber
Posted by: "investor952" investor952@yahoo.com investor952
Sat Sep 10, 2011 2:02 pm (PDT)
hmmm...then check this out:
http://investing.money.msn. com/investments/ stock-ratings? symbol=T
here is part of what it shows me:
AT&T INC: STOCK RATING SUMMARY
9
StockScouter
AT&T Inc, a large-cap growth company in the public utilities sector, is expected to outperform the market over the next six months with very low risk.
10 is the best possible rating.
QUICK SUMMARY
Pro
Earnings growth in the past year has accelerated moderately compared to earnings growth in the past three years. Positive
The price-to-earnings multiple is lower than average for all stocks in the StockScouter universe. Positive
The StockScouter measure of relative price change and consistency is high. Positive
Con
One or more analysts has modestly decreased quarterly earnings estimates for T. Negative
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The MSN website is *NOT* working.
>
> http://moneycentral.msn.com/ investor/ research/ sreport.asp? symbol=MMM& QD=1&OP=1& Y1=1&CR=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
>
> ...gives me "Ticker not found". The add-in gets the data from the "Print
> Report" page.
>
> On Sat, Sep 10, 2011 at 1:30 PM, investor952 <investor952@...> wrote:
>
> > I just got the same problem. When I go to the MSN Stock Scouter
> > website..that seems to be working, however, I get the same error as you
> > describe below when using the Excel formula.
> >
>
- 4.6.
-
Re: RCHGetElementNumber
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 2:15 pm (PDT)
But that is NOT the web page the add-in is getting the data from if you use
RCHGetElementNumber().
If you want to get it from THAT web page, you'll need to write your own
RCHGetTableCell() function.
In any case, the "Print Report" page seems to be working now -- at least
parts of it. For example:
=RCHGetElementNumber("MMM",1)
...is no longer returning "Error", but now is returning:
Company description not available.
And I'm getting a lot of "NA" values. But at least the ticker symbols are
now being found. It may take some time before they fix it completely.
On Sat, Sep 10, 2011 at 2:02 PM, investor952 <investor952@yahoo.com > wrote:
> hmmm...then check this out:
>
> http://investing.money.msn. com/investments/ stock-ratings? symbol=T
>
- 5a.
-
Re: Spreadsheet Auto-Update
Posted by: "Troy" troy.mills@tx.rr.com troyamills
Sat Sep 10, 2011 11:53 am (PDT)
Randy,
I have a spreadsheet where I have built a simple array using RCHGetYahooQuotes to obtain the last price on a list of several stocks. However, the values are not automatically updating when I open the spreadsheet. Seeing your response to Mark I confirmed I had Calculation Options set to Automatic in Excel. Still no luck. What else could be preventing the array from updating when I open the spreadsheet?
Regards,
Troy
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> No reason to auto-update at the end of each day, or maintain a database.
> When you open the workbook, the formulas will get the currently available
> data from the Internet. There should be no reason for you to be re-entering
> the formulas -- perhaps you have calculation set to manual?
>
> On Thu, Sep 8, 2011 at 11:47 AM, Mark <drklein01@...> wrote:
>
> > I'm new here so let me first give thanks to you, Randy, for sharing your
> > work with us and continuing to offer your time in monitoring and responding
> > to this group.
> >
> > What I want to do is maintain an historical Excel database that I can
> > easily auto-update at the end of each day. I have a starting date in mind
> > so what I have done thus far is size the 3-column array accordingly so as to
> > have the starting date at the top and the most recent date at the bottom.
> >
> > I suspect this is not the best setup for auto-updating the database,
> > however. I actually have several ticker symbols that I wish to update every
> > day in the same size array. The formula I have been using is
> > =RCHGetYahooHistory("XYZ",,, ,,,,,"TDA" ,,,1) since all I care about is the
> > ticker, date, and adjusted close and I want the desired starting date to be
> > at the top. Tomorrow morning if I wish to add today's close, though, it
> > appears I will have to click on the upper-left cell, highlight the entire
> > array plus one additional row, and ctrl-shift-enter . That will be
> > relatively cumbersome to do with several tickers in non-consecutive columns
> > of one spreadsheet.
> >
> > Is there a way I can have the arrays automatically fill from the desired
> > start date through the most recent day's quote upon every opening of the
> > spreadsheet?
> >
>
- 5b.
-
Re: Spreadsheet Auto-Update
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 12:08 pm (PDT)
Possibly you don't have your Internet Options set to get a new web page each
time it is visited? Then you could just be picking up a cached copy of the
web page in the Temporary Internet Files folder.
On Sat, Sep 10, 2011 at 11:53 AM, Troy <troy.mills@tx.rr.com > wrote:
>
> I have a spreadsheet where I have built a simple array using
> RCHGetYahooQuotes to obtain the last price on a list of several stocks.
> However, the values are not automatically updating when I open the
> spreadsheet. Seeing your response to Mark I confirmed I had Calculation
> Options set to Automatic in Excel. Still no luck. What else could be
> preventing the array from updating when I open the spreadsheet?
>
- 6a.
-
Is SMF using IE proxy?
Posted by: "gz_cp" gz_cp@yahoo.com gz_cp
Sat Sep 10, 2011 12:10 pm (PDT)
How to avoid it?
If I have IE proxy setup, how to let SMF use direct connection?
- 6b.
-
Re: Is SMF using IE proxy?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 12:23 pm (PDT)
I don't know anything about IE proxy. Never heard the term before.
The add-in uses the same Microsoft engine that IE uses (XMLHTTP), so it does
share the IE cookies and Temporary Internet Files and their settings.
On Sat, Sep 10, 2011 at 12:10 PM, gz_cp <gz_cp@yahoo.com > wrote:
>
> How to avoid it?
> If I have IE proxy setup, how to let SMF use direct connection?
>
- 6c.
-
Re: Is SMF using IE proxy?
Posted by: "gz_cp" gz_cp@yahoo.com gz_cp
Sat Sep 10, 2011 1:07 pm (PDT)
Yes I meant the proxy set in IE.
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I don't know anything about IE proxy. Never heard the term before.
>
> The add-in uses the same Microsoft engine that IE uses (XMLHTTP), so it does
> share the IE cookies and Temporary Internet Files and their settings.
>
> On Sat, Sep 10, 2011 at 12:10 PM, gz_cp <gz_cp@...> wrote:
>
> >
> > How to avoid it?
> > If I have IE proxy setup, how to let SMF use direct connection?
> >
>
- 7a.
-
Re: RCHGetElementNumber problem with ADVFN template
Posted by: "mutantcar" mutant.car@virgin.net mutantcar
Sat Sep 10, 2011 6:15 pm (PDT)
I see what you mean about LLOY. Silly me! Quite new to this, so not sure what information I want, just looking what's available.
It's working now. I tried the stuff on 'Links'. I've also realised, I need 'NYSE:IBM'. If I just enter IBM, I get 'LSE:IBM', which doesn't have the historical info.
Disappointing to find this information seemingly not available for UK stocks on ADVFN without a subscription upgrade. Think I'll be cancelling my trial subscription with them.
Thanks again.
- 7b.
-
Re: RCHGetElementNumber problem with ADVFN template
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 6:49 pm (PDT)
I think the default "exchanges" are based on your location, so you may have
to keep that in mind when entering ticker symbols.
On Sat, Sep 10, 2011 at 6:15 PM, mutantcar <mutant.car@virgin.net > wrote:
> I see what you mean about LLOY. Silly me! Quite new to this, so not sure
> what information I want, just looking what's available.
>
> It's working now. I tried the stuff on 'Links'. I've also realised, I need
> 'NYSE:IBM'. If I just enter IBM, I get 'LSE:IBM', which doesn't have the
> historical info.
>
> Disappointing to find this information seemingly not available for UK
> stocks on ADVFN without a subscription upgrade. Think I'll be cancelling my
> trial subscription with them.
>
- 8a.
-
Re: Pulling Competitors off of Yahoo! Finance
Posted by: "scott jackson" scottandrewjackson@yahoo.com scottandrewjackson
Sat Sep 10, 2011 8:01 pm (PDT)
Randy,
When I use the formula you gave me it worked, but I needed to reference a ticker placed in a different cell: I used this: =RCHGetTableCell("http://finance. yahoo.com/ "&B3&",3,"Market Cap:",,,,-2) . For some reason it's not working. am I referencing the ticker cell wrong?q/co?s=
Also, do you have a database where we can upload our work for others to use?
Thank you,
- Scott Jackson
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, September 9, 2011 1:33 PM
Subject: Re: [smf_addin] Pulling Competitors off of Yahoo! Finance
Just go backwards, as in:
=RCHGetTableCell("http://finance. yahoo.com/ ",column,"Market Cap:",,,,-2)q/co?s=SIGM
...varying "column" from 2 to 6.
On Fri, Sep 9, 2011 at 1:09 PM, scott jackson <scottandrewjackson@yahoo.com > wrote:
>
>Using the RCHgettablecell function I am trying to pull the competitors ticker symbols off of yahoo finance http://finance.yahoo.com/ There is no title in the row labled "tickers" and there is no column header. Do you have any suggestions?q/co?s=SIGM+ Competitors.
>
>
- 8b.
-
Re: Pulling Competitors off of Yahoo! Finance
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Sep 10, 2011 10:04 pm (PDT)
That can't be the formula you are using. EXCEL won't even let me enter it,
telling me I have an error. I don't know what the trailing ampersand and
double quote is for after the cell reference. That says you want to start
another string to concatenate. I suspect you just want:
=RCHGetTableCell("http://finance. yahoo.com/ "&B3,3,"Marketq/co?s=
Cap:",,,,-2)
There is a folder in the files area called "Uploads by members", where you
can upload any add-in workbook you create.
On Sat, Sep 10, 2011 at 8:01 PM, scott jackson <scottandrewjackson@yahoo.com
> wrote:
>
> When I use the formula you gave me it worked, but I needed to reference a
> ticker placed in a different cell: I used this: =RCHGetTableCell("
> http://finance.yahoo.com/ "&B3&",3,"Market Cap:",,,,-2) . For someq/co?s=
> reason it's not working. am I referencing the ticker cell wrong?
>
> Also, do you have a database where we can upload our work for others to
> use?
>
- 9.
-
Elements 4951-4958 and 5052-5058
Posted by: "Joel" joel.andrews@lpl.com joelfp2000
Sat Sep 10, 2011 9:06 pm (PDT)
Randy,
I was wondering if you could check on elements 4951-4958 and 5051 - 5058. I can't seem to get them working. These deal with the rankings of mutual funds in their particular categories.
Thanks so much.
Joel
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