6 New Messages
Digest #2800
Messages
Mon Oct 7, 2013 7:43 am (PDT) . Posted by:
weekeewawa
hello randy
how do i extract certain data from bloomberg using
rchgettablecell?
tried using the code below but the data just does not point to
what i want
=RCHGetTableCell("http://www.bloomberg.com/quote/"&A1&"",1,"Sub-I\
ndustry")
i want to get data for example
1) Sub-Industry (IT Services)2) price of the stock (182.8720
USD)3) name of the stock (International Business Machines Corp)
thanks
how do i extract certain data from bloomberg using
rchgettablecell?
tried using the code below but the data just does not point to
what i want
=RCHGetTableCell(
ndustry"
i want to get data for example
1) Sub-Industry (IT Services)2) price of the stock (182.8720
USD)3) name of the stock (International Business Machines Corp)
thanks
Mon Oct 7, 2013 8:17 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You didn't look at the source code of the web page, did you? None of the
things you want are in tables.
Try:
=smfGetTagContent("http://www.bloomberg.com/quote/IBM:US
","span",1,"Sub-Industry")
=smfGetTagContent("http://www.bloomberg.com/quote/IBM:US
","h2",1,"ticker_header")
=smfGetTagContent("http://www.bloomberg.com/quote/IBM:US
","span",1,"add_ticker")
Your URL was bad as well. The ticker symbols needs the ":US" suffix on it.
That last item needs to be parsed to get out the specific data your want.
I'll leave that to you.
On Mon, Oct 7, 2013 at 7:43 AM, <weekeewawa@yahoo.com> wrote:
>
>
> how do i extract certain data from bloomberg using rchgettablecell?
>
> tried using the code below but the data just does not point to what i want
>
> =RCHGetTableCell("http://www.bloomberg.com/quote/"&A1&"",1,"Sub-Industry")
>
> i want to get data for example
>
> 1) Sub-Industry (IT Services)
> 2) price of the stock (182.8720 USD)
> 3) name of the stock (International Business Machines Corp)
>
>
>
things you want are in tables.
Try:
=smfGetTagContent(
","
=smfGetTagContent(
","
=smfGetTagContent(
","
Your URL was bad as well. The ticker symbols needs the ":US" suffix on it.
That last item needs to be parsed to get out the specific data your want.
I'll leave that to you.
On Mon, Oct 7, 2013 at 7:43 AM, <weekeewawa@yahoo.
>
>
> how do i extract certain data from bloomberg using rchgettablecell?
>
> tried using the code below but the data just does not point to what i want
>
> =RCHGetTableCell(
>
> i want to get data for example
>
> 1) Sub-Industry (IT Services)
> 2) price of the stock (182.8720 USD)
> 3) name of the stock (International Business Machines Corp)
>
>
>
Mon Oct 7, 2013 5:08 pm (PDT) . Posted by:
weekeewawa
hello randy,
when i extract the price data for IBM using the code below
=smfGetTagContent(
1,"add_
the result shows 182.100 <Span> USD
is there a way to just display 182.100?
thanks
---In smf_addin@yahoogrou
You didn't look at the source code of the web page, did you? None
of the things you want are in tables.
Try:
=smfGetTagContent(
<http://www.bloomber
","
=smfGetTagContent(
<http://www.bloomber
=smfGetTagContent(
<http://www.bloomber
Your URL was bad as well. The ticker symbols needs the ":US"
suffix on it. That last item needs to be parsed to get out the
specific data your want. I'll leave that to you.
On Mon, Oct 7, 2013 at 7:43 AM, <weekeewawa@
<mailto:weekeewa
how do i extract certain data from bloomberg using
rchgettablecell?
tried using the code below but the data just does not point to
what i want
=RCHGetTableCell(
<http://www.bloomber
i want to get data for example
1) Sub-Industry (IT Services) 2) price of the stock (182.8720
USD) 3) name of the stock (International Business Machines Corp)
Mon Oct 7, 2013 7:19 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Use the smfStrExtr() function, as we've done before...
On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@yahoo.com> wrote:
> when i extract the price data for IBM using the code below
>
> =smfGetTagContent("http://www.bloomberg.com/quote/IBM:US
> ","span",1,"add_ticker")
>
> the result shows 182.100 <Span> USD
>
> is there a way to just display 182.100?
>
On Mon, Oct 7, 2013 at 5:08 PM, <weekeewawa@yahoo.
> when i extract the price data for IBM using the code below
>
> =smfGetTagContent(
> ","
>
> the result shows 182.100 <Span> USD
>
> is there a way to just display 182.100?
>
Mon Oct 7, 2013 12:42 pm (PDT) . Posted by:
"sethi_neil" sethi_neil
I am new to this group, so I apologize if this is answered somewhere else (I tried to search for it), but I didn't see anywhere that you can get Morningstar data like moat rating, stewardship rating, etc. Is it possible to the add-in to pull that data?
Thanks very much for any help.
Neil
Thanks very much for any help.
Neil
Mon Oct 7, 2013 12:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You would need to manually log in to MorningStar with the EXCEL Web Query
dialog (or IE) first. but once you have the IE security cookie in place,
you can extract the data off their web pages.
For example, the RCHGetTableCell-Template-Morningstar-Stock-Grades.xls
template from the files area produces this:
*MMM* *Description* *Value* MorningStar Rating: 2
Growth Rating: C Profitability Rating: C Financial Health Rating: B
Consider Buying: $84.00 Fair Value: $105.00 Consider Selling:
$131.25 Stewardship Grade: NA Economic Moat: Wide Fair Value
Certainty: Low
The formula for Economic Moat looks like this:
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol="&B$2,
2,">Economic Moat",,,,1)
On Mon, Oct 7, 2013 at 12:27 PM, sethi_neil <sethi_neil@yahoo.com> wrote:
> I am new to this group, so I apologize if this is answered somewhere else
> (I tried to search for it), but I didn't see anywhere that you can get
> Morningstar data like moat rating, stewardship rating, etc. Is it possible
> to the add-in to pull that data?
>
>
dialog (or IE) first. but once you have the IE security cookie in place,
you can extract the data off their web pages.
For example, the RCHGetTableCell-
template from the files area produces this:
*MMM* *Description* *Value* MorningStar Rating: 2
Growth Rating: C Profitability Rating: C Financial Health Rating: B
Consider Buying: $84.00 Fair Value: $105.00 Consider Selling:
$131.25 Stewardship Grade: NA Economic Moat: Wide Fair Value
Certainty: Low
The formula for Economic Moat looks like this:
=RCHGetTableCell(
http://quicktake.
2,">
On Mon, Oct 7, 2013 at 12:27 PM, sethi_neil <sethi_neil@yahoo.
> I am new to this group, so I apologize if this is answered somewhere else
> (I tried to search for it), but I didn't see anywhere that you can get
> Morningstar data like moat rating, stewardship rating, etc. Is it possible
> to the add-in to pull that data?
>
>
Tidak ada komentar:
Posting Komentar