Rabu, 10 April 2013

[smf_addin] Digest Number 2579

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

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
> >
> >
> >
> >
> >
>

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
> > >
> > >
> > >
> > >
> > >
> >
>
>

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
> > >
> > >
> > >
> > >
> > >
> >
>
>
>

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&#39;'

how do i extract the ''Sales&#39;' 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&#39;' in that ''Growth&#39;' 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&quot; 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?
> >
>

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&quot; 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&#39;'
>
> how do i extract the ''Sales&#39;' 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&#39;' in
> that ''Growth&#39;' 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

Tidak ada komentar:

Posting Komentar