StockFetcher Forums · Filter Exchange · sentiment indicator<< >>Post Follow-up
sohailmithani
192 posts
msg #107485
Ignore sohailmithani
8/9/2012 10:40:17 AM

Hi all,

I am trying to create a filter which shows the ratio of stocks above their ma(200) to the total number of stocks in SP500.

If the ratio is above 50% then it is bullish sentiment else bearish. Lets call this 'sentiment indicator'. Once this is done, I would like to add rsi, macd and stochastics to this 'sentiment indicator' and go long when these also align with trend determined.

Can any guru pls help me create this one.

Kevin_in_GA
4,536 posts
msg #107488
Ignore Kevin_in_GA
8/9/2012 11:41:42 AM

Fetcher[

market is S&P 500

close above MA(200)

]



Now manually divide the resulting number from this filter (341 as of this writing) by 500. Answer = 68.2%

There is really no way to use the result number as part of any filter. Sorry.

sohailmithani
192 posts
msg #107490
Ignore sohailmithani
8/9/2012 11:51:28 AM

Thanks.

How about count function for # of stocks above and below ma(200) and then take ratio of above to total number of stocks. There has to be some way to find this trigger.

Kevin_in_GA
4,536 posts
msg #107491
Ignore Kevin_in_GA
8/9/2012 12:17:35 PM

The count function returns a 1 or 0, not a sum.

This type of capability has been requested a number of times in the past without success.

Bottom line is that this cannot be done in SF until they update the code. Contact SF and see if this time they would do this.

Cheese
118 posts
msg #107513
Ignore Cheese
8/10/2012 1:43:08 AM

In the meantime, you may want to refer to this chart by Joanne Klein:
http://stockcharts.com/public/1107832/chartbook/253632655;



StockFetcher Forums · Filter Exchange · sentiment indicator<< >>Post Follow-up

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