13 Messages
Digest #3696
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?
>
>
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?
>>
>>
>
>
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?
>
=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?
>>
>
>
>
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?
>>>
>>
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?
>>>>
>>>
>
>
//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
>>>
>>>
>>>
>>>
>>>
>>>
>
>
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?
>>>
>>>
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?
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,
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.
>
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.
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.
>
>
>
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