5 Messages
Digest #3829
Messages
Sat Oct 29, 2016 5:57 am (PDT) . Posted by:
wongkayau
Hi Randy,
Good morning.
I have been using excel to download index data from Bloomberg via this link:
http://www.bloomberg.com/markets/api/bulk-time-series/price/HSI:IND?timeFrame=1_YEAR
However, it does not work suddenly, although it works fine and I place the url in Firefox which shows all the data.
Is it because Bloomberg does not allow excel data download anymore?
Thank you so much for your help.
Best regards,
Laurent
Good morning.
I have been using excel to download index data from Bloomberg via this link:
http://www.bloomberg.com/markets/api/bulk-time-series/price/HSI:IND?timeFrame=1_YEAR
However, it does not work suddenly, although it works fine and I place the url in Firefox which shows all the data.
Is it because Bloomberg does not allow excel data download anymore?
Thank you so much for your help.
Best regards,
Laurent
Sat Oct 29, 2016 4:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Note that when you go to the URL you site, you end up on a different web
page:
https://www.bloomberg.com/markets/api/bulk-time-series/price/HSI:IND?timeFrame=1_YEAR
That is, "http" to "https". The add-in doesn't like being redirected to a
different URL. But your browser doesn't mind.
On Sat, Oct 29, 2016 at 5:57 AM, wongkayau@
... wrote:
> I have been using excel to download index data from Bloomberg via this
> link:
>
> http://www.bloomberg.com/markets/api/bulk-time-series/
> price/HSI:IND?timeFrame=1_YEAR
>
> However, it does not work suddenly, although it works fine and I place the
> url in Firefox which shows all the data.
>
> Is it because Bloomberg does not allow excel data download anymore?
>
>
page:
https://www.bloomberg.com/markets/api/bulk-time-series/price/HSI:IND?timeFrame=1_YEAR
That is, "http" to "https". The add-in doesn't like being redirected to a
different URL. But your browser doesn't mind.
On Sat, Oct 29, 2016 at 5:57 AM, wongkayau@
... wrote:
> I have been using excel to download index data from Bloomberg via this
> link:
>
> http://www.bloomberg.com/markets/api/bulk-time-series/
> price/HSI:IND?
>
> However, it does not work suddenly, although it works fine and I place the
> url in Firefox which shows all the data.
>
> Is it because Bloomberg does not allow excel data download anymore?
>
>
Sat Oct 29, 2016 7:26 pm (PDT) . Posted by:
wongkayau
Hi Randy,
Thank you so much! You are so great.
Since the data has already been downloaded to Firefox/IE by "https://", is it possible to capture the data to excel? I have tried Data from Web of "Data" tab in excel, and a dialogue box has been popped up to open HSI_IND.json. I don't know how to deal with it. Could you please help?
Thanks a lot.
Best regards,
L
Thank you so much! You are so great.
Since the data has already been downloaded to Firefox/IE by "https:
Thanks a lot.
Best regards,
L
Sat Oct 29, 2016 8:01 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Here's how I would extract the data from that JSON output using the add-in
functions:
C4: =RCHGetWebData("
https://www.bloomberg.com/markets/api/bulk-time-series/price/HSI:IND?timeFrame=1_YEAR
")
B5: =B4+1
C5: =DATEVALUE(smfStrExtr(smfWord($C$4,$B5+1,"""date"""),":""",""""))
D5:
=smfConvertData(smfStrExtr(smfWord($C$4,$B5+1,"""date"""),"value"":","}"))
...and then copy row 5 down as needed.
On Sat, Oct 29, 2016 at 7:26 PM, wongkayau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Since the data has already been downloaded to Firefox/IE by "https://",
> is it possible to capture the data to excel? I have tried Data from Web of
> "Data" tab in excel, and a dialogue box has been popped up to open
> HSI_IND.json. I don't know how to deal with it. Could you please help?
>
>
functions:
C4: =RCHGetWebData("
https://www.bloomberg.com/markets/api/bulk-time-series/price/HSI:IND?timeFrame=1_YEAR
")
B5: =B4+1
C5: =DATEVALUE(smfStrExtr(smfWord($C$4,$B5+1,"""date"""),":""",""""))
D5:
=smfConvertData(smfStrExtr(smfWord($C$4,$B5+1,"""date"""),"value"":","}"))
...and then copy row 5 down as needed.
On Sat, Oct 29, 2016 at 7:26 PM, wongkayau@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
> Since the data has already been downloaded to Firefox/IE by "https:
> is it possible to capture the data to excel? I have tried Data from Web of
> "Data" tab in excel, and a dialogue box has been popped up to open
> HSI_IND.json. I don't know how to deal with it. Could you please help?
>
>
Sat Oct 29, 2016 9:09 am (PDT) . Posted by:
"Magic Oreo" cs.holdings
That's clever … thanks!!
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, October 24, 2016 11:18 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] yahoo history array start date
You can specify no dates or both dates, but not just one date...
If you're just looking for YTD numbers, try something like:
=RCHGetYahooHistory("^GSPC",2016,1,4,2016,12,31,"w","dA",,,1)
Then it will just give you what's available for the range of the two dates.
On Mon, Oct 24, 2016 at 3:54 AM, pc_babe@
... wrote:
Im trying to use the yahoo historical array. I'd like the start date to begin with this calendar year from Jan 4, 2016 ...and wrote:
=
RCHGetYahooHistory("^GSPC";,2016,01,04,,,,"w","dA",,,1)
But, the comment comes with "problems with start date". If I leave the dats switches empty, it works fine, but provides data to the size of the array
Do you have a suggestion?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Monday, October 24, 2016 11:18 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] yahoo history array start date
You can specify no dates or both dates, but not just one date...
If you're just looking for YTD numbers, try something like:
=RCHGetYahooHistory
Then it will just give you what's available for the range of the two dates.
On Mon, Oct 24, 2016 at 3:54 AM, pc_babe@
... wrote:
Im trying to use the yahoo historical array. I'd like the start date to begin with this calendar year from Jan 4, 2016 ...and wrote:
=
RCHGetYahooHistory(
But, the comment comes with "problems with start date". If I leave the dats switches empty, it works fine, but provides data to the size of the array
Do you have a suggestion?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar