4 New Messages
Digest #2710
Messages
Thu Jul 25, 2013 8:15 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sample ticker symbol please...
On Thu, Jul 25, 2013 at 8:07 PM, Joel <joel.andrews@lpl.com > wrote:
>
> Question, I am using the quicktake print report (=RCHGetTableCell("
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol= "&$A2,1,"average
> eff maturity"))to try to get the Bond Quality (eg. AAA, AA, A, BBB, etc)
> and also the Bond Sector Ratings (eg. Government, treasuries, tips, us
> agency; Corporate, mortgage pass through, etc.). Do you have any idea how
> I can do this?
>
On Thu, Jul 25, 2013 at 8:07 PM, Joel <joel.andrews@
>
> Question, I am using the quicktake print report (=RCHGetTableCell(
> http://quicktake.
> eff maturity"
> and also the Bond Sector Ratings (eg. Government, treasuries, tips, us
> agency; Corporate, mortgage pass through, etc.). Do you have any idea how
> I can do this?
>
Thu Jul 25, 2013 8:25 pm (PDT) . Posted by:
"gbullr" gbullr
Take a look at SMF Bond Price file from me in the links user uploaded files.
--- In smf_addin@yahoogroups.com , "Joel" <joel.andrews@...> wrote:
>
> Randy,
>
> Thanks so much for all of your help with this great add-in!
>
> Question, I am using the quicktake print report (=RCHGetTableCell("http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol= "&$A2,1,"average eff maturity"))to try to get the Bond Quality (eg. AAA, AA, A, BBB, etc) and also the Bond Sector Ratings (eg. Government, treasuries, tips, us agency; Corporate, mortgage pass through, etc.). Do you have any idea how I can do this?
>
> Thanks in advance!
>
> Joel
>
--- In smf_addin@yahoogrou
>
> Randy,
>
> Thanks so much for all of your help with this great add-in!
>
> Question, I am using the quicktake print report (=RCHGetTableCell(
>
> Thanks in advance!
>
> Joel
>
Thu Jul 25, 2013 8:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I didn't get a print page for any of the three there.
On Thu, Jul 25, 2013 at 8:25 PM, gbullr <gaston.bullrich@gmail.com > wrote:
> Take a look at SMF Bond Price file from me in the links user uploaded
> files.
>
> --- In smf_addin@yahoogroups.com , "Joel" <joel.andrews@...> wrote:
> >
> > Randy,
> >
> > Thanks so much for all of your help with this great add-in!
> >
> > Question, I am using the quicktake print report (=RCHGetTableCell("
> http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol= "&$A2,1,"average
> eff maturity"))to try to get the Bond Quality (eg. AAA, AA, A, BBB, etc)
> and also the Bond Sector Ratings (eg. Government, treasuries, tips, us
> agency; Corporate, mortgage pass through, etc.). Do you have any idea how
> I can do this?
> >
> > Thanks in advance!
> >
> > Joel
> >
>
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
>
>
>
On Thu, Jul 25, 2013 at 8:25 PM, gbullr <gaston.bullrich@
> Take a look at SMF Bond Price file from me in the links user uploaded
> files.
>
> --- In smf_addin@yahoogrou
> >
> > Randy,
> >
> > Thanks so much for all of your help with this great add-in!
> >
> > Question, I am using the quicktake print report (=RCHGetTableCell(
> http://quicktake.
> eff maturity"
> and also the Bond Sector Ratings (eg. Government, treasuries, tips, us
> agency; Corporate, mortgage pass through, etc.). Do you have any idea how
> I can do this?
> >
> > Thanks in advance!
> >
> > Joel
> >
>
>
>
>
> ------------
>
> Yahoo! Groups Links
>
>
>
>
Thu Jul 25, 2013 9:19 pm (PDT) . Posted by:
"Gururaj Rao" gurujapan
On Fri, Jul 26, 2013 at 10:01 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
>
>
> You wouldn't need to re-enter the URL each time, with a new ticker symbol.
> You could just use normal EXCEL processing to create a concatenated URL.
> For example, if your ticker symbol is in cell A2, the formula would be:
>
> =smfConvertData(smfGetTagContent("
> http://quotes.morningstar.com/stock/c-header?&t= "&A2,
> "span",0,"vkey=""ProjectedYield"""))
>
>
> Sorry, Randy, I was not clear about the question I posted.
The example above is only for Yield.
I wish to get many other kinds of data from the morningstar site such as
P/E, P/CF and data from other pages at the same site.
So I presume I need to get the relevant URL, insert it between the
parentheses here --> =smfConvertData(smfGetTagContent( .....), get
parameters such as "span",0,"vkey=""P/E "") and so on, after viewing the
source page and insert them?
Any simple methods to know about the parameters to insert after the URL? Or
should a layman like me give up at this stage? Any pointers would be
appreciated .
Thanks in advance,
Gururaj Rao
> On Thu, Jul 25, 2013 at 5:37 PM, Gururaj Rao <honyakusha@gmail.com > wrote:
>
>
>> On Thu, Jul 25, 2013 at 10:24 AM, Randy Harmelink <rharmelink@gmail.com >wrote:
>>
>>>
>>> Actually, element #63 is from MSN, not MorningStar. On the MSN company
>>> name lookup, I don't see an option for a country of India. So I don't know
>>> if they carry data on them.
>>>
>>> You can get the yield from Morningstar with:
>>>
>>> =smfConvertData(smfGetTagContent("
>>> http://quotes.morningstar.com/stock/c-header?&t=XNSE:WIPRO ",
>>> "span",0,"vkey=""ProjectedYield"""))
>>>
>>> So I have to use the URL each time to capture data and just entering the
>> TICKER SYMBOL to use the functions will not work with MSN or Morningstar."
>> This tells me the enormous time and you must have put in to help us
>> capture various data by just entering the TICKER SYMBOL!
>>
>> Incidentally, I tried using the Yahoo Finance Functions by entering
>> Indian Ticker Symbols and they work fine!
>>
>> Thanks for the prompt assistance and for the amazing work you have put in!
>>
>
>
>
> You wouldn't need to re-enter the URL each time, with a new ticker symbol.
> You could just use normal EXCEL processing to create a concatenated URL.
> For example, if your ticker symbol is in cell A2, the formula would be:
>
> =smfConvertData(
> http://quotes.
> "span"
>
>
> Sorry, Randy, I was not clear about the question I posted.
The example above is only for Yield.
I wish to get many other kinds of data from the morningstar site such as
P/E, P/CF and data from other pages at the same site.
So I presume I need to get the relevant URL, insert it between the
parentheses here --> =smfConvertData(
parameters such as "span"
source page and insert them?
Any simple methods to know about the parameters to insert after the URL? Or
should a layman like me give up at this stage? Any pointers would be
appreciated .
Thanks in advance,
Gururaj Rao
> On Thu, Jul 25, 2013 at 5:37 PM, Gururaj Rao <honyakusha@gmail.
>
>
>> On Thu, Jul 25, 2013 at 10:24 AM, Randy Harmelink <rharmelink@gmail.
>>
>>>
>>> Actually, element #63 is from MSN, not MorningStar. On the MSN company
>>> name lookup, I don't see an option for a country of India. So I don't know
>>> if they carry data on them.
>>>
>>> You can get the yield from Morningstar with:
>>>
>>> =smfConvertData(
>>> http://quotes.
>>> "span"
>>>
>>> So I have to use the URL each time to capture data and just entering the
>> TICKER SYMBOL to use the functions will not work with MSN or Morningstar.
>> This tells me the enormous time and you must have put in to help us
>> capture various data by just entering the TICKER SYMBOL!
>>
>> Incidentally, I tried using the Yahoo Finance Functions by entering
>> Indian Ticker Symbols and they work fine!
>>
>> Thanks for the prompt assistance and for the amazing work you have put in!
>>
>
Tidak ada komentar:
Posting Komentar