15 New Messages
Digest #2697
Messages
Wed Jul 17, 2013 8:40 am (PDT) . Posted by:
"cfelix781" cfelix781
Hi,
I'm looking to extract key executives by company from companies listed on the toronto stock exchange. Can somebody help me with the formula that should be used to perform this task?
Thanks
I'm looking to extract key executives by company from companies listed on the toronto stock exchange. Can somebody help me with the formula that should be used to perform this task?
Thanks
Wed Jul 17, 2013 8:59 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sample URL please?
On Wed, Jul 17, 2013 at 5:12 AM, cfelix781 <cfelix781@gmail.com > wrote:
>
> I'm looking to extract key executives by company from companies listed on
> the toronto stock exchange. Can somebody help me with the formula that
> should be used to perform this task?
>
On Wed, Jul 17, 2013 at 5:12 AM, cfelix781 <cfelix781@gmail.
>
> I'm looking to extract key executives by company from companies listed on
> the toronto stock exchange. Can somebody help me with the formula that
> should be used to perform this task?
>
Wed Jul 17, 2013 11:56 am (PDT) . Posted by:
"cfelix781" cfelix781
http://finance.
--- In smf_addin@yahoogrou
>
> Sample URL please?
>
> On Wed, Jul 17, 2013 at 5:12 AM, cfelix781 <cfelix781@
>
> >
> > I'm looking to extract key executives by company from companies listed on
> > the toronto stock exchange. Can somebody help me with the formula that
> > should be used to perform this task?
> >
>
Wed Jul 17, 2013 12:20 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
How about an array-entered:
=RCHGetHTMLTable("http://finance.yahoo.com/q/pr?s=BZA.TO ",">Key
Executives",2,"",2)
On Wed, Jul 17, 2013 at 11:56 AM, cfelix781 <cfelix781@gmail.com > wrote:
>
> http://finance.yahoo.com/q/pr?s=BZA.TO+Profile
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Sample URL please?
> >
> > On Wed, Jul 17, 2013 at 5:12 AM, cfelix781 <cfelix781@...> wrote:
> >
> > >
> > > I'm looking to extract key executives by company from companies listed
> on
> > > the toronto stock exchange. Can somebody help me with the formula that
> > > should be used to perform this task?
>
=RCHGetHTMLTable(
Executives"
On Wed, Jul 17, 2013 at 11:56 AM, cfelix781 <cfelix781@gmail.
>
> http://finance.
>
> --- In smf_addin@yahoogrou
> >
> > Sample URL please?
> >
> > On Wed, Jul 17, 2013 at 5:12 AM, cfelix781 <cfelix781@
> >
> > >
> > > I'm looking to extract key executives by company from companies listed
> on
> > > the toronto stock exchange. Can somebody help me with the formula that
> > > should be used to perform this task?
>
Wed Jul 17, 2013 9:48 am (PDT) . Posted by:
"Craig" c1sander
Is there good way to extract a column of data (or several columns) from a
table. I'm interested in this table in particular
http://biz.yahoo.com/research/earncal/today.html . I'd like to get the
ticker symbols for companies with earnings announcements.
Thanks,
Craig
table. I'm interested in this table in particular
http://biz.yahoo.
ticker symbols for companies with earnings announcements.
Thanks,
Craig
Wed Jul 17, 2013 9:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
This appears to do the trick:
=INDEX(RCHGetHTMLTable("http://biz.yahoo.com/research/earncal/today.html
",">Conference",-1,"",1,,500,2),,2)
Of course, you could grab them one by one:
=RCHGetTableCell("http://biz.yahoo.com/research/earncal/today.html
",2,">Conference",,,,_row_)
...where you just start _row_ at 1 and increment for each additional ticker
symbol.
On Wed, Jul 17, 2013 at 9:48 AM, Craig <craig.sander@comcast.net > wrote:
> Is there good way to extract a column of data (or several columns) from a
> table. I'm interested in this table in particular
> http://biz.yahoo.com/research/earncal/today.html . I'd like to get the
> ticker symbols for companies with earnings announcements.
>
=INDEX(RCHGetHTMLTa
","
Of course, you could grab them one by one:
=RCHGetTableCell(
",2,"
...where you just start _row_ at 1 and increment for each additional ticker
symbol.
On Wed, Jul 17, 2013 at 9:48 AM, Craig <craig.sander@
> Is there good way to extract a column of data (or several columns) from a
> table. I'm interested in this table in particular
> http://biz.yahoo.
> ticker symbols for companies with earnings announcements.
>
Wed Jul 17, 2013 10:34 am (PDT) . Posted by:
"gbullr" gbullr
Randy.
In advance thank you for this addin, it is a life saver.
One of the few places that provides Bond price data is Finra.
http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C515717&symbol=AV.GE
That link is to a particular bond but I am trying to get price, yield and other data. I have been able to get the data using googlespreadsheets but finra has changed how they serve the data from HTML (I guess) to JSP. My tech terminology may not be correct.
Can your addin pull data from these tables if I feed it the right URL.
Thanks you.
In advance thank you for this addin, it is a life saver.
One of the few places that provides Bond price data is Finra.
http://finra-
That link is to a particular bond but I am trying to get price, yield and other data. I have been able to get the data using googlespreadsheets but finra has changed how they serve the data from HTML (I guess) to JSP. My tech terminology may not be correct.
Can your addin pull data from these tables if I feed it the right URL.
Thanks you.
Wed Jul 17, 2013 10:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Note that the page you cited actually has the data within a frame. You're
actually seeing MorningStar data:
http://quotes.morningstar.com/bondquote/quote.action?t=C515717
But they are dynamically loading the data from sourced web pages, and
extraction from them is not trivial. For example, to get the last traded
price:
=smfConvertData(smfStrExtr(RCHGetWebData("
http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
Trade Price"),"\t\t","\"))
The various source web pages:
http://quotes.morningstar.com/bondquote/quote/c-banner?&t=C515717
http://quotes.morningstar.com/bondquote/quote/c-bond?&t=C515717
http://quotes.morningstar.com/bondquote/quote/c-classification?&t=C515717
http://quotes.morningstar.com/bondquote/quote/c-credit?&t=C515717
http://quotes.morningstar.com/bondquote/quote/c-issue?&t=C515717
http://quotes.morningstar.com/bondquote/quote/c-redemption?&t=C515717
http://quotes.morningstar.com/bondquote/quote/c-tax?&t=C515717
Take a look at them and see what a mess they are.
On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich@gmail.com > wrote:
>
> In advance thank you for this addin, it is a life saver.
>
> One of the few places that provides Bond price data is Finra.
>
>
> http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C515717&symbol=AV.GE
>
> That link is to a particular bond but I am trying to get price, yield and
> other data. I have been able to get the data using googlespreadsheets but
> finra has changed how they serve the data from HTML (I guess) to JSP. My
> tech terminology may not be correct.
>
> Can your addin pull data from these tables if I feed it the right URL.
>
actually seeing MorningStar data:
http://quotes.
But they are dynamically loading the data from sourced web pages, and
extraction from them is not trivial. For example, to get the last traded
price:
=smfConvertData(
http://quotes.
Trade Price")
The various source web pages:
http://quotes.
http://quotes.
http://quotes.
http://quotes.
http://quotes.
http://quotes.
http://quotes.
Take a look at them and see what a mess they are.
On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich@
>
> In advance thank you for this addin, it is a life saver.
>
> One of the few places that provides Bond price data is Finra.
>
>
> http://finra-
>
> That link is to a particular bond but I am trying to get price, yield and
> other data. I have been able to get the data using googlespreadsheets but
> finra has changed how they serve the data from HTML (I guess) to JSP. My
> tech terminology may not be correct.
>
> Can your addin pull data from these tables if I feed it the right URL.
>
Wed Jul 17, 2013 11:00 am (PDT) . Posted by:
"gbullr" gbullr
Thank you.
I will see if I can mess around w/ what you have provided so that I can get the data.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Note that the page you cited actually has the data within a frame. You're
> actually seeing MorningStar data:
>
> http://quotes.morningstar.com/bondquote/quote.action?t=C515717
>
> But they are dynamically loading the data from sourced web pages, and
> extraction from them is not trivial. For example, to get the last traded
> price:
>
> =smfConvertData(smfStrExtr(RCHGetWebData("
> http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
> Trade Price"),"\t\t","\"))
>
> The various source web pages:
>
> http://quotes.morningstar.com/bondquote/quote/c-banner?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-bond?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-classification?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-credit?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-issue?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-redemption?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-tax?&t=C515717
>
> Take a look at them and see what a mess they are.
>
> On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich@...> wrote:
>
> >
> > In advance thank you for this addin, it is a life saver.
> >
> > One of the few places that provides Bond price data is Finra.
> >
> >
> > http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C515717&symbol=AV.GE
> >
> > That link is to a particular bond but I am trying to get price, yield and
> > other data. I have been able to get the data using googlespreadsheets but
> > finra has changed how they serve the data from HTML (I guess) to JSP. My
> > tech terminology may not be correct.
> >
> > Can your addin pull data from these tables if I feed it the right URL.
> >
>
I will see if I can mess around w/ what you have provided so that I can get the data.
--- In smf_addin@yahoogrou
>
> Note that the page you cited actually has the data within a frame. You're
> actually seeing MorningStar data:
>
> http://quotes.
>
> But they are dynamically loading the data from sourced web pages, and
> extraction from them is not trivial. For example, to get the last traded
> price:
>
> =smfConvertData(
> http://quotes.
> Trade Price")
>
> The various source web pages:
>
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
>
> Take a look at them and see what a mess they are.
>
> On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich
>
> >
> > In advance thank you for this addin, it is a life saver.
> >
> > One of the few places that provides Bond price data is Finra.
> >
> >
> > http://finra-
> >
> > That link is to a particular bond but I am trying to get price, yield and
> > other data. I have been able to get the data using googlespreadsheets but
> > finra has changed how they serve the data from HTML (I guess) to JSP. My
> > tech terminology may not be correct.
> >
> > Can your addin pull data from these tables if I feed it the right URL.
> >
>
Wed Jul 17, 2013 11:52 am (PDT) . Posted by:
"gbullr" gbullr
So I see that on the Finra banner page there are certain other headers that appear like last trade date but when I replace in your function call Last Trade Price for Last Trade Date nothing appears.
What am I doing wrong?
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Note that the page you cited actually has the data within a frame. You're
> actually seeing MorningStar data:
>
> http://quotes.morningstar.com/bondquote/quote.action?t=C515717
>
> But they are dynamically loading the data from sourced web pages, and
> extraction from them is not trivial. For example, to get the last traded
> price:
>
> =smfConvertData(smfStrExtr(RCHGetWebData("
> http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
> Trade Price"),"\t\t","\"))
>
> The various source web pages:
>
> http://quotes.morningstar.com/bondquote/quote/c-banner?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-bond?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-classification?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-credit?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-issue?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-redemption?&t=C515717
> http://quotes.morningstar.com/bondquote/quote/c-tax?&t=C515717
>
> Take a look at them and see what a mess they are.
>
> On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich@...> wrote:
>
> >
> > In advance thank you for this addin, it is a life saver.
> >
> > One of the few places that provides Bond price data is Finra.
> >
> >
> > http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C515717&symbol=AV.GE
> >
> > That link is to a particular bond but I am trying to get price, yield and
> > other data. I have been able to get the data using googlespreadsheets but
> > finra has changed how they serve the data from HTML (I guess) to JSP. My
> > tech terminology may not be correct.
> >
> > Can your addin pull data from these tables if I feed it the right URL.
> >
>
What am I doing wrong?
Thanks.
--- In smf_addin@yahoogrou
>
> Note that the page you cited actually has the data within a frame. You're
> actually seeing MorningStar data:
>
> http://quotes.
>
> But they are dynamically loading the data from sourced web pages, and
> extraction from them is not trivial. For example, to get the last traded
> price:
>
> =smfConvertData(
> http://quotes.
> Trade Price")
>
> The various source web pages:
>
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
> http://quotes.
>
> Take a look at them and see what a mess they are.
>
> On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich
>
> >
> > In advance thank you for this addin, it is a life saver.
> >
> > One of the few places that provides Bond price data is Finra.
> >
> >
> > http://finra-
> >
> > That link is to a particular bond but I am trying to get price, yield and
> > other data. I have been able to get the data using googlespreadsheets but
> > finra has changed how they serve the data from HTML (I guess) to JSP. My
> > tech terminology may not be correct.
> >
> > Can your addin pull data from these tables if I feed it the right URL.
> >
>
Wed Jul 17, 2013 12:06 pm (PDT) . Posted by:
"gbullr" gbullr
I have changed your function call to this":
=smfConvertData(smfStrExtr(RCHGetWebData("http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last Trade Date"),">","\"))
Thank you
--- In smf_addin@yahoogroups.com , "gbullr" <gaston.bullrich@...> wrote:
>
> So I see that on the Finra banner page there are certain other headers that appear like last trade date but when I replace in your function call Last Trade Price for Last Trade Date nothing appears.
>
> What am I doing wrong?
>
> Thanks.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Note that the page you cited actually has the data within a frame. You're
> > actually seeing MorningStar data:
> >
> > http://quotes.morningstar.com/bondquote/quote.action?t=C515717
> >
> > But they are dynamically loading the data from sourced web pages, and
> > extraction from them is not trivial. For example, to get the last traded
> > price:
> >
> > =smfConvertData(smfStrExtr(RCHGetWebData("
> > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
> > Trade Price"),"\t\t","\"))
> >
> > The various source web pages:
> >
> > http://quotes.morningstar.com/bondquote/quote/c-banner?&t=C515717
> > http://quotes.morningstar.com/bondquote/quote/c-bond?&t=C515717
> > http://quotes.morningstar.com/bondquote/quote/c-classification?&t=C515717
> > http://quotes.morningstar.com/bondquote/quote/c-credit?&t=C515717
> > http://quotes.morningstar.com/bondquote/quote/c-issue?&t=C515717
> > http://quotes.morningstar.com/bondquote/quote/c-redemption?&t=C515717
> > http://quotes.morningstar.com/bondquote/quote/c-tax?&t=C515717
> >
> > Take a look at them and see what a mess they are.
> >
> > On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich@> wrote:
> >
> > >
> > > In advance thank you for this addin, it is a life saver.
> > >
> > > One of the few places that provides Bond price data is Finra.
> > >
> > >
> > > http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C515717&symbol=AV.GE
> > >
> > > That link is to a particular bond but I am trying to get price, yield and
> > > other data. I have been able to get the data using googlespreadsheets but
> > > finra has changed how they serve the data from HTML (I guess) to JSP. My
> > > tech terminology may not be correct.
> > >
> > > Can your addin pull data from these tables if I feed it the right URL.
> > >
> >
>
=smfConvertData(
Thank you
--- In smf_addin@yahoogrou
>
> So I see that on the Finra banner page there are certain other headers that appear like last trade date but when I replace in your function call Last Trade Price for Last Trade Date nothing appears.
>
> What am I doing wrong?
>
> Thanks.
>
> --- In smf_addin@yahoogrou
> >
> > Note that the page you cited actually has the data within a frame. You're
> > actually seeing MorningStar data:
> >
> > http://quotes.
> >
> > But they are dynamically loading the data from sourced web pages, and
> > extraction from them is not trivial. For example, to get the last traded
> > price:
> >
> > =smfConvertData(
> > http://quotes.
> > Trade Price")
> >
> > The various source web pages:
> >
> > http://quotes.
> > http://quotes.
> > http://quotes.
> > http://quotes.
> > http://quotes.
> > http://quotes.
> > http://quotes.
> >
> > Take a look at them and see what a mess they are.
> >
> > On Wed, Jul 17, 2013 at 10:33 AM, gbullr <gaston.bullrich
> >
> > >
> > > In advance thank you for this addin, it is a life saver.
> > >
> > > One of the few places that provides Bond price data is Finra.
> > >
> > >
> > > http://finra-
> > >
> > > That link is to a particular bond but I am trying to get price, yield and
> > > other data. I have been able to get the data using googlespreadsheets but
> > > finra has changed how they serve the data from HTML (I guess) to JSP. My
> > > tech terminology may not be correct.
> > >
> > > Can your addin pull data from these tables if I feed it the right URL.
> > >
> >
>
Wed Jul 17, 2013 12:17 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I would use:
=DATEVALUE(SUBSTITUTE(smfStrExtr(RCHGetWebData("
http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
Trade Date")," >","<"),"\",""))
The first ">" is much earlier than the date, immediately followed by the
"\", so your formula was extracting a null string. I found it easiest to
start from the basic extraction:
=RCHGetWebData("
http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
Trade Date")
...and go from there.
Like I said, it's not really a trivial task to go get all the individual
items. :(
On Wed, Jul 17, 2013 at 12:06 PM, gbullr <gaston.bullrich@gmail.com > wrote:
> I have changed your function call to this":
>
> =smfConvertData(smfStrExtr(RCHGetWebData("
> http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
> Trade Date"),">","\"))
>
=DATEVALUE(SUBSTITU
http://quotes.
Trade Date"),
The first ">" is much earlier than the date, immediately followed by the
"\"
start from the basic extraction:
=RCHGetWebData(
http://quotes.
Trade Date")
...and go from there.
Like I said, it's not really a trivial task to go get all the individual
items. :(
On Wed, Jul 17, 2013 at 12:06 PM, gbullr <gaston.bullrich@
> I have changed your function call to this":
>
> =smfConvertData(
> http://quotes.
> Trade Date"),
>
Wed Jul 17, 2013 12:21 pm (PDT) . Posted by:
"gbullr" gbullr
Thanks again. I will see what I can do w/ your guidance. I had some choice words for the FINRA team.
Best.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I would use:
>
> =DATEVALUE(SUBSTITUTE(smfStrExtr(RCHGetWebData("
> http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
> Trade Date")," >","<"),"\",""))
>
> The first ">" is much earlier than the date, immediately followed by the
> "\", so your formula was extracting a null string. I found it easiest to
> start from the basic extraction:
>
> =RCHGetWebData("
> http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
> Trade Date")
>
> ...and go from there.
>
> Like I said, it's not really a trivial task to go get all the individual
> items. :(
>
> On Wed, Jul 17, 2013 at 12:06 PM, gbullr <gaston.bullrich@...> wrote:
>
> > I have changed your function call to this":
> >
> > =smfConvertData(smfStrExtr(RCHGetWebData("
> > http://quotes.morningstar.com/bondquote/quote/c-banner?t=C515717 ","Last
> > Trade Date"),">","\"))
> >
>
Best.
--- In smf_addin@yahoogrou
>
> I would use:
>
> =DATEVALUE(SUBSTITU
> http://quotes.
> Trade Date"),
>
> The first ">" is much earlier than the date, immediately followed by the
> "\"
> start from the basic extraction:
>
> =RCHGetWebData(
> http://quotes.
> Trade Date")
>
> ...and go from there.
>
> Like I said, it's not really a trivial task to go get all the individual
> items. :(
>
> On Wed, Jul 17, 2013 at 12:06 PM, gbullr <gaston.bullrich
>
> > I have changed your function call to this":
> >
> > =smfConvertData(
> > http://quotes.
> > Trade Date"),
> >
>
Wed Jul 17, 2013 12:21 pm (PDT) . Posted by:
"Linda Calvert" tally0999
<br/>How are you?
http://www.feinkost30.de/vnw/uennt/wts/tvpe-jmqbgqq-ajkserxy
kindest regards
Linda Calvert
<br/><br/>Sent from Yahoo! Mail for iPhone
http://www.feinkost
kindest regards
Linda Calvert
<br/><
Wed Jul 17, 2013 5:26 pm (PDT) . Posted by:
"waterboy5555" waterboy5555
I would like to import 3 charts on the Morningstar portfolio X ray section to an Excel spreadsheet. I am not very familiar with VBA so I would need a good starting point of how to make such code. Thanks for your help.
Tidak ada komentar:
Posting Komentar