6 New Messages
Digest #2579
Messages
Tue Apr 9, 2013 3:34 am (PDT) . Posted by:
"tenenbaum88" tenenbaum88
I don't know if the group has seen this or not or the feasibility with integrating it into the SMF addon, but it has a stunning amount of free historical financial data available.
edit - after looking at some more, there is apparently an Excel and Matlab addin as well.
http://www.quandl.com/help/excel-add-in
edit - after looking at some more, there is apparently an Excel and Matlab addin as well.
http://www.quandl.
Tue Apr 9, 2013 7:53 am (PDT) . Posted by:
"quantwiz" quantwiz
Would you mind sharing your Excel spreadsheet?
Many thanks,
RMK
--- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
>
> Sort of! I have a spreadsheet that calculates the 8-day, 20-day, 50-day, 75-day and 200-day SMA among other things. It does indicate the spread between the 200-day SMA and the Current Price. It doesn't use cross over, it uses the slope of the SMA.
>
> For example, I know that on the last trading day 4/13/12 that the SPY was 10.92 above the 200-day SMA. The slopes are as follows:
> 8-day   -0.42%
> 20-day   -0.11%Â
>
> 50-day   0.08%
> 75-day   0.11%
> 200-day   0.04%
>
> The purpose of the spreadsheet was to track Marvin and Gerald Appel's ETF Rotation in the book"Beating the Market, 3 Months at a Time".
>
> If you want a copy post back.
>
> Ron Spruell
>
>
>
>
> >________________________________
> > From: scott_grant2 <scott_grant2@...>
> >To: smf_addin@yahoogroups.com
> >Sent: Sunday, April 15, 2012 12:11 AM
> >Subject: [smf_addin] Does anyone have an excel that uses a moving average crossover?
> >
> >
> >Â
> >I have an excel sheet that does a different kind
> >of trend, i could try and write it, i love the plug-in
> >but i wouldnt be ashamed to ask if anyone else has
> >already written one..
> >
> >thanks
> >Scott
> >
> >
> >
> >
> >
>
Many thanks,
RMK
--- In smf_addin@yahoogrou
>
> Sort of! I have a spreadsheet that calculates the 8-day, 20-day, 50-day, 75-day and 200-day SMA among other things. It does indicate the spread between the 200-day SMA and the Current Price. It doesn't use cross over, it uses the slope of the SMA.
>
> For example, I know that on the last trading day 4/13/12 that the SPY was 10.92 above the 200-day SMA. The slopes are as follows:
> 8-day   -0.42%
> 20-day   -0.11%Â
>
> 50-day   0.08%
> 75-day   0.11%
> 200-day   0.04%
>
> The purpose of the spreadsheet was to track Marvin and Gerald Appel's ETF Rotation in the book"Beating the Market, 3 Months at a Time".
>
> If you want a copy post back.
>
> Ron Spruell
>
>
>
>
> >________
> > From: scott_grant2 <scott_grant2@
> >To: smf_addin@yahoogrou
> >Sent: Sunday, April 15, 2012 12:11 AM
> >Subject: [smf_addin] Does anyone have an excel that uses a moving average crossover?
> >
> >
> >Â
> >I have an excel sheet that does a different kind
> >of trend, i could try and write it, i love the plug-in
> >but i wouldnt be ashamed to ask if anyone else has
> >already written one..
> >
> >thanks
> >Scott
> >
> >
> >
> >
> >
>
Tue Apr 9, 2013 8:26 am (PDT) . Posted by:
"Jason Strauss" g3m1n1980
I would also like to see a copy of this
On Apr 9, 2013, at 10:49 AM, "quantwiz"; <ronmkraft@gmail.com > wrote:
> Would you mind sharing your Excel spreadsheet?
> Many thanks,
> RMK
>
> --- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
> >
> > Sort of! I have a spreadsheet that calculates the 8-day, 20-day, 50-day, 75-day and 200-day SMA among other things. It does indicate the spread between the 200-day SMA and the Current Price. It doesn't use cross over, it uses the slope of the SMA.
> >
> > For example, I know that on the last trading day 4/13/12 that the SPY was 10.92 above the 200-day SMA. The slopes are as follows:
> > 8-day -0.42%
> > 20-day -0.11%
> >
> > 50-day 0.08%
> > 75-day 0.11%
> > 200-day 0.04%
> >
> > The purpose of the spreadsheet was to track Marvin and Gerald Appel's ETF Rotation in the book"Beating the Market, 3 Months at a Time".
> >
> > If you want a copy post back.
> >
> > Ron Spruell
> >
> >
> >
> >
> > >________________________________
> > > From: scott_grant2 <scott_grant2@...>
> > >To: smf_addin@yahoogroups.com
> > >Sent: Sunday, April 15, 2012 12:11 AM
> > >Subject: [smf_addin] Does anyone have an excel that uses a moving average crossover?
> > >
> > >
> > >
> > >I have an excel sheet that does a different kind
> > >of trend, i could try and write it, i love the plug-in
> > >but i wouldnt be ashamed to ask if anyone else has
> > >already written one..
> > >
> > >thanks
> > >Scott
> > >
> > >
> > >
> > >
> > >
> >
>
>
On Apr 9, 2013, at 10:49 AM, "quantwiz"
> Would you mind sharing your Excel spreadsheet?
> Many thanks,
> RMK
>
> --- In smf_addin@yahoogrou
> >
> > Sort of! I have a spreadsheet that calculates the 8-day, 20-day, 50-day, 75-day and 200-day SMA among other things. It does indicate the spread between the 200-day SMA and the Current Price. It doesn't use cross over, it uses the slope of the SMA.
> >
> > For example, I know that on the last trading day 4/13/12 that the SPY was 10.92 above the 200-day SMA. The slopes are as follows:
> > 8-day -0.42%
> > 20-day -0.11%
> >
> > 50-day 0.08%
> > 75-day 0.11%
> > 200-day 0.04%
> >
> > The purpose of the spreadsheet was to track Marvin and Gerald Appel's ETF Rotation in the book"Beating the Market, 3 Months at a Time".
> >
> > If you want a copy post back.
> >
> > Ron Spruell
> >
> >
> >
> >
> > >________
> > > From: scott_grant2 <scott_grant2@
> > >To: smf_addin@yahoogrou
> > >Sent: Sunday, April 15, 2012 12:11 AM
> > >Subject: [smf_addin] Does anyone have an excel that uses a moving average crossover?
> > >
> > >
> > >
> > >I have an excel sheet that does a different kind
> > >of trend, i could try and write it, i love the plug-in
> > >but i wouldnt be ashamed to ask if anyone else has
> > >already written one..
> > >
> > >thanks
> > >Scott
> > >
> > >
> > >
> > >
> > >
> >
>
>
Tue Apr 9, 2013 8:50 am (PDT) . Posted by:
"Mark Knecht" mw_knecht
Can't you guys just get a copy of talib (Open Source) and use that for all
your basic indicators?
On Tue, Apr 9, 2013 at 8:16 AM, Jason Strauss <xxjaysonxx@aol.com > wrote:
> **
>
>
> I would also like to see a copy of this
>
> On Apr 9, 2013, at 10:49 AM, "quantwiz"; <ronmkraft@gmail.com > wrote:
>
>
>
> Would you mind sharing your Excel spreadsheet?
> Many thanks,
> RMK
>
> --- In smf_addin@yahoogroups.com , Ron Spruell <hashky@...> wrote:
> >
> > Sort of! I have a spreadsheet that calculates the 8-day, 20-day,
> 50-day, 75-day and 200-day SMA among other things. It does indicate the
> spread between the 200-day SMA and the Current Price. It doesn't use cross
> over, it uses the slope of the SMA.
> >
> > For example, I know that on the last trading day 4/13/12 that the SPY
> was 10.92 above the 200-day SMA. The slopes are as follows:
> > 8-day -0.42%
> > 20-day -0.11%
> >
> > 50-day 0.08%
> > 75-day 0.11%
> > 200-day 0.04%
>
> >
> > The purpose of the spreadsheet was to track Marvin and Gerald Appel's
> ETF Rotation in the book"Beating the Market, 3 Months at a Time".
> >
> > If you want a copy post back.
> >
> > Ron Spruell
> >
> >
> >
> >
> > >________________________________
> > > From: scott_grant2 <scott_grant2@...>
> > >To: smf_addin@yahoogroups.com
> > >Sent: Sunday, April 15, 2012 12:11 AM
> > >Subject: [smf_addin] Does anyone have an excel that uses a moving
> average crossover?
> > >
> > >
> > >
> > >I have an excel sheet that does a different kind
> > >of trend, i could try and write it, i love the plug-in
> > >but i wouldnt be ashamed to ask if anyone else has
> > >already written one..
> > >
> > >thanks
> > >Scott
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
your basic indicators?
On Tue, Apr 9, 2013 at 8:16 AM, Jason Strauss <xxjaysonxx@aol.
> **
>
>
> I would also like to see a copy of this
>
> On Apr 9, 2013, at 10:49 AM, "quantwiz"
>
>
>
> Would you mind sharing your Excel spreadsheet?
> Many thanks,
> RMK
>
> --- In smf_addin@yahoogrou
> >
> > Sort of! I have a spreadsheet that calculates the 8-day, 20-day,
> 50-day, 75-day and 200-day SMA among other things. It does indicate the
> spread between the 200-day SMA and the Current Price. It doesn't use cross
> over, it uses the slope of the SMA.
> >
> > For example, I know that on the last trading day 4/13/12 that the SPY
> was 10.92 above the 200-day SMA. The slopes are as follows:
> > 8-day -0.42%
> > 20-day -0.11%
> >
> > 50-day 0.08%
> > 75-day 0.11%
> > 200-day 0.04%
>
> >
> > The purpose of the spreadsheet was to track Marvin and Gerald Appel's
> ETF Rotation in the book"Beating the Market, 3 Months at a Time".
> >
> > If you want a copy post back.
> >
> > Ron Spruell
> >
> >
> >
> >
> > >________
> > > From: scott_grant2 <scott_grant2@
> > >To: smf_addin@yahoogrou
> > >Sent: Sunday, April 15, 2012 12:11 AM
> > >Subject: [smf_addin] Does anyone have an excel that uses a moving
> average crossover?
> > >
> > >
> > >
> > >I have an excel sheet that does a different kind
> > >of trend, i could try and write it, i love the plug-in
> > >but i wouldnt be ashamed to ask if anyone else has
> > >already written one..
> > >
> > >thanks
> > >Scott
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
Wed Apr 10, 2013 2:44 am (PDT) . Posted by:
"weekeewawa" weekeewawa
great!
now having some fun and headache with the template
and also on morningstar again..
as you can see, on
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=IBM
there are 3 question
1) as you can see under valuation, there is this row which says
S&P 500 data through 04-08-13
i tried to use this code
=RCHGetTableCell("http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol= "&B2,
0,"Dividend Yield %","<table",,,0,"</table")
to extract that row
but the results shows ''Growth More'' which is the next box!
whats the problem with it?
2) as you can see in the next box ''Growth''
how do i extract the ''Sales'' row because in http://quicktake.morningstar.com/stocknet/printreport.aspx there are many many sales reference but i would like to point to a specific ''Sales'' in that ''Growth'' box only
how do i solve that?
3) how do i extract the row 1 Year% 3 Year% S&P 500?
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That formula can't be what you are using.
>
> You do need to look at the source code of the web page to see how things
> are coded. You would find out your search term is *not* what is in the
> source code. And that a table is coded within a table.
>
> Also, there is an issue with MorningStar web pages -- the default of
> RCHGetTableCell() is that the "end of the page" is the "</body" HTML tag,
> which is used when you need to skip rows. However, MorningStar doesn't code
> that tag, so you'll get errors using the default. You need something like
> this to account for that HTML coding error:
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=MMM ",
> 2,"Earnings Estimates","<table",,,1,"</table")
>
> I'd suggest you play with those parameters on the "By Table Cell" worksheet
> of the smfGetTagContent-Quick-Webpage-Examination.xls template.
>
> On Tue, Apr 9, 2013 at 1:07 AM, weekeewawa <weekeewawa@...> wrote:
>
> > and it brings me to another point
> >
> > as you can see the code
> >
> > =RCHGetTableCell("
> > http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=&A2,1, ">Annual
> > Earnings Estimates",,,,1)
> >
> > i am trying to extract the row consisting 12-12, 12-13 along with the row
> > consisting $ and growth%
> >
> > but it justs give me errrors after errors
> >
> > any advice on this issue?
> >
>
now having some fun and headache with the template
and also on morningstar again..
as you can see, on
http://quicktake.
there are 3 question
1) as you can see under valuation, there is this row which says
S&P 500 data through 04-08-13
i tried to use this code
=RCHGetTableCell(
0,"Dividend Yield %","
to extract that row
but the results shows ''Growth More'' which is the next box!
whats the problem with it?
2) as you can see in the next box ''Growth&#
how do i extract the ''Sales&#
how do i solve that?
3) how do i extract the row 1 Year% 3 Year% S&P 500?
thanks
--- In smf_addin@yahoogrou
>
> That formula can't be what you are using.
>
> You do need to look at the source code of the web page to see how things
> are coded. You would find out your search term is *not* what is in the
> source code. And that a table is coded within a table.
>
> Also, there is an issue with MorningStar web pages -- the default of
> RCHGetTableCell(
> which is used when you need to skip rows. However, MorningStar doesn't code
> that tag, so you'll get errors using the default. You need something like
> this to account for that HTML coding error:
>
> =RCHGetTableCell(
> http://quicktake.
> 2,"Earnings Estimates"
>
> I'd suggest you play with those parameters on the "By Table Cell" worksheet
> of the smfGetTagContent-
>
> On Tue, Apr 9, 2013 at 1:07 AM, weekeewawa <weekeewawa@
>
> > and it brings me to another point
> >
> > as you can see the code
> >
> > =RCHGetTableCell(
> > http://quicktake.
> > Earnings Estimates"
> >
> > i am trying to extract the row consisting 12-12, 12-13 along with the row
> > consisting $ and growth%
> >
> > but it justs give me errrors after errors
> >
> > any advice on this issue?
> >
>
Wed Apr 10, 2013 3:38 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
On Wed, Apr 10, 2013 at 2:44 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> 1) as you can see under valuation, there is this row which says
>
> S&P 500 data through 04-08-13
>
> i tried to use this code
>
> =RCHGetTableCell("
> http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol= "&B2,
> 0,"Dividend Yield %","<table",,,0,"</table")
>
> to extract that row
>
> but the results shows ''Growth More'' which is the next box!
>
> whats the problem with it?
>
Because you used "<table" as your second search term, telling it to go to
the next table.
Did you try the smfGetTagContent-Quick-Webpage-Examination.xls template?
Try these parameters:
*Web Page:*
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=IBM *Find
1:* Dividend Yield *Find 2:* *Find 3:* *Find 4:* *End:* </table
However, it's easiest to just go after it directly:
=RCHGetTableCell("
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=IBM ",
0,"S&P 500 data through")
> 2) as you can see in the next box ''Growth''
>
> how do i extract the ''Sales'' row because in
> http://quicktake.morningstar.com/stocknet/printreport.aspx there are many
> many sales reference but i would like to point to a specific ''Sales'' in
> that ''Growth'' box only
>
> how do i solve that?
I would use the link from the header. Take a look at:
*Web Page:*
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=IBM *Find
1:* "Financials.aspx? *Find 2:* Sales *Find 3:* *Find 4:* *End:*
</table
> 3) how do i extract the row 1 Year% 3 Year% S&P 500?
>
Take a look at:
*Web Page:*
http://quicktake.morningstar.com/stocknet/printreport.aspx?symbol=IBM *Find
1:* "Financials.aspx? *Find 2:* <table *Find 3:* *Find 4:* *End:*
</table
>
> 1) as you can see under valuation, there is this row which says
>
> S&P 500 data through 04-08-13
>
> i tried to use this code
>
> =RCHGetTableCell(
> http://quicktake.
> 0,"Dividend Yield %","
>
> to extract that row
>
> but the results shows ''Growth More'' which is the next box!
>
> whats the problem with it?
>
Because you used "<table&quo
the next table.
Did you try the smfGetTagContent-
Try these parameters:
*Web Page:*
http://quicktake.
1:* Dividend Yield *Find 2:* *Find 3:* *Find 4:* *End:* </table
However, it's easiest to just go after it directly:
=RCHGetTableCell(
http://quicktake.
0,"S&
> 2) as you can see in the next box ''Growth&#
>
> how do i extract the ''Sales&#
> http://quicktake.
> many sales reference but i would like to point to a specific ''Sales&#
> that ''Growth&#
>
> how do i solve that?
I would use the link from the header. Take a look at:
*Web Page:*
http://quicktake.
1:* "Financials.
</table
> 3) how do i extract the row 1 Year% 3 Year% S&P 500?
>
Take a look at:
*Web Page:*
http://quicktake.
1:* "Financials.
</table
Tidak ada komentar:
Posting Komentar