Senin, 12 Maret 2012

[smf_addin] Digest Number 2144

Messages In This Digest (5 Messages)

Messages

1a.

Simple question re: Extracting Data froma Web Site

Posted by: "Pankaj" yahooprofileagarwal_p@pankaj.ca   agarwal_p

Sun Mar 11, 2012 10:21 am (PDT)



Sorry, guys, I'm a complete neophyte to programming, though good with Excel, and loving this Addin, hence the many questions!

In the following question, how do I replace kors with the cell reference for kors e.g. A11?

=RCHGetTableCell("http://finviz.com/quote.ashx?t=kors",1,">SMA50")

Thanks!
Pankaj

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Pretty straight-forward for the data they have. For example:
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">Price")
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">Volume")
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">Beta")
>
> But they don't show open price as textual data that I can see -- only placed
> in the chart image.
>
> On Thu, Dec 17, 2009 at 6:57 PM, davey_11372 <davey_11372@...> wrote:
>
> > Can anyone give me some guidelines as to how I could use the smf add-in or
> > one of the templates to extract data from the following site.
> >
> > finviz.com
> >
> > On the main page, on the right side, once you type in a ticker, it takes
> > you to the page with charts/data for the specific stock. Below the chart
> > area is a table with various statistics. How can I create a template so that
> > I could download/import data to the following layout in excel:
> >
> > column A = Ticker
> > B = Open Price
> > C = Close Price
> > D = Volume
> > E = Beta
> >
> > ...
> > and so on.
> >
> > Like Yahoo, but it gives some data that yahoo does not.
> >
> > Something similar to the smfGetYahooHistory-Template.xls (in the
> > Files\SMFLite folder) available in here.
> >
>

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

Re: Simple question re: Extracting Data froma Web Site

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Sun Mar 11, 2012 10:35 am (PDT)



try
=RCHGetTableCell(http://finviz.com/quote.ashx?t="&range("a11")&''",1,">SMA50")

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@gmail.com

From: Pankaj
Sent: Sunday, March 11, 2012 12:21 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Simple question re: Extracting Data froma Web Site

Sorry, guys, I'm a complete neophyte to programming, though good with Excel, and loving this Addin, hence the many questions!

In the following question, how do I replace kors with the cell reference for kors e.g. A11?

=RCHGetTableCell("http://finviz.com/quote.ashx?t=kors",1,">SMA50")

Thanks!
Pankaj

--- In mailto:smf_addin%40yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Pretty straight-forward for the data they have. For example:
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">Price")
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">Volume")
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=MMM",1,">Beta")
>
> But they don't show open price as textual data that I can see -- only placed
> in the chart image.
>
> On Thu, Dec 17, 2009 at 6:57 PM, davey_11372 <davey_11372@...> wrote:
>
> > Can anyone give me some guidelines as to how I could use the smf add-in or
> > one of the templates to extract data from the following site.
> >
> > finviz.com
> >
> > On the main page, on the right side, once you type in a ticker, it takes
> > you to the page with charts/data for the specific stock. Below the chart
> > area is a table with various statistics. How can I create a template so that
> > I could download/import data to the following layout in excel:
> >
> > column A = Ticker
> > B = Open Price
> > C = Close Price
> > D = Volume
> > E = Beta
> >
> > ...
> > and so on.
> >
> > Like Yahoo, but it gives some data that yahoo does not.
> >
> > Something similar to the smfGetYahooHistory-Template.xls (in the
> > Files\SMFLite folder) available in here.
> >
>

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

Re: Simple question re: Extracting Data froma Web Site

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

Sun Mar 11, 2012 12:08 pm (PDT)



Nothing to do with programming or the add-in -- just a normal EXCEL string
concatenation:

=RCHGetTableCell("http://finviz.com/quote.ashx?t="&A11,1,">SMA50")

On Sun, Mar 11, 2012 at 10:21 AM, Pankaj <yahooprofileagarwal_p@pankaj.ca>wrote:

> Sorry, guys, I'm a complete neophyte to programming, though good with
> Excel, and loving this Addin, hence the many questions!
>
> In the following question, how do I replace kors with the cell reference
> for kors e.g. A11?
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t=kors",1,">SMA50")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (16)
2a.

Re: New but interesting question

Posted by: "whitney" thelancour@yahoo.com   thelancour

Sun Mar 11, 2012 4:04 pm (PDT)



IS there anyway to get a value from a link? for instance http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev if you click on Act. Year Built it will pop up a cell value in a window. CAn smf do anything to gain this value? have a look and see what you think

--- In smf_addin@yahoogroups.com, "whitney" <thelancour@...> wrote:
>
> Is there a way to get the value in a link from the table cell? For example if you look at the page we have been using as reference,
>
> --- In smf_addin@yahoogroups.com, "dguillett1" <dguillett1@> wrote:
> >
> > I had a similar problem with and external query macro where Yahoo seems to be moving things around a LOT. Where I had been looking for “(“ with a fixed number or rows below to get the current price (using that instead of tag since getting many things from page). They changed from 4 rows down to 3. They changed it from a week or so earlier. So, I have resorted to to loop looking for the next cell with any number. Hopefully, I can now not have to change often depending on what they do.
> > =================
> > Spectra Energy Partners, LP Com (SEP) Finding this
> >
> > -NYSE
> > 31.24 Down0.35(1.11%) 4:02PM EST Looking down to here was 4 now 3
> >
> > ============================
> > Set coname = .Columns(1).Find(What:="(" & c, LookIn:=xlValues, LookAt:=xlPart, _
> > SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)
> > If Not coname Is Nothing Then
> > c.Offset(, 2).Value = Left(coname, InStr(coname, "(") - 1)’gets co name wo symbol
> > 'current price look in the next 10 rows
> >
> > For i = coname.Row To coname.Row + 10
> > If Left(.Cells(i, 1), 1) Like "[0-9]" Then
> > pricerow = i
> > Exit For
> > End If
> > Next i
> >
> > 'c.Offset(, 3).Value = Left(coname.Offset(3), InStr(coname.Offset(3), " ")) OLD
> > c.Offset(, 3) = Left(.Cells(pricerow, 1), InStr(.Cells(pricerow, 1), " ")) ’NEW
> > ‘=========
> > Don Guillett
> > SalesAid Software
> > dguillett1@
> >
> > From: Randy H
> > Sent: Friday, February 10, 2012 7:47 PM
> > To: smf_addin@yahoogroups.com
> > Subject: [smf_addin] Re: New but interesting question
> >
> >
> > Typically, that's what you would do. However, the problem is that the table is not coded properly in HTML. They have tags for the end of the row, but not to start the next row. If you go to the land calculation table there is a cell that says "Act. Year Built", well the only way to get the value is to click the on Act. Year Built which promps a pop up that states the year. Is there anyway to extract this with SMF add in? FYI the year is 1955. Thanks.
>
>
>
>
>
> >
> > A workaround would be to use something like:
> >
> > =smfGetTagContent("http://www.bcpa.net/RecInfo.asp?URL_Folio=514112040270","span",_n_,"Subdivision Sales","Page")
> >
> > ...where you would vary _n_ from 1 to whatever to get the next table cell, ignoring how the rows of the table are coded.
> >
> >
> >
> > On Fri, Feb 10, 2012 at 6:31 PM, whitney <thelancour@> wrote:
> >
> > thank you. If I want to go for earlier sale dates is it as simple as changing the last digit to a 2 or 3 for 2nd and 3rd row respectively? Seems to be giving me an error.......
> >
>

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

Re: New but interesting question

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

Sun Mar 11, 2012 6:08 pm (PDT)



You should be able to get the two "Year Built" values with:

=0+smfStrExtr(smfGetTagContent("
http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev","td",-1,"Year
Built"),"theyear=","'")

=0+smfStrExtr(smfStrExtr(smfGetTagContent("
http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev","td",-1,"Year
Built"),"Year Built","Year Built"),"theyear=","'")

On Sun, Mar 11, 2012 at 4:04 PM, whitney <thelancour@yahoo.com> wrote:

> IS there anyway to get a value from a link? for instance
> http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev if you
> click on Act. Year Built it will pop up a cell value in a window. CAn smf
> do anything to gain this value? have a look and see what you think
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
Recent Activity
Visit Your Group
Yahoo! News

Odd News

You won't believe

it, but it's true

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)