12 New Messages
Digest #2721
Messages
Sat Aug 3, 2013 1:21 am (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Thanks. Works beautifully.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try adding the end of the HTML tag right in front of it:
>
> =RCHGetTableCell("
> http://asia.advfn.com/exchanges/nasdaq/aapl/financials?btn=annual_reports
> ",5,">depreciation")
>
> ...otherwise it just looks for the first occurrence of the word
> "depreciation".
>
> On Fri, Aug 2, 2013 at 11:27 PM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> > When I enter =RCHGetTableCell("
> > http://asia.advfn.com/exchanges/nasdaq/aapl/financials?btn=annual_reports
> > ",5,"depreciation")
> > Instead of returning 3277, it gives me 87,846 which is "cost of sales with
> > depreciation". How can I get it to return the right value?
> >
>
--- In smf_addin@yahoogrou
>
> Try adding the end of the HTML tag right in front of it:
>
> =RCHGetTableCell(
> http://asia.
> ",5,"
>
> ...otherwise it just looks for the first occurrence of the word
> "depreciation&
>
> On Fri, Aug 2, 2013 at 11:27 PM, lawrence.leesh <lawrence.
>
> > When I enter =RCHGetTableCell(
> > http://asia.
> > ",5,"
> > Instead of returning 3277, it gives me 87,846 which is "cost of sales with
> > depreciation"
> >
>
Sat Aug 3, 2013 2:46 am (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Is there a way to extract
In millions of USD (except for per share items)from
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AAPL:NSQ&subview=IncomeStatement
and
All amounts in Millions of US Dollars except per share items
from http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=s_ok&start_date=15&mode=annual_reports
thanks
--- In smf_addin@yahoogroups.com , "lawrence.leesh" <lawrence.leesh@...> wrote:
>
> Thanks. Works beautifully.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Try adding the end of the HTML tag right in front of it:
> >
> > =RCHGetTableCell("
> > http://asia.advfn.com/exchanges/nasdaq/aapl/financials?btn=annual_reports
> > ",5,">depreciation")
> >
> > ...otherwise it just looks for the first occurrence of the word
> > "depreciation".
> >
> > On Fri, Aug 2, 2013 at 11:27 PM, lawrence.leesh <lawrence.leesh@>wrote:
> >
> > > When I enter =RCHGetTableCell("
> > > http://asia.advfn.com/exchanges/nasdaq/aapl/financials?btn=annual_reports
> > > ",5,"depreciation")
> > > Instead of returning 3277, it gives me 87,846 which is "cost of sales with
> > > depreciation". How can I get it to return the right value?
> > >
> >
>
In millions of USD (except for per share items)from
http://markets.
and
All amounts in Millions of US Dollars except per share items
from http://asia.
thanks
--- In smf_addin@yahoogrou
>
> Thanks. Works beautifully.
>
> --- In smf_addin@yahoogrou
> >
> > Try adding the end of the HTML tag right in front of it:
> >
> > =RCHGetTableCell(
> > http://asia.
> > ",5,"
> >
> > ...otherwise it just looks for the first occurrence of the word
> > "depreciation&
> >
> > On Fri, Aug 2, 2013 at 11:27 PM, lawrence.leesh <lawrence.
> >
> > > When I enter =RCHGetTableCell(
> > > http://asia.
> > > ",5,"
> > > Instead of returning 3277, it gives me 87,846 which is "cost of sales with
> > > depreciation"
> > >
> >
>
Sat Aug 3, 2013 7:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfstrExtr(smfGetTagContent("
http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AAPL:NSQ&subview=IncomeStatement ","span",-2,"except
for"),"~","<")
...and:
=smfGetTagContent("
http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=s_ok&start_date=15&mode=annual_reports ","font",-3,"except
per share")
=smfGetTagContent("
http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=s_ok&start_date=15&mode=annual_reports ","font",-2,"except
per share")
On Sat, Aug 3, 2013 at 2:46 AM, lawrence.leesh <lawrence.leesh@yahoo.com >wrote:
> Is there a way to extract
> In millions of USD (except for per share items)from
>
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AAPL:NSQ&subview=IncomeStatement
>
> and
> All amounts in Millions of US Dollars except per share items
> from
> http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=s_ok&start_date=15&mode=annual_reports
>
=smfstrExtr(
http://markets.
for"),"
...and:
=smfGetTagContent(
http://asia.
per share")
=smfGetTagContent(
http://asia.
per share")
On Sat, Aug 3, 2013 at 2:46 AM, lawrence.leesh <lawrence.leesh@
> Is there a way to extract
> In millions of USD (except for per share items)from
>
> http://markets.
>
> and
> All amounts in Millions of US Dollars except per share items
> from
> http://asia.
>
Sat Aug 3, 2013 2:16 pm (PDT) . Posted by:
"lawrence.leesh" lawrence.leesh
Thanks Randy.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try:
>
> =smfstrExtr(smfGetTagContent("
> http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AAPL:NSQ&subview=IncomeStatement ","span",-2,"except
> for"),"~","<")
>
> ...and:
>
> =smfGetTagContent("
> http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=s_ok&start_date=15&mode=annual_reports ","font",-3,"except
> per share")
>
> =smfGetTagContent("
> http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=s_ok&start_date=15&mode=annual_reports ","font",-2,"except
> per share")
>
> On Sat, Aug 3, 2013 at 2:46 AM, lawrence.leesh <lawrence.leesh@...>wrote:
>
> > Is there a way to extract
> > In millions of USD (except for per share items)from
> >
> > http://markets.ft.com/research/Markets/Tearsheets/Financials?s=AAPL:NSQ&subview=IncomeStatement
> >
> > and
> > All amounts in Millions of US Dollars except per share items
> > from
> > http://asia.advfn.com/exchanges/NASDAQ/AAPL/financials?btn=s_ok&start_date=15&mode=annual_reports
> >
>
--- In smf_addin@yahoogrou
>
> Try:
>
> =smfstrExtr(
> http://markets.
> for"),"
>
> ...and:
>
> =smfGetTagContent(
> http://asia.
> per share")
>
> =smfGetTagContent(
> http://asia.
> per share")
>
> On Sat, Aug 3, 2013 at 2:46 AM, lawrence.leesh <lawrence.
>
> > Is there a way to extract
> > In millions of USD (except for per share items)from
> >
> > http://markets.
> >
> > and
> > All amounts in Millions of US Dollars except per share items
> > from
> > http://asia.
> >
>
Sat Aug 3, 2013 10:36 am (PDT) . Posted by:
"gbullr" gbullr
Randy
Is there an easy way to get S&P TRI for dates off this page:
http://ycharts.com/indices/%5ESPXTR
using your addin..
Lets say
12/31/2012 to 7/31/2013
Thank you very much.
--- In smf_addin@yahoogroups.com , "lexstar" <lexstar@...> wrote:
>
> Thanks everyone for your observations and comments. Greatly appreciated.
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > That's because the provider of the charts data for Yahoo doesn't always
> > adjust for dividends. I've noticed that in the past. It's one reason I'm
> > not real fond of their charts.
> >
> > ^GSPC has no dividend adjustments. VFINX and SPY do.
> >
> > The total return index for the S&P 500 is ^PXTY, but Yahoo doesn't carry
> > historical quotes for it.
> >
> > On Fri, Jun 22, 2012 at 4:51 AM, MikeM <mikemcq802@> wrote:
> >
> > > If you use Yahoo to chart ^gspc and compare it to SPY and VFINX they line
> > > up exactly.
> > >
> > > How are you calculating the returns for them?
> > >
> >
>
Is there an easy way to get S&P TRI for dates off this page:
http://ycharts.
using your addin..
Lets say
12/31/2012 to 7/31/2013
Thank you very much.
--- In smf_addin@yahoogrou
>
> Thanks everyone for your observations and comments. Greatly appreciated.
>
>
> --- In smf_addin@yahoogrou
> >
> > That's because the provider of the charts data for Yahoo doesn't always
> > adjust for dividends. I've noticed that in the past. It's one reason I'm
> > not real fond of their charts.
> >
> > ^GSPC has no dividend adjustments. VFINX and SPY do.
> >
> > The total return index for the S&P 500 is ^PXTY, but Yahoo doesn't carry
> > historical quotes for it.
> >
> > On Fri, Jun 22, 2012 at 4:51 AM, MikeM <mikemcq802@
> >
> > > If you use Yahoo to chart ^gspc and compare it to SPY and VFINX they line
> > > up exactly.
> > >
> > > How are you calculating the returns for them?
> > >
> >
>
Sat Aug 3, 2013 11:18 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, no. It displays the data for the new dates dynamically.
Why not just use the smfPricesByDates() function?
On Sat, Aug 3, 2013 at 10:36 AM, gbullr <gaston.bullrich@gmail.com > wrote:
>
> Is there an easy way to get S&P TRI for dates off this page:
>
> http://ycharts.com/indices/%5ESPXTR
>
> using your addin..
>
> Lets say
>
> 12/31/2012 to 7/31/2013
>
Why not just use the smfPricesByDates(
On Sat, Aug 3, 2013 at 10:36 AM, gbullr <gaston.bullrich@
>
> Is there an easy way to get S&P TRI for dates off this page:
>
> http://ycharts.
>
> using your addin..
>
> Lets say
>
> 12/31/2012 to 7/31/2013
>
Sat Aug 3, 2013 11:28 am (PDT) . Posted by:
"Gaston Bullrich" gbullr
Would be happy to if I could find a source for S&P total return index.
On Sat, Aug 3, 2013 at 2:18 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> Sorry, no. It displays the data for the new dates dynamically.
>
> Why not just use the smfPricesByDates() function?
>
>
> On Sat, Aug 3, 2013 at 10:36 AM, gbullr <gaston.bullrich@gmail.com > wrote:
>
>>
>> Is there an easy way to get S&P TRI for dates off this page:
>>
>> http://ycharts.com/indices/%5ESPXTR
>>
>> using your addin..
>>
>> Lets say
>>
>> 12/31/2012 to 7/31/2013
>>
>
>
>
--
Gaston Bullrich
20 East 67th Street Apt 2F
New York, NY 10065
Cel. 917 517 9907
On Sat, Aug 3, 2013 at 2:18 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> Sorry, no. It displays the data for the new dates dynamically.
>
> Why not just use the smfPricesByDates(
>
>
> On Sat, Aug 3, 2013 at 10:36 AM, gbullr <gaston.bullrich@
>
>>
>> Is there an easy way to get S&P TRI for dates off this page:
>>
>> http://ycharts.
>>
>> using your addin..
>>
>> Lets say
>>
>> 12/31/2012 to 7/31/2013
>>
>
>
>
--
Gaston Bullrich
20 East 67th Street Apt 2F
New York, NY 10065
Cel. 917 517 9907
Sat Aug 3, 2013 11:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Using the adjusted closing prices on Yahoo gives you the total return...
On Sat, Aug 3, 2013 at 11:28 AM, Gaston Bullrich
<gaston.bullrich@gmail.com >wrote:
>
> Would be happy to if I could find a source for S&P total return index.
>
On Sat, Aug 3, 2013 at 11:28 AM, Gaston Bullrich
<gaston.bullrich@
>
> Would be happy to if I could find a source for S&P total return index.
>
Sat Aug 3, 2013 11:54 am (PDT) . Posted by:
"gbullr" gbullr
Differences. Obviously SPY is a better source than ^GSPC. SPY is close on full year but not for the last month. 12 bps is a pretty big difference for what I am using it. If you have any suggestions I would appreciate it. Best and thanks again.
12/31/2012 7/31/2013 Return
spy 141.03 168.71 19.63%
6/30/2013 7/31/2013
spy 160.42 168.71 5.17%
12/31/2012 7/31/2013 Return
^GSPC 1426.19 1685.73 18.20%
6/30/2013 7/31/2013
^GSPC 1606.28 1685.73 4.95%
12/31/2012 7/31/2013 Return
S&P 500 TR 2504.44 2995.72 19.62%
6/30/2013 7/31/2013
S&P 500 TR 2850.66 2995.72 5.09%
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Using the adjusted closing prices on Yahoo gives you the total return...
>
> On Sat, Aug 3, 2013 at 11:28 AM, Gaston Bullrich
> <gaston.bullrich@...>wrote:
>
> >
> > Would be happy to if I could find a source for S&P total return index.
> >
>
12/31/2012 7/31/2013 Return
spy 141.03 168.71 19.63%
6/30/2013 7/31/2013
spy 160.42 168.71 5.17%
12/31/2012 7/31/2013 Return
^GSPC 1426.19 1685.73 18.20%
6/30/2013 7/31/2013
^GSPC 1606.28 1685.73 4.95%
12/31/2012 7/31/2013 Return
S&P 500 TR 2504.44 2995.72 19.62%
6/30/2013 7/31/2013
S&P 500 TR 2850.66 2995.72 5.09%
--- In smf_addin@yahoogrou
>
> Using the adjusted closing prices on Yahoo gives you the total return...
>
> On Sat, Aug 3, 2013 at 11:28 AM, Gaston Bullrich
> <gaston.bullrich
>
> >
> > Would be happy to if I could find a source for S&P total return index.
> >
>
Sat Aug 3, 2013 1:04 pm (PDT) . Posted by:
"ajtalukdar" ajtalukdar
Thanks Randy. This works like a charm!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's because you have a CSX and WAG on the London Stock Exchange, which
> is what the "uk" website will default to when no stock exchange is cited.
> If you're after U.S. stocks, you should always use the exchange prefix when
> using the "uk" website. So, try NYSE:CSX and NYSE:WAG as your ticker
> symbols.
>
> On Fri, Aug 2, 2013 at 11:21 PM, ajtalukdar <ajtalukdar@...> wrote:
>
> > Applying the UK prefix fix works, however only partly. Now I find that
> >
> > the following calls work
> > RCHGetElementNumber("ORCL";,8186)
> > RCHGetElementNumber("YUM",8186)
> >
> > while the following DO NOT work - returning Error
> > RCHGetElementNumber("CSX",8186)
> > RCHGetElementNumber("WAG",8186)
> >
> > Any ideas why some stock codes are working while others are not?
> >
>
--- In smf_addin@yahoogrou
>
> That's because you have a CSX and WAG on the London Stock Exchange, which
> is what the "uk" website will default to when no stock exchange is cited.
> If you're after U.S. stocks, you should always use the exchange prefix when
> using the "uk" website. So, try NYSE:CSX and NYSE:WAG as your ticker
> symbols.
>
> On Fri, Aug 2, 2013 at 11:21 PM, ajtalukdar <ajtalukdar@
>
> > Applying the UK prefix fix works, however only partly. Now I find that
> >
> > the following calls work
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > while the following DO NOT work - returning Error
> > RCHGetElementNumber
> > RCHGetElementNumber
> >
> > Any ideas why some stock codes are working while others are not?
> >
>
Sat Aug 3, 2013 4:51 pm (PDT) . Posted by:
"cfelix781" cfelix781
Randy,
This worked great.
Staying on that same web page, how would I modify your formula to extract the following:
1) Description
2) Website
3) Industry Classification
4) Phone & Fax Number
5) Email & Physical Addresses
to distinct cells in my worksheet?
I've been tinkering around with the formula you provided, but haven't been able to find the right combination to allow me to extract the information I'm looking for.
Thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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?
> >
>
This worked great.
Staying on that same web page, how would I modify your formula to extract the following:
1) Description
2) Website
3) Industry Classification
4) Phone & Fax Number
5) Email & Physical Addresses
to distinct cells in my worksheet?
I've been tinkering around with the formula you provided, but haven't been able to find the right combination to allow me to extract the information I'm looking for.
Thanks!
--- In smf_addin@yahoogrou
>
> How about an array-entered:
>
> =RCHGetHTMLTable(
> Executives"
>
> On Wed, Jul 17, 2013 at 11:56 AM, 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?
> >
>
Sat Aug 3, 2013 5:06 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Most have examples in the message archives, which you can find with a
search. For example, I found these two right away:
=smfGetTagContent("http://finance.yahoo.com/q/pr?s=MMM ","p",1,">Business
Summary")
=smfGetTagContent("http://finance.yahoo.com/q/pr?s=KO ","a",1,"Website:")
On Sat, Aug 3, 2013 at 4:51 PM, cfelix781 <cfelix781@gmail.com > wrote:
>
> Staying on that same web page, how would I modify your formula to extract
> the following:
>
> 1) Description
> 2) Website
> 3) Industry Classification
> 4) Phone & Fax Number
> 5) Email & Physical Addresses
>
> to distinct cells in my worksheet?
>
> I've been tinkering around with the formula you provided, but haven't been
> able to find the right combination to allow me to extract the information
> I'm looking for.
>
search. For example, I found these two right away:
=smfGetTagContent(
Summary"
=smfGetTagContent(
On Sat, Aug 3, 2013 at 4:51 PM, cfelix781 <cfelix781@gmail.
>
> Staying on that same web page, how would I modify your formula to extract
> the following:
>
> 1) Description
> 2) Website
> 3) Industry Classification
> 4) Phone & Fax Number
> 5) Email & Physical Addresses
>
> to distinct cells in my worksheet?
>
> I've been tinkering around with the formula you provided, but haven't been
> able to find the right combination to allow me to extract the information
> I'm looking for.
>
Tidak ada komentar:
Posting Komentar