StockFetcher Forums · View by Author: (556 messages)  [ Display By: Date / Subject ]<< 1 2 3 4 5 ... 56 >> 
Filter Exchange · "Death Cross" help neeed
glgene
msg #95754
8/20/2010 2:07:23 AM

The "Death Cross" is when the 50-day moving average crosses below the 200-day moving average of a major index. I'm not sure if that typically applies to the major barometer Dow 30 or SP 500 index.

Anyway, in a newsletter I read tonight, its "Death Cross" favors the Exponential Moving Average (vs. the Simple Moving Average). It also favors the Dow 30. Here is a script I wrote that calculates both the Simple MA and Exponential of the Dow, SP 500, QQQQ, and VTI (I use DIA for the Dow, and SPY for SP 500):

Fetcher[
symlist(dia,spy,qqqq,vti)
add column separator
add column ma(50)
add column ma(200)
set{g,ma(50)/ma(200)}
add column g{SMA-cross}
add column separator
add column ema(50)
add column ema(200)
set{k,ema(50)/ema(200)}
add column k{ema-cross}
]


I would like to have the SMA-cross and EMA-cross columns to include 3 places to the right of the decimal, In other words (e.g.,) DIA on 8/19/10 would show as 1.011....not 1.01 as it now shows. I have my reasons.

The newsletter says, in essence, if the Dow 30 EMA "Death Cross" occurs......it will be the last nail in the bearish coffin.

According to the above script, here are 8/19/10 results of the EMA crossovers:

SPY, 1.00
QQQQ, 1.02
DIA, 1.01
VTI, 1.00

I would like to change the script so I can get the results to show 3 places to the right of the decimal point, using SF's new "rounded" feature, or alternate way (preferably using the "rounded" feature). Can someone help? Thanks.

Filter Exchange · "Death Cross" help neeed
glgene
msg #95757
8/20/2010 8:52:39 AM

Mystiq,

Your idea may be right on target.

I was just following the newsletter writer's pick on using the Dow 50-day (EMA) cross below the Dow 200-day(EMA) figure. Still trying to figure out how to get 3 places to the right of the decimal figure. Anybody with an idea how to do this (preferably using SF's 'rounded' feature, if that's possible)?

Thanks, again!

In the meantime, mystiq, why do you suggest using the EMA for the 50-day and SMA on 200-day figure?

Filter Exchange · "Death Cross" help neeed
glgene
msg #95768
8/21/2010 8:51:33 PM

mystiq,

I said, "In the meantime, mystiq, why do you suggest using the EMA for the 50-day and SMA on 200-day figure?

You replied: "EMA represents the fast line and SMA the slow line. For spotting early moves AND ...less false moves."

----------------------------------------------------------

I can certainly see your first point at times (early moves), but can you elaborate on your second point (less false moves)? Not sure why the latter would be true. Please...share your thoughts. I'm always open to constructive input!

As you know, dividing EMA(50) by MA(200) is easily doable.

For actual numbers, at end-of-day on Friday, Aug. 20, here are comparative numbers on the ETF, SPY (SP 500):

Less than 1.00 (i.e., .99 or lower) would represent the so-called "Death Cross" has taken place:

MA(50) / MA(200) = 109.11 / 111.88 = .9752 (rounded .98)

EMA(50) / MA(200) = 109.88 / 111.88 = .9821 (rounded .98)

EMA(50) / EMA(200) = 109.88 / 109.76 = 1.0011 (rounded 1.00)

Note: I prefer the non-rounded number for more precision. That is fixable, thanks to the suggestion earlier!

The article I read 2 days ago, said the writer preferred using strictly the EMA crossover. Don't know if that is just his opinion, or conventional wisdom. I had always thought the Death Cross was based on the crossover of the Simple Moving Average (MA). But maybe the hybrid of EMA(50) / MA(200) makes the most sense. Anyway, from the numbers above, we're "dying" on the first two numbers, and just hanging by a thread on the strictly EMA (the third one) crossover. At least with SPY.

Additional comments from anyone?

Filter Exchange · "Death Cross" help neeed
glgene
msg #95772
8/22/2010 12:29:02 AM

Here is the update I made to my original script. I changed the % column to effectively get a 4-figure to the right of the decimal (thanks to the suggestion), by multiplying by 100. Thus, instead of the previous answer showing (e.g.,) .98, it now shows as 97.52. In other words, 97.52%. That would be the same as .9752 that I originally sought. I also added these columns: WMA(30), RSI(14) and MACD(12,26). Does anyone have any other suggestions for indicators to include?

Fetcher[
symlist(dia,spy,qqqq,vti)
add column separator
add column wma(30)
add column rsi(14)
add column macd(12,26,9)
add column cci(20)
add column separator
add column ma(50)
add column ma(200)
set{g,ma(50)/ma(200)}
set{g1,g*100}
add column g1{SMA-x%}
add column separator
add column ema(50)
add column ema(200)
set{k,ema(50)/ema(200)}
set{k1,k*100}
add column k1{ema-x%}
add column separator
]



Filter Exchange · "Death Cross" help neeed
glgene
msg #95788
8/23/2010 9:13:06 AM

Mystiq,

You said I should try using IFT(). Now that's a new one to me. So I had to look it up in the SF Manual, page 64.

I feel like a kindergartner hanging out with 3rd graders in school. I haven't even passed SF 101, and you want me to jump to SF 301....? Just kidding, of course. I certainly admire you and others for your scripting expertise.

That said, om page 64, SF uses the example of IFT(5,9). First number is the RSI days, the second number is the weighted MA days [not EMA].

5,9 seem short, considering I'm using your suggested script line in conjunction with 50-day and 200-day numbers for the so-called Death Cross. In light of what I just said, would you still use IFT(5,9) or other numbers?

Zack

Filter Exchange · "Death Cross" help neeed
glgene
msg #95826
8/24/2010 11:36:05 PM

For what it's worth: SPY (proxy for SP-500) crossed below the so-called "Death Cross" today, using the most recent script I posted 4 msgs. above. It's the one using 50/200 EMA crossover. <100.00 means it's below the Death Cross.

----------------08/23 ---------- 08/24

SPY ........... 100.04 ........... 99.92.......... [SMA crossover took place on 7/6/2010 at .9974

QQQQ ....... 101.62 .......... 101.48

DIA ............ 101.00 ........... 100.90 .......[SMA crossover took place 7/7/2010 at .9983

VTI ............ 100.19 ............ 100.07


I'm NOT suggesting the Death Cross is a valid timing system. I'm just reporting the dates, and the script (4 msgs. above) if you want to track it. Later this week, I'll show you the actual trading results of buy/hold vs. trading using the 50/200 EMA signal. The results, for what they're worth, favor the 50/200 EMA Death Cross system (more gain, less risk). You saved your bu-- during 2001-2002, and 2008. How many of us wish we could re-think our investing during those periods?!

As Sgt. Joe Friday used to say on the TV series DRAGNET, "Just the facts, ma'am [sir]."


-- Zack

General Discussion · % of SP 500 stocks higher than 200-day MA
glgene
msg #88280
2/14/2010 11:45:12 PM

Some time ago, I wrote a short script that got me the results for this subject heading. But I didn't save that script. It went something like this:

index is sp500
stocks>ma(200)

The above script doesn't work, unfortunately. I ran it, it got me 495 as the result. #@!

The reason I'm seeking it is because of an article in the Feb. 15, 2010 issue of Barron's (page M3), which stated:

"...if the S&P 500 has recently slipped to just 7% above its 200-day MA, it ought to be closely watched. If that edge shrinks to below 5%, watch out."

Well, according to FT software, SPY closed at $108.04 on 2/12/2010. It's 200-day MA is $102.59. Thus, the 200-day MA of SPY is just 5.04% above its close on 2/12/2010.

Could someone here show me the script to show how many stocks in the SP 500 are above their 200-day MA? Thanks so much.

Zack



General Discussion · % of SP 500 stocks higher than 200-day MA
glgene
msg #88287
2/15/2010 9:53:36 AM

Thanks. Just what I needed!

Zack

Filter Exchange · % of time above a stock's 20-day EMA
glgene
msg #99170
2/16/2011 11:18:25 PM

Need some help here. I was at an IBD Meet-up last night, and the facilitator said his software could track this:

"Show the % of time over the last 100 market days a given stock symbol (e.g., ETN) was above its 20-day EMA."
His answer, for ETN, was 95%.

Can this be programmed into SF? Using the Count feature, but showing the output in % format (such as 95%)? I haven't used such feature, so I would appreciate any help here with building this SF script (using a Symlist of stock symbols).

If someone can help, THANKS in advance.

Gene


Filter Exchange · % of time above a stock's 20-day EMA
glgene
msg #99171
2/16/2011 11:58:37 PM

Here is my start, but not sure how to include the Count feature, to show what % of time a stock symbol (e.g., ETN) is above its 20-day EMA over the past 100 market days.

Fetcher[
symlist (etn)
draw ema(20)
]



Can someone complete my desired script? Thanks!

Gene

StockFetcher Forums ·  · << 1 2 3 4 5 ... 56 >>

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2018 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus