15 New Messages
Digest #2609
Messages
Wed May 8, 2013 3:12 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
works well!
other than this, is this the code to exttract data from this page
http://financials.morningstar.com/company-profile/c.action?t=IBM®ion=USA&culture=en-us
(specifically wants the ''Business Description IBM'' section to be extracted)?
tried the page source method but doesnt work
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You've got an extra double quote after the A1 cell reference.
>
> On Wed, May 8, 2013 at 1:59 AM, weekeewawa <weekeewawa@...> wrote:
>
> > works well
> >
> > however, when i tried to point to cell A1, it gives me an error
> >
> > =SUBSTITUTE(SUBSTITUTE(smfGetTagContent("
> > http://www.reuters.com/finance/stocks/companyProfile?symbol= ''&A1","div",1,"Full
> > Description"),"</p>",CHAR(13)),"<p>",CHAR(10))
> >
> > thats the code i used, is that correct?
> >
>
works well!
other than this, is this the code to exttract data from this page
http://financials.
(specifically wants the ''Business Description IBM'' section to be extracted)?
tried the page source method but doesnt work
thanks
--- In smf_addin@yahoogrou
>
> You've got an extra double quote after the A1 cell reference.
>
> On Wed, May 8, 2013 at 1:59 AM, weekeewawa <weekeewawa@
>
> > works well
> >
> > however, when i tried to point to cell A1, it gives me an error
> >
> > =SUBSTITUTE(
> > http://www.reuters.
> > Description"
> >
> > thats the code i used, is that correct?
> >
>
Wed May 8, 2013 3:27 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's a dynamically generated web page, so the data isn't there. It
sources it from here:
http://financials.morningstar.com/company-profile/component.action?component=BusinessDesc&t=IBM
When you look at the source code of your web page below, look for the
"loadcompanyprofiledata" subroutine and how it is invoked to get the data
from the source pages.
On Wed, May 8, 2013 at 3:12 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> other than this, is this the code to exttract data from this page
>
>
> http://financials.morningstar.com/company-profile/c.action?t=IBM®ion=USA&culture=en-us
>
> (specifically wants the ''Business Description IBM'' section to be
> extracted)?
>
> tried the page source method but doesnt work
>
sources it from here:
http://financials.
When you look at the source code of your web page below, look for the
"loadcompanypr
from the source pages.
On Wed, May 8, 2013 at 3:12 AM, weekeewawa <weekeewawa@yahoo.
>
> other than this, is this the code to exttract data from this page
>
>
> http://financials.
>
> (specifically wants the ''Business Description IBM'' section to be
> extracted)?
>
> tried the page source method but doesnt work
>
Wed May 8, 2013 9:59 am (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy
i see that the page source doesnt display the data that i needed
therefore back to reuters
on this page
http://www.reuters.com/finance/stocks/overview?symbol=IBM
how do i extract from
1) OVERALL
2) FINANCIALS
3) COMPETITORS
section
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's a dynamically generated web page, so the data isn't there. It
> sources it from here:
>
> http://financials.morningstar.com/company-profile/component.action?component=BusinessDesc&t=IBM
>
> When you look at the source code of your web page below, look for the
> "loadcompanyprofiledata" subroutine and how it is invoked to get the data
> from the source pages.
>
> On Wed, May 8, 2013 at 3:12 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > other than this, is this the code to exttract data from this page
> >
> >
> > http://financials.morningstar.com/company-profile/c.action?t=IBM ®ion=USA&culture=en-us
> >
> > (specifically wants the ''Business Description IBM'' section to be
> > extracted)?
> >
> > tried the page source method but doesnt work
> >
>
i see that the page source doesnt display the data that i needed
therefore back to reuters
on this page
http://www.reuters.
how do i extract from
1) OVERALL
2) FINANCIALS
3) COMPETITORS
section
thanks!
--- In smf_addin@yahoogrou
>
> That's a dynamically generated web page, so the data isn't there. It
> sources it from here:
>
> http://financials.
>
> When you look at the source code of your web page below, look for the
> "loadcompanypr
> from the source pages.
>
> On Wed, May 8, 2013 at 3:12 AM, weekeewawa <weekeewawa@
>
> >
> > other than this, is this the code to exttract data from this page
> >
> >
> > http://financials.
> >
> > (specifically wants the ''Business Description IBM'' section to be
> > extracted)?
> >
> > tried the page source method but doesnt work
> >
>
Wed May 8, 2013 10:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
What did you try?
On Wed, May 8, 2013 at 9:59 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> i see that the page source doesnt display the data that i needed
>
> therefore back to reuters
>
> on this page
>
> http://www.reuters.com/finance/stocks/overview?symbol=IBM
>
> how do i extract from
>
> 1) OVERALL
>
>
> 2) FINANCIALS
>
>
> 3) COMPETITORS
>
> section
>
On Wed, May 8, 2013 at 9:59 AM, weekeewawa <weekeewawa@yahoo.
>
> i see that the page source doesnt display the data that i needed
>
> therefore back to reuters
>
> on this page
>
> http://www.reuters.
>
> how do i extract from
>
> 1) OVERALL
>
>
> 2) FINANCIALS
>
>
> 3) COMPETITORS
>
> section
>
Wed May 8, 2013 8:42 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy
what i mean is,
is there any code that i can extract datas from this page
http://www.reuters.com/finance/stocks/overview?symbol=IBM
where i can extract datas from the section
1) OVERALL
2) FINANCIAL
3) COMPETITORS
thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> What did you try?
>
> On Wed, May 8, 2013 at 9:59 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > i see that the page source doesnt display the data that i needed
> >
> > therefore back to reuters
> >
> > on this page
> >
> > http://www.reuters.com/finance/stocks/overview?symbol=IBM
> >
> > how do i extract from
> >
> > 1) OVERALL
> >
> >
> > 2) FINANCIALS
> >
> >
> > 3) COMPETITORS
> >
> > section
> >
>
what i mean is,
is there any code that i can extract datas from this page
http://www.reuters.
where i can extract datas from the section
1) OVERALL
2) FINANCIAL
3) COMPETITORS
thanks!
--- In smf_addin@yahoogrou
>
> What did you try?
>
> On Wed, May 8, 2013 at 9:59 AM, weekeewawa <weekeewawa@
>
> >
> > i see that the page source doesnt display the data that i needed
> >
> > therefore back to reuters
> >
> > on this page
> >
> > http://www.reuters.
> >
> > how do i extract from
> >
> > 1) OVERALL
> >
> >
> > 2) FINANCIALS
> >
> >
> > 3) COMPETITORS
> >
> > section
> >
>
Wed May 8, 2013 10:16 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to learn how to do these yourself. All three are very
straight-forward:
=RCHGetTableCell("http://www.reuters.com/finance/stocks/overview?symbol=IBM
",1,"Beta:")
=RCHGetTableCell("http://www.reuters.com/finance/stocks/overview?symbol=IBM ",1,"P/E
(TTM)")
=RCHGetHTMLTable("http://www.reuters.com/finance/stocks/overview?symbol=IBM
","Competitors";,1,"",1)
On Wed, May 8, 2013 at 8:42 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hello randy
>
> what i mean is,
>
> is there any code that i can extract datas from this page
>
> http://www.reuters.com/finance/stocks/overview?symbol=IBM
>
> where i can extract datas from the section
>
> 1) OVERALL
>
> 2) FINANCIAL
>
> 3) COMPETITORS
>
straight-forward:
=RCHGetTableCell(
",1,"
=RCHGetTableCell(
(TTM)")
=RCHGetHTMLTable(
","
On Wed, May 8, 2013 at 8:42 PM, weekeewawa <weekeewawa@yahoo.
> hello randy
>
> what i mean is,
>
> is there any code that i can extract datas from this page
>
> http://www.reuters.
>
> where i can extract datas from the section
>
> 1) OVERALL
>
> 2) FINANCIAL
>
> 3) COMPETITORS
>
Wed May 8, 2013 5:53 am (PDT) . Posted by:
"antonvanas1989" antonvanas1989
To clarify i use those data/ratios only for historical view of the company. So it is a comparison with historical data/ratios. For the most current ratios i use ADVFN MRQ data and for prices i use Yahoo! Those data/ratios are correct.
And as graphic (view of price to earnings/dividend) i use prices(low to high) and a line for earnings and dividens. So when dividens are diluted in the price already the graphic is not realistic.
--- In smf_addin@yahoogroups.com , "antonvanas1989" <antonvanas1989@...> wrote:
>
> Posted By: rharmelink rharmelink Send Email
> Fri May 3, 2013 11:40 pm |
>
> Yahoo adjusts both for dividends and for splits. I would think you'd want prices adjusted only by splits for your calculations. But that's just an opinion.
>
> You could do your own adjustments, only for splits. See:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/14400
>
>
>
> This was the answer on the other topic i had, sorry i had posted this question by mail and online, my bad.
>
> It is true that my sheet can only get 2012 information if it is set to public by advfn. But i use those data to make a graphic, and use those data also for showing the past preformance. So lets say you want toknow the average P/E ratio of Coca Cola of the last 5-10 year. i got them. But if the prices from yahoo! get diluted year by year, there is no real use for those calculations, because they not represent the "orginal" data.
>
> My formula's used:
> Low: =IFERROR(smfPricesBetween(YHTicker;L3;L4;"06");"--")
> High: =IFERROR(smfPricesBetween(YHTicker;L3;L4;"04");"--")
> Close: =IFERROR(smfPricesByDates(YHTicker;L4);"0,00")
> Adj. Close: =IFERROR(RCHGetYahooHistory(YHTicker;YEAR(L3);MONTH(L3);DAY(L3);YEAR(L4);MONTH(L4);DAY(L4);;"C";0);"--")
>
> Where L3 = 01-01-2012 and L4 = 12-31-2012
>
> So i need the "real" period low/high for the P/E(low/high)
>
> Those period prices are for past preformance calculations. So you get a view of the past from the company.
>
And as graphic (view of price to earnings/dividend) i use prices(low to high) and a line for earnings and dividens. So when dividens are diluted in the price already the graphic is not realistic.
--- In smf_addin@yahoogrou
>
> Posted By: rharmelink rharmelink Send Email
> Fri May 3, 2013 11:40 pm |
>
> Yahoo adjusts both for dividends and for splits. I would think you'd want prices adjusted only by splits for your calculations. But that's just an opinion.
>
> You could do your own adjustments, only for splits. See:
>
> http://finance.
>
>
>
> This was the answer on the other topic i had, sorry i had posted this question by mail and online, my bad.
>
> It is true that my sheet can only get 2012 information if it is set to public by advfn. But i use those data to make a graphic, and use those data also for showing the past preformance. So lets say you want toknow the average P/E ratio of Coca Cola of the last 5-10 year. i got them. But if the prices from yahoo! get diluted year by year, there is no real use for those calculations, because they not represent the "orginal" data.
>
> My formula'
> Low: =IFERROR(smfPricesB
> High: =IFERROR(smfPricesB
> Close: =IFERROR(smfPricesB
> Adj. Close: =IFERROR(RCHGetYaho
>
> Where L3 = 01-01-2012 and L4 = 12-31-2012
>
> So i need the "real" period low/high for the P/E(low/high)
>
> Those period prices are for past preformance calculations. So you get a view of the past from the company.
>
Wed May 8, 2013 6:58 am (PDT) . Posted by:
"tora_toba" tora_toba
I had actually changed the "ks" to "bs" shortly after that email I sent you (I just didn't update you on that when I caught it) but was still getting an error until last night when I added the '&"&ql="'. Adding it at the end of the "~~~~~" didn't work either until I took it outside of the quote. So I don't know why it makes a difference since you say it's irrelevant but it was what made it work.
I'll try the smfEval later today.
Thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The "&ql=1" is irrelevant. What mattered is that you changed the base URL.
> Original:
>
> 1648;YahooQBS;Quarterly Balance Sheet -- Total Assets --
> FQ1;=RCHGetTableCell("http://finance.yahoo.com/q/ks?s=~~~~~ ",1,">TOTAL
> ASSETS")
>
> Note it is getting the "Key Statistics" page (i.e. "ks"). Your version
> below has "bs" for the balance sheet. That's why you're no longer getting
> an error.
>
> If you want to test a formula in your workbook, you could do:
>
> =smfEval(SUBSTITUTE(C4,"~~~~~",C3))
>
> ...where C4 contains a ticker symbol and C3 contains your element
> definition formula without the "=", such as:
>
> RCHGetTableCell("http://finance.yahoo.com/q/bs?s=~~~~~ ",1,"TOTAL ASSETS")
>
> On Tue, May 7, 2013 at 9:15 PM, tora_toba <ctphan02@...> wrote:
>
> > Yes, I did several times. I also restarted excel as well in case it
> > needed it to recognize the changes in the element text file. I'm thinking
> > it's not adding the "&ql=1" after the ticker in the URL when replacing the
> > "~~~~~" in the string. At least when I looked through your code, I
> > couldn't see how it would add it offhand.
> >
> > Ok... now that I've said that, I just got it to work by changing the line
> > in the element file to this:
> >
> > 1648;YahooQBS;Quarterly Balance Sheet -- Total Assets --
> > FQ1;=RCHGetTableCell("http://finance.yahoo.com/q/bs?s=~~~~~ "&"&ql=1",1,"TOTAL
> > ASSETS")
> >
> > I also took out the "1" after the "=" and it still seemed to work, so I
> > assume the "1" passed in after the comma does that?
> >
>
I'll try the smfEval later today.
Thanks!
--- In smf_addin@yahoogrou
>
> The "&ql=1" is irrelevant. What mattered is that you changed the base URL.
> Original:
>
> 1648;YahooQBS;
> FQ1;=RCHGetTableCel
> ASSETS"
>
> Note it is getting the "Key Statistics" page (i.e. "ks"
> below has "bs" for the balance sheet. That's why you're no longer getting
> an error.
>
> If you want to test a formula in your workbook, you could do:
>
> =smfEval(SUBSTITUTE
>
> ...where C4 contains a ticker symbol and C3 contains your element
> definition formula without the "="
>
> RCHGetTableCell(
>
> On Tue, May 7, 2013 at 9:15 PM, tora_toba <ctphan02@
>
> > Yes, I did several times. I also restarted excel as well in case it
> > needed it to recognize the changes in the element text file. I'm thinking
> > it's not adding the "&ql=1" after the ticker in the URL when replacing the
> > "~~~~~" in the string. At least when I looked through your code, I
> > couldn't see how it would add it offhand.
> >
> > Ok... now that I've said that, I just got it to work by changing the line
> > in the element file to this:
> >
> > 1648;YahooQBS;
> > FQ1;=RCHGetTableCel
> > ASSETS"
> >
> > I also took out the "1" after the "=" and it still seemed to work, so I
> > assume the "1" passed in after the comma does that?
> >
>
Wed May 8, 2013 7:53 am (PDT) . Posted by:
"scott_mastbrook" scott_mastbrook
Thank you. That worked.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not a clue. Here's what I did:
>
> 1. Entered this formula and got the expected "Error" value returned:
>
> =smfGet888OptionQuote("QQQ",,,,"HV10L")
>
> 2. Hit alt+d+d+w to open up the EXCEL Web Query and entered this web
> address:
>
> http://www.optionseducation.org/quotes.html?quote=SPY
>
> ...which is the ultimate result of all the redirection, as you noted.
> So, basically, just a shortcut way to get to that final result instead of
> navigating the other web pages to get there. Note that I cancel out of the
> Web Query dialog at this point, instead of trying to import something. All
> I needed to do was visit that web page to have the EXCEL IE object create
> the necessary security cookie for further accesses to the iVolatility
> website.
>
> 3. Ran the smfForceRecalculation macro. The formula recalculated with
> 0.047.
>
>
> On Tue, May 7, 2013 at 10:38 AM, scott_mastbrook
> <scott_mastbrook@...>wrote:
>
> >
> > still not sure why I can't get the smfGet888OptionQuote function to work
> > though. any thoughts on my issue there?
> >
>
--- In smf_addin@yahoogrou
>
> Not a clue. Here's what I did:
>
> 1. Entered this formula and got the expected "Error" value returned:
>
> =smfGet888OptionQuo
>
> 2. Hit alt+d+d+w to open up the EXCEL Web Query and entered this web
> address:
>
> http://www.optionse
>
> ...which is the ultimate result of all the redirection, as you noted.
> So, basically, just a shortcut way to get to that final result instead of
> navigating the other web pages to get there. Note that I cancel out of the
> Web Query dialog at this point, instead of trying to import something. All
> I needed to do was visit that web page to have the EXCEL IE object create
> the necessary security cookie for further accesses to the iVolatility
> website.
>
> 3. Ran the smfForceRecalculati
> 0.047.
>
>
> On Tue, May 7, 2013 at 10:38 AM, scott_mastbrook
> <scott_mastbrook
>
> >
> > still not sure why I can't get the smfGet888OptionQuot
> > though. any thoughts on my issue there?
> >
>
Wed May 8, 2013 8:54 am (PDT) . Posted by:
"crollalanzaws" crollalanzaws
Hi,
I've been having some difficulty trying to figure out how to get data from a table where the headings are along the columns and data to be extracted is along a row.
The website is: http://www.nbc.ca/bnc/cda/feeds5/0,2726,divId-2_langId-1_navCode-14854,00.html
I would like to be able to pull the data that is underneath the column "In Canadian Dollars"
Thank you.
I've been having some difficulty trying to figure out how to get data from a table where the headings are along the columns and data to be extracted is along a row.
The website is: http://www.nbc.
I would like to be able to pull the data that is underneath the column "In Canadian Dollars"
Thank you.
Wed May 8, 2013 8:58 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to use the parameter that tells the function to skip rows. For
example:
=RCHGetTableCell("
http://www.nbc.ca/bnc/cda/feeds5/0,2726,divId-2_langId-1_navCode-14854,00.html
",
1,"in Canadian dollars",,,,1)
On Wed, May 8, 2013 at 7:58 AM, crollalanzaws
<florio.crollalanza@yahoo.com >wrote:
>
> I've been having some difficulty trying to figure out how to get data
> from a table where the headings are along the columns and data to be
> extracted is along a row.
> The website is:
> http://www.nbc.ca/bnc/cda/feeds5/0,2726,divId-2_langId-1_navCode-14854,00.html
>
> I would like to be able to pull the data that is underneath the column "In
> Canadian Dollars"
>
example:
=RCHGetTableCell(
http://www.nbc.
",
1,"in Canadian dollars"
On Wed, May 8, 2013 at 7:58 AM, crollalanzaws
<florio.crollalanza@
>
> I've been having some difficulty trying to figure out how to get data
> from a table where the headings are along the columns and data to be
> extracted is along a row.
> The website is:
> http://www.nbc.
>
> I would like to be able to pull the data that is underneath the column "In
> Canadian Dollars"
>
Wed May 8, 2013 10:55 am (PDT) . Posted by:
"crollalanzaws" crollalanzaws
Something is not quite working yet.
When I press the Excel function button, fx, to look at the arguments, it
shows a calculated value of 1.25, as expected. But the cell itself shaw
a value of "FALSE"
I trield playing around with the parameters, but I can't get it to work.
The link is right, and the input values line up as expected for the
function.
Thank you.
Wed May 8, 2013 11:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Do you have a special format on the cell?
On Wed, May 8, 2013 at 10:55 AM, crollalanzaws <florio.crollalanza@yahoo.com
> wrote:
> Something is not quite working yet.
>
> When I press the Excel function button, *f*x, to look at the arguments,
> it shows a calculated value of 1.25, as expected. But the cell itself shaw
> a value of "FALSE".
>
> I trield playing around with the parameters, but I can't get it to work.
> The link is right, and the input values line up as expected for the
> function.
>
>
On Wed, May 8, 2013 at 10:55 AM, crollalanzaws <florio.crollalanza@
> wrote:
> Something is not quite working yet.
>
> When I press the Excel function button, *f*x, to look at the arguments,
> it shows a calculated value of 1.25, as expected. But the cell itself shaw
> a value of "FALSE"
>
> I trield playing around with the parameters, but I can't get it to work.
> The link is right, and the input values line up as expected for the
> function.
>
>
Wed May 8, 2013 11:50 am (PDT) . Posted by:
"crollalanzaws" crollalanzaws
No, that's what I had thought that it might be. I went through all the different formats, and the cell comes up as FALSE for all formats. Then, i decided to respond back because I wasn't getting anywhere.
On the web site the value displays as "1,25 %"
Wed May 8, 2013 1:11 pm (PDT) . Posted by:
"crollalanzaws" crollalanzaws
I finally figured it out. Embarassing mistake. Somehow I pasted the
formula 2x. The formula was so long that it occupied more than one line
of the formula bar. I didn't notice because the formula bar by default
displays one line, and the argument screen only displayed the formula
once. Thank you.
--- In smf_addin@yahoogrou
>
>
> No, that's what I had thought that it might be. I went through all the
different formats, and the cell comes up as FALSE for all formats. Then,
i decided to respond back because I wasn't getting anywhere.
>
> On the web site the value displays as "1,25 %"
>
Tidak ada komentar:
Posting Komentar