10 New Messages
Digest #2465
Messages
Sat Jan 12, 2013 6:56 am (PST) . Posted by:
"almazuca" almazuca
mmm ok, then it's a Yahoo problem, right?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Sorry, but "N/A" is what Yahoo is populating the CSV file with. The add-in
> can only parse out what Yahoo sends.
>
> For example:
>
> http://download.finance.yahoo.com/d/quotes.csv?s=SAN.MC&f=sl1d1t1c1ohgv&e=.csv
>
> On Sat, Jan 5, 2013 at 7:31 AM, almazuca wrote:
>
> >
> > It seems now Spanish stocks data are not working anymore. A simple query
> > as:
> >
> > =RCHGetYahooQuotes("SAN.MC";"p") returns N/A
> >
> > other European and US stocks work perfectly but all MC stocks don't. Any
> > clue why is this happening?
> >
> >
>
--- In smf_addin@yahoogrou
>
> Sorry, but "N/A" is what Yahoo is populating the CSV file with. The add-in
> can only parse out what Yahoo sends.
>
> For example:
>
> http://download.
>
> On Sat, Jan 5, 2013 at 7:31 AM, almazuca wrote:
>
> >
> > It seems now Spanish stocks data are not working anymore. A simple query
> > as:
> >
> > =RCHGetYahooQuotes(
> >
> > other European and US stocks work perfectly but all MC stocks don't. Any
> > clue why is this happening?
> >
> >
>
Sat Jan 12, 2013 7:00 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Right.
On Sat, Jan 12, 2013 at 7:56 AM, almazuca almazuca@yahoo.com > wrote:
> mmm ok, then it's a Yahoo problem, right?
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> >
> > Sorry, but "N/A" is what Yahoo is populating the CSV file with. The
> add-in
> > can only parse out what Yahoo sends.
> >
> > For example:
> >
> >
> http://download.finance.yahoo.com/d/quotes.csv?s=SAN.MC&f=sl1d1t1c1ohgv&e=.csv
>
On Sat, Jan 12, 2013 at 7:56 AM, almazuca almazuca@yahoo.
> mmm ok, then it's a Yahoo problem, right?
>
> --- In smf_addin@yahoogrou
> >
> > Sorry, but "N/A" is what Yahoo is populating the CSV file with. The
> add-in
> > can only parse out what Yahoo sends.
> >
> > For example:
> >
> >
> http://download.
>
Sat Jan 12, 2013 7:36 am (PST) . Posted by:
"Jacob Jose" pepecan47
Thank you very much Randy.
Do I need the latest SMF Add-In for this formula to work? I am getting VALUE!
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, January 11, 2013 10:31:17 PM
Subject: Re: [smf_addin] Morningstar star's rating
They're no longer using an image on the web page for the star rating. Instead, try:
=0+smfStrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t= "&C5,"r_star"),"r_star","'")
On Fri, Jan 11, 2013 at 8:24 PM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
>The retrieval of the M* star rating stopped working. This is the formula I've been using successfully for several months:
>
>=VALUE(RCHGetWebData("http://quote.morningstar.com/stock/s.aspx?t= "&A3,"star.gif",1,-1))&"*"
>
>Any idea what is going on?
Do I need the latest SMF Add-In for this formula to work? I am getting VALUE!
Regards,
Jose L. Jacob
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, January 11, 2013 10:31:17 PM
Subject: Re: [smf_addin] Morningstar star's rating
They're no longer using an image on the web page for the star rating. Instead, try:
=0+smfStrExtr(
On Fri, Jan 11, 2013 at 8:24 PM, Jacob Jose pepecan47@yahoo.
>
>The retrieval of the M* star rating stopped working. This is the formula I've been using successfully for several months:
>
>=VALUE(RCHGetWe
>
>Any idea what is going on?
Sat Jan 12, 2013 8:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Break down the formula into it's components and see what you get for each.
I'm assuming either the RCHGetWebData() isn't getting something, or the
smfStrExtr() isn't extracting a number, so adding 0 to the result would
give a #VALUE! error.
What ticker symbol are you using?
On Sat, Jan 12, 2013 at 8:36 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
> Do I need the latest SMF Add-In for this formula to work? I am getting
> VALUE!
>
> *From:* Randy Harmelink rharmelink@gmail.com >
> *To:* smf_addin@yahoogroups.com
> *Sent:* Friday, January 11, 2013 10:31:17 PM
> *Subject:* Re: [smf_addin] Morningstar star's rating
> **
>
> They're no longer using an image on the web page for the star rating.
> Instead, try:
>
> =0+smfStrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t=
> "&C5,"r_star"),"r_star","'")
>
I'm assuming either the RCHGetWebData(
smfStrExtr() isn't extracting a number, so adding 0 to the result would
give a #VALUE! error.
What ticker symbol are you using?
On Sat, Jan 12, 2013 at 8:36 AM, Jacob Jose pepecan47@yahoo.
>
> Do I need the latest SMF Add-In for this formula to work? I am getting
> VALUE!
>
> *From:* Randy Harmelink rharmelink@gmail.
> *To:* smf_addin@yahoogrou
> *Sent:* Friday, January 11, 2013 10:31:17 PM
> *Subject:* Re: [smf_addin] Morningstar star's rating
> **
>
> They're no longer using an image on the web page for the star rating.
> Instead, try:
>
> =0+smfStrExtr(
> "&C5,"
>
Sat Jan 12, 2013 8:43 am (PST) . Posted by:
"Jacob Jose" pepecan47
Using formula
=RCHGetWebData("http://quotes.morningstar.com/stock/s?t= "&B1,"r_star")
Ticker MCD
r_star3' id='star_span'>>rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, January 12, 2013 11:09:02 AM
Subject: Re: [smf_addin] Morningstar star's rating
Break down the formula into it's components and see what you get for each. I'm assuming either the RCHGetWebData() isn't getting something, or the smfStrExtr() isn't extracting a number, so adding 0 to the result would give a #VALUE! error.
What ticker symbol are you using?
On Sat, Jan 12, 2013 at 8:36 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>Do I need the latest SMF Add-In for this formula to work? I am getting VALUE!
>From: Randy Harmelink rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, January 11, 2013 10:31:17 PM
>Subject: Re: [smf_addin] Morningstar star's rating
>
>
>They're no longer using an image on the web page for the star rating. Instead, try:=0+smfStrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t= "&C5,"r_star"),"r_star","'")
=RCHGetWebData(
Ticker MCD
r_star3' id='star_
To: smf_addin@yahoogrou
Sent: Saturday, January 12, 2013 11:09:02 AM
Subject: Re: [smf_addin] Morningstar star's rating
Break down the formula into it's components and see what you get for each. I'm assuming either the RCHGetWebData(
What ticker symbol are you using?
On Sat, Jan 12, 2013 at 8:36 AM, Jacob Jose pepecan47@yahoo.
>Do I need the latest SMF Add-In for this formula to work? I am getting VALUE!
>From: Randy Harmelink rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Friday, January 11, 2013 10:31:17 PM
>Subject: Re: [smf_addin] Morningstar star's rating
>
>
>They'
Sat Jan 12, 2013 8:58 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Looks to me like the smfStrExtr() should work on that retrieved data --
what result do you get?
On Sat, Jan 12, 2013 at 9:43 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
> Using formula
> =RCHGetWebData("http://quotes.morningstar.com/stock/s?t= "&B1,"r_star")
>
> Ticker MCD
> r_star3' id='star_span'>>
what result do you get?
On Sat, Jan 12, 2013 at 9:43 AM, Jacob Jose pepecan47@yahoo.
>
> Using formula
> =RCHGetWebData(
>
> Ticker MCD
> r_star3' id='star_
Sat Jan 12, 2013 9:16 am (PST) . Posted by:
"Jacob Jose" pepecan47
I am getting #VALUE!
Do I need the latest SMF Add-In for this formula to work? I didn't update to the most recent one. I have the latest from the In Progress - Beta folder. I am a bit paranoid and always wait a month or so to apply the latest update.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, January 12, 2013 11:58:11 AM
Subject: Re: [smf_addin] Morningstar star's rating
Looks to me like the smfStrExtr() should work on that retrieved data -- what result do you get?
On Sat, Jan 12, 2013 at 9:43 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
>Using formula
> =RCHGetWebData("http://quotes.morningstar.com/stock/s?t=%22&B1,%22r_star ")
>
>Ticker MCD
>r_star3' id='star_span'>>
Do I need the latest SMF Add-In for this formula to work? I didn't update to the most recent one. I have the latest from the In Progress - Beta folder. I am a bit paranoid and always wait a month or so to apply the latest update.
Regards,
Jose L. Jacob
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, January 12, 2013 11:58:11 AM
Subject: Re: [smf_addin] Morningstar star's rating
Looks to me like the smfStrExtr() should work on that retrieved data -- what result do you get?
On Sat, Jan 12, 2013 at 9:43 AM, Jacob Jose pepecan47@yahoo.
>
>Using formula
> =RCHGetWebData(
>
>Ticker MCD
>r_star3&#
Sat Jan 12, 2013 12:40 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
So you're getting #VALUE! with:
=smfStrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t=
"&C5,"r_star"),"r_star","'")
You shouldn't need the latest add-in. And that function shouldn't return
#VALUE! unless there is a problem with the parameters.
Hmmm. Are you using an older version of EXCEL? If so the length of the
RCHGetWebData() could be causing a #VALUE! error -- it may exceed the
maximum string length of that version. If so, try:
=smfStrExtr(RCHGetWebData("http://quotes.morningstar.com/stock/s?t=
"&C5,"r_star",50),"r_star","'")
...and see if you get a #VALUE! error on that.
On Sat, Jan 12, 2013 at 10:16 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
> I am getting #VALUE!
>
> Do I need the latest SMF Add-In for this formula to work? I didn't update
> to the most recent one. I have the latest from the In Progress - Beta folder.
> I am a bit paranoid and always wait a month or so to apply the latest
> update.
>
>
=smfStrExtr(
"&C5,"
You shouldn'
#VALUE! unless there is a problem with the parameters.
Hmmm. Are you using an older version of EXCEL? If so the length of the
RCHGetWebData(
maximum string length of that version. If so, try:
=smfStrExtr(
"&C5,"
...and see if you get a #VALUE! error on that.
On Sat, Jan 12, 2013 at 10:16 AM, Jacob Jose pepecan47@yahoo.
>
> I am getting #VALUE!
>
> Do I need the latest SMF Add-In for this formula to work? I didn't update
> to the most recent one. I have the latest from the In Progress - Beta folder.
> I am a bit paranoid and always wait a month or so to apply the latest
> update.
>
>
Sat Jan 12, 2013 12:36 pm (PST) . Posted by:
"coghoo59" coghoo59
I just joined the group and have downloaded and installed the SMF add-in into Excel 2010. I enabled the SMF add-in by checking the box in the list of available add-ins. I also unchecked the box for the MSN Stockquotes add-in. But when I click on the Add-Ins tab on the ribbon I continue to see the MSN add-in, and do not see the SMF add-in.
What am I missing?
Thanks.
What am I missing?
Thanks.
Sat Jan 12, 2013 12:44 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
The SMF add-in doesn't put anything into the ribbon. It's primarily a
collection of user-defined functions.
On Sat, Jan 12, 2013 at 10:00 AM, coghoo59 lcoggins@gmail.com > wrote:
> I just joined the group and have downloaded and installed the SMF add-in
> into Excel 2010. I enabled the SMF add-in by checking the box in the list
> of available add-ins. I also unchecked the box for the MSN Stockquotes
> add-in. But when I click on the Add-Ins tab on the ribbon I continue to
> see the MSN add-in, and do not see the SMF add-in.
>
> What am I missing?
>
collection of user-defined functions.
On Sat, Jan 12, 2013 at 10:00 AM, coghoo59 lcoggins@gmail.
> I just joined the group and have downloaded and installed the SMF add-in
> into Excel 2010. I enabled the SMF add-in by checking the box in the list
> of available add-ins. I also unchecked the box for the MSN Stockquotes
> add-in. But when I click on the Add-Ins tab on the ribbon I continue to
> see the MSN add-in, and do not see the SMF add-in.
>
> What am I missing?
>
Tidak ada komentar:
Posting Komentar