8 New Messages
Digest #2660
Messages
Mon Jun 17, 2013 2:08 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
For what it is worth, I have also run into problems where the retrieval using lower case did not work. I change the symbol to uppercase and it works just fine. Jut this weekend I had the problem with this statement
IFERROR(smfConvertData(smfGetTagContent("http://dividata.com/stock/~~~~~/dividend ","p",g$4,">Ex-Dividend Date"))/1,0)
It was strange because some lower case symbols worked while others did not. I fixed it by using the UPPER formula.
Haven't had ny problems using upper case symbols.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Monday, June 17, 2013 11:00 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Real Time Quote wtih smfGetTagContent Function
I'm not sure what to tell you. Your formula worked just fine for me. I just put AAPL into cell C2 and then copied and pasted it. And if I change the ticker symbol, it updates to the new company.
On Mon, Jun 17, 2013 at 6:43 AM, ridgebacksexcel <tmallen2@bellsouth.net > wrote:
I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
Here is the formula with cell C2 showing the ticker: aapl
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s= "&$C2,"span",-1,"yfs_l84"))
I pulled "yfs_l84" directly from the source code.
Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
IFERROR(smfConvertD
It was strange because some lower case symbols worked while others did not. I fixed it by using the UPPER formula.
Haven't had ny problems using upper case symbols.
Kermit
From: smf_addin@yahoogrou
Sent: Monday, June 17, 2013 11:00 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo Real Time Quote wtih smfGetTagContent Function
I'm not sure what to tell you. Your formula worked just fine for me. I just put AAPL into cell C2 and then copied and pasted it. And if I change the ticker symbol, it updates to the new company.
On Mon, Jun 17, 2013 at 6:43 AM, ridgebacksexcel <tmallen2@bellsouth.
I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
Here is the formula with cell C2 showing the ticker: aapl
=smfConvertData(
I pulled "yfs_l84" directly from the source code.
Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
Mon Jun 17, 2013 5:36 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Randy, I just uploaded this file -- Fails-on-upper-and-lower-case-symbols.xlsx -- to the Files <http://finance.groups.yahoo.com/group/smf_addin/files/ > > Uploads by forum members folder
It is just one example of a spreadsheet that fails on upper or lower case. To test it I have been rebooting each time before I open the file. The same symbols do not fail every time.
I hilited in RED those which were failing the last time I save the file. All of the symbols in this file are valid on dividata.com
Also, it has nothing to do with how many symbols I have in the list. It has failed with as little as 6 and as many as is in the uploaded file.
Yes rebooting does not make a difference as I testing by rebooting before each file open and without rebooting it fails both ways. I rebooted just to eliminate that as a cause.
This fails on a few other spreadsheet I have as well.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Kermit W. Prather
Sent: Monday, June 17, 2013 5:08 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Yahoo Real Time Quote with smfGetTagContent Function
For what it is worth, I have also run into problems where the retrieval using lower case did not work. I change the symbol to uppercase and it works just fine. Jut this weekend I had the problem with this statement
IFERROR(smfConvertData(smfGetTagContent("http://dividata.com/stock/~~~~~/dividend ","p",g$4,">Ex-Dividend Date"))/1,0)
It was strange because some lower case symbols worked while others did not. I fixed it by using the UPPER formula.
Haven't had ny problems using upper case symbols.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Monday, June 17, 2013 11:00 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Real Time Quote wtih smfGetTagContent Function
I'm not sure what to tell you. Your formula worked just fine for me. I just put AAPL into cell C2 and then copied and pasted it. And if I change the ticker symbol, it updates to the new company.
On Mon, Jun 17, 2013 at 6:43 AM, ridgebacksexcel <tmallen2@bellsouth.net > wrote:
I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
Here is the formula with cell C2 showing the ticker: aapl
=smfConvertData(smfGetTagContent("http://finance.yahoo.com/q?s= "&$C2,"span",-1,"yfs_l84"))
I pulled "yfs_l84" directly from the source code.
Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
It is just one example of a spreadsheet that fails on upper or lower case. To test it I have been rebooting each time before I open the file. The same symbols do not fail every time.
I hilited in RED those which were failing the last time I save the file. All of the symbols in this file are valid on dividata.com
Also, it has nothing to do with how many symbols I have in the list. It has failed with as little as 6 and as many as is in the uploaded file.
Yes rebooting does not make a difference as I testing by rebooting before each file open and without rebooting it fails both ways. I rebooted just to eliminate that as a cause.
This fails on a few other spreadsheet I have as well.
Kermit
From: smf_addin@yahoogrou
Sent: Monday, June 17, 2013 5:08 PM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] Yahoo Real Time Quote with smfGetTagContent Function
For what it is worth, I have also run into problems where the retrieval using lower case did not work. I change the symbol to uppercase and it works just fine. Jut this weekend I had the problem with this statement
IFERROR(smfConvertD
It was strange because some lower case symbols worked while others did not. I fixed it by using the UPPER formula.
Haven't had ny problems using upper case symbols.
Kermit
From: smf_addin@yahoogrou
Sent: Monday, June 17, 2013 11:00 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Yahoo Real Time Quote wtih smfGetTagContent Function
I'm not sure what to tell you. Your formula worked just fine for me. I just put AAPL into cell C2 and then copied and pasted it. And if I change the ticker symbol, it updates to the new company.
On Mon, Jun 17, 2013 at 6:43 AM, ridgebacksexcel <tmallen2@bellsouth.
I saw somewhere on this site a code for extracting a Real Time Quote from the Yahoo Finance Summary page for a company. In this case AAPL.
I am using this function that I have adjusted from what I copied to see if I can get it to work. It shows the function correctly extracting the quote but the formula result is False, not the data extracted.
Here is the formula with cell C2 showing the ticker: aapl
=smfConvertData(
I pulled "yfs_l84" directly from the source code.
Is there a way to pull these real time quotes from this page for all tickers and not just aapl?
Mon Jun 17, 2013 7:11 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I just tried getting all of the web pages in my browser at the same time.
Many had a web page that simply said "Try later". So all of those will get
"Error" returned by an add-in function, since there is nothing in the
content of the web page to extract.
So it is the website telling you you're accessing too many web pages too
quickly. I don't know what their determination is of that. Presumably,
number of requests from an IP address.
On Mon, Jun 17, 2013 at 5:36 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> *Randy, I just uploaded this file --
> Fails-on-upper-and-lower-case-symbols.xlsx -- to the* *Files<http://finance.groups.yahoo.com/group/smf_addin/files/ >> Uploads by forum members folder
> *
>
> * *
>
> *It is just one example of a spreadsheet that fails on upper or lower
> case. To test it I have been rebooting each time before I open the file.
> The same symbols do not fail every time.*
>
> *I hilited in RED those which were failing the last time I save the file.
> All of the symbols in this file are valid on dividata.com *
>
> *Also, it has nothing to do with how many symbols I have in the list. It
> has failed with as little as 6 and as many as is in the uploaded file. *
>
> * *
>
> *Yes rebooting does not make a difference as I testing by rebooting
> before each file open and without rebooting it fails both ways. I rebooted
> just to eliminate that as a cause. *
>
> * *
>
> *This fails on a few other spreadsheet I have as well. *
>
> **
>
Many had a web page that simply said "Try later". So all of those will get
"Error" returned by an add-in function, since there is nothing in the
content of the web page to extract.
So it is the website telling you you're accessing too many web pages too
quickly. I don't know what their determination is of that. Presumably,
number of requests from an IP address.
On Mon, Jun 17, 2013 at 5:36 PM, Kermit W. Prather
<kermitp@tampabay.
>
> *Randy, I just uploaded this file --
> Fails-on-upper-
> *
>
> * *
>
> *It is just one example of a spreadsheet that fails on upper or lower
> case. To test it I have been rebooting each time before I open the file.
> The same symbols do not fail every time.*
>
> *I hilited in RED those which were failing the last time I save the file.
> All of the symbols in this file are valid on dividata.com *
>
> *Also, it has nothing to do with how many symbols I have in the list. It
> has failed with as little as 6 and as many as is in the uploaded file. *
>
> * *
>
> *Yes rebooting does not make a difference as I testing by rebooting
> before each file open and without rebooting it fails both ways. I rebooted
> just to eliminate that as a cause. *
>
> * *
>
> *This fails on a few other spreadsheet I have as well. *
>
> **
>
Mon Jun 17, 2013 2:23 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The MSN data elements had to be redefined last year because MSN changed
their site structure, so if you don't have the latest definitions you would
get an "Error" returned. If you are using the latest versions, you should
have the current element definitions.
When they redid the stock print page, they decided to put the previous
day's closing price on the web page as "Last Price", so element #25 hasn't
been the current quote for well over a year.
For RCHGetYahooQuotes(), you'll need to have the literal "l1" in cell C14
for it to return anything.
Both of these functions are currently working fine for me:
=RCHGetElementNumber("MMM";,25)
=RCHGetYahooQuotes("MMM","l1")
On Mon, Jun 17, 2013 at 10:31 AM, the_drake_03 <the_drake_03@yahoo.com >wrote:
>
> I've been using Element for several years. I've searched all around the
> forum but can't find an answer. It seems like #25 last price has changed
> and we should use RCHGetYahooQuotes instead.
>
> When I put in =RCHGetElementNumber($A7, C$14)I get "Error"
>
> When I put in =RCHGetYahooQuotes($A7, C$14)I get a blank cell, nothing,
> nada. I've tried with stocks, ETFs, and mutual funds.
>
> I'm trying to get the latest price, real time or delay, doesn't matter.
>
> I've downloaded the latest version from the forum here.
>
> Can someone help and tell me what I'm doing wrong?
>
their site structure, so if you don't have the latest definitions you would
get an "Error" returned. If you are using the latest versions, you should
have the current element definitions.
When they redid the stock print page, they decided to put the previous
day's closing price on the web page as "Last Price", so element #25 hasn't
been the current quote for well over a year.
For RCHGetYahooQuotes(
for it to return anything.
Both of these functions are currently working fine for me:
=RCHGetElementNumbe
=RCHGetYahooQuotes(
On Mon, Jun 17, 2013 at 10:31 AM, the_drake_03 <the_drake_03@
>
> I've been using Element for several years. I've searched all around the
> forum but can't find an answer. It seems like #25 last price has changed
> and we should use RCHGetYahooQuotes instead.
>
> When I put in =RCHGetElementNumbe
>
> When I put in =RCHGetYahooQuotes(
> nada. I've tried with stocks, ETFs, and mutual funds.
>
> I'm trying to get the latest price, real time or delay, doesn't matter.
>
> I've downloaded the latest version from the forum here.
>
> Can someone help and tell me what I'm doing wrong?
>
Mon Jun 17, 2013 3:15 pm (PDT) . Posted by:
"the_drake_03" the_drake_03
Terrific!!
GetElement(mmm, 25) does not work for me but GetYahooQuotes does.
Thank you soo much!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The MSN data elements had to be redefined last year because MSN changed
> their site structure, so if you don't have the latest definitions you would
> get an "Error" returned. If you are using the latest versions, you should
> have the current element definitions.
>
> When they redid the stock print page, they decided to put the previous
> day's closing price on the web page as "Last Price", so element #25 hasn't
> been the current quote for well over a year.
>
> For RCHGetYahooQuotes(), you'll need to have the literal "l1" in cell C14
> for it to return anything.
>
> Both of these functions are currently working fine for me:
>
> =RCHGetElementNumber("MMM";,25)
> =RCHGetYahooQuotes("MMM","l1")
>
> On Mon, Jun 17, 2013 at 10:31 AM, the_drake_03 <the_drake_03@...>wrote:
>
> >
> > I've been using Element for several years. I've searched all around the
> > forum but can't find an answer. It seems like #25 last price has changed
> > and we should use RCHGetYahooQuotes instead.
> >
> > When I put in =RCHGetElementNumber($A7, C$14)I get "Error"
> >
> > When I put in =RCHGetYahooQuotes($A7, C$14)I get a blank cell, nothing,
> > nada. I've tried with stocks, ETFs, and mutual funds.
> >
> > I'm trying to get the latest price, real time or delay, doesn't matter.
> >
> > I've downloaded the latest version from the forum here.
> >
> > Can someone help and tell me what I'm doing wrong?
> >
>
GetElement(mmm, 25) does not work for me but GetYahooQuotes does.
Thank you soo much!
--- In smf_addin@yahoogrou
>
> The MSN data elements had to be redefined last year because MSN changed
> their site structure, so if you don't have the latest definitions you would
> get an "Error" returned. If you are using the latest versions, you should
> have the current element definitions.
>
> When they redid the stock print page, they decided to put the previous
> day's closing price on the web page as "Last Price", so element #25 hasn't
> been the current quote for well over a year.
>
> For RCHGetYahooQuotes(
> for it to return anything.
>
> Both of these functions are currently working fine for me:
>
> =RCHGetElementNumbe
> =RCHGetYahooQuotes(
>
> On Mon, Jun 17, 2013 at 10:31 AM, the_drake_03 <the_drake_
>
> >
> > I've been using Element for several years. I've searched all around the
> > forum but can't find an answer. It seems like #25 last price has changed
> > and we should use RCHGetYahooQuotes instead.
> >
> > When I put in =RCHGetElementNumbe
> >
> > When I put in =RCHGetYahooQuotes(
> > nada. I've tried with stocks, ETFs, and mutual funds.
> >
> > I'm trying to get the latest price, real time or delay, doesn't matter.
> >
> > I've downloaded the latest version from the forum here.
> >
> > Can someone help and tell me what I'm doing wrong?
> >
>
Mon Jun 17, 2013 2:28 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The positioning values only work if you have the comment box visible. They
don't work if you have the comment box hidden. That's an EXCEL limitation.
On Mon, Jun 17, 2013 at 11:34 AM, Pete <petekoch@yahoo.com > wrote:
> The following comment works just fine:
>
> =RCHCreateComment("
> http://stockcharts.com/c-sc/sc?p=W&yr=0&mn=36&dy=0&i=t39628903145&r=9933&s=
> "&Ticker,99,800,515)
>
> But when I try to move the chart down or to the right, it remains in the
> same (relative) position:
>
> =RCHCreateComment("
> http://stockcharts.com/c-sc/sc?p=W&yr=0&mn=36&dy=0&i=t39628903145&r=9933&s=
> "&Ticker,99,800,515,0,150,150)
>
> What I would really like to do is move the chart up and to the left (with
> negative numbers?).
>
> What am I missing/doing wrong ? Or is it that I am running
> Version 2.1.2012.02.02 ???
>
don't work if you have the comment box hidden. That's an EXCEL limitation.
On Mon, Jun 17, 2013 at 11:34 AM, Pete <petekoch@yahoo.
> The following comment works just fine:
>
> =RCHCreateComment(
> http://stockcharts.
> "&Ticker,
>
> But when I try to move the chart down or to the right, it remains in the
> same (relative) position:
>
> =RCHCreateComment(
> http://stockcharts.
> "&Ticker,
>
> What I would really like to do is move the chart up and to the left (with
> negative numbers?).
>
> What am I missing/doing wrong ? Or is it that I am running
> Version 2.1.2012.02.
>
Mon Jun 17, 2013 3:06 pm (PDT) . Posted by:
"Pete" petekoch
Thanks, Randy. I did look at the code, but I guess I missed it.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The positioning values only work if you have the comment box visible. They
> don't work if you have the comment box hidden. That's an EXCEL limitation.
>
> On Mon, Jun 17, 2013 at 11:34 AM, Pete <petekoch@...> wrote:
>
> > The following comment works just fine:
> >
> > =RCHCreateComment("
> > http://stockcharts.com/c-sc/sc?p=W&yr=0&mn=36&dy=0&i=t39628903145&r=9933&s=
> > "&Ticker,99,800,515)
> >
> > But when I try to move the chart down or to the right, it remains in the
> > same (relative) position:
> >
> > =RCHCreateComment("
> > http://stockcharts.com/c-sc/sc?p=W&yr=0&mn=36&dy=0&i=t39628903145&r=9933&s=
> > "&Ticker,99,800,515,0,150,150)
> >
> > What I would really like to do is move the chart up and to the left (with
> > negative numbers?).
> >
> > What am I missing/doing wrong ? Or is it that I am running
> > Version 2.1.2012.02.02 ???
> >
>
--- In smf_addin@yahoogrou
>
> The positioning values only work if you have the comment box visible. They
> don't work if you have the comment box hidden. That's an EXCEL limitation.
>
> On Mon, Jun 17, 2013 at 11:34 AM, Pete <petekoch@
>
> > The following comment works just fine:
> >
> > =RCHCreateComment(
> > http://stockcharts.
> > "&Ticker,
> >
> > But when I try to move the chart down or to the right, it remains in the
> > same (relative) position:
> >
> > =RCHCreateComment(
> > http://stockcharts.
> > "&Ticker,
> >
> > What I would really like to do is move the chart up and to the left (with
> > negative numbers?).
> >
> > What am I missing/doing wrong ? Or is it that I am running
> > Version 2.1.2012.02.
> >
>
Mon Jun 17, 2013 7:16 pm (PDT) . Posted by:
"sri yanto" sri.yanto
thanks alot randy
i'll update my addin
thank bro
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The current official release is 2.1.2012.12.29.
>
> The formula isn't working for you because of a change made to smfStrExtr()
> in July of 2012, to allow the tilda symbol to represent the start or end of
> the string. As a result, it's finding nothing, resulting in a zero value.
>
> On Mon, Jun 17, 2013 at 2:39 AM, sri yanto <sri.yanto@...> wrote:
>
> > i'am using
> > addin
> >
> > version 2.1.2012.02.02
> > randy, there's any update of addin ?
> > thanks
> >
>
i'll update my addin
thank bro
--- In smf_addin@yahoogrou
>
> The current official release is 2.1.2012.12.
>
> The formula isn't working for you because of a change made to smfStrExtr()
> in July of 2012, to allow the tilda symbol to represent the start or end of
> the string. As a result, it's finding nothing, resulting in a zero value.
>
> On Mon, Jun 17, 2013 at 2:39 AM, sri yanto <sri.yanto@
>
> > i'am using
> > addin
> >
> > version 2.1.2012.02.
> > randy, there's any update of addin ?
> > thanks
> >
>
Tidak ada komentar:
Posting Komentar