14 Messages
Digest #3158
Messages
Fri Aug 22, 2014 8:03 am (PDT) . Posted by:
c2adf9311e2c386ea6b50154ae931d42
Any working variable/formula for ETF fee ratio? Using Excel 2007. Can't find any working FEE ratio for ETF.
Fri Aug 22, 2014 8:13 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Is this what you're wanting?
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=SPY",1,"Expense Ratio")
On Fri, Aug 22, 2014 at 8:03 AM, sdglobe@... wrote:
> Any working variable/formula for ETF fee ratio? Using Excel 2007. Can't
> find any working FEE ratio for ETF.
>
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=SPY",1,"
On Fri, Aug 22, 2014 at 8:03 AM, sdglobe@... wrote:
> Any working variable/formula for ETF fee ratio? Using Excel 2007. Can't
> find any working FEE ratio for ETF.
>
Fri Aug 22, 2014 8:24 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
AAII just put out their annual report on ETF's – just remember all their published work is from an investor perspective.
You can get that information off the AAII.COM website. Cost is very low $29 yr for membership
or $49 membership + computerized investing newsletter
or like myself a lifetime membership with access to all AAII features for $290
They offer a 30 trail for any of the memberships.
I got the lifetime for my 7 adults children because they are more investor than traders.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, August 22, 2014 11:04 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Any working variable/formula for ETF fee ratio?
Any working variable/formula for ETF fee ratio? Using Excel 2007. Can't find any working FEE ratio for ETF.
You can get that information off the AAII.COM website. Cost is very low $29 yr for membership
or $49 membership + computerized investing newsletter
or like myself a lifetime membership with access to all AAII features for $290
They offer a 30 trail for any of the memberships.
I got the lifetime for my 7 adults children because they are more investor than traders.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, August 22, 2014 11:04 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Any working variable/formula for ETF fee ratio?
Any working variable/formula for ETF fee ratio? Using Excel 2007. Can't find any working FEE ratio for ETF.
Hi,
I've been pulling that info from Morningstar manually. I assume
that ETF EXP does not vary too much therefore it does not need
updating every time I refresh my work sheet.
Of course I sacrifice convenience, but gain performance.
Remember that each ETF in your work sheet would require a visit
to Yahoo's site.
Cheers,
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Aug 22, 2014 12:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Any working variable/formula for ETF fee
ratio?
Is this what you're wanting?
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=SPY
<http://finance.yahoo.com/q/pr?s=SPY> ",1,"Expense Ratio")
On Fri, Aug 22, 2014 at 8:03 AM, sdglobe@... wrote:
Any working variable/formula for ETF fee ratio? Using Excel 2007.
Can't find any working FEE ratio for ETF.
I've been pulling that info from Morningstar manually. I assume
that ETF EXP does not vary too much therefore it does not need
updating every time I refresh my work sheet.
Of course I sacrifice convenience, but gain performance.
Remember that each ETF in your work sheet would require a visit
to Yahoo's site.
Cheers,
Armando
-----Original Message-----
From: "Randy Harmelink rharmelink@gmail.com [smf_addin]"
Sent: Aug 22, 2014 12:13 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Any working variable/formula for ETF fee
ratio?
Is this what you're wanting?
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=SPY
<http://finance.yahoo.com/q/pr?s=SPY> ",1,"
On Fri, Aug 22, 2014 at 8:03 AM, sdglobe@... wrote:
Any working variable/formula for ETF fee ratio? Using Excel 2007.
Can't find any working FEE ratio for ETF.
Fri Aug 22, 2014 10:19 am (PDT) . Posted by:
c2adf9311e2c386ea6b50154ae931d42
Thank you Randy. What can I do to replace SPY with a cell like B21?
Fri Aug 22, 2014 10:34 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just use the normal EXCEL string concatenation:
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=" & B21,1,"Expense Ratio")
On Fri, Aug 22, 2014 at 10:19 AM, sdglobe@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> What can I do to replace SPY with a cell like B21?
>
=RCHGetTableCell("http://finance.yahoo.com/q/pr?s=" & B21,1,"Expense Ratio")
On Fri, Aug 22, 2014 at 10:19 AM, sdglobe@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> What can I do to replace SPY with a cell like B21?
>
Fri Aug 22, 2014 8:05 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Anyone have a list of the IBD top 50 and the dates they were last put on the
list?
I'm trying to calculate how stocks perform after they are placed on the IBD
top 50 list.
Appreciate any help on this request.
It is a one-time thing I am trying to do. The information will not be shared
with anyone.
It is more curiosity than anything else.
Thanks,
Kermit
list?
I'm trying to calculate how stocks perform after they are placed on the IBD
top 50 list.
Appreciate any help on this request.
It is a one-time thing I am trying to do. The information will not be shared
with anyone.
It is more curiosity than anything else.
Thanks,
Kermit
Fri Aug 22, 2014 9:10 am (PDT) . Posted by:
lexstar
Hi All.... is there a data limit to which Yahoo will allow you to download data using this function smfGetTagContent()? If so, what's the limit? I try using it to download Splits, and I find that it is limiting me from downloading all the list of stocks that I want (ie. over 2000 stocks that I keep track of it).
If so, is there another way around it?
Thanks in advance.
If so, is there another way around it?
Thanks in advance.
Fri Aug 22, 2014 9:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The add-in has a built-in limit of 1000 web pages at a time, because it
saves web pages internally before extracting data from them, and there are
only 1000 slots for saving web pages.
On Fri, Aug 22, 2014 at 9:10 AM, lexstar@... wrote:
> Hi All.... is there a data limit to which Yahoo will allow you to
> download data using this function smfGetTagContent()? If so, what's the
> limit? I try using it to download Splits, and I find that it is limiting
> me from downloading all the list of stocks that I want (ie. over 2000
> stocks that I keep track of it).
>
> If so, is there another way around it?
>
saves web pages internally before extracting data from them, and there are
only 1000 slots for saving web pages.
On Fri, Aug 22, 2014 at 9:10 AM, lexstar@... wrote:
> Hi All.... is there a data limit to which Yahoo will allow you to
> download data using this function smfGetTagContent(
> limit? I try using it to download Splits, and I find that it is limiting
> me from downloading all the list of stocks that I want (ie. over 2000
> stocks that I keep track of it).
>
> If so, is there another way around it?
>
Fri Aug 22, 2014 9:32 am (PDT) . Posted by:
lexstar
If that's the case, is't possible to split the 2000 stocks into, say 2 separate sheets, and then do 2 separate downloads? Will that work?
If not, can I just clear the cache and will that work?
If not, can I just clear the cache and will that work?
Fri Aug 22, 2014 9:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'd need to convert the first 1000 to values, then either run
smfForceRecalculation or exit and restart EXCEL before doing the next 1000.
Why in the world would you need all that split data?
On Fri, Aug 22, 2014 at 9:32 AM, lexstar@... wrote:
>
> If that's the case, is't possible to split the 2000 stocks into, say 2
> separate sheets, and then do 2 separate downloads? Will that work?
> If not, can I just clear the cache and will that work?
>
smfForceRecalculati
Why in the world would you need all that split data?
On Fri, Aug 22, 2014 at 9:32 AM, lexstar@... wrote:
>
> If that's the case, is't possible to split the 2000 stocks into, say 2
> separate sheets, and then do 2 separate downloads? Will that work?
> If not, can I just clear the cache and will that work?
>
Fri Aug 22, 2014 9:52 am (PDT) . Posted by:
lexstar
Randy,
Is there some kind of problem with this formula:
C1: =smfGetTagContent("http://finance.yahoo.com/q/bc?s=MMM http://finance.yahoo.com/q/bc?s=MMM","nobr",ROWS(C$1:C1),"Splits:")
On my end, it doesn't give me anything?
Is there some kind of problem with this formula:
C1: =smfGetTagContent("http://finance.yahoo.com/q/bc?s=MMM http://finance.yahoo.com/q/bc?s=MMM","
On my end, it doesn't give me anything?
Fri Aug 22, 2014 10:16 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Worked fine here...
On Fri, Aug 22, 2014 at 9:52 AM, lexstar@... wrote:
>
> Is there some kind of problem with this formula:
>
> C1: =smfGetTagContent("http://finance.yahoo.com/q/bc?s=MMM
> ","nobr",ROWS(C$1:C1),"Splits:")
>
> On my end, it doesn't give me anything?
>
On Fri, Aug 22, 2014 at 9:52 AM, lexstar@... wrote:
>
> Is there some kind of problem with this formula:
>
> C1: =smfGetTagContent("http://finance.yahoo.com/q/bc?s=MMM
> ","
>
> On my end, it doesn't give me anything?
>
Fri Aug 22, 2014 2:57 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
I use http://getsplithistory.com/MMM Symbol needs to be in uppercase or it give you another page. Then you have to manually enter the symbol.
I create an array with this formula
=RCHGetHTMLTable("http://getsplithistory.com/"&$C$5,"",1,"",1)
Where cell C5 has the uppercase symbol
You need a 5 column by xx rows
Good luck,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, August 22, 2014 12:53 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Historical Dividends & Stocksplits
Randy,
Is there some kind of problem with this formula:
C1: =smfGetTagContent("http://finance.yahoo.com/q/bc?s=MMM","nobr",ROWS(C$1:C1),"Splits:")
On my end, it doesn't give me anything?
I create an array with this formula
=RCHGetHTMLTable("http://getsplithistory.com/"&$C$5,"",1,"",1)
Where cell C5 has the uppercase symbol
You need a 5 column by xx rows
Good luck,
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Friday, August 22, 2014 12:53 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Yahoo Historical Dividends & Stocksplits
Randy,
Is there some kind of problem with this formula:
C1: =smfGetTagContent("http://finance.yahoo.com/q/bc?s=MMM","
On my end, it doesn't give me anything?
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar