5 New Messages
Digest #2466
Messages
Sun Jan 13, 2013 7:22 am (PST) . Posted by:
"Paul mcglinchey" mcglinchey77
This is the link you need to use then extract the price info from it
=RCHGetWebData("http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallback=jsonp1358089488792&symbols=AFM101&webmasterId=101020&_=1358089550952 ",1,1000)
Randy showed me how to do something very simialr with golf data a earlier in the week, if you look at that thread it should help you.
--- In smf_addin@yahoogroups.com , "iamruf" wrote:
>
> I am trying to import from web url below using Excel 2010 Data/From Web import without success. Excel data retrieval from many other url sites has been successful.
> Excel returns a dialog box for this url - Web query returned no data (with instructions on how to edit the named query).
> Is there a problem with this url?
> http://tmx.quotemedia.com/funds-ca-quote.php?qm_symbol=AFM101
> Alternatively, is there an SMF AddIn function that will work?
>
=RCHGetWebData(
Randy showed me how to do something very simialr with golf data a earlier in the week, if you look at that thread it should help you.
--- In smf_addin@yahoogrou
>
> I am trying to import from web url below using Excel 2010 Data/From Web import without success. Excel data retrieval from many other url sites has been successful.
> Excel returns a dialog box for this url - Web query returned no data (with instructions on how to edit the named query).
> Is there a problem with this url?
> http://tmx.quotemed
> Alternatively, is there an SMF AddIn function that will work?
>
Sun Jan 13, 2013 11:34 am (PST) . Posted by:
"iamruf" iamruf
TO: Paul mcglinchey
Hi Paul, I am truly amazed that you would take the time & effort to respond to my request. I thought I had seen the last thread from Randy which seemed to close the door on this url.
I used your formula:
=RCHGetWebData("http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba \ck=jsonp1358089488792&symbols=AFM101&webmasterId=101020&_=1358089550952",1,1000)
and immediately it returned the following string:
({"copyright":"Copyright (c) 2013 QuoteMedia, Inc.","symbolcount";:1,"quotedata":[{"symbol":"AFM101","datatype":"mutual fund","entitlement";:"EOD";,"delaymin":null,"datetime":"2013-01-11T20:00:00-05:00","pricedata":{ "last":"11.5589", "change":"0.0051", "changepercent":"0.044141", "sharevolume":"0"}}]});
As an absolute novice, I would appreciate your help in parsing the relevant data from this string.
Also, there is a wealth of data on this url:
http://tmx.quotemedia.com/funds-ca-quote.php?qm_symbol=AFM101
with additional pages for Profile, Sales Data etc.
Would it be possible to extract & parse all of the data?
Again, many thanks.
--- In smf_addin@yahoogroups.com , "iamruf" wrote:
>
> I am trying to import from web url below using Excel 2010 Data/From Web import without success. Excel data retrieval from many other url sites has been successful.
> Excel returns a dialog box for this url - Web query returned no data (with instructions on how to edit the named query).
> Is there a problem with this url?
> http://tmx.quotemedia.com/funds-ca-quote.php?qm_symbol=AFM101
> Alternatively, is there an SMF AddIn function that will work?
>
Hi Paul, I am truly amazed that you would take the time & effort to respond to my request. I thought I had seen the last thread from Randy which seemed to close the door on this url.
I used your formula:
=RCHGetWebData(
and immediately it returned the following string:
({"copyright&q
As an absolute novice, I would appreciate your help in parsing the relevant data from this string.
Also, there is a wealth of data on this url:
http://tmx.quotemed
with additional pages for Profile, Sales Data etc.
Would it be possible to extract & parse all of the data?
Again, many thanks.
--- In smf_addin@yahoogrou
>
> I am trying to import from web url below using Excel 2010 Data/From Web import without success. Excel data retrieval from many other url sites has been successful.
> Excel returns a dialog box for this url - Web query returned no data (with instructions on how to edit the named query).
> Is there a problem with this url?
> http://tmx.quotemed
> Alternatively, is there an SMF AddIn function that will work?
>
Sun Jan 13, 2013 11:21 am (PST) . Posted by:
"Jacob Jose" pepecan47
That was it... I use Excel 2003. Now it's working.
Thanks a lot
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, January 12, 2013 3:40:34 PM
Subject: Re: [smf_addin] Morningstar star's rating
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.
Thanks a lot
Regards,
Jose L. Jacob
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, January 12, 2013 3:40:34 PM
Subject: Re: [smf_addin] Morningstar star's rating
So you're getting #VALUE! with:
=smfStrExtr(
You shouldn'
Hmmm. Are you using an older version of EXCEL? If so the length of the RCHGetWebData(
=smfStrExtr(
...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.
Sun Jan 13, 2013 1:58 pm (PST) . Posted by:
"codyklein" codyklein
This also works for me:
=rchgetwebdata("http://quotes.morningstar.com/stock/s?t= "&A2,"r_star",1,6)
If you want a value & not text then add:
VALUE(rchgetwebdata("http://quotes.morningstar.com/stock/s?t= "&A2,"r_star",1,6))
--- In smf_addin@yahoogroups.com , Jacob Jose wrote:
>
> 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
> 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 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?
>
=rchgetwebdata(
If you want a value & not text then add:
VALUE(rchgetwebdata
--- In smf_addin@yahoogrou
>
> 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
> 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 wrote:
>
> >
> >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?
>
Sun Jan 13, 2013 8:40 pm (PST) . Posted by:
"Jacob Jose" pepecan47
Thank you, it works for me too.
Regards,
Jose L. Jacob
________________________________
From: codyklein codyklein@alum.drexel.edu >
To: smf_addin@yahoogroups.com
Sent: Sunday, January 13, 2013 4:58:35 PM
Subject: [smf_addin] Re: Morningstar star's rating
This also works for me:
=rchgetwebdata("http://quotes.morningstar.com/stock/s?t= "&A2,"r_star",1,6)
If you want a value & not text then add:
VALUE(rchgetwebdata("http://quotes.morningstar.com/stock/s?t= "&A2,"r_star",1,6))
--- In mailto:smf_addin%40yahoogroups.com, Jacob Jose wrote:
>
> 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
> To: mailto:smf_addin%40yahoogroups.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 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?
>
Regards,
Jose L. Jacob
____________
From: codyklein codyklein@alum.
To: smf_addin@yahoogrou
Sent: Sunday, January 13, 2013 4:58:35 PM
Subject: [smf_addin] Re: Morningstar star's rating
This also works for me:
=rchgetwebdata(
If you want a value & not text then add:
VALUE(rchgetwebdata
--- In mailto:smf_addin%
>
> 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
> To: mailto:smf_addin%
> 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 wrote:
>
> >
> >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?
>
Tidak ada komentar:
Posting Komentar