Senin, 16 Januari 2012

[smf_addin] Digest Number 2077

Messages In This Digest (19 Messages)

Messages

1a.

problem with smfGetADVFNElement

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

Sun Jan 15, 2012 3:55 am (PST)



Randy,

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&"<";;"--"))


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

Re: problem with smfGetADVFNElement

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

Sun Jan 15, 2012 4:05 am (PST)



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@yahoo.com>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 (5)
1c.

Re: problem with smfGetADVFNElement

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

Sun Jan 15, 2012 3:13 pm (PST)



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, 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 (5)
1d.

Re: problem with smfGetADVFNElement

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

Sun Jan 15, 2012 3:23 pm (PST)



You can use multiple search strings. Just repeat the search string to find
the second one.

Or, I sometimes use the statement header to place me first, then get the
line item from that statement.

On Sun, Jan 15, 2012 at 4:13 PM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

>
> another issue found, depreciation is two times listed but how i get both?
> (income statement / cashflow statement)
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1e.

Re: problem with smfGetADVFNElement

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

Sun Jan 15, 2012 3:29 pm (PST)



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 (5)
2a.

Fw: Re: Yahoo Finance "Last Trade"cell

Posted by: "randy tofsrud" rst66@yahoo.com   rst66

Sun Jan 15, 2012 7:27 am (PST)



Randy,
I am having problems with this.
I have replaced "ticker"with the stock ticker and have inserted the stock ticker after 184_ but it still doesn't work.
Is there something else that I should be doing? Do I need to download something other than the SMF Add-In?
Thank You,

--- On Sat, 1/14/12, Randy Harmelink <rharmelink@gmail.com> wrote:

From: Randy Harmelink <rharmelink@gmail.com>
Subject: Re: Yahoo Finance "Last Trade"cell
To: "randy tofsrud" <rst66@yahoo.com>
Date: Saturday, January 14, 2012, 1:10 AM

Try:

=0+smfGetTagContent("http://finance.yahoo.com/q?s="&Ticker,"span",-1,"yfs_l84_")

PS: In the future, please direct add-in related questions to the Yahoo group. Too many messages sent directly to me end up in my SPAM bucket, so I may never see them.

On Fri, Jan 13, 2012 at 9:19 AM, randy tofsrud <rst66@yahoo.com> wrote:

Hello,

Yahoo Finance has removed the "Last Trade"cell from their pages. Is it possible to grab the real time quotes that they provide?

Thank You,

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

Re: Fw: Re: Yahoo Finance "Last Trade"cell

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

Sun Jan 15, 2012 8:31 am (PST)



Can you cite the exact formula you are using, please?

On Sun, Jan 15, 2012 at 7:29 AM, randy tofsrud <rst66@yahoo.com> wrote:

>
> I am having problems with this.
> I have replaced "ticker"with the stock ticker and have inserted the stock
> ticker after 184_ but it still doesn't work.
> Is there something else that I should be doing? Do I need to download
> something other than the SMF Add-In?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3a.

adding a specific element number to smflite

Posted by: "David" davecharlaff@hotmail.com   copthornelabs

Sun Jan 15, 2012 11:00 am (PST)



Randy,

How would I add a specific element no say 949 to the smflite sample spreadsheet.

I have array entered a short watchlist and grab some of the standard elements off yahoo but i'd like to have the choice to add the retrieval of a specific element number to the array.

How might this be done?

Dave C.

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

Re: adding a specific element number to smflite

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

Sun Jan 15, 2012 12:56 pm (PST)



I'm not aware of an smfLite version of the RCHGetElementNumber() function.
It would be problematic, because the element definitions are external to
the add-in.

On Sun, Jan 15, 2012 at 11:59 AM, David <davecharlaff@hotmail.com> wrote:

>
> How would I add a specific element no say 949 to the smflite sample
> spreadsheet.
>
> I have array entered a short watchlist and grab some of the standard
> elements off yahoo but i'd like to have the choice to add the retrieval of
> a specific element number to the array.
>
> How might this be done?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
3c.

Re: adding a specific element number to smflite

Posted by: "David" davecharlaff@hotmail.com   copthornelabs

Sun Jan 15, 2012 2:09 pm (PST)



Randy
Could you suggest a format that would get that element number (949 Yahoo) for me for my watchlist and put it into column B alonside the symbols in col A?
Just looking for a starting format.
Thx
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm not aware of an smfLite version of the RCHGetElementNumber() function.
> It would be problematic, because the element definitions are external to
> the add-in.
>
> On Sun, Jan 15, 2012 at 11:59 AM, David <davecharlaff@...> wrote:
>
> >
> > How would I add a specific element no say 949 to the smflite sample
> > spreadsheet.
> >
> > I have array entered a short watchlist and grab some of the standard
> > elements off yahoo but i'd like to have the choice to add the retrieval of
> > a specific element number to the array.
> >
> > How might this be done?
> >
>

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

Re: adding a specific element number to smflite

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

Sun Jan 15, 2012 2:19 pm (PST)



Most elements are just hard-coded versions of the RCHGetTableCell()
function. In this case:

=RCHGetTableCell("http://finance.yahoo.com/q/ks?s="&Ticker,1,"ENTERPRISE
VALUE/EBITDA")

On Sun, Jan 15, 2012 at 3:09 PM, David <davecharlaff@hotmail.com> wrote:

> Could you suggest a format that would get that element number (949 Yahoo)
> for me for my watchlist and put it into column B alonside the symbols in
> col A?
> Just looking for a starting format.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)
4a.

Don't Know What Happened

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

Sun Jan 15, 2012 12:52 pm (PST)



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.

Larry

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

Re: Don't Know What Happened

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

Sun Jan 15, 2012 1:02 pm (PST)



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 (3)
4c.

Re: Don't Know What Happened

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

Sun Jan 15, 2012 3:30 pm (PST)



Thanks Randy. Now that I know where to attack, I should be able to fix it. Having spent so much time already, I'm a little embarrasses that I didn't look there myself.
Larry

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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 (3)
5a.

smfGetOptionQuotes not working for some datacodes

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

Sun Jan 15, 2012 8:52 pm (PST)



Hi Randy .... Thanks for such a big help with your brilliant product ... I am now totally dependent upon it for all my option transactions ... I have been using smfGetOptionQuotes successfully as a cell reference to obtain Option information on a daily basis ... for some reason the datacodes c,u,t,j and k stopped working; getting "error" and "N/A" result for all of 10 different option symbols ... the datacodes l,b,a,g,h,s are working fine .... I do not know if j and k ever worked ... I added them only today ... example of the format I am using is smfGetOptionQuotes($B4,J$2) .... Thanks in appreciation of your help ...

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

Re: smfGetOptionQuotes not working for some datacodes

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

Sun Jan 15, 2012 10:05 pm (PST)



Nothing wrong with the j and k data items -- N/A is what Yahoo currently
has on their web pages.

The c, u, and t data items stopped working because Yahoo changed the format
of their quotes page and have dropped the "Last Trade:" and "Trade Time:"
table items. However, I was able to pick up the data items from the "flash
quote" at the top of the page to replace them. I just hope the changes are
done with...

I just uploaded version 2.1.2012.01.15 of the add-in to the "Works in
Progress" folder with the changes. To upgrade, you need to exit EXCEL,
download the new ZIP, extract its files into the SMF add-in folder,
replacing files as needed. When you restart EXCEL, it should be running the
new version. You can double check with:

=RCHGetElementNumber("Version")

On Sun, Jan 15, 2012 at 9:52 PM, Ashish <ashishkm@yahoo.com> wrote:

> Hi Randy .... Thanks for such a big help with your brilliant product ... I
> am now totally dependent upon it for all my option transactions ... I have
> been using smfGetOptionQuotes successfully as a cell reference to obtain
> Option information on a daily basis ... for some reason the datacodes
> c,u,t,j and k stopped working; getting "error" and "N/A" result for all of
> 10 different option symbols ... the datacodes l,b,a,g,h,s are working fine
> .... I do not know if j and k ever worked ... I added them only today ...
> example of the format I am using is smfGetOptionQuotes($B4,J$2) .... Thanks
> in appreciation of your help ...
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6a.

Version Difference??

Posted by: "kim54blake" kblake@rogers.com   kim54blake

Sun Jan 15, 2012 8:58 pm (PST)



Hi Randy hope you have been keeping well. I recently updated to the latest version 2011.12.01 from 2010.08.02. Now this formula no longer works: =RCHGetTableCell("http://www.pgatour.com/.element/ssi/auto/3.0/sdms/stats/r/body/2012/189_body.html",$A$5,"Y-T-D statistics through: ","<table",">"&$H8&"</",,,"</table") where $A$5=2 and H8 is the name of the player for my golf pool.
Can you help me figure out why the new version does not work?
I substituted 109 for 189 it made no difference, tried experimenting to no avail
Thanks Take care

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

Re: Version Difference??

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

Sun Jan 15, 2012 9:12 pm (PST)



Your formula works for me. Steve Stricker returns "1142000" !

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of kim54blake
Sent: Sunday, January 15, 2012 11:58 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Version Difference??

Hi Randy hope you have been keeping well. I recently updated to the latest
version 2011.12.01 from 2010.08.02. Now this formula no longer works:
=RCHGetTableCell("http://www.pgatour.com/.element/ssi/auto/3.0/sdms/stats/r/
body/2012/189_body.html",$A$5,"Y-T-D statistics through:
","<table",">"&$H8&"</",,,"</table") where $A$5=2 and H8 is the name of the
player for my golf pool.
Can you help me figure out why the new version does not work?
I substituted 109 for 189 it made no difference, tried experimenting to no
avail
Thanks Take care

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

Re: Version Difference??

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

Sun Jan 15, 2012 9:16 pm (PST)



As with Mike, your formula is working fine here...

Maybe you just got a bad web page? Did you try running
smfForceRecalculation? Did you exit and re-enter EXCEL after updating the
add-in, to make sure it loaded the new version (it loads add-in when it
starts).

On Sun, Jan 15, 2012 at 9:58 PM, kim54blake <kblake@rogers.com> wrote:

> Hi Randy hope you have been keeping well. I recently updated to the latest
> version 2011.12.01 from 2010.08.02. Now this formula no longer works:
> =RCHGetTableCell("
> http://www.pgatour.com/.element/ssi/auto/3.0/sdms/stats/r/body/2012/189_body.html",$A$5,"Y-T-D
> statistics through: ","<table",">"&$H8&"</",,,"</table") where $A$5=2 and
> H8 is the name of the player for my golf pool.
> Can you help me figure out why the new version does not work?
> I substituted 109 for 189 it made no difference, tried experimenting to no
> avail
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Odd News

You won't believe

it, but it's true

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.

Diposting oleh EXCEL FEED LEARNING di 01.57

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)