[smf_addin] Digest Number 3425

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3425

1a

Re: Extract Closing Price From Bloomberg by bushpilote

1b

Re: Extract Closing Price From Bloomberg by "Randy Harmelink" rharmelink

2a

Re: ask randy about Ft.com [1 Attachment] by sri.yanto

Messages

1a

Re: Extract Closing Price From Bloomberg

Fri Jun 5, 2015 4:20 am (PDT) . Posted by:

bushpilote

Hi Randy, it worked beautifully. Thanks.


I have a follow up question.


The price change element in $ for a price decrease has the following description,
.price-container.down
.change-container {
color: #F00


How can I extract the color code "#F00"?

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

1b

Re: Extract Closing Price From Bloomberg

Fri Jun 5, 2015 8:24 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see that CSS code in the source code of the web page.

Another option is to pull the data out of the META tags:

=smfConvertData(smfstrExtr(RCHGetWebData("http://www.bloomberg.com/quote/
"&$D7,
"itemprop=""price""",100),"content=""",""""))

=smfConvertData(smfstrExtr(RCHGetWebData("http://www.bloomberg.com/quote/
"&$D7,
"itemprop=""priceChange""",100),"content=""",""""))

=smfConvertData(smfstrExtr(RCHGetWebData("http://www.bloomberg.com/quote/
"&$D7,
"itemprop=""priceChangePercent""",100),"content=""",""""))

=smfConvertData(smfstrExtr(RCHGetWebData("http://www.bloomberg.com/quote/
"&$D7,
"itemprop=""quoteTime""",100),"content=""",""""))

=smfstrExtr(RCHGetWebData("http://www.bloomberg.com/quote/
"&$D7,"itemprop=""priceCurrency""",100),"content=""","""")

On Fri, Jun 5, 2015 at 4:19 AM, bushpilote@yahoo.ca [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> it worked beautifully. Thanks.
>
> I have a follow up question.
>
> The price change element in $ for a price decrease has the following
> description,
> .price-container.down
> .change-container {
> color: #F00
>
> How can I extract the color code "#F00"?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (12) . Top ^

2a

Re: ask randy about Ft.com [1 Attachment]

Fri Jun 5, 2015 7:20 am (PDT) . Posted by:

sri.yanto

oke randy, thanks anyway

maybe my IE have some problem
for other site, like bberg...it's works very well


tks you





---In smf_addin@yahoogroups.com, <rharmelink@...> wrote :

I don't know what to tell you. I was able to bring up the web page, both in IE and FireFox. But I have an older version of IE. It may have been a temporary issue with one or more, maybe even all, of their servers.

On Fri, Jun 5, 2015 at 1:10 AM, sri.yanto... wrote:

i want ask something about IE and Ft.com


i'm using Ft.com several days ago to get daily price, then untill i found, my conection to Ft.com doesn't work any longer.


then i check to internet explorer, so i found Ft.com doesn't permit us to enter certain quotes.


i'm ask to you...were..it's happen to you too?


here the link


United Tractors Tbk PT, UNTR:JKT summary - FT.com http://markets.ft.com/research/Markets/Tearsheets/Summary?s=UNTR:JKT

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 21

• Privacy • Unsubscribe • Terms of Use