5 New Messages
Digest #2712
3b
Re: Problem reading ticker symbol for Indian stocks in Morningstar by "Randy Harmelink" rharmelink
Messages
Fri Jul 26, 2013 5:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
But I do prefer helping people that at least tried something..
It can make the answer I give more meaningful. For applying to the NEXT
one... :)
On Fri, Jul 26, 2013 at 2:35 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> That will work,****
>
> ** **
>
> I continue to be amazed at how quickly you respond with the right answer.
> ****
>
> ** **
>
> I spent more time than that messing with it before taking the easy way out
> and asking you.****
>
>
>
It can make the answer I give more meaningful. For applying to the NEXT
one... :)
On Fri, Jul 26, 2013 at 2:35 PM, Kermit W. Prather
<kermitp@tampabay.
>
> That will work,****
>
> ** **
>
> I continue to be amazed at how quickly you respond with the right answer.
> ****
>
> ** **
>
> I spent more time than that messing with it before taking the easy way out
> and asking you.****
>
>
>
Fri Jul 26, 2013 5:40 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
For complete tables:
=RCHGetHTMLTable("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=PDVYX ","Bond
Quality",-1,"",2)
=RCHGetHTMLTable("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=PDVYX ","Sector
Weightings",-1,"",2)
Otherwise, something like these for the individual items:
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=PDVYX ",
1,"Bond Quality",">AAA<")
=RCHGetTableCell("
http://quicktake.morningstar.com/fundnet/printreport.aspx?symbol=PDVYX ",
2,"Sector Weightings","Mortgage Pass-Thru")
On Fri, Jul 26, 2013 at 4:28 PM, Joel <joel.andrews@lpl.com > wrote:
> Ticker symbol would be PDVYX
>
> > On Thu, Jul 25, 2013 at 8:07 PM, Joel <joel.andrews@...> 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?
>
=RCHGetHTMLTable(
http://quicktake.
Quality"
=RCHGetHTMLTable(
http://quicktake.
Weightings"
Otherwise, something like these for the individual items:
=RCHGetTableCell(
http://quicktake.
1,"Bond Quality"
=RCHGetTableCell(
http://quicktake.
2,"Sector Weightings"
On Fri, Jul 26, 2013 at 4:28 PM, Joel <joel.andrews@
> Ticker symbol would be PDVYX
>
> > On Thu, Jul 25, 2013 at 8:07 PM, Joel <joel.andrews@
> > >
> > > Question, I am using the quicktake print report (=RCHGetTableCell(
> > > http://quicktake.
> "&$A2,1,
> > > eff maturity"
> 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?
>
Fri Jul 26, 2013 5:57 pm (PDT) . Posted by:
"Gururaj Rao" gurujapan
On Fri, Jul 26, 2013 at 5:41 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
>
>
> Nothing simple at this point. At one point, all of the data for a stock on
> MorningStar could be found on a print report page. That's what I originally
> defined all of the elements for. But then they moved away from that print
> report page and went to individual pages that dynamically display the data
> -- which means the data isn't in the source code of that web page, and
> there is nothing for the add-in to extract.
>
> Lately, I've been poking around on their dynamic web pages, and have found
> out they have source pages that they used to build the dynamic page. The
> formula I gave you for yield pulls the data from just one of those web
> page. Unfortunately, their are dozens of them. See this and the thread it
> is in: http://finance.groups.yahoo.com/group/smf_addin/message/22957
>
> So I've been working on a template that shows the formula for extracting
> each data item from each of those pages. Maybe to eventually be used to
> redefine the old elements and make some new ones.
>
> The formula I gave you was one of those from my template, but I've only
> done a few web pages so far. For example, the basic quote page:
>
WOW! This is fantastic. Just substituted the ticker and all the values
flashed in. Thanks for the prompt reply, Randy.
I have two questions - I'm not sure whether I can capture data from other
websites using all the information you have given, but here goes:
1) How do I figure out which data is extractable?
For instance:
http://money.livemint.com/IID63/F107685/Valuation/Ratios/Company.aspx
http://money.livemint.com/IID64/F107685/Financial/Ratios/Company.aspx
http://money.livemint.com/IID60/F107685/BalSheet/Company.aspx
Are the data at the above sites extractable?
2) If yes, would it be possible for me to use
=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/stock/c-header?&t=MMM
","div",0,"vkey=""LastPrice"""))
with the URLs and relevant parameters suitably replaced after viewing the
source page to capture the values?
I know this is simplifying matters to the extreme; but if I could, I would
be willing to put in some work and share the results with others in the
forum.
Thanks again for your prompt responses.
Gururaj Rao
>
>
> Nothing simple at this point. At one point, all of the data for a stock on
> MorningStar could be found on a print report page. That's what I originally
> defined all of the elements for. But then they moved away from that print
> report page and went to individual pages that dynamically display the data
> -- which means the data isn't in the source code of that web page, and
> there is nothing for the add-in to extract.
>
> Lately, I've been poking around on their dynamic web pages, and have found
> out they have source pages that they used to build the dynamic page. The
> formula I gave you for yield pulls the data from just one of those web
> page. Unfortunately, their are dozens of them. See this and the thread it
> is in: http://finance.
>
> So I've been working on a template that shows the formula for extracting
> each data item from each of those pages. Maybe to eventually be used to
> redefine the old elements and make some new ones.
>
> The formula I gave you was one of those from my template, but I've only
> done a few web pages so far. For example, the basic quote page:
>
WOW! This is fantastic. Just substituted the ticker and all the values
flashed in. Thanks for the prompt reply, Randy.
I have two questions - I'm not sure whether I can capture data from other
websites using all the information you have given, but here goes:
1) How do I figure out which data is extractable?
For instance:
http://money.
http://money.
http://money.
Are the data at the above sites extractable?
2) If yes, would it be possible for me to use
=smfConvertData(
http://quotes.
","
with the URLs and relevant parameters suitably replaced after viewing the
source page to capture the values?
I know this is simplifying matters to the extreme; but if I could, I would
be willing to put in some work and share the results with others in the
forum.
Thanks again for your prompt responses.
Gururaj Rao
Fri Jul 26, 2013 6:32 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
1. You really need to look at the source code of the web page and see if
the data is there. I use this template from the FILES area to play around
with a new web page to see what's there:
smfGetTagContent-Quick-Webpage-Examination.xls
For example, the "By HTML Tag" can show you all of the tables on the web
page. Or, you could try to position yourself at the top of a table, and
examine all the rows.
2. The most commonly used function for custom extractions is the
RCHGetTableCell() function. For example, on that first URL you cite:
=RCHGetTableCell("
http://money.livemint.com/IID63/F107685/Valuation/Ratios/Company.aspx ",1,">BSE
Code")
...will extract the BSE Code. That's about as simple as that function
gets. Or:
=RCHGetTableCell("
http://money.livemint.com/IID63/F107685/Valuation/Ratios/Company.aspx ",1,"Total
Debt/Equity(%)")
...varying that 1 from 1 to 5 would get you the five years of the Total
Debt/Equity ratio.
If you do a lot of extractions from a page, or multiple related pages, it
would be very helpful to upload some type of template showing all of the
formulas to the "Uploads by Forum Members" folder. Then others can use the
formulas without needing to reinvent the wheel.
On Fri, Jul 26, 2013 at 5:57 PM, Gururaj Rao <honyakusha@gmail.com > wrote:
>
> 1) How do I figure out which data is extractable?
> For instance:
> http://money.livemint.com/IID63/F107685/Valuation/Ratios/Company.aspx
>
> http://money.livemint.com/IID64/F107685/Financial/Ratios/Company.aspx
>
> http://money.livemint.com/IID60/F107685/BalSheet/Company.aspx
> Are the data at the above sites extractable?
>
> 2) If yes, would it be possible for me to use
> =smfConvertData(smfGetTagContent("
> http://quotes.morningstar.com/stock/c-header?&t=MMM
> ","div",0,"vkey=""LastPrice"""))
> with the URLs and relevant parameters suitably replaced after viewing the
> source page to capture the values?
>
> I know this is simplifying matters to the extreme; but if I could, I would
> be willing to put in some work and share the results with others in the
> forum.
>
>
the data is there. I use this template from the FILES area to play around
with a new web page to see what's there:
smfGetTagContent-
For example, the "By HTML Tag" can show you all of the tables on the web
page. Or, you could try to position yourself at the top of a table, and
examine all the rows.
2. The most commonly used function for custom extractions is the
RCHGetTableCell(
=RCHGetTableCell(
http://money.
Code")
...will extract the BSE Code. That's about as simple as that function
gets. Or:
=RCHGetTableCell(
http://money.
Debt/Equity(
...varying that 1 from 1 to 5 would get you the five years of the Total
Debt/Equity ratio.
If you do a lot of extractions from a page, or multiple related pages, it
would be very helpful to upload some type of template showing all of the
formulas to the "Uploads by Forum Members" folder. Then others can use the
formulas without needing to reinvent the wheel.
On Fri, Jul 26, 2013 at 5:57 PM, Gururaj Rao <honyakusha@gmail.
>
> 1) How do I figure out which data is extractable?
> For instance:
> http://money.
>
> http://money.
>
> http://money.
> Are the data at the above sites extractable?
>
> 2) If yes, would it be possible for me to use
> =smfConvertData(
> http://quotes.
> ","
> with the URLs and relevant parameters suitably replaced after viewing the
> source page to capture the values?
>
> I know this is simplifying matters to the extreme; but if I could, I would
> be willing to put in some work and share the results with others in the
> forum.
>
>
Fri Jul 26, 2013 10:12 pm (PDT) . Posted by:
"PeteA" option2z
Yes, SMF works fine with 2013. I use it every day.
BUT, 2013 does NOT support the MDI (Multiple Document Interface) a MAJOR,
MAJOR failing for the way I use Excel, so I kept my 2010 license installed
too for when I need several sheets open in the same window.
Thanks,
Pete A
<http://www.sundognorth.com/TtP-S/ >
BUT, 2013 does NOT support the MDI (Multiple Document Interface) a MAJOR,
MAJOR failing for the way I use Excel, so I kept my 2010 license installed
too for when I need several sheets open in the same window.
Thanks,
Pete A
<http://www.sundogno
Tidak ada komentar:
Posting Komentar