Kamis, 12 Mei 2016

[smf_addin] Digest Number 3696

13 Messages

Digest #3696
2a
Re: commodity price in bloomberg by "Randy Harmelink" rharmelink
2b
2c
Re: commodity price in bloomberg by "Randy Harmelink" rharmelink
2d
2e
Re: commodity price in bloomberg by "Randy Harmelink" rharmelink
2f
2g
Re: commodity price in bloomberg by "Randy Harmelink" rharmelink
2h
Re: commodity price in bloomberg by "Frank kirk" nautilustech
3a
Yahoo Major Holders by nicolaslee1992
3b
Re: Yahoo Major Holders by "Randy Harmelink" rharmelink
3c
Re: Yahoo Major Holders by "Kermit W. Prather" kermitpra
3d
Re: Yahoo Major Holders by "Randy Harmelink" rharmelink

Messages

Tue May 10, 2016 10:32 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Relevant URL please?

On Mon, May 9, 2016 at 7:00 PM, Ranto Sb rantosb@
​...wrote:

>
> How are you? thank you for your help in excel formula to get stock data.
> I need your help, is there any way or formula to get commodity data like
> WTI or Brent crude oil in Bloomberg?
>
>

Tue May 10, 2016 7:32 pm (PDT) . Posted by:

"Ranto Sb" sojuaon

For Example: http://www.bloomberg.com/quote/CL1:COM

thnx,

//ranto

2016-05-11 0:32 GMT+07:00 Randy Harmelink rharmelink@gmail.com [smf_addin] <
smf_addin@yahoogroups.com>:

>
>
> Relevant URL please?
>
> On Mon, May 9, 2016 at 7:00 PM, Ranto Sb rantosb@
> ​...wrote:
>
>>
>> How are you? thank you for your help in excel formula to get stock data.
>> I need your help, is there any way or formula to get commodity data like
>> WTI or Brent crude oil in Bloomberg?
>>
>>
>
>

Tue May 10, 2016 11:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Something like last price would be:

=smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM
","div",-1,"class=""price""",,,,1)

Something like open price would be:

=smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM","div",1,"As of
","Open",,,1)

On Tue, May 10, 2016 at 7:31 PM, Ranto Sb rantosb@
​...wrote:

>
> For Example: http://www.bloomberg.com/quote/CL1:COM
>
> How are you? thank you for your help in excel formula to get stock data.
> I need your help, is there any way or formula to get commodity data like
> WTI or Brent crude oil in Bloomberg?
>

Tue May 10, 2016 11:28 pm (PDT) . Posted by:

"Ranto Sb" sojuaon

Thnx Randy.
btw, is it possible to get historical data?

//ranto

2016-05-11 13:13 GMT+07:00 Randy Harmelink rharmelink@gmail.com [smf_addin]
<smf_addin@yahoogroups.com>:

>
>
> Something like last price would be:
>
> =smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM
> ","div",-1,"class=""price""",,,,1)
>
> Something like open price would be:
>
> =smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM","div",1,"As of
> ","Open",,,1)
>
>
> On Tue, May 10, 2016 at 7:31 PM, Ranto Sb rantosb@
> ​...wrote:
>
>>
>> For Example: http://www.bloomberg.com/quote/CL1:COM
>>
>> How are you? thank you for your help in excel formula to get stock data.
>> I need your help, is there any way or formula to get commodity data like
>> WTI or Brent crude oil in Bloomberg?
>>
>
>
>

Tue May 10, 2016 11:30 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Which link gets you to historical data?

On Tue, May 10, 2016 at 11:28 PM, Ranto Sb rantosb@itb98.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Thnx Randy.
> btw, is it possible to get historical data?
>
>
> //ranto
>
> 2016-05-11 13:13 GMT+07:00 Randy Harmelink rharmelink@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com>:
>
>>
>>
>> Something like last price would be:
>>
>> =smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM
>> ","div",-1,"class=""price""",,,,1)
>>
>> Something like open price would be:
>>
>> =smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM","div",1,"As
>> of ","Open",,,1)
>>
>>
>> On Tue, May 10, 2016 at 7:31 PM, Ranto Sb rantosb@
>> ​...wrote:
>>
>>>
>>> For Example: http://www.bloomberg.com/quote/CL1:COM
>>>
>>> How are you? thank you for your help in excel formula to get stock data.
>>> I need your help, is there any way or formula to get commodity data like
>>> WTI or Brent crude oil in Bloomberg?
>>>
>>

Wed May 11, 2016 12:27 am (PDT) . Posted by:

"Ranto Sb" sojuaon

in bloomberg, this web site: http://www.bloomberg.com/quote/CL1:COM

//ranto

2016-05-11 13:30 GMT+07:00 Randy Harmelink rharmelink@gmail.com [smf_addin]
<smf_addin@yahoogroups.com>:

>
>
> Which link gets you to historical data?
>
> On Tue, May 10, 2016 at 11:28 PM, Ranto Sb rantosb@itb98.com [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> Thnx Randy.
>> btw, is it possible to get historical data?
>>
>>
>> //ranto
>>
>> 2016-05-11 13:13 GMT+07:00 Randy Harmelink rharmelink@gmail.com
>> [smf_addin] <smf_addin@yahoogroups.com>:
>>
>>>
>>>
>>> Something like last price would be:
>>>
>>> =smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM
>>> ","div",-1,"class=""price""",,,,1)
>>>
>>> Something like open price would be:
>>>
>>> =smfGetTagContent("http://www.bloomberg.com/quote/CL1:COM","div",1,"As
>>> of ","Open",,,1)
>>>
>>>
>>> On Tue, May 10, 2016 at 7:31 PM, Ranto Sb rantosb@
>>> ​...wrote:
>>>
>>>>
>>>> For Example: http://www.bloomberg.com/quote/CL1:COM
>>>>
>>>> How are you? thank you for your help in excel formula to get stock data.
>>>> I need your help, is there any way or formula to get commodity data
>>>> like WTI or Brent crude oil in Bloomberg?
>>>>
>>>
>
>

Wed May 11, 2016 12:34 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I don't see any historical data there...

On Wed, May 11, 2016 at 12:21 AM, Ranto Sb rantosb@itb98.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> in bloomberg, this web site: http://www.bloomberg.com/quote/CL1:COM
>
> 2016-05-11 13:30 GMT+07:00 Randy Harmelink rharmelink@
> <rharmelink@gmail.com>
> ​...​
> :
>
>>
>> Which link gets you to historical data?
>>
>> On Tue, May 10, 2016 at 11:28 PM, Ranto Sb rantosb@ <rantosb@itb98.com>
>> ​...​
>> :
>>
>>>
>>> Thnx Randy.
>>> btw, is it possible to get historical data?
>>>
>>>

Wed May 11, 2016 2:42 pm (PDT) . Posted by:

"Frank kirk" nautilustech

The information you're looking for is available from FRED using the smfGetEconData formula.


On Tue, May 10, 2016 at 22:31, Ranto Sb rantosb@itb98.com [smf_addin]<smf_addin@yahoogroups.com> wrote:

For Example: http://www.bloomberg.com/quote/CL1:COM

thnx,

//ranto

2016-05-11 0:32 GMT+07:00 Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com>:

 

Relevant URL please?

On Mon, May 9, 2016 at 7:00 PM, Ranto Sb rantosb@​...wrote:

How are you? thank you for your help in excel formula to get stock data.
I need your help, is there any way or formula to get commodity data like WTI or Brent crude oil in Bloomberg?

Tue May 10, 2016 11:53 am (PDT) . Posted by:

nicolaslee1992

Hey,

Big fan of your product. I was wondering if it was possible to use RCH to grab Major Holders data from Yahoo Finance. MSN used to have it before it went obsolete..

Any help is appreciated.

Best,

Tue May 10, 2016 12:19 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

How about from MorningStar instead? They're more up-to-date, and you can
get the top 20 of each. There are two templates in the FILES area of the
Yahoo group:

RCHGetTableCell-Template-Morningstar-Top-20-Stock-Holders.xls
RCHGetTableCell-Template-Morningstar-Top-Stock-Holders.xls

On Tue, May 10, 2016 at 10:40 AM, nicolaslee1992@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> Big fan of your product. I was wondering if it was possible to use RCH to
> grab Major Holders data from Yahoo Finance. MSN used to have it before it
> went obsolete..
>
> Any help is appreciated.
>

Tue May 10, 2016 3:20 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I know it would be asking a lot but can you move all the files to the website?
I did search the website but those 2 files are not there.
Quite a few of us no longer use yahoo groups.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, May 10, 2016 3:14 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Yahoo Major Holders


How about from MorningStar instead? They're more up-to-date, and you can get the top 20 of each. There are two templates in the FILES area of the Yahoo group:

RCHGetTableCell-Template-Morningstar-Top-20-Stock-Holders.xls
RCHGetTableCell-Template-Morningstar-Top-Stock-Holders.xls

On Tue, May 10, 2016 at 10:40 AM, nicolaslee1992@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Big fan of your product. I was wondering if it was possible to use RCH to grab Major Holders data from Yahoo Finance. MSN used to have it before it went obsolete..

Any help is appreciated.


Tue May 10, 2016 4:22 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That was the original plan. It's just that it requires a major chunk of
time to complete the process. At this point, doing it piecemeal would take
2 to 3 times as long to do.

The "Uploads by forum members" will always stay in the Yahoo group.

On Tue, May 10, 2016 at 2:24 PM, 'Kermit W. Prather' kermitp@
​...wrote:

>
> I know it would be asking a lot but can you move all the files to the
> website?
>
> I did search the website but those 2 files are not there.
>
> Quite a few of us no longer use yahoo groups.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar