Minggu, 30 Oktober 2016

[smf_addin] Digest Number 3829

5 Messages

Digest #3829
1a
bloomberg data by wongkayau
1b
Re: bloomberg data by "Randy Harmelink" rharmelink
1c
1d
Re: bloomberg data by "Randy Harmelink" rharmelink
2a
Re: yahoo history array start date by "Magic Oreo" cs.holdings

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








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?
>
>

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

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?
>
>

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&quot;,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?


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

Tidak ada komentar:

Poskan Komentar