5 New Messages
Digest #2523
Messages
Mon Feb 25, 2013 11:52 am (PST) . Posted by:
"Randy Harmelink" rharmelink
A workaround would be to grab it from the quotes page:
=RCHGetTableCell("http://finance.yahoo.com/q?s=mmm ",1,"Next Earnings Date")
On Mon, Feb 25, 2013 at 7:19 AM, JCHyjun jchyjun@yahoo.com > wrote:
> You are right but how to grab this info in MS_Excel?
>
=RCHGetTableCell(
On Mon, Feb 25, 2013 at 7:19 AM, JCHyjun jchyjun@yahoo.
> You are right but how to grab this info in MS_Excel?
>
Mon Feb 25, 2013 4:18 pm (PST) . Posted by:
"DonaldB" donald_brown_48367
Hi Randy,
Is there a way to get the actual number of advancing / declining stocks off the yahoo market statistics page rather than the percentage in brackets? (I can use the percentage and then calculate the number from the total number of stocks but it is always a little off from the actual posted number). Thanks for your help.
Regards,
Don
Is there a way to get the actual number of advancing / declining stocks off the yahoo market statistics page rather than the percentage in brackets? (I can use the percentage and then calculate the number from the total number of stocks but it is always a little off from the actual posted number). Thanks for your help.
Regards,
Don
Mon Feb 25, 2013 6:42 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Actually, if you look at the values, the element numbers are returning
both. Apparently, Yahoo has modified the web page, and added the percentage
values in the same table cell as the number of shares, since I defined the
elements for their Market Statistics web page.
For example, when I look at the upper left-hand corner of the template,
this formula:
=RCHGetElementNumber("YahooMS", 13822)
...is actually returning:
996 (24%)
The two values can easily be extracted:
=0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"~"," ")
=0+smfStrExtr(RCHGetElementNumber("YahooMS", 13822),"(",")")
HOWEVER -- take a look at the differences between these three web page:
http://finance.yahoo.com/advances
http://www.barchart.com/stocks/momentum.php
http://online.wsj.com/mdc/public/page/2_3021-tradingdiary2.html
http://unicorn.us.com/advdec/
Quite a difference in values, huh? To me, the Yahoo numbers look very bad.
First off, I suspect the other sources omit things like ETFs? It doesn't
really help to count advancing/declining when you can have ETFs that are
both long and short -- if one advances, the other should be declining.
On Mon, Feb 25, 2013 at 5:18 PM, DonaldB donald_brown_48367@yahoo.com >wrote:
>
> Is there a way to get the actual number of advancing / declining stocks
> off the yahoo market statistics page rather than the percentage in
> brackets? (I can use the percentage and then calculate the number from the
> total number of stocks but it is always a little off from the actual posted
> number). Thanks for your help.
>
both. Apparently, Yahoo has modified the web page, and added the percentage
values in the same table cell as the number of shares, since I defined the
elements for their Market Statistics web page.
For example, when I look at the upper left-hand corner of the template,
this formula:
=RCHGetElementNumbe
...is actually returning:
996 (24%)
The two values can easily be extracted:
=0+smfStrExtr(
=0+smfStrExtr(
HOWEVER -- take a look at the differences between these three web page:
http://finance.
http://www.barchart
http://online.
http://unicorn.
Quite a difference in values, huh? To me, the Yahoo numbers look very bad.
First off, I suspect the other sources omit things like ETFs? It doesn't
really help to count advancing/declining when you can have ETFs that are
both long and short -- if one advances, the other should be declining.
On Mon, Feb 25, 2013 at 5:18 PM, DonaldB donald_brown_
>
> Is there a way to get the actual number of advancing / declining stocks
> off the yahoo market statistics page rather than the percentage in
> brackets? (I can use the percentage and then calculate the number from the
> total number of stocks but it is always a little off from the actual posted
> number). Thanks for your help.
>
Mon Feb 25, 2013 9:00 pm (PST) . Posted by:
"drsues02" drsues02
Trying to pull info from the otcmarkets.com website. Here is the standard URL:
Ticker: CSVI
http://www.otcmarkets.com/stock/CSVI/financials
I'd like to be able to pull the basic financial information for each period listed - revenues, operating income, etc, along with items from the balance sheet & cash flow if possible.
When I try to look at the page in a web query via excel, it doesn't seem to have the nicely formatted tables, and when moving between the Income Statement and Balance Sheet, the URL doesn't change..
Would also be great to pull additional info from other closely related pages i.e. http://www.otcmarkets.com/stock/CSVI/company-info by searching for a specific string (like Market Value)
Ticker: CSVI
http://www.otcmarke
I'd like to be able to pull the basic financial information for each period listed - revenues, operating income, etc, along with items from the balance sheet & cash flow if possible.
When I try to look at the page in a web query via excel, it doesn't seem to have the nicely formatted tables, and when moving between the Income Statement and Balance Sheet, the URL doesn't change..
Would also be great to pull additional info from other closely related pages i.e. http://www.otcmarke
Mon Feb 25, 2013 9:12 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but the financial statements web pages are dynamically generated, so
there is nothing within the source code of the web page for the add-in to
extract.
The other item is relatively easy:
=RCHGetTableCell("http://www.otcmarkets.com/stock/CSVI/company-info ",1,">Market
Value")
On Mon, Feb 25, 2013 at 10:00 PM, drsues02 drsues02@hotmail.com > wrote:
> Trying to pull info from the otcmarkets.com website. Here is the standard
> URL:
>
> Ticker: CSVI
> http://www.otcmarkets.com/stock/CSVI/financials
>
> I'd like to be able to pull the basic financial information for each
> period listed - revenues, operating income, etc, along with items from the
> balance sheet & cash flow if possible.
>
> When I try to look at the page in a web query via excel, it doesn't seem
> to have the nicely formatted tables, and when moving between the Income
> Statement and Balance Sheet, the URL doesn't change..
>
> Would also be great to pull additional info from other closely related
> pages i.e. http://www.otcmarkets.com/stock/CSVI/company-info by searching
> for a specific string (like Market Value)
>
there is nothing within the source code of the web page for the add-in to
extract.
The other item is relatively easy:
=RCHGetTableCell(
Value")
On Mon, Feb 25, 2013 at 10:00 PM, drsues02 drsues02@hotmail.
> Trying to pull info from the otcmarkets.com website. Here is the standard
> URL:
>
> Ticker: CSVI
> http://www.otcmarke
>
> I'd like to be able to pull the basic financial information for each
> period listed - revenues, operating income, etc, along with items from the
> balance sheet & cash flow if possible.
>
> When I try to look at the page in a web query via excel, it doesn't seem
> to have the nicely formatted tables, and when moving between the Income
> Statement and Balance Sheet, the URL doesn't change..
>
> Would also be great to pull additional info from other closely related
> pages i.e. http://www.otcmarke
> for a specific string (like Market Value)
>
Tidak ada komentar:
Posting Komentar