[smf_addin] Digest Number 1977

EXCEL Stock Market Functions Add-in

Messages In This Digest (6 Messages)

1a.

Re: WSJ Market Data From: bushpilote@yahoo.ca

1b.

Re: WSJ Market Data From: Randy Harmelink

2a.

Re: Recording each and every price stamp in a new row from a stream From: Farhan Ansari

3a.

RCH get web data and narrowing source data return From: futants46and2

3b.

Re: RCH get web data and narrowing source data return From: Randy Harmelink

3c.

Re: RCH get web data and narrowing source data return From: Sill. Micheal

View All Topics | Create New Topic

Messages

1a.

Re: WSJ Market Data

Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca   bushpilote

Thu Oct 6, 2011 6:27 am (PDT)

Thanks for the quick reply Randy.

At my end, the function returns the text "P/E RATIO". I tried using different row/column number combination to try to get the actual pe with no luck.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Simple as pie:
>
> =RCHGetHTMLTable("http://online.wsj.com/mdc/public/page/2_3021-peyield.html",">Dow
> Industrial",-1,"",1)
>
> On Wed, Oct 5, 2011 at 4:59 AM, <bushpilote@...> wrote:
>
> >
> > I have been unable to pull P/E ratios from ""
> > http://online.wsj.com/mdc/public/page/2_3021-peyield.html?mod=mdc_h_usshl"
> > with the function recommended below.
> >
> > Any suggestion on getting this to work would be appreciated.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

1b.

Re: WSJ Market Data

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

Thu Oct 6, 2011 8:22 am (PDT)

It's an array-entered function (over a range) with no row/column number
combinations...

You said you wanted the RCHGetHTMLTable() function for retrieval, not
RCHGetTableCell().

On Thu, Oct 6, 2011 at 6:27 AM, <bushpilote@yahoo.ca> wrote:

>
> At my end, the function returns the text "P/E RATIO". I tried using
> different row/column number combination to try to get the actual pe with no
> luck.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Simple as pie:
> >
> > =RCHGetHTMLTable("
> http://online.wsj.com/mdc/public/page/2_3021-peyield.html",">Dow
> > Industrial",-1,"",1)
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

2a.

Re: Recording each and every price stamp in a new row from a stream

Posted by: "Farhan Ansari" farhan86a@gmail.com   farsdocs

Thu Oct 6, 2011 6:46 am (PDT)

..yeah Paul, but the fact is that I am from India and am working on Indian
markets. And we do not have technically competent data service providers
except the likes of Bloomberg or Thomson Reuters which are very expensive.
Even the brokers here shy away from technology. They have everything for the
big folks!

But I figured a way out of pretty much what I had intended to do and it got
me to record the data from streaming cells (with the help of someone so the
credit goes to him). I am posting the code here too for others' reference,
its a raw code and needs development from here on. Apologize if its not in
sync of the rules of this group.

Private Sub Worksheet_Calculate()
capturerow = 2
'is the row in which the data is streaming'

currow = Range("A65536").End(xlUp).Row

Cells(currow + 1, 1) = Cells(capturerow, 1)
Cells(currow + 1, 2) = Cells(capturerow, 2)
Cells(currow + 1, 3) = Cells(capturerow, 3)

End Sub

-F

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

3a.

RCH get web data and narrowing source data return

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

Thu Oct 6, 2011 3:50 pm (PDT)

Hi Randy,

I am trying to scrape/parse data from a php site. I saved the source code of the site to my desktop and I am using the RCHgetwebdata to pull the data into excel. The formula I am using is =RCHGetwebdata("C:\Users\Desktop\acquireEvents[1].txt",TICKER,) the formula works well, it pulls all the data I need (TICKER represents a range I defined in excel. The range contains a bunch of different symbols). The problem I ran into is the formula pulls / scrapes the data first displaying the information I request, and afterward it includes the entire source code eg. I request to scrape "RBN" in the source code, and RBN shows up in the corresponding cell, and than the entire source code afterwards. Can I add an element to my formula which will define an exact endpoint for my desired scrape / parsed data .

Thanks,
Elliot.

Back to top

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

3b.

Re: RCH get web data and narrowing source data return

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

Thu Oct 6, 2011 4:30 pm (PDT)

Check the documentation -- there is a parameter to limit the length of what
is returned.

On Thu, Oct 6, 2011 at 3:50 PM, futants46and2 <futants46and2@yahoo.com>wrote:

>
> I am trying to scrape/parse data from a php site. I saved the source code
> of the site to my desktop and I am using the RCHgetwebdata to pull the data
> into excel. The formula I am using is
> =RCHGetwebdata("C:\Users\Desktop\acquireEvents[1].txt",TICKER,) the formula
> works well, it pulls all the data I need (TICKER represents a range I
> defined in excel. The range contains a bunch of different symbols). The
> problem I ran into is the formula pulls / scrapes the data first displaying
> the information I request, and afterward it includes the entire source code
> eg. I request to scrape "RBN" in the source code, and RBN shows up in the
> corresponding cell, and than the entire source code afterwards. Can I add an
> element to my formula which will define an exact endpoint for my desired
> scrape / parsed data .
>

Back to top

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

3c.

Re: RCH get web data and narrowing source data return

Posted by: "Sill. Micheal" futants46and2@yahoo.com   futants46and2

Thu Oct 6, 2011 5:06 pm (PDT)

Yes,! it works.

Thanks you,
Elliot.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, October 6, 2011 7:30 PM
Subject: Re: [smf_addin] RCH get web data and narrowing source data return

 
Check the documentation -- there is a parameter to limit the length of what is returned.

On Thu, Oct 6, 2011 at 3:50 PM, futants46and2 <futants46and2@yahoo.com> wrote:

>I am trying to scrape/parse data from a php site. I saved the source code of the site to my desktop and I am using the RCHgetwebdata to pull the data into excel. The formula I am using is =RCHGetwebdata("C:\Users\Desktop\acquireEvents[1].txt",TICKER,) the formula works well, it pulls all the data I need (TICKER represents a range I defined in excel. The range contains a bunch of different symbols). The problem I ran into is the formula pulls / scrapes the data  first displaying the information I request, and afterward it includes the entire source code eg. I request to scrape "RBN" in the source code, and RBN shows up in the corresponding cell, and than the entire source code afterwards. Can I add an element to my formula which will define an exact endpoint for my desired scrape / parsed data .
>

Back to top

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

Recent Activity

•  81
  New Members

Visit Your Group

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New business?

Get new customers.

List your web site

in Yahoo! Search.

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

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

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