Selasa, 14 Februari 2012

[smf_addin] Digest Number 2114

Messages In This Digest (11 Messages)

1a.
Re: New but interesting question From: whitney
2a.
AdvFN and UK Stocks From: paul84j
2b.
Re: AdvFN and UK Stocks From: Steven Sun
2c.
Re: AdvFN and UK Stocks From: paul84j
2d.
Re: AdvFN and UK Stocks From: Mike McQuaid
2e.
Re: AdvFN and UK Stocks From: Randy Harmelink
2f.
Re: AdvFN and UK Stocks From: Randy Harmelink
2g.
Re: AdvFN and UK Stocks From: Randy Harmelink
2h.
Re: AdvFN and UK Stocks From: Mike McQuaid
2i.
Re: AdvFN and UK Stocks From: paul84j
3.
Income Statement Waterfall Chart From: Randy Harmelink

Messages

1a.

Re: New but interesting question

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

Mon Feb 13, 2012 8:36 am (PST)



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

2a.

AdvFN and UK Stocks

Posted by: "paul84j" paul84j@yahoo.ie   paul84j

Mon Feb 13, 2012 10:55 am (PST)



Is anybody else finding that the LSE: ticker prefix for getting UK stock data from the AdvFN site no longer works?

Has anybody found a workaround to get this data?

Thanks,
Paul.

2b.

Re: AdvFN and UK Stocks

Posted by: "Steven Sun" ssun24cd@gmail.com   ssun_tdam

Mon Feb 13, 2012 11:01 am (PST)



use http://money.msn.com/.

Steveo

On Mon, Feb 13, 2012 at 1:55 PM, paul84j <paul84j@yahoo.ie> wrote:

> **
>
>
> Is anybody else finding that the LSE: ticker prefix for getting UK stock
> data from the AdvFN site no longer works?
>
> Has anybody found a workaround to get this data?
>
> Thanks,
> Paul.
>
>
>
2c.

Re: AdvFN and UK Stocks

Posted by: "paul84j" paul84j@yahoo.ie   paul84j

Mon Feb 13, 2012 11:09 am (PST)



Thanks for reply but I find that the MSN data is not as comprehensive as that offered by AdvFN. Their site still has the data, it's just that the LSE: prefix is returning "Error". There must be some way to get it.

--- In smf_addin@yahoogroups.com, Steven Sun <ssun24cd@...> wrote:
>
> use http://money.msn.com/.
>
> Steveo
>
> On Mon, Feb 13, 2012 at 1:55 PM, paul84j <paul84j@...> wrote:
>
> > **
> >
> >
> > Is anybody else finding that the LSE: ticker prefix for getting UK stock
> > data from the AdvFN site no longer works?
> >
> > Has anybody found a workaround to get this data?
> >
> > Thanks,
> > Paul.
> >
> >
> >
>

2d.

Re: AdvFN and UK Stocks

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Mon Feb 13, 2012 12:02 pm (PST)



They don't work for me either.

I tried LSE:TRI for Trifast and get all errors thru SMF. Probably because
the web page on www.AdvFN.com for its financials looks very different than
provided for US exhange companies.

I can't say I ever tried an LSE:ticker before. But, the financial data
looks the same whether you go through uk.advfn.com or www.advfn.com.

It seems that if Randy doesn't do some magic with GetAdvFNElement you might
need to use smfGetTagContent or smfGetTable or GetTableCell instead.


_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of paul84j
Sent: Monday, February 13, 2012 2:09 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: AdvFN and UK Stocks

Thanks for reply but I find that the MSN data is not as comprehensive as
that offered by AdvFN. Their site still has the data, it's just that the
LSE: prefix is returning "Error". There must be some way to get it.

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Steven Sun <ssun24cd@...> wrote:
>
> use http://money.msn.com/.
>
> Steveo
>
> On Mon, Feb 13, 2012 at 1:55 PM, paul84j <paul84j@...> wrote:
>
> > **
> >
> >
> > Is anybody else finding that the LSE: ticker prefix for getting UK stock
> > data from the AdvFN site no longer works?
> >
> > Has anybody found a workaround to get this data?
> >
> > Thanks,
> > Paul.
> >
> >
> >
>

2e.

Re: AdvFN and UK Stocks

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

Mon Feb 13, 2012 12:37 pm (PST)



I looked at a half-dozen or so London exchange companies and didn't see a
single one with quarterly and annual financial statements data. Without
those web pages, the add-in would never be able to retrieve the data.

If that's true for all LSE stocks, you'd need to find a different source of
the data...

On Mon, Feb 13, 2012 at 11:55 AM, paul84j <paul84j@yahoo.ie> wrote:

> Is anybody else finding that the LSE: ticker prefix for getting UK stock
> data from the AdvFN site no longer works?
>
> Has anybody found a workaround to get this data?
>
2f.

Re: AdvFN and UK Stocks

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

Mon Feb 13, 2012 12:37 pm (PST)



Can you point me to a ticker symbol that DOES have the data? I couldn't
find an example.

On Mon, Feb 13, 2012 at 12:09 PM, paul84j <paul84j@yahoo.ie> wrote:

> Thanks for reply but I find that the MSN data is not as comprehensive as
> that offered by AdvFN. Their site still has the data, it's just that the
> LSE: prefix is returning "Error". There must be some way to get it.
>
2g.

Re: AdvFN and UK Stocks

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

Mon Feb 13, 2012 12:40 pm (PST)



I don't see any LSE:TRI quarterly or annual financial statements web pages,
so smfGetAdvFNElement() would always return "Error" for anything that is
requested...

On Mon, Feb 13, 2012 at 1:03 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

> **
>
> They don't work for me either.
>
> I tried LSE:TRI for Trifast and get all errors thru SMF. Probably because
> the web page on www.AdvFN.com for its financials looks very different
> than provided for US exhange companies.
>
> I can't say I ever tried an LSE:ticker before. But, the financial data
> looks the same whether you go through uk.advfn.com or www.advfn.com.
>
> It seems that if Randy doesn't do some magic with GetAdvFNElement you
> might need to use smfGetTagContent or smfGetTable or GetTableCell instead.
>
2h.

Re: AdvFN and UK Stocks

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Mon Feb 13, 2012 12:51 pm (PST)



Agreed. But, there was some limited annual financial data so it seems you
could have GetAdvFnElement and GetElement return just the bits it could find
(with their unique search terms) or perhaps create a GetUKAdvFnElement
function dedicated for that purpose. That would be the "magic" I eluded to
:)

Probably easier just to have folks use the GetTable... or GetTag..
functions.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Monday, February 13, 2012 3:41 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: AdvFN and UK Stocks

I don't see any LSE:TRI quarterly or annual financial statements web pages,
so smfGetAdvFNElement() would always return "Error" for anything that is
requested...

On Mon, Feb 13, 2012 at 1:03 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

They don't work for me either.

I tried LSE:TRI for Trifast and get all errors thru SMF. Probably because
the web page on www.AdvFN.com for its financials looks very different than
provided for US exhange companies.

I can't say I ever tried an LSE:ticker before. But, the financial data
looks the same whether you go through uk.advfn.com or www.advfn.com.

It seems that if Randy doesn't do some magic with GetAdvFNElement you might
need to use smfGetTagContent or smfGetTable or GetTableCell instead.

2i.

Re: AdvFN and UK Stocks

Posted by: "paul84j" paul84j@yahoo.ie   paul84j

Mon Feb 13, 2012 1:54 pm (PST)



Thanks again for the replies Randy and all, it's appreciated.

AdvFN have a banner on their UK website which invites users to "View Our New Historical Fundamentals" and clicking brings you to a subscription page where the different offerings and prices are set out, so I guess that answers the question...

It does seem to be a new development because for some time previously I was getting the info I was looking for returned from AdvFN using the RCHGetElementNumber function for UK co's...

I'll start working on my Plan B!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I looked at a half-dozen or so London exchange companies and didn't see a
> single one with quarterly and annual financial statements data. Without
> those web pages, the add-in would never be able to retrieve the data.
>
> If that's true for all LSE stocks, you'd need to find a different source of
> the data...
>
> On Mon, Feb 13, 2012 at 11:55 AM, paul84j <paul84j@...> wrote:
>
> > Is anybody else finding that the LSE: ticker prefix for getting UK stock
> > data from the AdvFN site no longer works?
> >
> > Has anybody found a workaround to get this data?
> >
>

3.

Income Statement Waterfall Chart

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

Tue Feb 14, 2012 1:49 am (PST)



An interesting blog entry on creating some financial statement charts in
EXCEL:

http://www.dailydoseofexcel.com/archives/2012/02/10/income-statement-waterfall-chart/
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Search Ads

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

Tidak ada komentar:

Posting Komentar