2 New Messages
Digest #2387
Messages
Wed Oct 31, 2012 4:31 pm (PDT) . Posted by:
"Bill" shanahanbill
The result returned for this RCHGetElementNumber query for the 'category' of a mutual fund had been working for some time.
When I recently (10-28-12) refreshed the results in my spreadsheet every fund using this query returned the result 'Category:' instead of the appropriate category data.
It seems that the query is retrieving the Morningstar page from this site: http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=~~~~~. If you enter this query into your browser, the page returned appears to have all the pertinent information except for Category and Index, which now appear as:
"Category: " and "Index: ". Data for each fund is now blank.
Is this a recent, permanent development or has something else gone awry with the query or my spreadsheet?????
When I recently (10-28-12) refreshed the results in my spreadsheet every fund using this query returned the result 'Category:' instead of the appropriate category data.
It seems that the query is retrieving the Morningstar page from this site: http://quicktake.
"Category: " and "Index: ". Data for each fund is now blank.
Is this a recent, permanent development or has something else gone awry with the query or my spreadsheet?
Wed Oct 31, 2012 4:31 pm (PDT) . Posted by:
"g_oudreva" g_oudreva
Hi Randy, I'm trying to extract the stock split info as you have noted, but I am only returning the first stock split and none of the others. Am I doing something wrong? Do I need to array enter?
(I'm a newbie with this smgGetTagContent and not sure how to use it exactly.)
I would like to extract all of a company's stock split data in a single row, with each date and each split ratio in a different cell.
Such as this for MMM:
______________A________B________C_________D_________E________F___
Row 1:____6/16/1972____2____6/16/1987_____2_____4/11/1994____2___etc.
Do you know how this could possibly be solved?
Thank you so much for your help!
--- In smf_addin@yahoogroups.com , "Ron" <ronaldj309@...> wrote:
>
> Thanks very much, just what I needed.
>
> FYI: My use of Global Variables apparently was hiding info EXCEL needed to do things in the proper sequence. Getting rid of them, got me off and running.
>
> Ron Johnson
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > It is on their web pages of the dividend data, but not in their CSV file
> > offering. So you could grab them off of the web pages by iterating over
> > them. However, in the past, I've grabbed them from here (look under the
> > chart):
> >
> > http://finance.yahoo.com/q/bc?s=MMM
> >
> > For example, copy these formula into cells C1:E1 and copy down:
> >
> > C1: =smfGetTagContent("http://finance.yahoo.com/q/bc?s=MMM
> > ","nobr",ROWS(C$1:C1),"Splits:")
> > D1: =DATEVALUE(smfStrExtr("|"&$C1,"|","["))
> > E1: =smfStrExtr("|"&$C1,"[",":")/smfStrExtr("|"&$C1,":","]")
> >
> > ...and you'll get something like this:
> >
> > Jun 16, 1972 [2:1] 1972-06-16 2.00 Jun 16, 1987 [2:1] 1987-06-16 2.00 Apr
> > 11, 1994 [2:1] 1994-04-11 2.00 Sep 30, 2003 [2:1] 2003-09-30 2.00 Error
> > #VALUE! #VALUE! Error #VALUE! #VALUE! Error #VALUE! #VALUE! Error #VALUE!
> > #VALUE!
> >
> > On Sat, May 7, 2011 at 2:39 PM, Ron <ronaldj309@> wrote:
> >
> > > Any possibility of adding the ability to download the stock split info. I
> > > see it interspersed in the Yahoo Dividend data.
> > >
> >
>
(I'm a newbie with this smgGetTagContent and not sure how to use it exactly.)
I would like to extract all of a company's stock split data in a single row, with each date and each split ratio in a different cell.
Such as this for MMM:
____________
Row 1:____6/16/1972_
Do you know how this could possibly be solved?
Thank you so much for your help!
--- In smf_addin@yahoogrou
>
> Thanks very much, just what I needed.
>
> FYI: My use of Global Variables apparently was hiding info EXCEL needed to do things in the proper sequence. Getting rid of them, got me off and running.
>
> Ron Johnson
> --- In smf_addin@yahoogrou
> >
> > It is on their web pages of the dividend data, but not in their CSV file
> > offering. So you could grab them off of the web pages by iterating over
> > them. However, in the past, I've grabbed them from here (look under the
> > chart):
> >
> > http://finance.
> >
> > For example, copy these formula into cells C1:E1 and copy down:
> >
> > C1: =smfGetTagContent(
> > ","nobr",ROWS(
> > D1: =DATEVALUE(smfStrEx
> > E1: =smfStrExtr(
> >
> > ...and you'll get something like this:
> >
> > Jun 16, 1972 [2:1] 1972-06-16 2.00 Jun 16, 1987 [2:1] 1987-06-16 2.00 Apr
> > 11, 1994 [2:1] 1994-04-11 2.00 Sep 30, 2003 [2:1] 2003-09-30 2.00 Error
> > #VALUE! #VALUE! Error #VALUE! #VALUE! Error #VALUE! #VALUE! Error #VALUE!
> > #VALUE!
> >
> > On Sat, May 7, 2011 at 2:39 PM, Ron <ronaldj309@
> >
> > > Any possibility of adding the ability to download the stock split info. I
> > > see it interspersed in the Yahoo Dividend data.
> > >
> >
>
Tidak ada komentar:
Posting Komentar