Senin, 16 Januari 2012

[smf_addin] Digest Number 2079

Messages In This Digest (25 Messages)

Messages

1a.

Re: [Bulk] Re: [smf_addin] Don't Know What Happened

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

Mon Jan 16, 2012 11:29 am (PST)



Oh, the yfs_l84 string has a lower case L before the 84 (on my computer
lower case "L" and upper case "i" look identical).

_____

From: Mike McQuaid [mailto:mikemcq802@yahoo.com]
Sent: Monday, January 16, 2012 2:27 PM
To: 'smf_addin@yahoogroups.com'
Subject: RE: [Bulk] Re: [smf_addin] Don't Know What Happened

Um, RCHGetYahooQuotes? See Randy's doc.

Or, smfGetTagContent. Also see Randy's docs.

Example for AAPL:

=smfGetTagContent("http://finance.yahoo.com/q?s=AAPL","span",0,"yfs_l84
<http://finance.yahoo.com/q?s=AAPL> ")

There are other "last prices" available from various providers accessible
through RCHGetElementNumber. MSN is 25, if I remember right. See the
ElementDefinitions in your SMF install directory.

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Ron Daring
Sent: Monday, January 16, 2012 1:56 PM
To: smf_addin@yahoogroups.com
Subject: [Bulk] Re: [smf_addin] Don't Know What Happened

Hi all,

Has anyone discovered a solution to this change to the Yahoo Summary page,
yet?

I was using "RCHGetTableCell("http://finance.yahoo.com/q?s=~~~~~",1,"
<http://finance.yahoo.com/q?s=~~~~~> >Last Trade")" in my lookup tables just
fine for months, but it broke when Yahoo deleted the "Last Trade" from their
Summary page. Since then, I havn't been able to use anything similar on any
financial site to get the current price. At this point, I would be happy to
get it from any site. I just need to replace a formula for that 1 column.
Everything else still works.

Thanks in advance,

Ron

From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Sunday, January 15, 2012 1:02 PM
Subject: Re: [smf_addin] Don't Know What Happened

Nothing happened to the add-in or the VBA code.

What happened is that Yahoo changed the format of their summary page -- it
no longer has a table entry for "Last Trade:".

On Sun, Jan 15, 2012 at 1:52 PM, laurancehill <lohill@cox.net> wrote:

Randy,
I have done something to my Excel or to my installation of the SMF_addin
that has caused the addin to cease giving me values. Here is a function
that has worked for me without fail for at least four years and as of last
friday it stopped working. In the function the array aYdata is global.
Going back over it has shown me some faults but the fact is that it has
worked in the past.

Public Function GetAPrice(sTicker As String) As Boolean
'Takes a passed Ticker and retrieves a global array (aYdata) of Yahoo
data
'aYdata(0) = Ticker (s)
'aYdata(1) = Last Price (l1) el-one
'aYdata(2) = Dividend/Share (d)
'aYdata(3) = Stock Name (n)

Dim sURL, sData As String
Dim nPos As Integer

sURL = "http://finance.yahoo.com/q?s=" + sTicker
sData = RCHGetTableCell(sURL, 1, "Trade:")
If sData = "Error" Then
sData = RCHGetTableCell(sURL, 1, "Net Asset Value:")
End If
aYdata(1) = sData
sData = RCHGetTableCell(sURL, 1, "Yield:")
If InStr(1, sData, "Error") = 0 And InStr(1, sData, "N/A") = 0 Then
nPos = InStr(1, sData, "(")
aYdata(2) = Left(sData, nPos - 1)
Else
aYdata(2) = "0"
End If
If aYdata(1) = "" Then
GetAPrice = False
Else
GetAPrice = True
End If
End Function

In stepping back through the code the first call to the addin causes sData
to be "Error", the second call causes it to be "Error" and the last gets
"N/A (N/A)"

I have reinstalled the latest version of the addin and have tested it by
setting a cell of Excel to "RCHGetElementNumber("AAPL",25)" and it gave the
correct answer. I assume that lets me know the adding is working correctly.
Do you have any clue as to what might be going on?

I am using Excel which I think is 2007. At least that is what the help
says. This is in Windows 7 but under Parallels on a Macintosh (10.7.2). It
has been in Parallels for at least two years.

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

Re: [Bulk] Re: [smf_addin] Don't Know What Happened

Posted by: "Laurance Hill" lohill@cox.net   laurancehill

Mon Jan 16, 2012 11:56 am (PST)



Since all I wanted was last price and dividend and MSN was oK for me, I changed my function to:

Public Function GetAPrice(sTicker As String) As Boolean
'Takes a passed Ticker and retrieves a global array (aYdata) of Yahoo data
'aYdata(0) = Ticker (s)
'aYdata(1) = Last Price (l1) el-one
'aYdata(2) = Dividend/Share (d)
'aYdata(3) = Stock Name (n)

Dim sURL, sData As String
Dim nPos As Integer

If sTicker <> "VFINX" Then
sData = RCHgetElementNumber(sTicker, 25)
If sData = "Error" Then
GetAPrice = False
aYdata(1) = 0
Else
If sData > 0 Then
aYdata(1) = sData
sData = RCHgetElementNumber(sTicker, 46)
If sData = "Error" Then
aYdata(2) = 0
Else
If sData = "NA" Then
aYdata(2) = 0
Else
aYdata(2) = sData
End If
GetAPrice = True
End If
Else
GetAPrice = False
End If
End If
Else
sURL = "http://finance.yahoo.com/q?s=" + sTicker
sData = RCHGetTableCell(sURL, 1, "Prev Close:")
aYdata(1) = sData
aYdata(2) = 0
GetAPrice = True
End If
End Function

The 'crazy' bit about "VFINX" is because it is my benchmark and RCHgetElementNumber would not get it.

We'll see how this goes once the market is back.
Larry
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
1c.

Re: [Bulk] Re: [smf_addin] Don't Know What Happened

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

Mon Jan 16, 2012 12:17 pm (PST)



FYI -- upper and lower case on search strings only make a difference with
the RCHGetWebData() function.

On Mon, Jan 16, 2012 at 12:30 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

> **
>
> Oh, the yfs_l84 string has a lower case L before the 84 (on my computer
> lower case "L" and upper case "i" look identical).
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (10)
2a.

Randy, how do i extract single closing price of mutual fund X days a

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

Mon Jan 16, 2012 11:56 am (PST)



Hello Randy,

Is there a way I can extract the closing price of a mutual fund x trading days ago, just that one close?..like say, 63 days ago? Thanks.

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

Re: Randy, how do i extract single closing price of mutual fund X da

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

Mon Jan 16, 2012 12:04 pm (PST)



See docs for RCHGetYahooHistory

Set your start and end dates to just the single date you want

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of investor952
Sent: Monday, January 16, 2012 2:57 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Randy, how do i extract single closing price of mutual
fund X days ago

Hello Randy,

Is there a way I can extract the closing price of a mutual fund x trading
days ago, just that one close?..like say, 63 days ago? Thanks.

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

Re: Randy, how do i extract single closing price of mutual fund X da

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

Mon Jan 16, 2012 12:19 pm (PST)



RCHGetYahooHistory() is one way to go, but you need to specify an actual
trading day, or it will return blanks.

I typically use smfPricesByDates() when I want a particular closing price,
but it only returns adjusted prices, which some people don't like. But this
function will give you the adjusted closing price from the last date the
stock traded if you don't give it a valid trading day (just carrying it
forward).

On Mon, Jan 16, 2012 at 12:56 PM, investor952 <investor952@yahoo.com> wrote:

>
> Is there a way I can extract the closing price of a mutual fund x trading
> days ago, just that one close?..like say, 63 days ago? Thanks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

Managing with Excel Arrays

Posted by: "Ashish" ashishkm@yahoo.com   ashishkm

Mon Jan 16, 2012 1:34 pm (PST)



I understand the benefit of using Arrays with SMF Add-in functions like RCHGetYahooQuotes() or smfGetOptionQuotes() but I find it quite cumbersome to manage a large array which, from time to time, needs quite a few rows to be deleted (for example at option expirations) ... o if I need to sort the array based on certain parameters based outside of the array .... it is entirely possible that I do not know some of the tricks that might exist .... any suggestions? ... thanks in advance ....

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

Re: Managing with Excel Arrays

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

Mon Jan 16, 2012 3:39 pm (PST)



Actually, there is no real advantage to array-entering smfGetOptionQuotes()
-- it uses an individual RCHGetTableCell() function to actually retrieve
each data item. I just allowed it to be array-entered so it was consistent
with how RCHGetYahooQuotes() was entered.

Otherwise, for RCHGetYahooQuotes() and smfGetOptionQuotes(), you just need
to sort the ticker symbols (based on whatever sort you want). The
array-entered data would just recalculate. But that does require you to
have the sort field outside of the array, as it sounds like you are already
doing.

On Mon, Jan 16, 2012 at 2:34 PM, Ashish <ashishkm@yahoo.com> wrote:

> I understand the benefit of using Arrays with SMF Add-in functions like
> RCHGetYahooQuotes() or smfGetOptionQuotes() but I find it quite cumbersome
> to manage a large array which, from time to time, needs quite a few rows to
> be deleted (for example at option expirations) ... o if I need to sort the
> array based on certain parameters based outside of the array .... it is
> entirely possible that I do not know some of the tricks that might exist
> .... any suggestions? ... thanks in advance ....
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4.1.

Stock Screener

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

Mon Jan 16, 2012 1:38 pm (PST)



I'm looking to set up a stock screener that reports all equities whose 50 Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented something like this?

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.2.

Re: Stock Screener

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

Mon Jan 16, 2012 1:58 pm (PST)



use rchgetelementnumber() and field 977 and 978.

Stevo

On Mon, Jan 16, 2012 at 4:38 PM, lewglenn <lewglenn@yahoo.com> wrote:

> **
>
>
> I'm looking to set up a stock screener that reports all equities whose 50
> Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented
> something like this?
>
> Thanks.
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.3.

Re: Stock Screener

Posted by: "Lew Glenn" lewglenn@yahoo.com   lewglenn

Mon Jan 16, 2012 2:51 pm (PST)



This will get me the 50- and 200-day SMA for a specified ticker symbol. But is there a way to loop on the function for all ticker symbols listed on the NYSE or NASDAQ for example?

________________________________
From: Steven Sun <ssun24cd@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Monday, January 16, 2012 1:58 PM
Subject: Re: [smf_addin] Stock Screener


 
use rchgetelementnumber() and field 977 and 978.

Stevo

On Mon, Jan 16, 2012 at 4:38 PM, lewglenn <lewglenn@yahoo.com> wrote:

> 
>I'm looking to set up a stock screener that reports all equities whose 50 Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented something like this?
>
>Thanks.
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.4.

Re: Stock Screener

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

Mon Jan 16, 2012 3:04 pm (PST)



Get a full list of stock symbols by yourself and use excel to do a quick
math on current price along with the two fields- i.e. % of price deviation
from 50-day and 200-day MAs.

On Mon, Jan 16, 2012 at 5:51 PM, Lew Glenn <lewglenn@yahoo.com> wrote:

> **
>
>
> This will get me the 50- and 200-day SMA for a specified ticker symbol.
> But is there a way to loop on the function for all ticker symbols listed on
> the NYSE or NASDAQ for example?
>
> ------------------------------
> *From:* Steven Sun <ssun24cd@gmail.com>
> *To:* smf_addin@yahoogroups.com
> *Sent:* Monday, January 16, 2012 1:58 PM
> *Subject:* Re: [smf_addin] Stock Screener
>
>
> use rchgetelementnumber() and field 977 and 978.
>
> Stevo
>
> On Mon, Jan 16, 2012 at 4:38 PM, lewglenn <lewglenn@yahoo.com> wrote:
>
> **
>
> I'm looking to set up a stock screener that reports all equities whose
> 50 Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented
> something like this?
>
> Thanks.
>
>
>
>
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.5.

Re: Stock Screener

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

Mon Jan 16, 2012 3:23 pm (PST)



There is also the problem of the add-in limiting to 1000 pages in one
session (I think that's the right number).

There are far more than 1000 listed stocks in the US.

So, you'd also have to break up the ticker list into separate spreadsheets
of no more than 1000 and exit Excel and restart for each one.
smfForceRecalc won't reset the max.

My broker, Schwab, has the 50/200 SMA crossover as one of the elements in
their screening tool - you can even choose bullish or bearish. They have
various other technical indicators too. You can run the screener and export
the results (coincidentally also max of 1000 tickers at once). That could
be a starting point for a reasonable list of tickers. Perhaps your broker
has something like this too?

There's a bit of manual effort involved so doing this daily might be
tedious. But, trying to retrieve and analyze 1000's of pages with the
add-in daily isn't what it was designed for either. Randy has limited it so
people don't abuse the free services available.


_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Steven Sun
Sent: Monday, January 16, 2012 6:05 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Stock Screener

Get a full list of stock symbols by yourself and use excel to do a quick
math on current price along with the two fields- i.e. % of price deviation
from 50-day and 200-day MAs.

On Mon, Jan 16, 2012 at 5:51 PM, Lew Glenn <lewglenn@yahoo.com> wrote:

This will get me the 50- and 200-day SMA for a specified ticker symbol. But
is there a way to loop on the function for all ticker symbols listed on the
NYSE or NASDAQ for example?

_____

From: Steven Sun <ssun24cd@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Monday, January 16, 2012 1:58 PM
Subject: Re: [smf_addin] Stock Screener

use rchgetelementnumber() and field 977 and 978.

Stevo

On Mon, Jan 16, 2012 at 4:38 PM, lewglenn <lewglenn@yahoo.com> wrote:

I'm looking to set up a stock screener that reports all equities whose 50
Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented
something like this?

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.6.

Re: Stock Screener

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

Mon Jan 16, 2012 3:33 pm (PST)



DO NOT do something like that. Creating a screener requires creating a
massive database. I DON'T want people misusing the free data sources for
something like. It would be so easy for them to change their web sites so
the add-in could no longer access their data.

The typical process should be to use existing screeners to winnow down your
choice of stocks to a manageable few, then to use the add-in to gather more
detailed information on those few stocks.

Comparing SMA's is a trivial task for several of the cheaper screeners out
there (StockFetcher, StockScreen123, etc). Even the free screener, FinViz,
whose output can be retrieved using the add-in (see the "Links" area of the
group for more info) can do it directly on the 50-day and 200-day SMAs.

PS: Yahoo uses calendar days instead of trading days for their 50-day and
200-day numbers.

On Mon, Jan 16, 2012 at 2:38 PM, lewglenn <lewglenn@yahoo.com> wrote:

> I'm looking to set up a stock screener that reports all equities whose 50
> Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented
> something like this?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.7.

Re: Stock Screener

Posted by: "Lew Glenn" lewglenn@yahoo.com   lewglenn

Mon Jan 16, 2012 5:12 pm (PST)



The math is trivial. Getting the list isn't. And then, even assuming I had the list, calling rchgetelementnumber() for each element in the list would mean a very large number of separate web calls. I'm thinking there must be a more efficient way to do this. But, thanks for your input.

________________________________
From: Steven Sun <ssun24cd@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Monday, January 16, 2012 3:04 PM
Subject: Re: [smf_addin] Stock Screener


 
Get a full list of stock symbols by yourself and use excel to do a quick math on current price along with the two fields- i.e. % of price deviation from 50-day and 200-day MAs.

On Mon, Jan 16, 2012 at 5:51 PM, Lew Glenn <lewglenn@yahoo.com> wrote:

> 
>This will get me the 50- and 200-day SMA for a specified ticker symbol. But is there a way to loop on the function for all ticker symbols listed on the NYSE or NASDAQ for example?
>
>
>
>
>________________________________
> From: Steven Sun <ssun24cd@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Monday, January 16, 2012 1:58 PM
>Subject: Re: [smf_addin] Stock Screener
>
>
>
> 
>use rchgetelementnumber() and field 977 and 978.
>
>Stevo
>
>
>On Mon, Jan 16, 2012 at 4:38 PM, lewglenn <lewglenn@yahoo.com> wrote:
>
>
>> 
>>I'm looking to set up a stock screener that reports all equities whose 50 Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented something like this?
>>
>>Thanks.
>>
>>
>
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.8.

Re: Stock Screener

Posted by: "Lew Glenn" lewglenn@yahoo.com   lewglenn

Mon Jan 16, 2012 5:13 pm (PST)



OK, thanks. I won't abuse the system.

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Monday, January 16, 2012 3:33 PM
Subject: Re: [smf_addin] Stock Screener


 
DO NOT do something like that. Creating a screener requires creating a massive database. I DON'T want people misusing the free data sources for something like. It would be so easy for them to change their web sites so the add-in could no longer access their data.

The typical process should be to use existing screeners to winnow down your choice of stocks to a manageable few, then to use the add-in to gather more detailed information on those few stocks.

Comparing SMA's is a trivial task for several of the cheaper screeners out there (StockFetcher, StockScreen123, etc). Even the free screener, FinViz, whose output can be retrieved using the add-in (see the "Links" area of the group for more info) can do it directly on the 50-day and 200-day SMAs.

PS: Yahoo uses calendar days instead of trading days for their 50-day and 200-day numbers.

On Mon, Jan 16, 2012 at 2:38 PM, lewglenn <lewglenn@yahoo.com> wrote:

I'm looking to set up a stock screener that reports all equities whose 50 Day SMA exceeds its 200 Day SMA. Has anyone in this group implemented something like this?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
4.9.

Re: Stock Screener

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

Mon Jan 16, 2012 5:21 pm (PST)



Do take a look at the FinViz process. Once you've created the screen and
know the URL parameters, you can either export the data directly from
FinViz each time you need it, or use the add-in to retrieve the CSV file
any time you want.

On Mon, Jan 16, 2012 at 6:13 PM, Lew Glenn <lewglenn@yahoo.com> wrote:

>
> OK, thanks. I won't abuse the system.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (31)
5a.

Re: problem with smfGetADVFNElement

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

Mon Jan 16, 2012 2:05 pm (PST)



Because smfGetAdvFNElement works much better!

Thnxs Randy i go for the header;)

--- In smf_addin@yahoogroups.com, "Mike McQuaid" <mikemcq802@...> wrote:
>
> Can't you just use the RCHGetElementNumber function for that? Elements 5406
> and 6716 for the deprec from last annual stmt, for example?
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
> Of antonvanas1989
> Sent: Sunday, January 15, 2012 6:14 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: problem with smfGetADVFNElement
>
>
>
>
> thnxs didnt see that.
>
> another issue found, depreciation is two times listed but how i get both?
> (income statement / cashflow statement)
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
> Randy Harmelink <rharmelink@> wrote:
> >
> > That particular label looks like:
> >
> > >pre-tax income <
> >
> > ...instead of the normal:
> >
> > >pre-tax income<
> >
> > (note the blank before the less than sign)
> >
> > Just add a blank to the end of your "pre-tax income" label.
> >
> > On Sun, Jan 15, 2012 at 4:55 AM, antonvanas1989 <antonvanas1989@>wrote:
> >
> > >
> > > one line from smfGetADVFNElement is not working..
> > >
> > > pre-tax income is result (--) while all other lines from advfn are
> fine..
> > >
> > > Whats the problem?
> > >
> > > Formula used: =IF(UPPER($C$3)="
> > > ";"--";smfGetADVFNElement($C$3;"A";COLUMNS($D:D);">"&$C34&"<";;"--"))
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
>

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

Re: problem with smfGetADVFNElement

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

Mon Jan 16, 2012 2:54 pm (PST)



How is this:

=RCHGetAdvFNElement("IBM","A",1,"Net Cash from Total Operating Activities")

better than this?

=RCHGetElementNumber("IBM",6855)

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of antonvanas1989
Sent: Monday, January 16, 2012 5:05 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: problem with smfGetADVFNElement

Because smfGetAdvFNElement works much better!

Thnxs Randy i go for the header;)

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"Mike McQuaid" <mikemcq802@...> wrote:
>
> Can't you just use the RCHGetElementNumber function for that? Elements
5406
> and 6716 for the deprec from last annual stmt, for example?
>
> _____
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
> Of antonvanas1989
> Sent: Sunday, January 15, 2012 6:14 PM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: [smf_addin] Re: problem with smfGetADVFNElement
>
>
>
>
> thnxs didnt see that.
>
> another issue found, depreciation is two times listed but how i get both?
> (income statement / cashflow statement)
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
<mailto:smf_addin%40yahoogroups.com> ,
> Randy Harmelink <rharmelink@> wrote:
> >
> > That particular label looks like:
> >
> > >pre-tax income <
> >
> > ...instead of the normal:
> >
> > >pre-tax income<
> >
> > (note the blank before the less than sign)
> >
> > Just add a blank to the end of your "pre-tax income" label.
> >
> > On Sun, Jan 15, 2012 at 4:55 AM, antonvanas1989 <antonvanas1989@>wrote:
> >
> > >
> > > one line from smfGetADVFNElement is not working..
> > >
> > > pre-tax income is result (--) while all other lines from advfn are
> fine..
> > >
> > > Whats the problem?
> > >
> > > Formula used: =IF(UPPER($C$3)="
> > > ";"--";smfGetADVFNElement($C$3;"A";COLUMNS($D:D);">"&$C34&"<";;"--"))
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > >
> >
>

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

Re: problem with smfGetADVFNElement

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

Mon Jan 16, 2012 3:41 pm (PST)



To tell the truth, I prefer the first -- it's self-documenting.

I almost got rid of the RCHGetElementNumber() function after I wrote
RCHGetTableCell().

On Mon, Jan 16, 2012 at 3:55 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

> **
>
> How is this:
>
> =RCHGetAdvFNElement("IBM","A",1,"Net Cash from Total Operating Activities")
>
> better than this?
>
> =RCHGetElementNumber("IBM",6855)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
5d.

Re: problem with smfGetADVFNElement

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

Mon Jan 16, 2012 3:55 pm (PST)



Except that ElementNumber has the find strings externalized. So, when
changes occur it's easier to correct.

You are also less likely to make typos which create problems that are
difficult to see :)

But, thanks, glad to know it's just user preference rather than some
inherent advantage.

oh, and, for the record, I should have typed smfGetAdvFNElement below, not
RCH...

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Monday, January 16, 2012 6:42 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: problem with smfGetADVFNElement

To tell the truth, I prefer the first -- it's self-documenting.

I almost got rid of the RCHGetElementNumber() function after I wrote
RCHGetTableCell().

On Mon, Jan 16, 2012 at 3:55 PM, Mike McQuaid <mikemcq802@yahoo.com> wrote:

How is this:

=RCHGetAdvFNElement("IBM","A",1,"Net Cash from Total Operating Activities")

better than this?

=RCHGetElementNumber("IBM",6855)

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (9)
6a.

RCHGetTableCell explanation

Posted by: "Ashish" ashishkm@yahoo.com   ashishkm

Mon Jan 16, 2012 4:29 pm (PST)



I am having problem in interpreting the use of RCHGetTableCell syntax ... I wonder if someone who understands this syntax can take a look, for example at, JPM Option Quote Table in Yahoo and provide the proper syntax (purely as an example, for learning purpose)) for accessing Jan 37.50 Call Option "bid" value (which is 0.06) ...The URL for the table is http://finance.yahoo.com/q/op?s=JPM+Options ... Thanks in advance ...

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

Re: RCHGetTableCell explanation

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

Mon Jan 16, 2012 4:42 pm (PST)



Easy Peasy. Here's what the smfGetOptionQuotes() function ends up using to
extract the data:

=RCHGetTableCell("http://finance.yahoo.com/q/op?s=JPM",3,"120121C00037500")

Basically, look for the date/Call/Strike string portion of the ticker
symbol, and then get the 3rd table cell following it.

On Mon, Jan 16, 2012 at 5:29 PM, Ashish <ashishkm@yahoo.com> wrote:

> I am having problem in interpreting the use of RCHGetTableCell syntax ...
> I wonder if someone who understands this syntax can take a look, for
> example at, JPM Option Quote Table in Yahoo and provide the proper syntax
> (purely as an example, for learning purpose)) for accessing Jan 37.50 Call
> Option "bid" value (which is 0.06) ...The URL for the table is
> http://finance.yahoo.com/q/op?s=JPM+Options ... Thanks in advance ...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7a.

Re: Getting quotes for indices when using "RCHGetYahooQuotes()"

Posted by: "Mark Simms" marksimms@verizon.net   msimmsx

Mon Jan 16, 2012 5:15 pm (PST)



Turn off autocorrection:

Office Button|Excel Options|Proofing

and click on 'Autocorrect Options' button and change

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Randy Harmelink
Sent: Friday, June 24, 2011 1:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Getting quotes for indices when using
"RCHGetYahooQuotes()"

Yahoo is no long licensed to carry DJIA quotes, see:
http://help.yahoo.com/l/us/yahoo/finance/known_issues/fitaki-13.html

However, the work-around I use is to use ticker symbol INDU, which appears
to work (for now, anyway).

I tried ^HSI and it worked fine for me. However, I do have troubles trying
to enter "^HSI" into an EXCEL cell -- EXCEL wants to change it to "^HIS".
But it isn't the add-in that is changing the ticker symbol, it's the EXCEL
auto-correct function. For example, just type ^HSI into a cell and before
hitting enter, type a blank -- for me, EXCEL immediately changes ^HSI to
^HIS as soon as I type the blank and indicate I am done with the word.

On Fri, Jun 24, 2011 at 10:27 AM, wenxi.drake <wenxi.drake@yahoo.com> wrote:

Hi Thanks for the add-in. It's very helpful. But when I'm using
"RCHGetYahooQuotes()" to get the prices and other information for Dow Jones
Index (^DJI) and Hang Seng Index (^HSI), it doesn't work very well. I hope I
can get some help from you. Thank you in advance.

When quoting (^DJI), there is no information showing up at all.
When quoting (^HSI), it automatically changes to (^HIS), and nothing but the
symbol shows.

I'm pretty sure I followed all the instructions right. All the other index
or company quotes work well except above two. Please help me with this.
Thank you very much!!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
8.

Error using RCHGetTableElement

Posted by: "Venu" vn95118@yahoo.com   vn95118

Mon Jan 16, 2012 5:18 pm (PST)



Hi!

I am trying to use RCHGetTableElement to calculate some fundamental valuse for some ticker symbols. I am trying to get the data from Yahoo Key Statistics, but I get an undefined value for everything.

I backed off and tried to put =RCHGetTableElement("Source",941) into a cell and get undefined value.

What could I be doing wrong?

Thanks,
Venu

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
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.

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
MARKETPLACE

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

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

Diposting oleh EXCEL FEED LEARNING di 17.21

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)