2 Messages

Digest #4354

Re: Bloomberg data by bushpilote

Re: Bloomberg data by "Randy Harmelink" rharmelink

Messages

1a

No luck. I'll try it later on in the week . In the interim would it be possible to extract closing price from

https://markets.ft.com/data/indices/tearsheet/summary?s=BCOMSP:IOM https://markets.ft.com/data/indices/tearsheet/summary?s=BCOMSP:IOM or

close and previous close from

https://www.marketwatch.com/investing/index/bcomsp/historical?countrycode=xx https://www.marketwatch.com/investing/index/bcomsp/historical?countrycode=xx

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

1b

Re: Bloomberg data

Wed Jul 4, 2018 9:03 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("
https://markets.ft.com/data/indices/tearsheet/summary?s=BCOMSP:IOM
","span",1,">Price",,,,1)

=smfGetTagContent("
https://www.marketwatch.com/investing/index/bcomsp/historical?countrycode=xx
","p",2,"class=""lastprice""",,,,1)

You should try visiting the problem web pages in EXCEL's IE object
(keyboard shortcut alt+d+d+w) and see if there is any kind of message that
the website is giving you:

https://www.bloomberg.com/markets/api/bulk-time-series/price/HSI:IND?timeFrame=1_YEAR
https://www.bloomberg.com/quote/BCOM:IND

On Wed, Jul 4, 2018 at 7:23 AM, bushpilote@
...
wrote:

>
> No luck. I'll try it later on in the week . In the interim would it be
> possible to extract closing price from
>
> https://markets.ft.com/data/indices/tearsheet/summary?s=BCOMSP:IOM or
>
> close and previous close from
>
> https://www.marketwatch.com/investing/index/bcomsp/
> historical?countrycode=xx
>
>
>